Skip to main content
Solved

After clone Crystal reports are not working.

  • August 29, 2024
  • 2 replies
  • 135 views

Forum|alt.badge.img+1

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

Best answer by Dharmendra

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

View original
Did this topic help you find an answer to your question?

2 replies

Dharmendra
Hero (Employee)
Forum|alt.badge.img+6
  • Hero (Employee)
  • 46 replies
  • Answer
  • August 29, 2024

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


Forum|alt.badge.img+1

HI @Dharmendra ,

Thanks for your answer. The suggested solution works.

Regards,

Gautam


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings