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

Write Back in OBIEE 12C throws an error An error occurred while writing to the server. Please check

Received Response
32
Views
1
Comments
Vineela1
Vineela1 Rank 3 - Community Apprentice
edited August 2024 in Oracle Analytics Cloud and Server

OBIEE Version: 12.2.1.2.0

We have our writeback working previously but suddenly it is throwing the below error :

image.png

I had my .xml file as below:

image.png

& My instanceconfig.xml as below:

image.png

& I had my writeback enabled in RPD:

image.png
image.png
image.png

& My logs doesn't show any details about the error

Please help me in resolving the error

Answers

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    OBIEE 122120 is out of error correction support and pretty old. We recommend you to consider upgrading your systems

    Oracle Business Intelligence Enterprise Edition (OBIEE) Error Correction Support (Doc ID 1664916.1)

    Oracle Analytics Server Error Correction Support Policy and Dates (Doc ID 2775561.1)

    For this writeback issues, i'd recommend the below


    1. Increase the loglevel for OBIPS and OBIS to TRACE, and do a restart , check the sawlog* and the obis1-diag logs
    2. And then you may need to verify the templates that has been used and the way writeback is configured using the below doc
    https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-6F16F7CA-E525-4569-A5A0-C1C0F851F57E.htm#BIESG1355


    Ensure that the query you used in the template works fine standalone on sqldev.


    Other inputs are welcomed!