Hi, I hope someone can help me. Last weekend, our team made some changes to SQL. They added a column and removed 1 column; those added are not part of any view I used in Oracle. But because of the changes, oracle is now returning an error. When I go to connection on Oracle BI, it says failed to retrieve data, and it says unsupported column. Even my other connection is doing the same thing. Do I have to do anything on the RPD?

Hi @Jaymie , I would focus on the error that you are getting when you try to view a report first. It says that the OAC_LOGIN_INITBLOCK initialization block (defined in the RPD) must complete successfully. It has probably been marked as "Required for authentication" and gives you this kind of issues when its query returns no result. You need to open the RPD, check the query that must be executed by that initialization block, fix the SQL code if necessary, and eventually disable the "Required for authentication" option if it's no longer required.

Oracle Analytics Forum

Unsupported Column

Accepted answer

291

Views

Comments

Answers

SteveF-Oracle Mod

Apr 18, 2024 4:11PM

@Jaymie
Consider using the audit logs for your use-case.

How To Access Oracle Analytics Cloud Logs Through Oracle Cloud Infrastructure Logging [Video Content] (Doc ID 2990148.1)

https://community.oracle.com/products/oracleanalytics/discussion/20424/monitor-oac-through-the-oci-logging-service

0

Oracle Analytics Forum

Categories

Unsupported Column

Answers