Solved

Crystal Report using Operational REP Error Message: No PDF report returned from Crystal Web Service

  • 2 June 2020
  • 4 replies
  • 1095 views

Userlevel 7
Badge +18

Sorry, this was already logged but closed in error after getting an answer on enabling the Crystal Web Service Logs.

 

I have the same crystal report in 2 IFS instances.  One works without any issues where as the second on fails with the No PDF report returned from Crystal Web Service.

 

On checking the log file I get the following:


6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[GetSavedPDFReport] File Name : TnmtShpordBarc.rpt
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[GetSavedPDFReport] ParameterValues : 281.0 ,LangCode = gb
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[base64Encode] for 281
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[base64Encode] Encoded value : Mjgx
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[base64Decode] for Mjgx
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[base64Decode] Decoded to 281
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[OpenReport] File Name : gb\TnmtShpordBarc.rpt
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[OpenReport] The file F:\IFS\IFSCrystal\IFSR\gb\TnmtShpordBarc.rpt is found
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[LoadInfoServiceReport] Loading infoServe report : F:\IFS\IFSCrystal\IFSR\gb\TnmtShpordBarc.rpt
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : IFSRPDB ,AppOwner : IFSAPP
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[LoadInfoServiceReport] Setting up logon information for each database object.
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[SetTableLocation] Set appropriate post-fixes for INVENTORY_PART_A
6/2/2020 10:04:06 AM[IFSCRWebSetup_IFSR]-[SetDatabaseLocation] Generating fully qualified database object name for INVENTORY_PART_A
6/2/2020 10:04:07 AM[IFSCRWebSetup_IFSR]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
6/2/2020 10:04:07 AM[IFSCRWebSetup_IFSR]-The table 'INVENTORY_PART_A' could not be found. Error in File TnmtShpordBarc 28736_26664_.rpt:
The table could not be found.   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_IFSR\App_Code\Service.cs:line 1409
   at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetup_IFSR\App_Code\Service.cs:line 1381
   at Ifs_ReportService.LoadInfoServiceReport(String path, String DBUser, String DBPassword, String DBServerName, String AppOwner) in c:\inetpub\wwwroot\IFSCRWebSetup_IFSR\App_Code\Service.cs:line 1204

 

All other Crystal Reports work in both environments.

 

 

icon

Best answer by RutJWhalen 2 June 2020, 16:41

View original

4 replies

Userlevel 6
Badge +18

The table 'INVENTORY_PART_A' could not be found. Error in File TnmtShpordBarc 28736_26664_.rpt

The above error suggests an issue with the table/view getting referenced. Can you run the report directly in Crystal against the environment in question without any issue?

Userlevel 5
Badge +12

Hi,

If the same report is generating the expected output in another environment the problem might be with the object access. Check if necessary grants are there for INVENTORY_PART_A and it’s defined with APPOWNER. prefix in the database logic.

Userlevel 7
Badge +18

@Srikanth and @Ruchira 

Thank you very much for your replies.

It turned out that user IFSPRINT didn’t have access to the company/sites AND after granting the permission set IFSAPP_ALL to user IFSPRINT the issue was resolved.

Best Regards.

John

Userlevel 6
Badge +18

Glad the CWS issue is resolved now.

Reply