Skip to Content

Queries started executing with 02 level access intead of 03

Hi,

We have multiple queries that were running fine and then all of a sudden, the users started getting no data found. When someone with eleveated access runs the queries, we get data. A security trace shows that the queries are now using S_USER_AGR RC=4 & ACTVT=02. Security tell me that the execution should be ACTVT=03 but the cannot find out why all of a sudden it is trying it as ACTVT=02.

Where can we look to see why the queries are trying to execute with update type authority all of a sudden instead of just their normal read authority.

Note: The queryies have not changed. There are multiple queries involved and multiple info providers are involved.

Any help you can provide will be appreciated.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 15, 2011 at 08:47 PM

    A new BEx Global workbook had been published causing this unexpected result. The change was backed out.

    Add comment
    10|10000 characters needed characters exceeded