nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

As a BIconsumer cannot see the graphs when logged in BI Administrator can able to

3051369

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

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

'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.

3051369

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

Thomas Dodds

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?

[Deleted User]

"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.

Kamna

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!

3051369

Hi Thomas,

Iam applying security not at RPD but at report and dashboard level.same behaviour in Prod also.

Thanks & Regards

3051369

Hi Kamna,

He is able to see the barchart on the same page but not the Pie chart

Thanks

Thomas Dodds

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?

Kamna

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.

3051369

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