java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock ORA-06512: at "TST2B_OIM.OIM_SP_RECONBLKUSERCRUD", line 3844 ORA-06512: at "TST2B_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:95)

Oracle Community | 933033 | 4 years ago
  1. 0

    Error while linking the user

    Oracle Community | 4 years ago | 933033
    java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock ORA-06512: at "TST2B_OIM.OIM_SP_RECONBLKUSERCRUD", line 3844 ORA-06512: at "TST2B_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:95)
  2. 0

    Invalid datatype while calling a procedure from java

    Stack Overflow | 3 years ago | user980956
    java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype</p> <pre><code>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
  3. 0

    Unable to Start Oracle WebCenter Spaces

    Oracle Community | 7 years ago | user12303639
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cannot insert into table PS_TXN

    Oracle Community | 5 years ago | cartesian
    oracle.jbo.PCollException: JBO-28030: Could not insert row into table PS_TXN, collection id 3,956, persistent id 1
  6. 0

    ORA-06512: at "DEV3_SOAINFRA.EDN_DEQUEUE_OAOO_DELIVERY"

    Oracle Community | 4 years ago | ajgolden
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_AQ", line 335 ORA-06512: at "DEV3_SOAINFRA.EDN_DEQUEUE_OAOO_DELIVERY", line 14
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLSyntaxErrorException

    ORA-02049: timeout: distributed transaction waiting for lock ORA-06512: at "TST2B_OIM.OIM_SP_RECONBLKUSERCRUD", line 3844 ORA-06512: at "TST2B_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:95)

    at oracle.jdbc.driver.DatabaseError.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
    2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
    3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:423)
    5. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1095)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:201)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1036)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1379)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3568)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3739)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:8150)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.execute
    1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
    1 frame
  4. oracle.iam.reconciliation
    ActionTask.execute
    1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1288)
    2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1271)
    3. oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17)
    4. oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1316)
    5. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkUserMatchCRUD(ReconActionDao.java:686)
    6. oracle.iam.reconciliation.impl.UserHandler.executeBulkCUD(UserHandler.java:568)
    7. oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:34)
    8. oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:129)
    9. oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:90)
    10. oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)
    10 frames
  5. oracle.iam.platform
    MessageReceiver.onMessage
    1. oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:100)
    2. oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:70)
    3. oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
    3 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  7. com.bea.core
    JdkDynamicAopProxy.invoke
    1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
    2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    4. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    5. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    6. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    7. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    8. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    9. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    9 frames
  8. Unknown
    $Proxy334.onMessage
    1. $Proxy334.onMessage(Unknown Source)
    1 frame
  9. weblogic.ejb.container
    MDListener.onMessage
    1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
    2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
    3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
    3 frames
  10. weblogic.jms.client
    JMSSession$UseForRunnable.run
    1. weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
    2. weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
    3. weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
    4. weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
    5. weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
    5 frames
  11. weblogic.work
    ExecuteThread.execute
    1. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
    2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    2 frames