java.sql.SQLSyntaxErrorException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Error while linking the user
    via by 933033,
  • Unable to Start Oracle WebCenter Spaces
    via by user12303639,
  • Cannot insert into table PS_TXN
    via by cartesian,
  • Server startup issue
    via by 758233,
  • oracle.jbo.PCollException: JBO-28030
    via by user710437,
  • Indexing not working
    via by Njin,
  • Target Recon Not Working
    via by 877241,
    • 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(DatabaseError.java:135) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:423) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1095) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:201) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1036) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1379) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3568) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3739) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:8150) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99) at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1288) at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1271) at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17) at oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1316) at oracle.iam.reconciliation.dao.ReconActionDao.executeBulkUserMatchCRUD(ReconActionDao.java:686) at oracle.iam.reconciliation.impl.UserHandler.executeBulkCUD(UserHandler.java:568) at oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:34) at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:129) at oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:90) at oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72) at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:100) at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:70) at oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy334.onMessage(Unknown Source) at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466) at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371) at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327) at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659) at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345) at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821) at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115) at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170) at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)

    Users with the same issue

    asdasdasdasd
    2 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    JustinJustin
    1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    2 more bugmates