Hello all, Logged in as weblogic and even tried with another obiee admin user. Write back template code update Table1 set name=‘@2’,Amount=Amount1,amount1=‘@3’ where id = @1 Presentation Services log

His Rober a trigger is a good way but don’t know if this is the best solution.. as you mentioned it has a list of constraints that are written in the oracle documentation .. since there is no sql statement to update two tables at the same time is not a standard way.. perpahs the OP should to rethinks the model

You could; create a view on the table(s) in the underlying DB - assuming it is Oracle. create a trigger to handle inserts on the view, making the trigger take the data and insert it into both tables. (Or whatever more complex logic you desire, as complex as you like!) I have done this previously to get around the limitations of write back. I know write back is not apex, but you would have thought Oracle would have either provided fully formed form functionality, or not. Write back as it is is poor without out of system workarounds!

Hi I think you should close this thread

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

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

Find more posts tagged with

Accepted answers

All comments

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.