Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In this article we have described the basic understanding and trouble shooting standard checklist with its troubleshooting steps for Web Report module , those will help to understand the cause of the problem & its basic understanding to prevent such problem in future. Also it will help to avoid the unnecessary delay of tickets forwarding.

Check List

...

are described below in a table format

...

.

Issue Type / Problem Type

What to check / Basic actions

How to check ( Quick Guide )

Description / Remarks

Report is not opening / Home is not opening.

Run Report SYNC

  • Click on Repository tab and then run SYNC.

  • Restart IIS (Follow either step)

    • Open CMD ( in Run as admin privilege), type >IISRESET > Press Enter.

    • Open Windows Services (services.msc), restart the service ‘World Wide Web Publishing Service’

Entries in Ginapps.config for Report configuration

Ensure the following standard entries are present in Ginapps.config file.
Path: \GSL\GINESYS12\Shared\Ginapps.config

<add key="ReportURI" value="/GinesysReportUI/" />
<add key="CustomPort" value="" />

IMPORTANT: If different URL is mentioned as ReportUI and ReportAPI, DO NOT change that. Check accessing those URL for verification and consult with technical team if required.

Verify ReportAPI application

Access ReportAPI URL directly entering in browser. The format of ReportAPI URL is mentioned, change the server name or IP appropriately.

http://<Server name or IP>/GinesysReportAPI/Api.asmx

Verify ReportUI application

Access ReportUI URL directly entering in browser. The format of ReportAPI URL is mentioned, change the server name or IP appropriately

http://<Server name or IP>/GinesysReportUI/Admin.aspx

Test Admin Configuration: Data Sources Data Source connection string under Server tab.

Go to Server > Data > Source (Expand) >

  • For database connection check, Double click on GINESYS. Test Connection String using the iconIcon.

  • For To verify Assemblies , Test the connection String using the Icon.

Report path test connection under Server tab.

Server tab > General > Main Settings > We can find Test the Report Path line > Test the Report pathusing the Icon.

GinesysWebReprts.xml file is present or not

Find the file from the below path.

\GSL\GINESYS12\GinesysReport\ReportUI\Config\GinesysWebReports.xml

Physical Path , AppPool , Standard Folder Security permission set of ReportAPI folder.

Verify the physical path of ReportAPI folder and its AppPool from IIS Manager.

Verify the folder Security of ReportAPI folder. Standard set of security should be like :

  1. SYSTEM ( Full Permission)

  2. Creator Owner (Special Permission)

  3. Administrators (Full permission)

  4. Users (Read& Execute , List of Folders , Read , Special Permission)

  5. IIS_IUSRS (Full Permission)

Physical path & App pool is mentiond in the Advance settings of each Web application ( ReportAPI, ReportUI etc.)

Select any Web Application > At the right side pane we see the Advance settings > Enter into it & check the physical path of folder of that web application along with app pool.

Physical Path , AppPool , Standard Folder Security permission set of ReportUI folder.

Verify the physical path of ReportUI folder and its AppPool from IIS Manager. See in the description column.Verify the folder Security of ReportUI folder. Standard set of security should be like :

Right click on any folder ( ReportAPI , ReportUI etc. ) > Properties > Security tab > Check the below Set of Security.

  1. SYSTEM ( Full Permission)

  2. Creator Owner (Special Permission)

  3. Administrators (Full permission)

  4. Users (Read& Execute , List of Folders , Read , Special Permission)

  5. IIS_IUSRS (Full Permission)

Physical path & App pool is mentiond in the Advance settings of each Web application ( ReportAPI, ReportUI etc.)

Select any Web Application > At the right side pane we see the Advance settings > Enter into it & check the physical path of folder of that web application along with app pool.

Report SYNC is not happening

GinesysWebReprts.xml file is present or not.

Find the file from the below path.

\GSL\GINESYS12\GinesysReport\ReportUI\Config\GinesysWebReports.xml

Folder Security permission set of ReportUI & ReportAPI.Verify the standard Folder security permission

Right click on any folder ( ReportAPI , ReportUI etc. ) > Properties > Security tab > Check the below Set of Security.

  1. SYSTEM ( Full Permission)

  2. Creator Owner (Special Permission)

  3. Administrators (Full permission)

  4. Users (Read& Execute , List of Folders , Read , Special Permission)

  5. IIS_IUSRS (Full Permission)

Report Scheduler service is working

GinesysReportScheduler Service state.

Go to > RUN > Services.msc > Find the Report scheduler service > Check is it stopped or not installed.

If Service is not installed , see in the description section link.

If GinesysReportScheduler service is not installed then you need to install it. Please follow the below reference for Report Scheduler Service installation.

Ginesys Reports Installation Guide

eWebReportsScheduler.exe file is present or not

Find the below file is present or not from the following below path.

<Ginesys Installation_drive>\GSL\GINESYS12\GinesysReport\ReportScheduler\eWebReportsScheduler.exe

eWebReportsScheduler.xml file

Find the below file is present or not from the following below path.

<Ginesys Installation_drive>\GSL\GINESYS12\GinesysReport\ReportScheduler\eWebReportsScheduler.xml

Test connection of Schedule Remoting Host test connection ?

Server > General > Main Settings > Scheduler Settings > Find Schedule Remoting host > test Test the connection.

Enable Report Scheduling Option is True

Server > General > Main Settings > Scheduler Settings > Find Enable Report scheduling > It should be set as True.

eWebReportsScheduler.xml , eWebReportsScheduler.exe , eWebReportsScheduler.exe.config – this files along with all DLL files under Ginesys Report folder needs to be unblock.

Open CMD with Admin privilege and run the below command.

Type Powershell ( press Enter )

Type below command.

dir <<Drive>\GSL\GINESYS12\GinesysReport\ > -Recurse | Unblock -File

If Report Server or Report Installation folder location is different then change the mentioned path accordingly in How to check section.

Report Scheduler Mail is not happening / Schedule Report goes to Abend State.

GinesysReportScheduler Service state

RUN > Services.msc > Find the Report scheduler service > Check is the service it stopped or not installed.

If Service is not installed , see in the description section link.

If GinesysReportScheduler service is not installed then you need to install it. Please follow the below reference for Report Scheduler Service installation.

Ginesys Reports Installation Guide

Test mail credentials in SMTP mailer from Launchpad.

Open Launchpad > SMTP Mailer > Click on Stop Service > Click Edit on Pencil t button for editing > Put your credentials & test the smtp details. ( Do not save anything any details after checking on this window ) .

eWebReportsScheduler.exe file

Find the below file is present or not from the following below path.

<Ginesys Installation_drive>\GSL\GINESYS12\GinesysReport\ReportScheduler\eWebReportsScheduler.exe

Check mail SMTP Mail settings in eWebReportsScheduler.xml file

Find the below file & check the settings from the following below path and verify the SMTP details.

<Ginesys Installation_drive>\GSL\GINESYS12\GinesysReport\ReportScheduler\eWebReportsScheduler.xml

Check SMTP SSL settings in eWebReportsScheduler.xml file set as true or false.

The common known SMTP ports are used in mail configuration i.e. 587,465,25,995 etc.

SSL ports : 587 , 465

Non SSL ports : 25

If found SSL ports are associated under with SMTP server name. then SSL tag should be set as true .

NOTE : In Exceptional cases, private mail domain might be configured with 587 port with Non SSL configuration. So ,here we have to set false under SSL tag after testing with settings. It will be act like Non SSL 25 general SMTP port.

Failed to attach mail attachment for Report Scheduler. Then we need to accordingly.

eWebReportsScheduler.exe.config file settings under Runtime tag for mail attachment failure.

Following Below xml tag needs to be add under Runtime <Runtime> tag . from the the following path.

<loadFromRemoteSources enabled="true"/>

path : \GSL\GINESYS12\GinesysReport\ReportScheduler\eWebReportsScheduler.exe.config

Report Scheduler Abended under Report Scheduler PageeWebReportsScheduler.xml , eWebReportsScheduler.exe , eWebReportsScheduler.exe.config – this files along with all DLL files under Ginesys Report folder needs to be unblock.

Open CMD with Admin privilege and run the below command.

Type Powershell ( press Enter )

Type below command.

dir <<Drive>\GSL\GINESYS12\GinesysReport\ > -Recurse | Unblock -File

If Report Server or Report Installation folder location is different then change the mentioned path accordingly in How to check section.