Question

Failed to Report. Please contact your sys admin

  • 17 January 2020
  • 5 replies
  • 1694 views
C
Rank

‘Failed to retrieve Report’

 

Hello Community, 

 

We’ve having an issue on our test environment, receiving the ‘Failed to retrieve Report’  message (Apps 9 UDP7) when running a CR quick report. Everything fine in IFSL

The database has been refreshed from Live a few months ago, but to list the numerous things we have tried with no luck.

  1. Checked reports work through Crystal. Can confirm yes
  2. Checked credentials of all sys, print, ifssys, ifsapp accounts. Can log in to all 
  3. Performed a middleware reconfig
  4. Report is in the correct <HOME>Layout folder
  5. System parameters updated
    1. Host where CRWeb is installed
    2. Virtual Directory given to CRWeb services
    3. Updated logos value
  6. Checked Inetpub/wwwroot IFSCRWebSetup XML config files to ensure they are using TNS to correct DB
  7. Restarted IIS
  8. Restarted ‘All Servers’ bin files 
  9. Restarted windows services
  10. Restarted Extended server
  11. Removed anything other than standard views
  12. I am using the CR_WEB_INIT\ with correct linking
  13. Using IFSPRINT as the user to connect 
  14. Report is closed!!! (how many times does that get me!)

Run out of ideas, this is the log file (below) from the CRWebSetup

 

Any pointers very appreciated.

Rob

 

17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[ExportReport] Exporting the report in type : CrystalReport
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[ExportReport] File Name : Vaselife.rpt ,WebUser : ifsapp ,SecuredReport : NO
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[GetDbInfoFromXml] Loading data from ifs-crystal-config.XML
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[DecryptPassword] Decrypting Password : CgQIhTz1NdiJknGBrr4+Le1pRA==
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[DecryptPassword] Starting the Command Prompt process for decryption.
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[DecryptPassword] Ending the CMD process.
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[DecryptPassword] Decrypted.
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[DecryptPassword] Decrypting Password : CgQICtsMAADrDQ1MHc27NRj3dg==
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[DecryptPassword] Starting the Command Prompt process for decryption.
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[DecryptPassword] Ending the CMD process.
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[DecryptPassword] Decrypted.
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFST AppOwner-IFSAPP IALOwner-IFSINFO
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[GetDbInfoFromXml] Loading completed. 
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[LoadReport] Loading report : D:\IFS\IFSShared\IFSReports\IFST\Layout\Vaselife.rpt
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[LoadReport] DBUser = IFSSYS ,DBPassword : ******* ,DBServerName : IFST ,AppOwner : IFSAPP
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[LoadReport] Processing 1 parameters.
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[SetTableLocation] Set appropriate post-fixes for CR_WEB_INIT\
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-[SetDatabaseLocation] Generating fully qualified database object name for CR_WEB_INIT\
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-ERROR in [ExportReport] Error in exporting the report in CrystalReport format.
17/01/2020 13:54:35[IFSCRWebSetupIFST_1]-Logon failed.
Details:  [Database Vendor Code: 1005 ] Logon failed.
Details:  [Database Vendor Code: 1005 ] Error in File Vaselife .rpt:
Unable to connect: incorrect log on parameters.
Details:  [Database Vendor Code: 1005 ]   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\IFSCRWebSetupIFST_1\App_Code\Service.cs:line 1634
   at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetupIFST_1\App_Code\Service.cs:line 1610
   at Ifs_ReportService.LoadReport(String path, String DBUser, String DBPassword, String DBServerName, String LogonInfoValues, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetupIFST_1\App_Code\Service.cs:line 1513
   at Ifs_ReportService.ExportReport(String FileName, String WebUser, String SecuredReportRequired, String ExportType) in c:\inetpub\wwwroot\IFSCRWebSetupIFST_1\App_Code\Service.cs:line 903
 

5 replies

NickPorter
Rank
Userlevel 6
Badge +18

The error log is still indicating that it is a login issue.

Did you set the encrypted passwords in the ifs-crystal-config.xml file?  If the DB is a copy of Live DB, and the passwords are different, you might have different encrypted values (even for the same password value)

In addition to what you already changed, did you also make sure that the following System Parameters are set correctly?

  • “Extended Server URL”
  • “Specify if web database access security check is required”

Are any of the reports hard coded to a specific database and need to be changed?

Is the directory that holds the rpt files correct in the web.config file on CR web server?

Nick

C
Rank

Thanks for taking the time to reply.

 

The ifs-crystal-config.xml sits outside of anywhere we’d refresh data from IFSL (we pretty much only restore the DB, then run the installer in re-config), but I have copied the encrypted string from live across to the IFST ones, restarted IIS and still no luck.

Is there a way to regenerate these passwords?

 

Yes on the Extended Server Url

And and security value set to ‘No’

 

I don’t believe so, even through the are created and tested on a CR server using ODBC (slightly different name/connection string to TNS). So we develop against test using the IFST credentials, then merely copy the file in the IFSL layout, without changing anything the report. Thus suggesting nothing hard coded.

Yes, can confirm layout path is correct too.

 

Thanks again 

Rob

Rusiru Dharmadasa
Rank
Userlevel 7
Badge +19

Quick reports use IFSSYS user to connect to db. Most probably you might have different passwords in LIVE and this environment so now TEST db has wrong password - coming from LIVE. 

 

Do a reconfiguration using ifs installer.cmd and then take ifs-crystal-config.xml from ifshome/instance/<instance_name>/ifs-crystal...zip and replace it in crystal web instance directory. This will make sure you will have the correct encrypted password in configuration so the report should work. Make sure the tns corrected after replacing the ifs-crystal-config.xml file

Rusiru
NickPorter
Rank
Userlevel 6
Badge +18

You said you copied the encrypted string from Live system files to Test system files, but that won’t work. 

You’ll need to take the encrypted values from Test after you reconfigure and make sure that they match the ones in ifs-crystal-config.xml.  If not then copy the values from the Test crystal config zip file after reconfiguration to the deployed Test ifs-crystal-config.xml file.  Regardless of whether the actual password values you enter are the same or not, you will get a different encrypted value in the file between systems.

Nick

ChanakaAmarasekara
Rank
Userlevel 7
Badge +15

It says login issue. As Rusiru pointed out Quick Reports uses IFSSYS to login but do an impersination of the logged in user when running  the report and Operational Reports uses IFSPRINT. Maybe what's in the database is not the encrypted password.  Do a reconfiguration and use the newly generated xml in the CWS zip by replacing and check again.

Also make sure that the Oracle Client runtime is the same bit version as the Crystal. Net runtime and also make sure that only one version of Oracle and Crystal .Net runtime is installed.

Check if Java is installed and Java home and Java home\bin is set in the system path and the first path.

Make sure the NTS line is sql.net file is commented. This is given in the technology installation document. 

If you are using a 32bit version of Oracle and Crystal .Net runtime the check 32bit application support is enabled.

If you are logging in as an end user then make sire that end user has necessary access right to the views used in the rreport. You said logging ìn as IFSPRINT. If this is a quick report then the vies are not accessible. The previewing with the appowner.

 

 

- Chanaka Am -

Reply


Terms & ConditionsCookie settings