We recently updated our IBM i OS from V6R1 to V7R1. On V6R1 we were already running V2R1 of DB2 Web Query. Our current PTF group for web query is SF99647. After the OS update, we have a number of users on different reports where when they go to run a report that does prompting for parameters, the reports with a drop down list on a parameter no longer have any data listed in the drop down list.
To eliminate this being an authority issue with the IBM i authority, I tried to give the user profile *ALLOBJ authority. Still no data appeared in the drop down list. Next I added the user to the Web Query Administrator Group and the drop down list then had the desired data. I removed that *ALLOBJ authority from the profile and retried with the drop down data still appearing. Removing the user from Web Query Administrator and retrying caused the drop down data to not appear again.
These reports and their drop down lists all worked prior to our OS upgrade to V7R1 for users that did not belong to the Web Query Administrator Group. Is this a known issue with a solution available?