Categories
- All Categories
- 121 Oracle Analytics News
- 21 Oracle Analytics Videos
- 14.4K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Write Back in OBIEE 12c
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.
[[
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.
[[
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.
Answers
-
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
0 -
1. 12.2.1.4
2. Windows Server 2012 R2
3. No it is not a migrated system. Fresh install.
0 -
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.
0 -
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:
0 -
So what about that user profile you're using? Is he really a BIAdministrator? Does he possess "authenticateduser"?
0 -
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.
0 -
Good catch. it's always the things one assumes are correct to begin with and hence don't ask about.
0 -
Trying for writeback functionality in one of my reports but i encountered this error. I am able to execute update command in database using the same credentials which i have in connection pool. so , i think my issue is not related to write acess. can anyone please let me know what the issue would be?
0 -
This thread is 3 years old and it's not your question. If you have an issue please open a new thread and clearly state your issue with full (exact) version, browser and all details pertaining to the issue.
0