Solved

Crystal Reports Web Service Setup Problem

  • 5 October 2023
  • 3 replies
  • 244 views
A
Rank
Userlevel 3
Badge +9

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]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetSavedPDFReport] Exporting the report in PDF format.
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetSavedPDFReport] File Name : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetSavedPDFReport] ParameterValues : 1510184 ,LangCode = en
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[base64Encode] for 1510184
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[base64Encode] Encoded value : MTUxMDE4NA==
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[base64Decode] for MTUxMDE4NA==
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[base64Decode] Decoded to 1510184
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:27:56 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[OpenReport] File Name : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[IsFileNameValid] fileName : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[IsFileNameValid] decodedFileName : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[IsFileNameValid] basePathDB : C:\inetpub\wwwroot\IFSCRWebSetup\IFSCRWebSetup\tmp\
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[IsFileNameValid] basePathServer : C:\IFSWEB
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[IsFileNameValid] rptFullpath : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[IsFileNameValid] canonicalPath : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[IsFileNameValid] returning true
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[OpenReport] The file C:\IFSWEB\en\PO.rpt is found
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[LoadInfoServiceReport] Loading infoServe report : C:\IFSWEB\en\PO.rpt
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : testpdb ,AppOwner : IFSAPP
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[LoadInfoServiceReport] Setting up logon information for each database object.
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[SetTableLocation] Set appropriate post-fixes for PURCHASE_ORDER_PRINT_REP\
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[SetDatabaseLocation] Generating fully qualified database object name for PURCHASE_ORDER_PRINT_REP\
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[SetDatabaseLocation] Table.Location : PURCHASE_ORDER_PRINT_REP
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[SetTableLocation] Set appropriate post-fixes for PART_REVISION\
10/5/2023 9:27:57 AM[IFSCRWebSetup]-[SetDatabaseLocation] Generating fully qualified database object name for PART_REVISION\
10/5/2023 9:27:57 AM[IFSCRWebSetup]-ERROR in [LoadInfoServiceReport] 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]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:28:02 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:28:02 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO
10/5/2023 9:28:02 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:28:02 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Decrypted.
10/5/2023 9:28:02 AM[IFSCRWebSetup]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-testpdb AppOwner-IFSAPP IALOwner-IFSINFO
 

 

icon

Best answer by Charith Epitawatta 5 October 2023, 18:09

View original

3 replies

NickPorter
Rank
Userlevel 6
Badge +18

@Alex Ivkovic is this a Quick Report or an Operational Report?  Any sub-report in it?

Per the log you included it looks like something may be inaccessible to the user that this is running as.  My first thought is that your missing something from the Cloud CR design limitations that are defined in the tech docs, maybe something simple like the alias indicator.

Some links that may help, but you’re likely already gone through these in detail:

https://docs.ifs.com/techdocs/23r1/060_development/026_br_and_a/005_adhoc_reporting/080_dev_crep/005_cr_as_quickreport/#deploying_crystal_reports_for_ifs_cloud_web

https://docs.ifs.com/techdocs/23r1/060_development/025_operational_reporting/200_cr_as_operationalreport/

https://docs.ifs.com/techdocs/23r1/060_development/025_operational_reporting/200_cr_as_operationalreport/030_ex_cr_operationalreport/010_add_params/

https://docs.ifs.com/techdocs/23r1/060_development/025_operational_reporting/200_cr_as_operationalreport/030_ex_cr_operationalreport/020_ex_multiple_view/

Cheers,

Nick

Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @Alex Ivkovic,

It seems  you are using a view named PART_REVISION in your report. IFS only supports standard report views(views that end with _REP) in Crystal Reports and if you use any other view, then you need to grant SELECT privileges on them to IFSPRINT and IFSSYS users. 

Please try granting the above mentioned view and see if there is any difference. 

Hope this helps!

Charith - https://charith.xyz
A
Rank
Userlevel 3
Badge +9

Hi @Alex Ivkovic,

It seems  you are using a view named PART_REVISION in your report. IFS only supports standard report views(views that end with _REP) in Crystal Reports and if you use any other view, then you need to grant SELECT privileges on them to IFSPRINT and IFSSYS users. 

Please try granting the above mentioned view and see if there is any difference. 

Hope this helps! 

 

Perfect! That was exactly the problem. I had to add about 15 views but then it ran 

The crystal logging is very handy for troubleshooting this as the view you need to add is right above the failure 

10/5/2023 1:53:30 PM[IFSCRWebSetup]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER\
10/5/2023 1:53:31 PM[IFSCRWebSetup]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
10/5/2023 1:53:31 PM[IFSCRWebSetup]-Error in File OrderConfirmationTest 3912_3452_{CB9E7583-7DB0-42A0-906F-C571254F46E2}.rpt:
The table could not be found.   at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)

Reply


Terms & ConditionsCookie settings