ORA-01013: User Requested Cancel Of Current Operation

 

How To Handle Error Java.sql.SQLException: ORA-01013: User Requested Cancel Of Current Operation [ID 788246.1]

--------------------------------------------------------------------------------
 
  修改时间 29-OCT-2010     类型 HOWTO     状态 PUBLISHED  

In this Document
  Goal
  Solution

 

--------------------------------------------------------------------------------

 

Applies to:
Oracle Communications Order and Service Management - Version: 2.5.2 to 7.0.1 - Release: 2.5 to 7.0.0

Goal
This note describes how to handle the following ORA-1013 error when it appears in the OSM WebLogic server log:

<600108> : ORA-01013: user requested cancel of current operation

com.mslv.oms.handler.InternalErrorException: ORA-01013: user requested cancel of current operation
: ORA-01013: user requested cancel of current operation

at com.mslv.oms.handler.a.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)
at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)
at com.mslv.oms.jsp.processor.QueryResultsProcessor.d(Unknown Source)
at com.mslv.oms.jsp.processor.QueryResultsProcessor.processRequest(Unknown Source)
Truncated. see log file for complete stacktrace
java.sql.SQLException: ORA-01013: user requested cancel of current operation

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)

Solution
JDBC pool oms_pool has the following parameter to deal with this:
'Statement Timeout: '

For example, a setting of 60 will mean that whenever there is request from sessions in oms_pool, the session will set up a timer of 60 seconds. If the request can't finish within 60 seconds, the timer will be triggered and inform. the database to stop this request. As a result, the database duly complies.

Generally we should set up this parameter 'Statement Timeout: ' for all JDBC pools in OSM WebLogic domain, doing so will prevent JDBC sessions from hanging.

JDBC pool 'Statement Timeout: ' should always be greater than JTA of BEA domain.

If you run into ORA-01013, you can:

1. Analyze what the request should be, should it be finished with 'Statement Timeout: '? Is performance tuning needed?

2. Increase 'Statement Timeout: ' to quickly resolve the problem, you may need to increase JTA as well.

 相关的

 

--------------------------------------------------------------------------------
产品
--------------------------------------------------------------------------------

•More Applications > Industry Solutions > Communications > Oracle Communications Order and Service Management
关键字
--------------------------------------------------------------------------------
JAVA.SQL.SQLEXCEPTION; OMS; THROWSQLEXCEPTION; WEBLOGIC; PERFORMANCE TUNING; TIME OUT
错误
--------------------------------------------------------------------------------
ORA-1013; 1013 ERROR

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9252210/viewspace-681965/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9252210/viewspace-681965/