Question

No PDF report returned from Crystal Web Service - Apps 9

  • 31 March 2022
  • 5 replies
  • 417 views
K
Rank
Userlevel 4
Badge +8
  • Kasia
  • Sidekick (Customer)
  • 42 replies

Hi all,

 

I know this might of appeared on the forum before, however. Daily random number of print jobs have error messages with No PDF report returned from Crystal Web Service as a message. 

I’ve enabled Crystal logs to see if there was anything in them that could indicate any issues but there are no messages at all. Jobs goes from decrypting passwords, exporting the report in PDF format, getting report layout, processing it and finishes with it being completed successfully. 

Please see below, I’ve put xxx to replace sensitive info. 

 

 

31/03/2022 08:50:52[IFSCWSIFSL_1]-[DecryptPassword] Decrypting Password : xxxxx
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetDbInfoFromXml] Decrypted.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[DecryptPassword] Decrypting Password : xxxxx
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetDbInfoFromXml] Decrypted.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSL AppOwner-IFSAPP IALOwner-IFSINFO
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetSavedPDFReport] Exporting the report in PDF format.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetSavedPDFReport] File Name : InventoryPartBarcodeInv.rpt
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetSavedPDFReport] ParameterValues : 1103602.0 ,LangCode = gb
31/03/2022 08:50:52[IFSCWSIFSL_1]-[base64Encode] for 1103602
31/03/2022 08:50:52[IFSCWSIFSL_1]-[base64Encode] Encoded value : xxxxx
31/03/2022 08:50:52[IFSCWSIFSL_1]-[base64Decode] for xxxx
31/03/2022 08:50:52[IFSCWSIFSL_1]-[base64Decode] Decoded to 1103602
31/03/2022 08:50:52[IFSCWSIFSL_1]-[OpenReport] File Name : gb\InventoryPartBarcodeInv.rpt
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[OpenReport] The file E:\IFS\IFSShared\IFSReports\IFSL\Layout\gb\InventoryPartBarcodeInv.rpt is found
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[LoadInfoServiceReport] Loading infoServe report : E:\IFS\IFSShared\IFSReports\IFSL\Layout\gb\InventoryPartBarcodeInv.rpt
31/03/2022 08:50:52[IFSCWSIFSL_1]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : IFSL ,AppOwner : IFSAPP
31/03/2022 08:50:52[IFSCWSIFSL_1]-[DecryptPassword] Decrypting Password : xxxxx
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetDbInfoFromXml] Decrypted.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[DecryptPassword] Decrypting Password : xxxxx
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetDbInfoFromXml] Decrypted.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSL AppOwner-IFSAPP IALOwner-IFSINFO
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetSavedPDFReport] Exporting the report in PDF format.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetSavedPDFReport] File Name : InventoryPartBarcodeInv.rpt
31/03/2022 08:50:52[IFSCWSIFSL_1]-[LoadInfoServiceReport] Setting up logon information for each database object.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetSavedPDFReport] ParameterValues : 1103605.0 ,LangCode = gb
31/03/2022 08:50:52[IFSCWSIFSL_1]-[SetTableLocation] Set appropriate post-fixes for CDE_INV_PART_BARCODE_INV_RPT_A
31/03/2022 08:50:52[IFSCWSIFSL_1]-[base64Encode] for 1103605
31/03/2022 08:50:52[IFSCWSIFSL_1]-[SetDatabaseLocation] Generating fully qualified database object name for CDE_INV_PART_BARCODE_INV_RPT_A
31/03/2022 08:50:52[IFSCWSIFSL_1]-[base64Encode] Encoded value : xxxxx
31/03/2022 08:50:52[IFSCWSIFSL_1]-[base64Decode] for xxxxx
31/03/2022 08:50:52[IFSCWSIFSL_1]-[base64Decode] Decoded to 1103605
31/03/2022 08:50:52[IFSCWSIFSL_1]-[OpenReport] File Name : gb\InventoryPartBarcodeInv.rpt
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[OpenReport] The file E:\IFS\IFSShared\IFSReports\IFSL\Layout\gb\InventoryPartBarcodeInv.rpt is found
31/03/2022 08:50:52[IFSCWSIFSL_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
31/03/2022 08:50:52[IFSCWSIFSL_1]-[LoadInfoServiceReport] Loading infoServe report : E:\IFS\IFSShared\IFSReports\IFSL\Layout\gb\InventoryPartBarcodeInv.rpt
31/03/2022 08:50:52[IFSCWSIFSL_1]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : IFSL ,AppOwner : IFSAPP
31/03/2022 08:50:54[IFSCWSIFSL_1]-[DecryptPassword] Decrypting Password : xxxxx
31/03/2022 08:50:54[IFSCWSIFSL_1]-[GetDbInfoFromXml] Decrypted.
31/03/2022 08:50:54[IFSCWSIFSL_1]-[DecryptPassword] Decrypting Password : xxxxx
31/03/2022 08:50:54[IFSCWSIFSL_1]-[GetDbInfoFromXml] Decrypted.
31/03/2022 08:50:54[IFSCWSIFSL_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSL AppOwner-IFSAPP IALOwner-IFSINFO
31/03/2022 08:50:54[IFSCWSIFSL_1]-[GetSavedPDFReport] Exporting the report in PDF format.
31/03/2022 08:50:54[IFSCWSIFSL_1]-[GetSavedPDFReport] File Name : CDEShipmentDeliveryNote_v01.rpt
31/03/2022 08:50:54[IFSCWSIFSL_1]-[GetSavedPDFReport] ParameterValues : 1103609.0 ,LangCode = en
31/03/2022 08:50:54[IFSCWSIFSL_1]-[GetSavedPDFReport] The web instance is busy. The request will be forwarded to the next available instance.
31/03/2022 08:50:54[IFSCWSIFSL_1]-[SetDatabaseLocation] Table.Location : IFSAPP.CDE_INV_PART_BARCODE_INV_RPT
31/03/2022 08:50:54[IFSCWSIFSL_1]-[GetSavedPDFReport] SubReport count : 0
31/03/2022 08:50:54[IFSCWSIFSL_1]-[SetInfoServiceReportParameters] Result Key : 1103602 - Setting up parameters for InfoServices report.
31/03/2022 08:50:54[IFSCWSIFSL_1]-[SetInfoServiceReportParameters] Formula Form : IFS_RESULT_KEY
31/03/2022 08:50:56[IFSCWSIFSL_1]-[LoadInfoServiceReport] Setting up logon information for each database object.
31/03/2022 08:50:56[IFSCWSIFSL_1]-[SetTableLocation] Set appropriate post-fixes for CDE_INV_PART_BARCODE_INV_RPT_A
31/03/2022 08:50:56[IFSCWSIFSL_1]-[SetDatabaseLocation] Generating fully qualified database object name for CDE_INV_PART_BARCODE_INV_RPT_A
31/03/2022 08:50:57[IFSCWSIFSL_1]-[GetSavedPDFReport] Report of layout InventoryPartBarcodeInv.rpt has been exported successfully.
31/03/2022 08:50:58[IFSCWSIFSL_1]-[SetDatabaseLocation] Table.Location : IFSAPP.CDE_INV_PART_BARCODE_INV_RPT
31/03/2022 08:50:58[IFSCWSIFSL_1]-[GetSavedPDFReport] SubReport count : 0
31/03/2022 08:50:58[IFSCWSIFSL_1]-[SetInfoServiceReportParameters] Result Key : 1103605 - Setting up parameters for InfoServices report.
31/03/2022 08:50:58[IFSCWSIFSL_1]-[SetInfoServiceReportParameters] Formula Form : IFS_RESULT_KEY
31/03/2022 08:51:01[IFSCWSIFSL_1]-[GetSavedPDFReport] Report of layout InventoryPartBarcodeInv.rpt has been exported successfully.

 

As you can see no errors in logs yet job on IFS goes to error state. 

 

Has anyone experienced something like this before? Any steps I could perform to fix this? 

5 replies

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @Kasia,

 

Could you please check the log file to see if there are any error messages? Normally, there should be an error message explaining why you are getting the “No PDF report returned from Crystal Web Service” message.

https://www.linkedin.com/in/himashaabeywickrama
K
Rank
Userlevel 4
Badge +8

Hi @Kasia,

 

Could you please check the log file to see if there are any error messages? Normally, there should be an error message explaining why you are getting the “No PDF report returned from Crystal Web Service” message.

Hi @Himasha Abeywickrama ,

 

I have done that, please see above I’ve pasted part of it that corresponds with the time of print job in print manager. No errors in log.

 

I found an error but from yesterday and different report layout 

30/03/2022 16:29:19[IFSCWSIFSL_1]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
30/03/2022 16:29:19[IFSCWSIFSL_1]-Logon failed.
Details:  [Database Vendor Code: 12514 ]
Logon failed.
Details:  [Database Vendor Code: 12514 ]
Error in File CDEOrderConfirmation {1B1A83F8-22A4-486F-AD56-C1FABEF5F2A2}.rpt:
Unable to connect: incorrect log on parameters.
Details:  [Database Vendor Code: 12514 ]   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\IFSCWSIFSL_1\App_Code\Service.cs:line 1409
   at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCWSIFSL_1\App_Code\Service.cs:line 1381
   at Ifs_ReportService.LoadInfoServiceReport(String path, String DBUser, String DBPassword, String DBServerName, String AppOwner) in c:\inetpub\wwwroot\IFSCWSIFSL_1\App_Code\Service.cs:line 1204

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @Kasia,

Thanks for the info!

Are you trying to print the report using the IFS PDF Archiver? Since you have mentioned that this behavior is random, could you please try to print the report using the PDF archiver and see if you are getting the error message?

https://www.linkedin.com/in/himashaabeywickrama
K
Rank
Userlevel 4
Badge +8

Hi @Kasia,

Thanks for the info!

Are you trying to print the report using the IFS PDF Archiver? Since you have mentioned that this behavior is random, could you please try to print the report using the PDF archiver and see if you are getting the error message?

@Himasha Abeywickrama  thanks for your quick replies! 

 

Not using this method I did try generating PDF and Printing it but no errors. 

Thanks,

Kasia 

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @Kasia,

Go to server where you have setup the crystal web service and enable high debug logs if you have not yet done so,

Also, please check if following the below steps would fix the issue,

  1. Take the initpub backup.
  2. Uninstall the crystal services.
  3. Re install crystal service from new zip in IFS instance folder (install CWS from IFS Home)
  4. Restart the IIS.
  5. Retry generating the reports
https://www.linkedin.com/in/himashaabeywickrama

Reply


Terms & ConditionsCookie settings