OBIEE 12c - Write Back Error: "An error occurred while writing to the server. Please check to make s

3051163

Hi All,

Getting below error while attempting to implement Write-Back feature in OBIEE 12.2.1.0.0

"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"

System:

MS SQL server database

Oracle Business Intelligence 12.2.1.0.0

XML File:

<?xml version="1.0" encoding="utf-8" ?>

<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">

<WebMessageTable lang="en-us" system="WriteBack" table="Messages">

   <WebMessage name="WB_Test">

      <XML>

         <writeBack connectionPool="Connection Pool">

            <insert> </insert>

            <update>UPDATE WB SET COMMENTS='@{ce374fe936da06edc}' WHERE id=@{cf11242553a7dfdf3}</update>

<postUpdate>COMMIT</postUpdate>

         </writeBack>

      </XML>

   </WebMessage>

</WebMessageTable>

</WebMessageTables>

Currently, I have Admin rights and I strongly believe I have configured properly.

https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG1354 

I have tried various changes to XML file, but the problem still exists.

It would be great if anyone could assist with the above issue.

Thanks in advance.

cesar.advincula.o

If you see the example it should be works just try dont forget any instructions, also if you make some change in your template (XML file in customMessages directory) just need to refresh the metadata in Presentation Services.

1. Makes the WriteBack table noncacheable in the Physical layer

Uncheck the cachable option

2. Check the same name of the connection pool is the name of your physical layer.

3. Enables Read/Write permission on the  column in the WriteBack table in the Presentation layer to the BI Author and Authenticated User

4. Selects the Allow direct database request by default option in the General tab of the Database dialog

5. In the instance.configxml add

<WebConfig>

  <ServerInstance>

  <LightWriteback>true</LightWriteback>

  </ServerInstance>

</WebConfig>

6. The administrator grants the following privileges using the Administration: Manage Privileges page in Oracle BI Presentation Services:

• Manage Write Back to the BI Author
• Write Back to Database to the Authenticated User
  

7. Check again the code of the XML to ensure the columnID of the columns in your Analysis:

8.  In the template:

- use '' to VARCHAR COLUMN, for example, @{ce374fe936da06edc}'

- dont use '' to NUMBER COLUMN, for example, id=@{cf11242553a7dfdf3}

9. Did you check the  INSERT/UPDATE privileges in your SQL SERVER database?  The schema that you are using in your CONNECTION POOL in your template has these privileges?

Sorry by the screemshoots are in spanish, .

Chandu K

Check below log files that would help you out.

DOMAIN_HOME]/servers/obis1/logs/obis1-diagnostic.log

[DOMAIN_HOME]/servers/obis1/logs/obis1-query.log

[DOMAIN_HOME]/servers/obips1/logs/sawlog0.log