I’m unable to preview Crystal Reports in my Test IFS Apps 9 DB. I’ve recently updated the Test DB from Live, and copied all the crystal files too., and also updated values in SYSTEM PARAMETERS.
I’ve edited the database location in Crystal from IFSL to IFSR and can successfully preview data in reports from within Crystal.
But as soon as i try and preview the report from with IFS, i get the following error
and the following error in the crystal log. Any advice gratefully received. Thanks, Chris
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[OpenReport] File Name : en\PurchaseOrderPrintRepv2.rpt
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[OpenReport] The file D:\IFS\IFSShared\IFSReports\IFSR\Layout\en\PurchaseOrderPrintRepv2.rpt is found
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[GetSavedPDFReport] Exporting the report in PDF format.
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[GetSavedPDFReport] File Name : PurchaseOrderPrintRepv2.rpt
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[GetDbInfoFromXml] Loading data from ifs-crystal-config.XML
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[DecryptPassword] Decrypting Password : CgQIfu7ljkXXJ3w9HQIf2m60UU14eBDTmd2F
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[DecryptPassword] Starting the Command Prompt process for decryption.
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[DecryptPassword] Ending the CMD process.
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[DecryptPassword] Decrypted.
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[DecryptPassword] Decrypting Password : CgQIcdK9C7bd7wW5kJfJfWvCr3KwhMwWztDM
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[DecryptPassword] Starting the Command Prompt process for decryption.
30/07/2021 10:36:29[IFSCRWebSetupIFSR_3]-[DecryptPassword] Ending the CMD process.
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[DecryptPassword] Decrypted.
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSR AppOwner-IFSAPP IALOwner-IFSINFO
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[GetDbInfoFromXml] Loading completed.
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[base64Decode] for NjMzMjAy
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[base64Decode] Decoded successfully.
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[GetSavedPDFReport] Result Key : 633202 ,LangCode = en
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[LoadInfoServiceReport] Loading infoServe report : D:\IFS\IFSShared\IFSReports\IFSR\Layout\en\PurchaseOrderPrintRepv2.rpt
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : IFSR ,AppOwner : IFSAPP
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[LoadInfoServiceReport] Setting up logon information for each database object.
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[SetTableLocation] Set appropriate post-fixes for PURCHASE_ORDER_PRINT_REP_A
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-[SetDatabaseLocation] Generating fully qualified database object name for PURCHASE_ORDER_PRINT_REP_A
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-Failed to open the connection. Failed to open the connection.
PurchaseOrderPrintRepv2 {E489DEDA-3837-4890-B809-03A874038E61}.rpt 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\IFSCRWebSetupIFSR_3\App_Code\Service.cs:line 1614
at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetupIFSR_3\App_Code\Service.cs:line 1589
at Ifs_ReportService.LoadInfoServiceReport(String path, String DBUser, String DBPassword, String DBServerName, String AppOwner) in c:\inetpub\wwwroot\IFSCRWebSetupIFSR_3\App_Code\Service.cs:line 1417
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-ERROR in [GetSavedPDFReport] Error in exporting the report in PDF format.
30/07/2021 10:36:30[IFSCRWebSetupIFSR_3]-Object reference not set to an instance of an object. at Ifs_ReportService.GetSavedPDFReport(String FileName, String ParameterValues, String LangCode) in c:\inetpub\wwwroot\IFSCRWebSetupIFSR_3\App_Code\Service.cs:line 280
