Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Write Back in OBIEE 12c

DentsplySironaApr 10 2019 — edited Apr 12 2019

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

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

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

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

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

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

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

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

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

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

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

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

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

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

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

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

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

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

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'

AuthProps: AuthSchema=SSO|IMPERSONATE=xxxxxxxx|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=va4ihgjtlomkbp3qwn2e6urcszfdx7y8|User=xxxxxxxx|GUID=xxxxxxxx

SessionID: 10.6.210.233.1.jk1uv5e

RemoteIP: 10.6.210.233

SIKey: ssi

]]

The field type is a bit. 

This post has been answered by DentsplySirona on Apr 12 2019
Jump to Answer

Comments

james_sutherland
This should work if using TopLink/EclipseLink.
1 - 1