Solved

Failed to retrieve Report.Please Contact your System Administrator.

  • 15 February 2022
  • 5 replies
  • 656 views
mwilliams
Rank
Userlevel 1
Badge +3

Hi,

We are using IFS version 9 and I have a Quick Report (Crystal Report) which reads a number of IAL’s. When I view the report through Quick reports, the report was working OK.  I then included another IAL which reads  2 tables   IFSAPP.invoice_tab and IFSAPP.customer_order_inv_head_cft.  Our IAL’s are under IFSINFO.  The report was working ok until I included this last IAL.  It works ok inside Crystal Developer when I connect as ISAPP but when I run through IFS Quick Reports logged in to IFS  as IFSAPP I get the error
‘Failed to retrieve Report. Please Contact your System Administrator.’ and nothing else. 

any ideas ?
 

icon

Best answer by Charith Epitawatta 15 February 2022, 17:26

View original
This topic has been closed for comments

5 replies

Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @mwilliams,

Could you please try granting SELECT privileges on customer_order_inv_head_cft table to both IFSSYS and IFSPRINT users and see if that resolves the problem? If you are using Custom Field views or tables in Crystal Reports, they need to be granted to above users. 

If that does not resolve the issue, please look at the error in Crystal Web Service log file. That should have some clues as to where the problem lies. The log file should be at a place similar to "C:\inetpub\wwwroot\IFSCRWebSetup\IFSCRWebSetup_logs.log" in Crystal Web Service host.

Hope this helps!

Charith - https://charith.xyz
mwilliams
Rank
Userlevel 1
Badge +3

Thanks @Charith Epitawatta, It also looks like you can only build IALS over tables _TAB and _CFT .  If you try to reference base IFS views or CFV’s in your IAL’s then the Crystal report runs with no data returned.

mwilliams
Rank
Userlevel 1
Badge +3

@Charith Epitawatta I am now getting this issue in a different report, I hope you can help with this please.  I am getting the pop up window with this again ‘Failed to retrieve Report.Please Contact your System Administrator.’  There is an error at the end 

 

16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] File Name : BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] The file C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt is found
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetParameterCount] for BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetParameterCount] Report Document parameter count : 0
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetParameterCount] Parameter count : 0
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] File Name : BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] The file C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt is found
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[ExtractLogOnInfoA] File path : C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[ExtractLogOnInfoA] Loading the CR document.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetLogonInfoFromTable] Check database objects' access details. 
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetLogonInfoFromTable] Database objects count : 2
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetLogonInfoFromTable] CR Table Name : BA_GENERAL_S3_IAL_I
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetLogonInfoFromTable] CR Table Name : CD_GENERAL_S3_IAL_I
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetStringValue] Manipulating the logon information. >> 35
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetStringValue] Result : BA_GENERAL_S3_IALCD_GENERAL_S3_IAL
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[ExtractLogOnInfoA] Logon Information : NOTHERTABLES=0NUSEDTABLES=2TABLENAMES=USERIDS=DATABASENAMES=SERVERNAMES=USEDTABLES=BA_GENERAL_S3_IALCD_GENERAL_S3_IAL
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[base64Encode] for NOTHERTABLES=0NUSEDTABLES=2TABLENAMES=USERIDS=DATABASENAMES=SERVERNAMES=USEDTABLES=BA_GENERAL_S3_IALCD_GENERAL_S3_IAL
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[base64Encode] Encoded value : Tk9USEVSVEFCTEVTPTAdTlVTRURUQUJMRVM9Mh1UQUJMRU5BTUVTPR1VU0VSSURTPR1EQVRBQkFTRU5BTUVTPR1TRVJWRVJOQU1FUz0dVVNFRFRBQkxFUz1CQV9HRU5FUkFMX1MzX0lBTBxDRF9HRU5FUkFMX1MzX0lBTA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] File Name : BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] The file C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt is found
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] Check the output file type of the report.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] 
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] NoFormat###
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] NoFormat###CrystalReport###
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] NoFormat###CrystalReport###RichText###
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###HTML32###
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###HTML32###HTML40###
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[ExportReport] Exporting the report in type : CrystalReport
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[ExportReport] File Name : BA_BRO_ADDR_(v0.1).rpt ,WebUser : IFSAPP ,SecuredReport : NO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[LoadReport] Loading report : C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[LoadReport] DBUser = IFSSYS ,DBPassword : ******* ,DBServerName : TEST ,AppOwner : IFSAPP
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[LoadReport] Processing 2 parameters.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[SetTableLocation] Set appropriate post-fixes for BA_GENERAL_S3_IAL_I
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[SetDatabaseLocation] Generating fully qualified database object name for BA_GENERAL_S3_IAL_I
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[SetDatabaseLocation] Table.Location : IFSINFO.BA_GENERAL_S3_IAL
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[SetTableLocation] Set appropriate post-fixes for CD_GENERAL_S3_IAL_I
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[SetDatabaseLocation] Generating fully qualified database object name for CD_GENERAL_S3_IAL_I
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[SetDatabaseLocation] Table.Location : IFSINFO.CD_GENERAL_S3_IAL
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[LoadReport] The report contains 0 subreports.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[ExportReport] Number of subreports : 0
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[SetDefaultReportParameters] Setting up default parameters to 
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[getExportReport] Exporting the doc in CrystalReport format.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-ERROR in [ExportReport] Error in exporting the report in CrystalReport format.
16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-Value cannot be null.

A
Rank
Userlevel 2
Badge +6

Thanks @Charith Epitawatta, It also looks like you can only build IALS over tables _TAB and _CFT .  If you try to reference base IFS views or CFV’s in your IAL’s then the Crystal report runs with no data returned.

Depending on the mode of IAL it is acting as a table (quick access) or view. While your reports are getting data with IFSRINT, site, company or position based rowlevel security mechanisms can avoid you from getting data from views so you have to keep the data security and accessibility in mind while designing your IALs.

Ahmet GULTEKIN
Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @mwilliams,

Thanks @Charith Epitawatta, It also looks like you can only build IALS over tables _TAB and _CFT .  If you try to reference base IFS views or CFV’s in your IAL’s then the Crystal report runs with no data returned.

Depending on the mode of IAL it is acting as a table (quick access) or view. While your reports are getting data with IFSRINT, site, company or position based rowlevel security mechanisms can avoid you from getting data from views so you have to keep the data security and accessibility in mind while designing your IALs.

I also agree with above response from Ahmet.

Regarding the error you got for the other report, could you please refer to the “Design and Security aspects” section of following documentation and see if you have followed all the guidelines? 

 https://docs.ifs.com/techdocs/foundation1/050_development/025_operational_reporting/200_cr_as_operationalreport/default.htm#Design_and_Security_aspects

Since there is a “value cannot be null” error in your log, pay special attention to following points in above documentation:

  • Report Selection Formula
  • Other Report Parameters
  • IFS specific report parameters
  • Crystal Commands are not supported

Hope this helps!

Charith - https://charith.xyz
Terms & ConditionsCookie settings