Re: oracle wms are hanging

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/oracle-wms-are-hanging-tp8068p8073.html

This seems like an internal issue.

Collected info:
WMS ORA-01086 -- Probably a rollback is happening (with to savepoint clause), which erases all the savepoints automatically.
Note that:  Rollback without a savepoint ends the transaction, undoes all changes in the current transaction, erases all savepoints in the transaction and releases any transaction locks

probably, something is failing and it makes a rolback of the whole transaction.. We need to find what is failing.. That ORA-01086 may be a result rather than a cause.

UtilFns.java:719 -- the code and the line that is failing..
java.sql.SQLException: Exception while calling java.sql.SQLRecoverableException: No more data to read from socket -- this seems like a crash happening on the other side of the process where the data is read.

Please send me a debug log for the WMS:

How To Create INV Debug and MWA Log Files From WMS/MSCA Transactions Along With Pick Release and Interface Trip Stop Logs (Doc ID 1400383.1)

Also create a SR in parallel.. This may be caused by a bug or by a wrong data , as well..