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

    Write Back in OBIEE 12c

    DentsplySirona

      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.