Solved

No PDF report returned from Crystal Web Service

  • 24 November 2020
  • 7 replies
  • 1360 views
S
Rank
Userlevel 2
Badge +6

Hi,

Enviroment: Apps 10 Update 8

In our test environment we have just completed the following:

  1. Clone of our Live enviroment
  2. Updated Oracle from 12c to 19c

Once complete we have started testing and found we cannot get any Crystal Reports to run, when we do try we get an error “No PDF report returned from Crystal Web Service”.

Due to the clone I have made sure the system parameters are pointing to the test environment.

I have also turned on logging, see a log below…

I have highlighted the error in red:

 

11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[DecryptPassword] Decrypting Password : 
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetDbInfoFromXml] Decrypted.
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[DecryptPassword] Decrypting Password : 
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetDbInfoFromXml] Decrypted.
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSCST AppOwner-IFSAPP IALOwner-IFSINFO
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetSavedPDFReport] Exporting the report in PDF format.
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetSavedPDFReport] File Name : ArrivalReportAxis1.rpt
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetSavedPDFReport] ParameterValues : 66498.0 ,LangCode = gb
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[base64Encode] for 66498
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[base64Encode] Encoded value : NjY0OTg=
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[base64Decode] for NjY0OTg=
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[base64Decode] Decoded to 66498
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[OpenReport] File Name : gb\ArrivalReportAxis1.rpt
11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
11/24/2020 11:04:22 AM[IFSCRWebSetup_CST1]-[OpenReport] The file H:\IFS\IFSShared\IFSReports\IFSCST\Layout\gb\ArrivalReportAxis1.rpt is found
11/24/2020 11:04:22 AM[IFSCRWebSetup_CST1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
11/24/2020 11:04:22 AM[IFSCRWebSetup_CST1]-[LoadInfoServiceReport] Loading infoServe report : H:\IFS\IFSShared\IFSReports\IFSCST\Layout\gb\ArrivalReport1.rpt
11/24/2020 11:04:22 AM[IFSCRWebSetup_CST1]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : IFSCST ,AppOwner : IFSAPP
11/24/2020 11:04:22 AM[IFSCRWebSetup_CST1]-[LoadInfoServiceReport] Setting up logon information for each database object.
11/24/2020 11:04:22 AM[IFSCRWebSetup_CST1]-[SetTableLocation] Set appropriate post-fixes for ARRIVAL_REPORT_REP_
11/24/2020 11:04:22 AM[IFSCRWebSetup_CST1]-[SetDatabaseLocation] Generating fully qualified database object name for ARRIVAL_REPORT_REP_
11/24/2020 11:04:40 AM[IFSCRWebSetup_CST1]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
11/24/2020 11:04:40 AM[IFSCRWebSetup_CST1]-Failed to open the connection.
Details:  [Database Vendor Code: 12154 ] Failed to open the connection.
Details:  [Database Vendor Code: 12154 ] Failed to open the connection.
ArrivalReportAxis1 13976_19224_{D5ECD363-8B38-4E3D-B928-6FDBEB3B3972}.rpt
Details:  [Database Vendor Code: 12154 ]   at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)
   at CrystalDecisions.CrystalReports.Engine.Table.set_Location(String value)
   at Ifs_ReportService.SetDatabaseLocation(String databaseLocation, Table table) in c:\inetpub\wwwroot\IFSCRWebSetup_CST1\App_Code\Service.cs:line 1409
   at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetup_CST1\App_Code\Service.cs:line 1386
   at Ifs_ReportService.LoadInfoServiceReport(String path, String DBUser, String DBPassword, String DBServerName, String AppOwner) in c:\inetpub\wwwroot\IFSCRWebSetup_CST1\App_Code\Service.cs:line 1204

 

I have checked that IFSPRINT has the correct permissions and has access to the company and site,  these are not new reports they have all been established for a number of months.

I have opened a report in Crystal Reports and I can connect and run a report fine.

 

Any ideas would be much appreciated?

 

Many Thanks

Steve

icon

Best answer by SteveB 25 November 2020, 15:22

View original
This topic has been closed for comments

7 replies

Kasun Balasooriya
Rank
Userlevel 7
Badge +20

Hi Steve,

 

Since the error states :

11/24/2020 11:04:40 AM[IFSCRWebSetup_CST1]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
11/24/2020 11:04:40 AM[IFSCRWebSetup_CST1]-Failed to open the connection.
Details:  [Database Vendor Code: 12154 ] Failed to open the connection.
Details:  [Database Vendor Code: 12154 ] Failed to open the connection.

 

I would start troubleshooting by verifying whether the crystal web service can access the database. You can simply do a tnsping from the crystal web service machine to the db to verify.  Also make sure the view ARRIVAL_REPORT_REP_  has been granted to IFSSYS

 

Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
S
Rank
Userlevel 2
Badge +6

Hi Kasun,

Thanks for the reply

I have checked and can verify that the crystal web service can access the database (these are hosted on the same machine).

Also I can verify IFSSYS has permission to ARRIVAL_REPORT_REP_ 

Steve

Kasun Balasooriya
Rank
Userlevel 7
Badge +20

The Database Vendor Code: 12154 usually refers to ORA-12154  which hints about a TNS resolution failure. You can double check the oracle tns entry in ifs-crystal-config.xml and if that’s all good try to re-install the web service from a fresh zip archive from the IFS home. 

 

Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
S
Rank
Userlevel 2
Badge +6

Just thinking about this again, we have also changed the IFSSYS password, I see this is stored in the ifs-crystal-config.xml  encrypted?

Do you need to update this?

And if so how?

Kasun Balasooriya
Rank
Userlevel 7
Badge +20

Just thinking about this again, we have also changed the IFSSYS password, I see this is stored in the ifs-crystal-config.xml  encrypted?

Do you need to update this?

And if so how?

If you have updated the IFSSYS password you will have to run a reconfiguration to reflect the password update in the installation files for the crystal webservice. The CrystalWebService_64bit_DEV3APP10.zip will get updated during the re-config and you can use the updated zip archive to install the web service again. 

 

Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
S
Rank
Userlevel 2
Badge +6

I have followed your advice and installed the webservice again but its still the same?

1/25/2020 9:39:57 AM[IFSCRWebSetup]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
11/25/2020 9:39:57 AM[IFSCRWebSetup]-Failed to open the connection.
Details:  [Database Vendor Code: 12154 ] Failed to open the connection.
Details:  [Database Vendor Code: 12154 ] Failed to open the connection.
ArrivalReportAxis1 12868_3284_{32833AAA-F9D9-4FB5-AD8C-A95759485318}.rpt
Details:  [Database Vendor Code: 12154 ]   at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)
   at CrystalDecisions.CrystalReports.Engine.Table.set_Location(String value)
   at Ifs_ReportService.SetDatabaseLocation(String databaseLocation, Table table) in c:\inetpub\wwwroot\IFSCRWebSetup\App_Code\Service.cs:line 1409
   at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetup\App_Code\Service.cs:line 1386
   at Ifs_ReportService.LoadInfoServiceReport(String path, String DBUser, String DBPassword, String DBServerName, String AppOwner) in c:\inetpub\wwwroot\IFSCRWebSetup\App_Code\Service.cs:line 1204

I have checked the ifs-crystal-config.xml passwords to the configuration xml and they match.

 

S
Rank
Userlevel 2
Badge +6

I have finally got to the bottom of this, in tnsnames.ora the PDB entry was missing hence why the 12154 error code.

As soon as this was updated the Reports ran fine.

This happened when updating Oracle.

Thanks for all you help!

Terms & ConditionsCookie settings