Skip to main content

Issue Short Description: After clone from PROD to Non-PROD environment, Crystal reports are not working.

 

Log:
>GetAppSetting] Get the value for OpenReportPath from Web.config.
>LoadReport] Loading report : F:\IFS\crystal\OpenReportPath\Component Repair Card.rpt
>LoadReport] DBUser = ifssys ,DBPassword : ******* ,DBServerName : DB_Server_name ,AppOwner : IFSAPP
>LoadReport] Processing 9 parameters.
>SetTableLocation] Set appropriate post-fixes for CR_WEB_INIT_A
>SetDatabaseLocation] Generating fully qualified database object name for CR_WEB_INIT_A
ERROR in ExportReportWithParametersAndlogonInfo] Error in exporting the report in rpt format. Logon failed.
Details:   Database Vendor Code: 1017 ] Logon failed.
Unable to connect: incorrect log on parameters.
Details:  ÂDatabase Vendor Code: 1017 ]   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\App_Code\Service.cs:line 1405
   at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetup\App_Code\Service.cs:line 1381
   at Ifs_ReportService.LoadReport(String path, String DBUser, String DBPassword, String DBServerName, String LogonInfoValues, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetup\App_Code\Service.cs:line 1284
   at Ifs_ReportService.ExportReportWithParametersAndlogonInfo(String FileName, String WebUser, String SecuredReportRequired, String ParameterValues, String LogonInfoValues, String ExportType) in c:\inetpub\wwwroot\IFSCRWebSetup\App_Code\Service.cs:line 724

Hi @GAUTAM CHAUDHARY ,

 

Verify the credentials from CrystalWebService_XXXX.zip file and change it in the Crystal web instance directory if you find any difference. Restart the Crystal web server and verify the report. If still not working then you may try to reconfigure using ifs installer.cmd and then take the ifs-crystal-config.xml from ifs_home/instance/instance_name/CrystalWebService_XXXX.zip and replace it in the Crystal web instance directory. This will ensure you will have the correct encrypted password in the configuration, so the reports will work. Make sure the TNS is correct after replacing the ifs-crystal-config.xml file. Restart the Crystal web server and verify the report. 

 

Best Regards,
Dharmendra

HI @Dharmendra ,

Thanks for your answer. The suggested solution works.

Regards,

Gautam

Reply


Terms & ConditionsCookie settings