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.