Categories
The system is unable to read the Write Back Template . Please contact your system administrator.
HI
When i am trying to writeback, i am getting error as "The system is unable to read the Write Back Template . Please contact your system administrator." in obiee11g. Can you please suggest where I am going wrong
Placed xml template in below paths too
obi11g/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/msgdb/customMessages
obi11g//bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages
<?xml version="1.0" encoding="UTF-8"?>
-<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
-<WebMessageTable lang="en-us" table="Messages" system="WriteBack">
-<WebMessage name="Reverse">
-<XML>
-<writeBack connectionPool="Connection Pool">
<insert>insert into table (column1) values(@{cbb79f33511e76a58} )</insert>
<update>UPDATE table SET column1= @{cbb79f33511e76a58} </update>
</writeBack>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>
Answers
-
Sure, look at the rights that the OBIEE user has on the folder / file in question.
0 -
instanceconfig updated correctly? Writeback template name correct and no upper/lower errors? OBIPS bounced after the files were put in place or metadata refreshed? folder has correct permissions? etc etc etc...
0 -
HI
Yes, i set all as per document but still i am getting system cannot read template error
0 -
If you checked all I said for typos, permissions, upper/lower case and the instanceconfig is ok then it must work. Because I just did it in under10min and it works.
0 -
Christian, to what are you referring when you mention "folder permissions"? Are you talking about presentation layer table & columns?
As seems to be Oracle standard, the documentation (including KB notes) is scattered and contradictory. At this point, I am not 100% sure about:
A) Can I still use @1 notation for positional column references or must I use the column ID notation using IDs from XML e.g. @{c338a39bc2}. (System Admin Guide says either, most blog posts seem to use positional notation, Doc 1593885.1 says only column ID is valid. I have tried both.)
Does the .xml file go in(1) .../<instance>/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages
and/or
(2) .../<instance>/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/msgdb/CustomMessages
and/or
(3) .../Oracle_BI1/bifoundation/web/msgdb/CustomMessages (this folder didn't even exist in my installation)
System Admin Guide (for 11.1.1) says only (1). Doc 1593885.1 says (1) and (3). Some blog and forum posts (including this one) say (1) and (2). I have mine in all three because <shrug> who knows which doc is telling the correct story.
C) Does the message "unable to read Write Back Template" actually mean that OBIEE is having trouble reading/parsing the .xml? Or is that message going to pop no matter which part of the setup might be incorrect? Providing useful, detailed error messages has never been an OBIEE strong suit...
Well, off to quadruple-check everything.
0 -
Thank you
I did freshly everything and it worked.
just Update a column without where condition worked fine but when i am using an update with where condition it is throwing error.
i am using all varchar columns and used single quotes.
<update>UPDATE Table SET col4='@{4}' where col1 ='@{1}' AND col2= '@{2}' AND col3='@{3}'</update>
0