nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

<XML>

<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

Find more posts tagged with

Accepted answers

All comments

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

<XML>

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

<XML>

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

<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 connection pool permissions.jpg

1.2 in presentation level, in your subject area

2 subject area permissions.jpg

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

3 manage privilegies.jpg

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,