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

Question

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 - - - - - insert into table (column1) values(@{cbb79f33511e76a58} ) UPDATE table SET column1= @{cbb79f33511e76a58}

Jack · Answer

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 Table SET col4='@{4}' where col1 ='@{1}' AND col2= '@{2}' AND col3='@{3}'

JustTheFacts · Answer

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.) B) Does the .xml file go in (1) ...//bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages and/or (2) ...//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 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.

[Deleted User] · Answer

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.