Sufficent rights to refresh the query

HI All,

I am trying to refresh a webi report as an administrator and getting the below error. I tried running the other reports in the launchpad and all are running fine. Problem seems to be on this particular report and only one report has been created on the universe.

same report is running fine in development environment using the admin credentials.

error :You do not have sufficient rights to refresh the query. Some objects are not available to your user profile. Contact your administrator to request the necessary rights. (Error: INF )

Please help and help is much appreciated.


parasaram (BOB member since 2017-05-08)

Welcome to B:bob:B!
Try creating another report on the same universe - then you know if it is an access problem or a ‘this report’ problem. What rights do you have set in the CMC?


Nick Daniels :uk: (BOB member since 2002-08-15)

Hello -
In my case, the universe was updated - some objects were modified and moved, in that process if the objects were copied and pasted in different folder, the object IDs changed - that makes the report to give this error.

“You do not have sufficent rights to refresh the query. Some objects are not available to your user profile. Contact your administrator to request the necessary rights. (WIS 00002)”

Solution:

Re selecting the same universe through the ‘Data Access’->Tools options,
Now the objects are refreshed with the current IDs and the report runs fine.


mk19 :bangladesh: (BOB member since 2009-07-20)

mk19, your solution worked perfectly for me. I found this thread because I was having the same issue. Repointing to the same universe fixed my issue.
Thank you!


Stephen P :us: (BOB member since 2007-01-12)

Thanks Stephen - glad that the solution worked for you!


mk19 :bangladesh: (BOB member since 2009-07-20)