Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Writeback not updating

Received Response
23
Views
11
Comments
User_IYEB1
User_IYEB1 Rank 2 - Community Beginner
edited Aug 13, 2024 5:47PM in Oracle Analytics Cloud and Server

Hi,

We see that writeback in our one of OBIEE dashboard doesn't work often .

After we update the field and press apply or done it returns back with no value, meaning no value in the field. This is using Administrator account and permission is all fine. We have seen that it works sometimes too.

in server log, i see below message.

<writeBackResponse statePath="d:dashboard~p:5umfsqmk9j2b492k~r:thh00oh0mqb8ttqm~v:compoundView!1~v:tableView!1" tableId="saw_3245_4" type="update"><success/></writeBackResponse>[[

[2018-06-07T03:19:15.000-05:00] [OBIPS] [TRACE:1] [] [saw.securitysubsystem.checkauthentication] [ecid: 005RWZkPoUp6uHMaELe9US00016E0018ap,0:1:1] [tid: 3378018048] Authentication variables pending updates in session (before apply): AuthSchema=UidPwd|PWD=******|UID=administrator[[

[2018-06-07T03:19:15.000-05:00] [OBIPS] [TRACE:1] [] [saw.securitysubsystem.checkauthentication] [ecid: 005RWZkPoUp6uHMaELe9US00016E0018ap,0:1:1] [tid: 3378018048] Authentication variables pending updates in session (after apply): AuthSchema=UidPwd|PWD=******|UID=administrator[[

Any inputs is appreciated.

Thanks

Smitha

«1

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Have you tried testing the same insert / update statement directly against the DB when it fails to rule out data types / lengths / constraints etc as an issue?

    And at the risk of repeating myself (1 minute before Christian ) have you thought of using Apex or similar tool that is fit for purpose for data insert / manipulation - writeback is a crock...

  • User_IYEB1
    User_IYEB1 Rank 2 - Community Beginner

    Hi!

    Thanks. Yes, tried update against the DB directly , it works.

    regarding other tools, not yet.

    Thanks

    Smitha

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    And do you get anything in the log when it fails?

    And is caching off for the analysis with the writeback?

    And are all other things equal when it works and doesn't work; - user, browser, data?

  • User_IYEB1
    User_IYEB1 Rank 2 - Community Beginner

    <writeBackResponse statePath="d:dashboard~p:5umfsqmk9j2b492k~r:thh00oh0mqb8ttqm~v:compoundView!1~v:tableView!1" tableId="saw_3245_4" type="update"><success/></writeBackResponse>[[

    [2018-06-07T03:19:15.000-05:00] [OBIPS] [TRACE:1] [] [saw.securitysubsystem.checkauthentication] [ecid: 005RWZkPoUp6uHMaELe9US00016E0018ap,0:1:1] [tid: 3378018048] Authentication variables pending updates in session (before apply): AuthSchema=UidPwd|PWD=******|UID=administrator[[

    [2018-06-07T03:19:15.000-05:00] [OBIPS] [TRACE:1] [] [saw.securitysubsystem.checkauthentication] [ecid: 005RWZkPoUp6uHMaELe9US00016E0018ap,0:1:1] [tid: 3378018048] Authentication variables pending updates in session (after apply): AuthSchema=UidPwd|PWD=******|UID=administrator

    I see above in the log.

    And are all other things equal when it works and doesn't work; - user, browser, data? Yes, that is correct. All other things equal.

    Below is our Writeback XML.

    <?xml version="1.0" encoding="UTF-8"?>

    <WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">

    <WebMessageTable lang="en-us" table="Messages" system="WriteBack">

    <WebMessage name="WB">

    <XML>

    <writeBack connectionPool="PLMA_CP">

    <insert>SELECT NULL FROM DUAL</insert>

    <update> UPDATE HRBL_PPM_WRITEBACK_D SET PM_NOTES='@{cb8485dcc848ed301}',ALERT='@{c0d191abea9d518a9}' WHERE ACTIVITY_NO='@{c685ec171e5828393}' </update>

    </writeBack>

    </XML>

    </WebMessage>

    </WebMessageTable>

    </WebMessageTables>

    Thanks

    SMitha

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Also, what version of OBIEE are you using?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    One other thought, can you also use something in your analysis or browser 'developer features' so you can see the values of '@{c685ec171e5828393}' at runtime?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    This is definitely a failure to update being logged??

    type="update"><success/></writeBackResponse>[[

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    And check this out to get a clue on why it is failing; -

    https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qew10ui6m_4&_afrLoop=546784445028864#FIX

    OBIEE 11g: Writeback Does Not Display Detailed Errors in Front End. (Doc ID 1360106.1)

  • User_IYEB1
    User_IYEB1 Rank 2 - Community Beginner

    Thank you, i will check all of the above.

    our obiee version is 11.1.1.7.160119

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    If your question is answered could you kindly close it / mark correct / helpful as appropriate.

    If not could you provide detail?