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 Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Unsupported Column

Accepted answer

246

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

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Unsupported Column

Answers