Sivakumar Gopi Posted January 28, 2021 Share Posted January 28, 2021 Hi This new myibi looks great! In one of my task I do a table request to get some values, which I then read (READFILE) to save them in variables. I need these variables for other reports. It works fine in DEV and QA environments but failed when it went to PREPROD. I was able to find out the issue was because of the HOLDLIST setting. In all the environments the variable is set as ALL (checked using SET). In DEV and QA, immediately after table request it changes to PRINTONLY and so we were getting the right values for the variables. But in PREPROD, it was passing wrong values because as the HOLDIST variable did not change to PRINTONLY from ALL. I verified this by placing SET HOLDLIST at different places of the code. Has anyone experienced similar issues before For now I have added a ON TABLE SET HOLDLIST PRINTONLY to make it work but I wanted to know what could be the reason. Update: The issue occurs when procedure is ran through reportCaster in PREPROD. Thank you, SG Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted January 29, 2021 Share Posted January 29, 2021 Hi Slvakumar Welcome to myibi, I am glad you are enjoying it! Check the server profile (edasprof.prf) on the DEV and QA the SET HOLDLIST might be set in there and not on your PREPROD environment. Link to comment Share on other sites More sharing options...
Sivakumar Gopi Posted January 29, 2021 Author Share Posted January 29, 2021 Hi @chuck.wolff I did check the edasprof file in all the environments. It is set to ALL in all the environments. And one more thing that I noticed recently is that it works fine when ran from HTML page. This happens when ran through ReportCaster. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted January 30, 2021 Share Posted January 30, 2021 Hi Sivakumar ReportCaster jobs run through the reporting server so that setting should be in place and used. I think you need to report this discrepancy to techsupport. Link to comment Share on other sites More sharing options...
Martin Yergeau Posted February 1, 2021 Share Posted February 1, 2021 Sivakumar, have you check that you dont have any SITE_PROFILE which may change HOLDLIST setting Those are not executed from Report Caster image.png1032207 8.75 KB Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted February 1, 2021 Share Posted February 1, 2021 Good suggestion Martin However, if it is affecting ReportCaster it would be the Universal Profile Link to comment Share on other sites More sharing options...
Sivakumar Gopi Posted February 2, 2021 Author Share Posted February 2, 2021 Thanks @MartinY. But we dont have a SITE_PROFILE defined in the environments. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now