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.

  • get lookup decode values
    via by 793564,
  • UCM starting problem
    via by 921791,
  • Recon staus at Event Received
    via by 790345,
  • Send Email Notification failing
    via by 819936,
  • Target REconciliation
    via by Srivatsa.kashyap,
    • java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387) at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:479) at com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source) at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source) at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source) at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source) at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source) at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source) at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source) at com.thortech.xl.ejb.beansimpl.tcLookupOperationsBean.getLookupValuesForEncoded(Unknown Source) at com.thortech.xl.ejb.beans.tcLookupOperationsSession.getLookupValuesForEncoded(Unknown Source) at com.thortech.xl.ejb.beans.tcLookupOperations_u50o5o_ELOImpl.getLookupValuesForEncoded(tcLookupOperations_u50o5o_ELOImpl.java:484) at Thor.API.Operations.tcLookupOperationsClient.getLookupValuesForEncoded(Unknown Source) at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpTESTGPADAPTER.GET(adpTESTGPADAPTER.java:137) at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpTESTGPADAPTER.implementation(adpTESTGPADAPTER.java:62) at com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.insertResponseMilestones(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.eventPostUpdate(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.adapterfactory.events.tcAdpEvent.updateSchItem(Unknown Source) at com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeProcessAdapter(Unknown Source) at com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeAdapter(Unknown Source) at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpADCSPTCREATEUSER.implementation(adpADCSPTCREATEUSER.java:105) at com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcORC.insertNonConditionalMilestones(Unknown Source) at com.thortech.xl.dataobj.tcORC.completeSystemValidationMilestone(Unknown Source) at com.thortech.xl.dataobj.tcOrderItemInfo.completeCarrierBaseMilestone(Unknown Source) at com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(Unknown Source) at com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source) at com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.setProcessFormData(Unknown Source) at com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.setProcessFormData(Unknown Source) at com.thortech.xl.ejb.beans.tcFormInstanceOperationsSession.setProcessFormData(Unknown Source) at com.thortech.xl.ejb.beans.tcFormInstanceOperations_2j82mm_EOImpl.setProcessFormData(tcFormInstanceOperations_2j82mm_EOImpl.java:554) at Thor.API.Operations.tcFormInstanceOperationsClient.setProcessFormData(Unknown Source) at sun.reflect.GeneratedMethodAccessor1549.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.security.Security.runAs(Security.java:41) at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(Unknown Source) at Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source) at $Proxy67.setProcessFormData(Unknown Source) at com.thortech.xl.webclient.actions.DirectProvisionUserAction.handleVerifyProcessData(Unknown Source) at com.thortech.xl.webclient.actions.DirectProvisionUserAction.goNext(Unknown Source) at sun.reflect.GeneratedMethodAccessor646.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280) at com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source) at com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source) at com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

    Users with the same issue

    Unknown visitor2 times, last one,
    bpbhat77
    1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    543 more bugmates