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 Error in OBIEE 12.2.1

Venkata Rachuri

Hi All,

I am trying to create a write back form in OBIEE . My template

My Template :

<?xml version="1.0" encoding="utf-8" ?>

<XML>

<insert>INSERT INTO OBIEE_EMPLOYEE_WRITEBACK VALUES(obieewrite_seq.nextval,@{c1})</insert>

</writeBack>

</XML>

</WebMessage>

</WebMessageTable>

</WebMessageTables>

I am getting attached error

Saw Log Error :

[2016-11-16T14:17:03-06:00] [OBIPS] [ERROR:31] [] [saw.writeback.execute] [ecid: 2279be29-9b7e-4dbe-bb6c-3a0f43c7d1e5-000005ed,0:1] [tid: 2238666496] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: weblogic] Could not find privilege: Delete[[

File:coprivilegemap.cpp

Line:149

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

HttpCommand: WriteBack

[OBIPS] [ERROR:10] [] [saw.writeback.action.execute] [ecid: 2279be29-9b7e-4dbe-bb6c-3a0f43c7d1e5-000005ed,0:1] [tid: 2238666496] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: weblogic] The system was unable to generate appropriate SQL. Please contact your system administrator.

Template: 'INSERT INTO OBIEE_EMPLOYEE_WRITEBACK VALUES(obieewrite_seq.nextval,@{c1})'<br><br>Record: '<record type="update"><value columnID="cf4e17e03339d1164"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal"/></value><value columnID="cb75a98a50e5559eb" type="update"><newValue><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal">236955</sawx:expr></newValue><oldValue><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="sawx:null"/></oldValue></value></record>'[[

File:writebackaction.cpp

Line:287

Location:

saw.writeback.action.execute

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

HttpCommand: WriteBack

HttpArgs: type='update',SearchID='6ju9pjfh6hr962u3n4mh0j1c2a',_scid='TmjvwzzET7JNSMTjo7Xi',ButtonClicked='save',WriteBackXML='<writeback template="SetQuotaUseID"><record type="update"><value columnID="cf4e17e03339d1164"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal"/></value><value columnID="cb75a98a50e5559eb" type="update"><newValue><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal">236955</sawx:expr></newValue><oldValue><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="sawx:null"/></oldValue></value></record></writeback>',icharset='utf-8',ViewState='acogfk80aqvlekk6j9affghbra',TableId='saw_502_4',StatePath='d:dashboard~p:h56vca5hge5k90tl~r:dog9s4o44ifr6mti~v:compoundView!1~v:tableView!1'

Any help is appreciated

Find more posts tagged with

Accepted answers

All comments

cesar.advincula.o

1. Ensure that you have the NAME OF THE CONNECTION POOL of your ADMIN TOOL in the <writeBack connectionPool="OrgHierarchy"> TAG

Screen Shot 2016-11-16 at 3.40.45 PM.png

2. Check about your Privileges ( Administration -> Manage Privileges )

Screen Shot 2016-11-16 at 3.35.20 PM.png

3. Check the permissions "Execute Direct Database Request" of your Application Role has "Allow".

Screen+Shot+2016-11-16+at+3.43.28+PM.png

Venkata Rachuri

Hi ,

Thanks for your reply

Those are all taken care

Thanks

cesar.advincula.o

-Check the permissions "Execute Direct Database Request" of your Application Role should be "Allow".

Screen+Shot+2016-11-16+at+3.43.28+PM.png

- When you use the <INSERT> you should has a NULL ROW to insert.

Check the example (17.8.3) in the documentation https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG1356

The Oracle BI Administrator of the repository does the following:
- Creates a physical table called regiontypequota that includes the YR, Quarter, Region, ItemType, and Dollars columns
- Selects the Allow direct database request by default option in the General tab of the Database dialog
Using the Oracle BI Administration Tool, the Oracle BI Administrator of the repository:

Makes the WriteBack table noncacheable in the Physical layer
Makes the Dollars column in the WriteBack table writeable in the Business Model layer
Enables Read/Write permission on the Dollars column in the WriteBack table in the Presentation layer to the BI Author and Authenticated User

Restart and Test Again.

Venkata Rachuri

Yes those all are taken care.

Thanks

cesar.advincula.o

Did you check the example in the documentation in the link 17.8.3 ? https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG1356

It has almost a step by step.

Venkata Rachuri

Yes I did create my Template referring to that example.

My Template :

<?xml version="1.0" encoding="utf-8" ?>

<XML>

<insert>INSERT INTO OBIEE_EMPLOYEE_WRITEBACK VALUES(obieewrite_seq.nextval,@{c1})</insert>

</writeBack>

</XML>

</WebMessage>

</WebMessageTable>

</WebMessageTables>

I left blank between update tags as I am just doing insert.

Thanks

cesar.advincula.o

Do you check database permissions for insert in the schema using the sequence? Do you restart the presentation service to apply the changes that you made?

Venkata Rachuri

Yes. If I excute the sql statement directly on the database it inserts 1 row in to the table. So it works.

INSERT INTO OBIEE_EMPLOYEE_WRITEBACK VALUES(obieewrite_seq.nextval,1);

Thanks

3310714

Just curious, your statement is INSERT, but I see the record type = UPDATE? Is that normal?

Venkata Rachuri

If you create write back form you will see update button. when you click on it, it will open another form inside where you will do insert (or) update.

Even I put update statement I am seeing the this update thing. So I am guessing this is picking from GUI I guess.

Thanks