OBIEE Writeback Error

Sravan Gereddy

Hi All,

I created a report which writeback data into the database using OBIEE's Writeback functionality. I developed everything as per Oracle's recommendation and the code works fine in the lower environments. When the code has been pushed to prod and validating, the report throws an error "An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator." When checking the nqquery.log file, it states that the following error :

[2016-07-20T01:11:57.000-05:00] [OracleBIServerComponent] [TRACE:2] [USER-34] [] [ecid: a6ac3904e688fb58:-334205c1:155ff076bac:-8000-00000000000e5068,0:1:3] [tid: 471ce940] [requestid: 5670000c] [sessionid: 56700000] [username: UX006240] -------------------- Query Status: [nQSError: 17011] SQL statement execution failed. [[

[nQSError: 17001] Oracle Error code: 16000, message: ORA-16000: database open for read-only access

at OCI call OCIStmtExecute:

[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.

[nQSError: 43119] Query Failed:

When executing the same query which OBIEE has generated in sqldeveloper with the same connection pool defined in the repository, it works fine. I am unable to understand, what exacty could be the issue. Any help would be highly appreciated.

Thanks,

Sravan Gereddy

Frog Toad

Hi

Check the permissions in the connection pool

Sravan Gereddy

Hi,

Thanks for the response.

Yes, the option is checked but still the report throws an error. I have a new role created for this. I am just letting the Role to Read/Write. Should there be anything more than this?

[Deleted User]

Sravan Gereddy wrote:

ORA-16000: database open for read-only access
 

So 1000 dollar question: do your connection pool credentials actually allow read-write access? Or are you simply using a read-only account?

Sravan Gereddy

Yup and that's what i stated in the question clearly. "When executing the same query which OBIEE has generated in sqldeveloper with the same connection pool defined in the repository, it works fine. "

[Deleted User]

ORA-16000 is an error from the database.Not OBI. Hence my statement. Are you sure you're comparing apples and apples? No connection scripts in your connection pool? No weird database properties configured for your database object in the physical layer?