Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Writeback Error

Received Response
22
Views
5
Comments
Sravan Gereddy
Sravan Gereddy Rank 3 - Community Apprentice
edited Aug 13, 2024 6:15PM in Oracle Analytics Cloud and Server

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

Answers

  • Frog Toad
    Frog Toad Rank 4 - Community Specialist

    Hi

    Check the permissions in the connection pool

    1 connection pool permissions.jpg

  • Sravan Gereddy
    Sravan Gereddy Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 2 - Community Beginner 
    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
    Sravan Gereddy Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 2 - Community Beginner

    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?