WIS 30256 - View sql problem

building reports webintelligence
1

Hi All,

In one of my report i am getting you do not have right to view sql - WIS 30256.

I am receiving this error when i am trying to change the value of one of the parameter. More specifically i am getting this error when i am selecting the value from hierarchy shown while selecting the value.

I am not getting this problem when i enable view sql from CMC but the real issue is that for other users we can not grant this permission.

Please let me know if there is any solution for this issue.

Regards,
Honed Ali

honed_ali :india: (BOB member since 2009-04-16)

2

Your admnistrator will need to create different groups of users, and grant rights to the folder based on the groups. So in this case two groups, one group will have access to the SQL the other will not.

dessa :madagascar: (BOB member since 2004-01-29)

3

Hi All

Can anyone let me know why we need view sql permission for refreshing the report?

Regards,
Honed Ali

honed_ali :india: (BOB member since 2009-04-16)

4

Hi,

You don’t need view sql permission for refreshing the report.
But the error which you have specified occurs when you try to see the sql generated by the query.

Prashu :india: (BOB member since 2005-08-17)

5

Hi,

While refreshing the report i am getting this error and the error code is WIS 30196.

Please let me know how the error can be rectified.

Regards,
Honed Ali

honed_ali :india: (BOB member since 2009-04-16)

6

You need to clarify exactly what you want and what the problem is:

The post started out with error 30256 which is simply a permissions issue that can be rectified by granting permissions to view the SQL.

You don’t need view permission on the SQL to refresh a report, as Prashu has already stated.

I haven’t come across WIS 30196 and niether has the error message guide (at least my version) what is the description associated with it?

Have you or an administrator changed any settings in the CMC while trying to resolve the original “error”?

dessa :madagascar: (BOB member since 2004-01-29)

7

Hello,

I have the same issue…
I have granted “view SQL” right to my user, and when I refresh a report, I have an error “ERR_WIS_30256” telling me that I don’t have permission to visualize SQL

I have several reports in the same folder, and this appends only with one.
I’m not trying to visualize SQL request but only refresh the report…

tdeville (BOB member since 2009-07-29)

8

I’m sorry, I have the same issue, and what you think about this: I granted permission to view SQL in WebI documents, but there is no result. Any ideas?

Arthur Daedrah :ru: (BOB member since 2007-08-06)

9

This may be a very basic question but have you tried using the Check User Rights button on the rights tab of the folder where the user is having the issue. I have experienced conflicting security settings and that would help you find out where the problem lies.

BIDude :us: (BOB member since 2009-05-14)

10

Thanx for reply.
I used this feature and convinced that I have this right, but I can’t to see a sql script in report. Even I set up ALL ACCESS rights to folder, I can’t see a sql script in report.

I’ll try to find a solution of my issue.

Arthur Daedrah :ru: (BOB member since 2007-08-06)

11

I found solution here

Arthur Daedrah :ru: (BOB member since 2007-08-06)