Tuesday, November 12, 2013

Usage Tracking insert error in OBIEE 11g

we came across a very general error message when we took a look at the log file. This is something related to inserts. We are surprised why something related to inserts has been logged in OBIEE server log files where we only do the reads. Soon we realized that its related to usage tracking.

Error Message :

error inserting value into query_blob with below message

"ORA-01704: string literal too long"

Solution :

We tried many ways including deleting the column in both RPD and DATABASE but nothing helped. The solution we found is a patch from oracle to fix this bug.

BUG 12831483