Question

16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-Value cannot be null.

2 years ago
17 February 2022
4 replies
130 views

Userlevel 1

+3

mwilliams
Do Gooder (Customer)
7 replies

Hi All- I am getting this error in my Crystal Report (please scroll to the end), Many Thanks.

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.

This topic has been closed for comments

4 replies

Userlevel 5

+15

knepiosko
Hero (Partner)
303 replies
1 year ago
13 October 2022

Hello @mwilliams

I faced the same issue: Value cannot be null. Do You know what was the reason?

Userlevel 7

+15

ChanakaAmarasekara
Hero (Employee)
336 replies
1 year ago
17 October 2022

Hi,

Can you tell me what is the track you are in?

If this is a Quick Report (assuming it is as your are using IAL views) then I don’t see any details about the CR_WEB_INIT stored procedure in the log file. Hence I’m assuming that this is not added. If so, you need to add it to the layout. If not, you might see these kind of issue due to access rights. See below link for design guidelines.

https://docs.ifs.com/techdocs/Foundation1/050_development/026_br_and_a/005_adhoc_reporting/080_dev_crep/005_cr_as_quickreport/010_example/default.htm

https://docs.ifs.com/techdocs/Foundation1/050_development/026_br_and_a/005_adhoc_reporting/080_dev_crep/005_cr_as_quickreport/020_cr_wb_init/default.htm

Try adding the CR_WEB_INIT stored procedure and verify if it resolved the issue.

Regards.

Chanaka

Userlevel 1

+3

mwilliams
Author
Do Gooder (Customer)
7 replies
1 year ago
17 October 2022

From memory, I think it was due to a grant issue. The Crystal report was trying to access an IAL which wasn’t granted to IFSPRINT.

Userlevel 7

+15

ChanakaAmarasekara
Hero (Employee)
336 replies
1 year ago
17 October 2022

That is why you should add the CR_WEB_INIT. For quick reports the user that logs in to the database is not IFSPRINT. It’s IFSSYS. For Operational Reports if IFSPRINT. So if there is an issue of access for IFSSYS you might get this error. Adding the CR_WEB_INIT will make sure that the data is fetched from the current logged in user. So if the current user has access to the relevant IAL views then it should work. Try adding the CR_WEB_INIT according to the guide and check if it resolves the issue.