5 Replies Latest reply on Jul 20, 2016 1:09 PM by Christian Berg

    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