Skip to main content
Solved

Crystal Web Server HTTP 500 Error

W
Do Gooder (Partner)
Forum|alt.badge.img+6

Hi,

 

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,

Best answer by WyrAndreM

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.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

5 replies

NickPorter
Superhero (Customer)
Forum|alt.badge.img+18
  • NickPorter
  • Superhero (Customer)
  • 317 replies
  • May 24, 2021

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

Charith Epitawatta
1 person likes this
  • Charith Epitawatta
    Charith Epitawatta
Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31

Hi @WyrAndreM,

WyrAndreM wrote:

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:

  1. RMB on the Crystal Logs directory and go to properties -> security.
  2. Click on Edit button.
  3. Select IIS_IUSRS from "Group or username" section.  
  4. 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!

Charith - https://charith.xyz
Dasun Navoda
pwlm
M
3 people like this
  • Dasun Navoda
    Dasun Navoda
  • pwlm
    pwlm
  • M
    MitDenukN
W
Do Gooder (Partner)
Forum|alt.badge.img+6
  • WyrAndreM
  • Author
  • Do Gooder (Partner)
  • 18 replies
  • May 24, 2021

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:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[OpenReport] File Name : test.rpt
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[OpenReport] The file D:\IFS\IFSShared\IFST NEW\Layout\test.rpt is found
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetParameterCount] for test.rpt
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetParameterCount] Report Document parameter count : 2
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetParameterCount] Parameter count : 0
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[OpenReport] File Name : test.rpt
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[OpenReport] The file D:\IFS\IFSShared\IFST NEW\Layout\test.rpt is found
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[ExtractLogOnInfoA] File path : D:\IFS\IFSShared\IFST NEW\Layout\test.rpt
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[ExtractLogOnInfoA] Loading the CR document.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetLogonInfoFromTable] Check database objects' access details. 
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetLogonInfoFromTable] Database objects count : 2
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetLogonInfoFromTable] CR Table Name : COMPANY_A
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetLogonInfoFromTable] CR Table Name : CR_WEB_INIT_A
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetStringValue] Manipulating the logon information. >> 19
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetStringValue] Result : COMPANYCR_WEB_INIT
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[ExtractLogOnInfoA] Logon Information : NOTHERTABLES=0NUSEDTABLES=2TABLENAMES=USERIDS=DATABASENAMES=SERVERNAMES=USEDTABLES=COMPANYCR_WEB_INIT
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[base64Encode] for NOTHERTABLES=0NUSEDTABLES=2TABLENAMES=USERIDS=DATABASENAMES=SERVERNAMES=USEDTABLES=COMPANYCR_WEB_INIT
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[base64Encode] Encoded value : Tk9USEVSVEFCTEVTPTAdTlVTRURUQUJMRVM9Mh1UQUJMRU5BTUVTPR1VU0VSSURTPR1EQVRBQkFTRU5BTUVTPR1TRVJWRVJOQU1FUz0dVVNFRFRBQkxFUz1DT01QQU5ZHENSX1dFQl9JTklU
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[OpenReport] File Name : test.rpt
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[OpenReport] The file D:\IFS\IFSShared\IFST NEW\Layout\test.rpt is found
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] Check the output file type of the report.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] 
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] NoFormat###
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] NoFormat###CrystalReport###
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] NoFormat###CrystalReport###RichText###
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###HTML32###
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###HTML32###HTML40###
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[ExportReport] Exporting the report in type : CrystalReport
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[ExportReport] File Name : test.rpt ,WebUser : IFSPRINT ,SecuredReport : NO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[LoadReport] Loading report : D:\IFS\IFSShared\IFST NEW\Layout\test.rpt
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[LoadReport] DBUser = ifssys ,DBPassword : ******* ,DBServerName : IFSTPDB ,AppOwner : IFSAPP
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[LoadReport] Processing 2 parameters.
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[SetTableLocation] Set appropriate post-fixes for COMPANY_A
24/05/2021 22:18:48[IFSCRWebSetupVMT]-[SetDatabaseLocation] Generating fully qualified database object name for COMPANY_A
24/05/2021 22:18:48[IFSCRWebSetupVMT]-ERROR in [ExportReport] 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
 

 

W
Do Gooder (Partner)
Forum|alt.badge.img+6
  • WyrAndreM
  • Author
  • Do Gooder (Partner)
  • 18 replies
  • May 24, 2021

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

 

W
Do Gooder (Partner)
Forum|alt.badge.img+6
  • WyrAndreM
  • Author
  • Do Gooder (Partner)
  • 18 replies
  • Answer
  • May 25, 2021

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.

durette
1 person likes this
  • durette
    durette
Terms & ConditionsCookie settings

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