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!
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.
@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]-pDecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pDecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pOpenReport] File Name : BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pOpenReport] The file C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt is found
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pDecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pDecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetParameterCount] for BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetParameterCount] Report Document parameter count : 0
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetParameterCount] Parameter count : 0
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pDecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pDecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pOpenReport] File Name : BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pOpenReport] The file C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt is found
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pDecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pDecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pExtractLogOnInfoA] File path : C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pDecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pDecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pExtractLogOnInfoA] Loading the CR document.
16/02/2022 21:11:22 IFSCRWebSetupTEST_1]-pGetLogonInfoFromTable] Check database objects' access details.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetLogonInfoFromTable] Database objects count : 2
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetLogonInfoFromTable] CR Table Name : BA_GENERAL_S3_IAL_I
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetLogonInfoFromTable] CR Table Name : CD_GENERAL_S3_IAL_I
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetStringValue] Manipulating the logon information. >> 35
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetStringValue] Result : BA_GENERAL_S3_IALCD_GENERAL_S3_IAL
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uExtractLogOnInfoA] Logon Information : NOTHERTABLES=0NUSEDTABLES=2TABLENAMES=USERIDS=DATABASENAMES=SERVERNAMES=USEDTABLES=BA_GENERAL_S3_IALCD_GENERAL_S3_IAL
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-ubase64Encode] for NOTHERTABLES=0NUSEDTABLES=2TABLENAMES=USERIDS=DATABASENAMES=SERVERNAMES=USEDTABLES=BA_GENERAL_S3_IALCD_GENERAL_S3_IAL
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-ubase64Encode] Encoded value : Tk9USEVSVEFCTEVTPTAdTlVTRURUQUJMRVM9Mh1UQUJMRU5BTUVTPR1VU0VSSURTPR1EQVRBQkFTRU5BTUVTPR1TRVJWRVJOQU1FUz0dVVNFRFRBQkxFUz1CQV9HRU5FUkFMX1MzX0lBTBxDRF9HRU5FUkFMX1MzX0lBTA==
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uDecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uDecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uOpenReport] File Name : BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uOpenReport] The file C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt is found
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uDecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uDecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetExportTypes] Check the output file type of the report.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-uGetExportTypes]
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetExportTypes] NoFormat###
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetExportTypes] NoFormat###CrystalReport###
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetExportTypes] NoFormat###CrystalReport###RichText###
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###HTML32###
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetExportTypes] NoFormat###CrystalReport###RichText###WordForWindows###Excel###PortableDocFormat###HTML32###HTML40###
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tDecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tDecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tExportReport] Exporting the report in type : CrystalReport
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tExportReport] File Name : BA_BRO_ADDR_(v0.1).rpt ,WebUser : IFSAPP ,SecuredReport : NO
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tDecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tDecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetDbInfoFromXml] Decrypted.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tGetAppSetting] Get the value for OpenReportPath from Web.config.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tLoadReport] Loading report : C:\IFS\IFSShared\IFSReports\Layout\BA_BRO_ADDR_(v0.1).rpt
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tLoadReport] DBUser = IFSSYS ,DBPassword : ******* ,DBServerName : TEST ,AppOwner : IFSAPP
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tLoadReport] Processing 2 parameters.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tSetTableLocation] Set appropriate post-fixes for BA_GENERAL_S3_IAL_I
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tSetDatabaseLocation] Generating fully qualified database object name for BA_GENERAL_S3_IAL_I
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tSetDatabaseLocation] Table.Location : IFSINFO.BA_GENERAL_S3_IAL
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tSetTableLocation] Set appropriate post-fixes for CD_GENERAL_S3_IAL_I
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tSetDatabaseLocation] Generating fully qualified database object name for CD_GENERAL_S3_IAL_I
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tSetDatabaseLocation] Table.Location : IFSINFO.CD_GENERAL_S3_IAL
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tLoadReport] The report contains 0 subreports.
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tExportReport] Number of subreports : 0
16/02/2022 21:11:222IFSCRWebSetupTEST_1]-tSetDefaultReportParameters] Setting up default parameters to
16/02/2022 21:11:220IFSCRWebSetupTEST_1]-egetExportReport] Exporting the doc in CrystalReport format.
16/02/2022 21:11:220IFSCRWebSetupTEST_1]-ERROR in 1ExportReport] Error in exporting the report in CrystalReport format.
16/02/2022 21:11:220IFSCRWebSetupTEST_1]-Value cannot be null.
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.
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!
