Trying to set up Crystal Reports Web Service on IFS Cloud 23R1.
Print manager is showing error “No PDF report returned from Crystal Web Service”
The report runs in crystal reports against the instance database using IFSAPP but no other user-
The report worked fine in Apps10
Crystal Debug is showing:
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetAppSetting] Get the value for OpenReportPath from Web.config.
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetSavedPDFReport] Exporting the report in PDF format.
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetSavedPDFReport] File Name : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetSavedPDFReport] ParameterValues : 1510184 ,LangCode = en
10/5/2023 9:27:56 AM:IFSCRWebSetup]-ebase64Encode] for 1510184
10/5/2023 9:27:56 AM:IFSCRWebSetup]-ebase64Encode] Encoded value : MTUxMDE4NA==
10/5/2023 9:27:56 AM:IFSCRWebSetup]-ebase64Decode] for MTUxMDE4NA==
10/5/2023 9:27:56 AM:IFSCRWebSetup]-ebase64Decode] Decoded to 1510184
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM:IFSCRWebSetup]-eGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eOpenReport] File Name : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eIsFileNameValid] fileName : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eGetAppSetting] Get the value for OpenReportPath from Web.config.
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eIsFileNameValid] decodedFileName : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eIsFileNameValid] basePathDB : C:\inetpub\wwwroot\IFSCRWebSetup\IFSCRWebSetup\tmp\
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eIsFileNameValid] basePathServer : C:\IFSWEB
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eIsFileNameValid] rptFullpath : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eIsFileNameValid] canonicalPath : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eIsFileNameValid] returning true
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eOpenReport] The file C:\IFSWEB\en\PO.rpt is found
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eLoadInfoServiceReport] Loading infoServe report : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eLoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : testpdb ,AppOwner : IFSAPP
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eLoadInfoServiceReport] Setting up logon information for each database object.
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eSetTableLocation] Set appropriate post-fixes for PURCHASE_ORDER_PRINT_REP\
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eSetDatabaseLocation] Generating fully qualified database object name for PURCHASE_ORDER_PRINT_REP\
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eSetDatabaseLocation] Table.Location : PURCHASE_ORDER_PRINT_REP
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eSetTableLocation] Set appropriate post-fixes for PART_REVISION\
10/5/2023 9:27:57 AM:IFSCRWebSetup]-eSetDatabaseLocation] Generating fully qualified database object name for PART_REVISION\
10/5/2023 9:27:57 AM:IFSCRWebSetup]-ERROR in ELoadInfoServiceReport] Error in loading infoServices report.
10/5/2023 9:27:57 AM:IFSCRWebSetup]-Error in File PO 4788_5656_{9B4F6854-9A83-494B-AD1D-3FEB7BCAEEE6}.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\IFSCRWebSetup\App_Code\Service.cs:line 1756
at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetup\IFSCRWebSetup\App_Code\Service.cs:line 1728
at Ifs_ReportService.LoadInfoServiceReport(String path, String DBUser, String DBPassword, String DBServerName, String AppOwner) in c:\inetpub\wwwroot\IFSCRWebSetup\IFSCRWebSetup\App_Code\Service.cs:line 1551
10/5/2023 9:28:02 AM/IFSCRWebSetup]-AGetDbInfoFromXml] Decrypted.
10/5/2023 9:28:02 AM/IFSCRWebSetup]-AGetDbInfoFromXml] Decrypted.
10/5/2023 9:28:02 AM/IFSCRWebSetup]-AGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO
10/5/2023 9:28:02 AM/IFSCRWebSetup]-AGetDbInfoFromXml] Decrypted.
10/5/2023 9:28:02 AM/IFSCRWebSetup]-AGetDbInfoFromXml] Decrypted.
10/5/2023 9:28:02 AM/IFSCRWebSetup]-AGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO