BW errors in default trace files

[Former Member]

Hi everyone,

I can see many errors in default trace files in BI production system like below

Just an example

Cannot load query "ZFP_TREASURYDB_1001_CKJB" (data provider "CHART_TREASRY": No authorization for requested service)

com.sap.ip.bi.webapplications.dataproviders.selector.impl.Localization loaderr_query2

CHART_TREASRY

ZFP_TREASURYDB_1001_CKJB

No authorization for requested service#

These type of errors are hitting many tiems a day but no user is reporting and harldy very less number of users will login to bi portal and work.Its hard for me to find out to which user thses errors are coming.

Basically my question is - What to do if security person wants to provide authorization in specific(limits_ to a bi query. and what is the main reason for these type of errors?

Thanks to let me know.

[Former Member]

its very hard for us to find out the user who tried to use that query from portal.

Is ther any way to know which user tried to hit that?

I am unable to check the user either in applications log or in default traces

Thank you

[Former Member]

Hi,

To check which user has logged onto portal and which query he has executed, activate the BI cockpit content.

It will give reports which will tell you the all details about reporting users.

Thanks

Imran

[Former Member]

Sure, thanks