Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
As a BIconsumer cannot see the graphs when logged in BI Administrator can able to
Hi Guys, Any solution for below issue
As a BIconsumer cannot see the graphs when logged in BI Administrator can able to
Getting below error
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27005] Unresolved column
checked permissions at the subject area to the column and application roles everything is fine but BI consumer unable to see the graphs
Answers
-
'everything is fine' ... not really though, you have a problem. Do you have ANY object level security in the Subject Area on ANY of the columns or tables? If so, then the error message is telling you that the column doesn't exist (and for all intents and purposes it doesn't) ... I suspect column security is implemented, and since you need that security, then check NQSConfig.ini parameter PROJECT_INACCESSIBLE_COLUMN_AS_NULL in the security section. By default it is set to NO. Set it to YES. Restart services.
0 -
As you mentioned i had checked that in NQSConfig.ini parameter PROJECT_INACCESSIBLE_COLUMN_AS_NULL in the security section is set to YES only.
The above issue seems to be scurity issue but i have checked all the subject areas for the table and it has read access to the BI consumer like Administartor
but the charts are visble to BI administartor and not for consumer This issue looks starange for me
please let me know if you have any workarounds
Thanks & Regards
BK
0 -
if you have an RPD that has NO security in it, what is the result? Do you get different behavior on DEV vs TEST vs PROD?
0 -
"nQSError: 27005" is not only tied to that config parameter it's also possible that the user / application role has no rights on the presentation layer objects on SA, table or column level.
0 -
Check this option mentioned below:
Go to Administration -> Manage Privileges -> Access to Graph view-> Add the BIConsumer role. Access should be "Granted".
Try your luck!
0 -
Hi Thomas,
Iam applying security not at RPD but at report and dashboard level.same behaviour in Prod also.
Thanks & Regards
BK
0 -
Hi Kamna,
He is able to see the barchart on the same page but not the Pie chart
Thanks
BK
0 -
As @Christian Berg has also pointed out ... [nQSError: 27005] Unresolved column is coming from the BI server (unrelated to your security implemented in the web catalog). You have selected columns in the Criteria tab that either 1) no longer exist in your subject area or 2) the user you are logged in as does not have permission to see that column. These permissions are set in the RPD Presentation layer on the objects (presentation tables + columns) - check there that there is nothing amiss.
Does the bar chart reference different columns than the pie chart?
0 -
In that case, check the columns which are used for creation of the Pie chart. There is an issue with the column name, or might be the case that column was renamed and alias got deleted. Another possible reason might be that column permission is breaking somewhere due to which the BIAdministrator is able to view the Pie chart.
0 -
One strange thing happened,if i replicated the business model and subject area the PIE chart is working fine for the same columns and with out any change with respect to the original.
but not with original one.got confused with strange behavior
Thanks & Regards
BK
0