BI Publisher (MOSC)

MOSC Banner

Passing Parameter in BI Publisher getting the followoing error: "SQL or ORA exceptions caused due to

edited Nov 18, 2019 4:01AM in BI Publisher (MOSC) 4 commentsAnswered

Hi guys,

I have an error when passing parameter in query in bi publisher (OBIEE 12.2.1.4.0 (on primise)) and (12.2.4.0.0 (cloud))

the error is  " SQL or ORA exceptions caused due to invalid sql, database package state or some database exceptions "

after search, found this doc (Doc ID 2477086.1) and installed patch (Patch 28488603) according to this link :

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=281475194921172&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&…

but after that nothing happened and the error still exists.

*note: - the engine that query on it is (hive).

I will mention two queries and error exists in both of them:

1- first query:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center