2648649 - Incorrect value set after tuning dsi_isolation_level through RS config to default value - SAP RS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2648649 - Incorrect value set after tuning dsi_isolation_level through RS config to default value - SAP RS

Symptom

  • Change the dsi_isolation_level to different value
  • Now set back the value to the default value
  • Post that when you try to suspend and resume the connection you get the below error

    I. 2018/02/24 15:25:38. The DSI thread for database 'DC_CCDWP.ONL_REP' is shutdown.
    I. 2018/02/24 15:25:48. The DSI thread for database 'DC_CCDWP.ONL_REP' is started.
    E. 2018/02/24 15:25:48. ERROR #1028 DSI(228 DC_CCDWP.ONL_REP) - /generic/useful/cm.c(5209)
     Message from server: Message: 2179, State 0, Severity 16 -- 'ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
    '.
    E. 2018/02/24 15:25:48. ERROR #13045 DSI(228 DC_CCDWP.ONL_REP) - /generic/useful/cm.c(5213)
  • in the screen window you can see the messages as below:
     State 0, Severity 16 -- 'ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
     attempt to rollback configuration  dsi_isolation_level  set '0'   or dsi_isolation_level  set 'default'   couldn't help to avoid the same error after resume connection

Read more...

Environment

  • SAP Adaptive Server Enterprise/16.X
  • SAP Replication Server 15.7.X

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0 ; SAP Sybase Replication Server 15.7, option for Oracle ; SY REP SERVER MESSAGING 15.7

Keywords

CR783519, CR#783519, 783519, rs_configure, DCO, DSI , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.