WriteBack - obiee 11g - unable to read the Write Back Template

Layla Wolf

Dear all,

I need your help with setting u write back for one dashboard. I get the following error:

'The system is unable to read the Write Back Template 'SetComment'. Please contact your system administrator.'

Below is my xml, maybe there is a problem with it?

<?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="SetComment">

         <XML>

            <writeBack connectionPool="MMSR Connection pool">

                 <insert> </insert>

                <update>UPDATE REPORT_TABLE SET USER_COMMENT='@{cc1337a2d721091ed}' where ID='@{c9f06ed06018b4d62}'</update>

            </writeBack>

         </XML>

      </WebMessage>

   </WebMessageTable>

</WebMessageTables>

Also, I could not find the customMessages or analyticsRes folder anywhere, so I created both in two places:

/opt/software/share/oraclebi/MiddlewareHome/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages

/opt/software/share/oraclebi/MiddlewareHome/Oracle_BI1/bifoundation/web/msgdb/customMessages

Thank you very much , I really need your help

Layla Wolf

Anyone has a solution please?

Frog Toad

Hi!

Try to make your xml-template here:

<ORACLE_INSTANCE>/bifoundation/OracleBIPresentationServicesComponent/coreappplication_obips1/analyticsRes/customMessages

http://docs.oracle.com/cd/E21764_01/bi.1111/e10541/answersconfigset.htm#BIESG1354

Layla Wolf

Hi, problem is that under <ORACLE_INSTANCE>/bifoundation/OracleBIPresentationServicesComponent/coreappplication_obips1/ I could not find the analyticsRes folder, and so I had to create the two foler analyticsRes and customMessages by myself.

is this a problem?

Frog Toad

XML-the template must be located in a right path.

Problem - to find this right path

Check this path:

/opt/software/share/oraclebi/MiddlewareHome/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/msgdb/customMessages

Layla Wolf

so I checked the log in the server, and this is the error

[2016-06-13T17:56:36.000+02:00] [OBIPS] [WARNING:16] [] [saw.subsystem.messagetables.load] [ecid: 920fd1ffeb301c62:6f5da33b:151414550f8:-8000-0000000000b07136,0:1] [tid: 1832908544] Error loading XML Message File (/opt/software/share/oraclebi/MiddlewareHome/Oracle_BI1/bifoundation/web/msgdb/customMessages/WriteBackTemplate.xml): Sax parser returned an exception.

Message: The XML or Text declaration must start at line/column 1/1, Entity publicId: /opt/software/share/oraclebi/MiddlewareHome/Oracle_BI1/bifoundation/web/msgdb/customMessages/WriteBackTemplate.xml, Entity systemId: , Line number: 1, Column number: 8^M

Error Codes: UH6MBRBC^M

so it it finds the file, but there is problem with XML. Here is my xml:

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

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

<WebMessageTable embed='true' lang="en" system="WriteBack" table="Messages">

              <WebMessage name="SETCOMMENT">

                <XML>

                        <writeBack connectionPool="MMSR Connection pool">

                                <insert>UPDATE MMSR_REPORT_FX_SWAPS_EXCEPTION SET USER_COMMENT='@{cc1337a2d721091ed}' where ID='@{c9f06ed06018b4d62}'</insert>

                                <update>UPDATE MMSR_REPORT_FX_SWAPS_EXCEPTION SET USER_COMMENT='@{cc1337a2d721091ed}' where ID='@{c9f06ed06018b4d62}'</update>

                       </writeBack>

              </XML>

              </WebMessage>

              <WebMessage name="setcommentois">

                <XML>

                        <writeBack connectionPool="MMSR Connection pool">

                                <insert>UPDATE MMSR_REPORT_OIS_EXCEPTION SET USER_COMMENT='@{c1a709ab4c7ade65c}' where ID=@{c35ad0287d464973ff}</insert>

                                <update>UPDATE MMSR_REPORT_OIS_EXCEPTION SET USER_COMMENT='@{c1a709ab4c7ade65c}' where ID=@{c35ad0287d464973ff}</update>                                                                              </writeBack>

                </XMl>

              </WebMessage>

             </WebMessageTable>

        </WebMessageTables>

Maybe you can see the error?

Frog Toad

Try replace string

<WebMessageTable embed='true' lang="en" system="WriteBack" table="Messages">

to

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

Layla Wolf

Thanks for the help! now the XML error is gone, but I still get the error while trying to update.

The log file gives the error;

[2016-06-14T09:34:17.000+02:00] [OBIPS] [ERROR:31] [] [saw.writeback.execute] [ecid: 920fd1ffeb301c62:6f5da33b:151414550f8:-8000-0000000000b11045,0:1] [tid: 974960384] Could not find privilege: [[

File:coprivilegemap.cpp

Line:80

Location:

        saw.writeback.execute

        saw.httpserver.processrequest

        saw.rpc.server.responder

        saw.rpc.server

        saw.rpc.server.handleConnection

        saw.rpc.server.dispatch

        saw.threadpool.socketrpcserver

        saw.threads

SessionID: ec0nhmgo9t55rilt6l6v7l8ol4ch5i5h3q11m7i

AuthProps: AuthSchema=UidPwd|PWD=******|UID=WEBLOGIC|User=weblogic

ecid: 920fd1ffeb301c62:6f5da33b:151414550f8:-8000-0000000000b11045,0:1

I have set up all privileges in rpd and in administration

Frog Toad

2016-06-14T09:34:17.000+02:00] [OBIPS] [ERROR:31] [] [saw.writeback.execute] [ecid: 920fd1ffeb301c62:6f5da33b:151414550f8:-8000-0000000000b11045,0:1] [tid: 974960384] Could not find privilege: [[

Check permissions

In repository

1.1 in connection pool (for test - give permission to read/write to "Authenticated User")

1.2  in presentation level, in your subject area

Also check privilegies on "Write Back to Database" and ""Manage Write Back" in analytics: "Administration" -> "Manage Privilegies"

cesar.advincula.o

Furthermore, go to Identity Manager -> Choose your User -> Permission, and go to the connection pool and give the permissions Read / Write.

All the advice that people give you are right

Kind REgards,