7 Replies Latest reply on Apr 12, 2019 2:08 PM by Christian Berg

Write Back in OBIEE 12c

DentsplySirona Apr 10, 2019 12:36 PM

Trying to set up write back ability in 12c and I get to the point where I can enter the value but when I try to apply it I am getting this error: An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator.

Here are the saw.log file:

[2019-04-10T08:18:15-04:00] [OBIPS] [WARNING:16] [] [saw.security.userpopulationmanagerimpl.searchidentities] [ecid: ] [tid: 8756] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] GUID SADMIN for Account Type Users not found in cache or backend, marking as unknown[[

File:userpopulationmanagerimpl.cpp

Line:1018

Location:

saw.security.userpopulationmanagerimpl.searchidentities

saw.security.userpopulationmanagerimpl.getaccountdetailsbyid

saw.subsystem.mrulist.iteminfojson

saw.httpserver.processrequest

saw.rpc.server.responder

saw.rpc.server

saw.rpc.server.handleConnection

saw.rpc.server.dispatch

saw.threadpool.socketrpcserver

saw.threads

HttpCommand: loadFunctionInTemplate

SessionID: 10.6.210.233.1.jk1uv5e

RemoteIP: 10.6.210.233

SIKey: ssi

]]

[2019-04-10T08:18:15-04:00] [OBIPS] [WARNING:16] [] [saw.security.userpopulationmanagerimpl.searchidentities] [ecid: ] [tid: 8756] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] GUID Administrator for Account Type Users not found in cache or backend, marking as unknown[[

File:userpopulationmanagerimpl.cpp

Line:1018

Location:

saw.security.userpopulationmanagerimpl.searchidentities

saw.security.userpopulationmanagerimpl.getaccountdetailsbyid

saw.subsystem.mrulist.iteminfojson

saw.httpserver.processrequest

saw.rpc.server.responder

saw.rpc.server

saw.rpc.server.handleConnection

saw.rpc.server.dispatch

saw.threadpool.socketrpcserver

saw.threads

HttpCommand: loadFunctionInTemplate

SessionID: 10.6.210.233.1.jk1uv5e

RemoteIP: 10.6.210.233

SIKey: ssi

]]

[2019-04-10T08:18:33-04:00] [OBIPS] [ERROR:31] [] [saw.views.evc.activate] [ecid: ] [tid: 6680] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] Could not find privilege: Delete[[

File:coprivilegemap.cpp

Line:149

Location:

saw.views.evc.activate

saw.httpserver.processrequest

saw.rpc.server.responder

saw.rpc.server

saw.rpc.server.handleConnection

saw.rpc.server.dispatch

saw.threadpool.socketrpcserver

saw.threads

RSP: o:viewpreview~r:report

HttpCommand: AnswersGetView

SID: cgj2q5lfjv81rnt0vih19p2hmu

SessionID: 10.6.210.233.1.jk1uv5e

RptPath: /users/xxxxxxxx/WriteBack/AccountRestatement

RemoteIP: 10.6.210.233

SIKey: ssi

]]

[2019-04-10T08:18:42-04:00] [OBIPS] [ERROR:31] [] [saw.views.evc.activate] [ecid: ] [tid: 6680] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] Could not find privilege: Delete[[

File:coprivilegemap.cpp

Line:149

Location:

saw.views.evc.activate

saw.httpserver.processrequest

saw.rpc.server.responder

saw.rpc.server

saw.rpc.server.handleConnection

saw.rpc.server.dispatch

saw.threadpool.socketrpcserver

saw.threads

RSP: o:viewpreview~r:report

HttpCommand: AnswersGetView

SID: cgj2q5lfjv81rnt0vih19p2hmu

SessionID: 10.6.210.233.1.jk1uv5e

RptPath: /users/xxxxxxxx/WriteBack/AccountRestatement

RemoteIP: 10.6.210.233

SIKey: ssi

]]

[2019-04-10T08:18:43-04:00] [OBIPS] [ERROR:31] [] [saw.views.evc.activate] [ecid: ] [tid: 6680] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] Could not find privilege: Delete[[

File:coprivilegemap.cpp

Line:149

Location:

saw.views.evc.activate

saw.httpserver.processrequest

saw.rpc.server.responder

saw.rpc.server

saw.rpc.server.handleConnection

saw.rpc.server.dispatch

saw.threadpool.socketrpcserver

saw.threads

RSP: o:viewpreview~r:report

HttpCommand: AnswersGetView

SID: cgj2q5lfjv81rnt0vih19p2hmu

SessionID: 10.6.210.233.1.jk1uv5e

RptPath: /users/xxxxxxxx/WriteBack/AccountRestatement

RemoteIP: 10.6.210.233

SIKey: ssi

]]

[2019-04-10T08:18:45-04:00] [OBIPS] [ERROR:31] [] [saw.writeback.execute] [ecid: ] [tid: 6680] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] Could not find privilege: Insert[[

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

SessionID: 10.6.210.233.1.jk1uv5e

RemoteIP: 10.6.210.233

SIKey: ssi

]]

[2019-04-10T08:18:45-04:00] [OBIPS] [ERROR:31] [] [saw.writeback.execute] [ecid: ] [tid: 6680] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] 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

SessionID: 10.6.210.233.1.jk1uv5e

RemoteIP: 10.6.210.233

SIKey: ssi

]]

[2019-04-10T08:18:45-04:00] [OBIPS] [ERROR:16] [] [saw.writeback.action.executeimpl] [ecid: ] [tid: 6680] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] EXECUTE PHYSICAL CONNECTION POOL RestatementConnection UPDATE WC_RESTATEMENT SET REC_STATUS = 1 WHERE ROW_WID = 49[[

File:writebackaction.cpp

Line:882

Location:

saw.writeback.action.executeimpl

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

SessionID: 10.6.210.233.1.jk1uv5e

RemoteIP: 10.6.210.233

SIKey: ssi

]]

[2019-04-10T08:18:45-04:00] [OBIPS] [ERROR:16] [] [saw.writeback.action.executeimpl] [ecid: ] [tid: 6680] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator.\r\n

[[

File:writebackaction.cpp

Line:372

Location:

saw.writeback.action.executeimpl

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

SessionID: 10.6.210.233.1.jk1uv5e

RemoteIP: 10.6.210.233

SIKey: ssi

]]

[2019-04-10T08:18:45-04:00] [OBIPS] [ERROR:10] [] [saw.writeback.action.execute] [ecid: ] [tid: 6680] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: xxxxxxxx] An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator.\r\n

[[

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='cgj2q5lfjv81rnt0vih19p2hmu',_scid='J4uVioKcWK255I3mYE0A',ButtonClicked='save',WriteBackXML='<writeback template="AccountRestatment"><record type="update"><value columnID="c3ae98707c3c62d3b"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal">49</sawx:expr></value><value columnID="ccdd726ea8b2f0302"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal">1401</sawx:expr></value><value columnID="caa9fca88d53cbf2a"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">2019-04-09 11:26:07.643</sawx:expr></value><value columnID="c92b8718473b3364d"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string" /></value><value columnID="c5deb838f837b2232"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">SF1163335</sawx:expr></value><value columnID="c4e26583ac0eecc5b"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:string">SF1347150</sawx:expr></value><value columnID="c47eeb1fa0a56e3d9"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal">0</sawx:expr></value><value type="update" columnID="c044a72dbbe4b5a82"><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">1</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="xsd:decimal">0</sawx:expr></oldValue></value><value columnID="c9eb193d2ad6109fb"><sawx:expr xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xsd:decimal">0</sawx:expr></value><value columnID="cd52b40f9004e9d2a"><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></record></writeback>',icharset='utf-8',ViewState='4jtc29thjukuhnphtdhrbc3oim',TableId='saw_40_4',StatePath='o:viewpreview~r:report~v:compoundView!1~v:tableView!1'

SessionID: 10.6.210.233.1.jk1uv5e

RemoteIP: 10.6.210.233

SIKey: ssi

]]

The field type is a bit.

1. Re: Write Back in OBIEE 12c

Christian Berg Apr 10, 2019 1:48 PM (in response to DentsplySirona)

1.) Which exact "12c" - there were more than 20 so far.

2.) Which exact OS?

3.) Is that a migrated system? 12 doens't know "GUIDs" anymore - that was an 11g concept
Like Show 0 Likes(0)

Actions
2. Re: Write Back in OBIEE 12c

DentsplySirona Apr 10, 2019 2:21 PM (in response to Christian Berg)

1. 12.2.1.4

2. Windows Server 2012 R2

3. No it is not a migrated system. Fresh install.
Like Show 0 Likes(0)

Actions
3. Re: Write Back in OBIEE 12c

Christian Berg Apr 10, 2019 5:26 PM (in response to DentsplySirona)

If that's afresh install then several follow-up questions since the GUID part is questionable.

1.) How exactly did you configure writeback?

2.) SADMIN?! What kind of user is that supposed to be? OBIEE isn't Siebel CRM.
Like Show 0 Likes(0)

Actions
4. Re: Write Back in OBIEE 12c

DentsplySirona Apr 10, 2019 8:26 PM (in response to Christian Berg)

I am not sure where the SADMIN is coming from. We have not used that in years.

I followed the steps here: https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-6F16F7CA-E525-4569-A5A0-C1C0F851F57E.htm#BIESG9156

Here is what I did:

Repository setup
Physical: Database properties
Connection Pool
Physical Table: Cacheable unchecked
Here is the table

BMM Logical Column

Presentation: Subject Area

Column

Identity

Created xml template

<?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="AccountRestatment">
      <XML>
         <writeBack connectionPool="RestatementConnection">
                <insert> </insert>
<update>UPDATE WC_RESTATEMENT SET REC_STATUS = @{cdce4f3e1d70d2652} WHERE ROW_WID = @{c3ae98707c3c62d3b}</update>
</writeBack>
      </XML>
   </WebMessage>
</WebMessageTable>
</WebMessageTables>

Added this to instanceconfig.xml file
<LightWriteback>true</LightWriteback>

Report Setup
Changed Privileges

Now I am getting this:
Like Show 0 Likes(0)

Actions
5. Re: Write Back in OBIEE 12c

Christian Berg Apr 11, 2019 4:36 PM (in response to DentsplySirona)

So what about that user profile you're using? Is he really a BIAdministrator? Does he possess "authenticateduser"?
Like Show 0 Likes(0)

Actions
6. Re: Write Back in OBIEE 12c

DentsplySirona Apr 12, 2019 1:10 PM (in response to Christian Berg)

Thanks for looking at this. I finally found the issue and it was so simple and stupid. The user ID I was using to access the Database did not have write access. Once I changed to a different ID with write access everything worked.
Like Show 0 Likes(0)

Actions
7. Re: Write Back in OBIEE 12c

Christian Berg Apr 12, 2019 2:08 PM (in response to DentsplySirona)

Good catch. it's always the things one assumes are correct to begin with and hence don't ask about.
Like Show 0 Likes(0)

Actions