IBM Sterling Ideas

formerly Watson Supply Chain

Submit new product ideas for IBM Sterling solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed. Order Management, Store Engagement, Watson Order Optimizer, Inventory Visibility, CPQ and Call Center are now part of Watson Supply Chain

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

WTX/ITX Oracle adapter - automatic failover implementation

We are using the WTX/ITX Oracle adapter for our connection with an Oracle Exadata database. 

In case of database failure, Exadate switch automaticly to the second cluster node.


>> Problem :

 At the switch time, all running maps faile with error code :

 Error returned by OCIDescribeAny, errcode=25408

ORA-25408: can not safely replay call

 So, we must restart all systems and launchers to avoid this error.

 IBM recommended to use the ODBC adapter because that adapter support automatic failover.

 However, with the ODBC adapter, we have some trouble (see case TS002019037 for details)


 >> Solution :

We ask IBM to improve the Oracle adapter for the support of automatic failover to another node in Oracle cluster.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Apr 12 2019
  • Declined
How will this idea be used?

We will use this idea to improve our failover process 

What is your industry? Financial Markets
What is the idea priority? Urgent
  • Attach files
  • Admin
    Luke Raiano commented
    27 Aug, 2019 05:35pm

    AS infrastructure moves quickly to utilize Docker containers, this issue is greatly alleviated

  • Admin
    Luke Raiano commented
    28 May, 2019 05:19pm