Has anyone got any suggestions to a possible route cause?
Note I am doing this from a clone onto a new server VM, I know the passwords for the likes of IFSSYS and IFSPRINT not sure if that is the problem.
I am setting up crystal web service 64 bit I have done the following.
Installed 19c Database Client 64 Bit and commented out SQL Net Ora connection, Created TNS entry for target DB.
I have Amended the Machine.Config File for the .net framework.
I have installed Java and set my system environment variable.
Configured server for IIS with relevant compatibility support.
Installed 64 bit Crystal Web Service and Installed 64 bit Run time.
Installed .net 4.5 and set the CWS for the application pool.
Amended the crystal config file for the TNS entry.
I can Invoke certain operations on the report services such as check for CR web init.
But when I check the get saved report A I either get a HTTP 500 error in IE or in Chrome I get an error for failing to load database information.
Additionally the test operation yields the following.
Many Thanks,
Page 1 / 1
Did you definitely install the Crystal Web Service from the correct zip file? Being a clone (by which I take it you mean a clone of the Application Server) you might find that the encrypted passwords stored in the config file are not correct for the database.
You may need to reconfigure the AS to recreate the CR Web Service zip files to get valid hashed passwords for the instance.
Also, ensure that the instance name in the config file with the encrypted passwords matches the TNS entry on the server, and test connection via SQLPlus or similar from the server running Crystal to validate that is working and resolving as expected.
Nick
Hi @WyrAndreM,
Note I am doing this from a clone onto a new server VM, I know the passwords for the
I am assuming the clone here is a clone of the Crystal Web Server host.
Do you have Crystal logging enabled? You should find a much more comprehensive error if you check the logs.
The log file should be at a place similar to "C:\inetpub\wwwroot\IFSCRWebSetup\IFSCRWebSetup_logs.log"
If you don't have logging enabled, run "C:\inetpub\wwwroot\IFSCRWebSetup\CR_WEB_Log.exe" and select “High” to enable logging.
Sometimes you need to give permissions to IIS_IUSRS user to logs directory as well. Otherwise you would see an empty log file.
To do that:
RMB on the Crystal Logs directory and go to properties -> security.
Click on Edit button.
Select IIS_IUSRS from "Group or username" section.
Allow "full control" for IIS_IUSRS and save.
Once logging is enabled, invoke a report again and inspect the log file.
Most likely the problem is the passwords are not correct in the config files as Nick as mentioned, in which case you would have to use the latest version of the CWS zip file to create the CWS instance.
Hope this helps!
Thanks for the information both, I have double checked that the CWS is the 64 bit post re-config to make sure the correct hashed passwords are in the config file and that the Config file reflects a tested TNSname entry, I have high level logs which spit out the following after trying to preview test report.
Log File -
24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:18:482IFSCRWebSetupVMT]-uOpenReport] File Name : test.rpt 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetAppSetting] Get the value for OpenReportPath from Web.config. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uOpenReport] The file D:\IFS\IFSShared\IFST NEW\Layout\test.rpt is found 24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetParameterCount] for test.rpt 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetAppSetting] Get the value for OpenReportPath from Web.config. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetParameterCount] Report Document parameter count : 2 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetParameterCount] Parameter count : 0 24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:18:482IFSCRWebSetupVMT]-uOpenReport] File Name : test.rpt 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetAppSetting] Get the value for OpenReportPath from Web.config. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uOpenReport] The file D:\IFS\IFSShared\IFST NEW\Layout\test.rpt is found 24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetAppSetting] Get the value for OpenReportPath from Web.config. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uExtractLogOnInfoA] File path : D:\IFS\IFSShared\IFST NEW\Layout\test.rpt 24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uDecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:18:482IFSCRWebSetupVMT]-uExtractLogOnInfoA] Loading the CR document. 24/05/2021 22:18:482IFSCRWebSetupVMT]-uGetLogonInfoFromTable] Check database objects' access details. 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetLogonInfoFromTable] Database objects count : 2 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetLogonInfoFromTable] CR Table Name : COMPANY_A 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetLogonInfoFromTable] CR Table Name : CR_WEB_INIT_A 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetStringValue] Manipulating the logon information. >> 19 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetStringValue] Result : COMPANYCR_WEB_INIT 24/05/2021 22:18:482IFSCRWebSetupVMT]-tExtractLogOnInfoA] Logon Information : NOTHERTABLES=0NUSEDTABLES=2TABLENAMES=USERIDS=DATABASENAMES=SERVERNAMES=USEDTABLES=COMPANYCR_WEB_INIT 24/05/2021 22:18:482IFSCRWebSetupVMT]-tbase64Encode] for NOTHERTABLES=0NUSEDTABLES=2TABLENAMES=USERIDS=DATABASENAMES=SERVERNAMES=USEDTABLES=COMPANYCR_WEB_INIT 24/05/2021 22:18:482IFSCRWebSetupVMT]-tbase64Encode] Encoded value : Tk9USEVSVEFCTEVTPTAdTlVTRURUQUJMRVM9Mh1UQUJMRU5BTUVTPR1VU0VSSURTPR1EQVRBQkFTRU5BTUVTPR1TRVJWRVJOQU1FUz0dVVNFRFRBQkxFUz1DT01QQU5ZHENSX1dFQl9JTklU 24/05/2021 22:18:482IFSCRWebSetupVMT]-tDecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-tDecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:18:482IFSCRWebSetupVMT]-tOpenReport] File Name : test.rpt 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetAppSetting] Get the value for OpenReportPath from Web.config. 24/05/2021 22:18:482IFSCRWebSetupVMT]-tOpenReport] The file D:\IFS\IFSShared\IFST NEW\Layout\test.rpt is found 24/05/2021 22:18:482IFSCRWebSetupVMT]-tDecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-tDecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetExportTypes] Check the output file type of the report. 24/05/2021 22:18:482IFSCRWebSetupVMT]-tGetExportTypes] 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetExportTypes] NoFormat### 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetExportTypes] NoFormat###CrystalReport### 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetExportTypes] NoFormat###CrystalReport###RichText### 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows### 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel### 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat### 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###HTML32### 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###HTML32###HTML40### 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eDecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eDecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eExportReport] Exporting the report in type : CrystalReport 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eExportReport] File Name : test.rpt ,WebUser : IFSPRINT ,SecuredReport : NO 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eDecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eDecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetDbInfoFromXml] Decrypted. 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eGetAppSetting] Get the value for OpenReportPath from Web.config. 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eLoadReport] Loading report : D:\IFS\IFSShared\IFST NEW\Layout\test.rpt 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eLoadReport] DBUser = ifssys ,DBPassword : ******* ,DBServerName : IFSTPDB ,AppOwner : IFSAPP 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eLoadReport] Processing 2 parameters. 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eSetTableLocation] Set appropriate post-fixes for COMPANY_A 24/05/2021 22:18:48 IFSCRWebSetupVMT]-eSetDatabaseLocation] Generating fully qualified database object name for COMPANY_A 24/05/2021 22:18:48 IFSCRWebSetupVMT]-ERROR in EExportReport] Error in exporting the report in CrystalReport format. 24/05/2021 22:18:48 IFSCRWebSetupVMT]-Failed to load database information. Error in File test 9304_12188_{3D8DE62C-810F-46B1-A655-3B53FA7B843E}.rpt: Failed to load database information. 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\IFSCRWebSetupVMT\App_Code\Service.cs:line 1409 at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetupVMT\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\IFSCRWebSetupVMT\App_Code\Service.cs:line 1284 at Ifs_ReportService.ExportReport(String FileName, String WebUser, String SecuredReportRequired, String ExportType) in c:\inetpub\wwwroot\IFSCRWebSetupVMT\App_Code\Service.cs:line 659
Thanks for the information both, I have double checked points with hashed password and TNS entry and generated high level logs with the following.
24/05/2021 22:38:18[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA== 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted. 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted. 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[GetAppSetting] Get the value for OpenReportPath from Web.config. 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[LoadReport] Loading report : D:\IFS\IFSShared\IFST NEW\Layout\test.rpt 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[LoadReport] DBUser = ifssys ,DBPassword : ******* ,DBServerName : IFSTPDB ,AppOwner : IFSAPP 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[LoadReport] Processing 2 parameters. 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[SetTableLocation] Set appropriate post-fixes for COMPANY_A 24/05/2021 22:38:18[IFSCRWebSetupVMT]-[SetDatabaseLocation] Generating fully qualified database object name for COMPANY_A 24/05/2021 22:38:18[IFSCRWebSetupVMT]-ERROR in [ExportReport] Error in exporting the report in CrystalReport format. 24/05/2021 22:38:18[IFSCRWebSetupVMT]-Failed to load database information. Error in File test 9304_12164_{48B67BFE-20CF-435F-AA20-94CA49128B2C}.rpt: Failed to load database information. 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\IFSCRWebSetupVMT\App_Code\Service.cs:line 1409 at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetupVMT\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\IFSCRWebSetupVMT\App_Code\Service.cs:line 1284 at Ifs_ReportService.ExportReport(String FileName, String WebUser, String SecuredReportRequired, String ExportType) in c:\inetpub\wwwroot\IFSCRWebSetupVMT\App_Code\Service.cs:line 659
Thanks the issue seemed to boil down to an error in the tns names file for the way it was structured. SQL developer qualified it but when running a tnsping issues had occurred. Thanks for the help.
