Write back template error in obiee 12.2.1.0.0

Sunny86

Hello all,

Logged in as weblogic and even tried with another obiee admin user.

Write back template code

<?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="control_table">      <XML>         <writeBack connectionPool="PPRD1">            <insert> </insert>            <update>update Table1 set name=‘@2’,Amount=Amount1,amount1=‘@3’ where id = @1 </update>         </writeBack>      </XML>   </WebMessage></WebMessageTable></WebMessageTables>

Presentation Services log

ArijitC

I would like you to check if you have ' or ’ in the XML file. When you copy paste sometime it happens.

   <update>update Table1 set name=‘@2’,Amount=Amount1,amount1=‘@3’ where id = @1 </update>

Thanks.

ArijitC

Also Check the following ..if  Execute direct request is set as "allow".

Also need to add access from managed privilege screen.  User also need access to the following …

+ Write back database subject area, if any…

Thanks

Arijit

Robert Angel

You have probably checked this, but just in case, can you also confirm that the user your service runs as as the necessary rights on the file itself.

cesar.advincula.o

Hi, as I saw your first image issue that is because that OBIEE doesnt regcognize the template, make you sure that you XML TEMPLATE IS

<obiee_home>/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content/msgdb/l_en/

after it you should to provedide the proper privileges as the previous comments.

there is a detail post about that in this link Configuring Write Back in OBIEE12c - Red Stack Tech

Sunny86

I have used the redstck blog to configure it. But it is not resolved yet. Direct DB request is allowed. As Ceasar said error message says template not recognized. Any help will be highly appreciated ..

Robert Angel

Try the following, reproduce your update code between the insert tags, I am sure I have experienced errors previously if I did not have both populated...

Sunny86

Fixed it, by recreating the script and somehow now it worked .... is it possible to add multiple update statements ?

For example i have to update like below.

update Country set CountryName='@2',Country_Code=Country_Code_Og,ValueDollars=@3 where ID=@1

Update Country_Master set CountryName='@2',Country_Code=Country_Code_Og,ValueDollars=@3 where ID=@1

Or the second statement like

update country_master a set countryname,country_code_og,valueDollars=(select countryname,country_code_og,valueDollars from country b where a.ID=b.ID) where a.ID=@1

Robert Angel

Yes, you can even call a procedure to push the whole logic through an API equivalent, with writeback functionality being so limited I like this as an option partly for reasons of security, partly for data quality.

Robert Angel

Or on the API thought, do what I have done previously and create a view with a trigger on it to handle the multiple table logic, makes it clean, safe, and keeps the DB logic in the DB.

Sunny86

I tried to update multiple columns and it is not working.