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.

  • Send Email Notification failing
    via by 819936,
  • Target REconciliation
    via by Srivatsa.kashyap,
  • Lookup Query Error in Process Form
    via by Oim Developer,
  • UCM starting problem
    via by 921791,
    • java.sql.SQLSyntaxErrorException: ORA-00936: missing expression 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:1187) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1378) 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.dataobj.util.tcEmailNotificationUtil.getFromAddress(Unknown Source) at com.thortech.xl.dataobj.util.tcEmailNotificationUtil.constructEmail(Unknown Source) at com.thortech.xl.dataobj.util.tcEmailNotificationUtil.constructEmail(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.checkForEmailNotification(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.tcORC.postInsertSysVal(Unknown Source) at com.thortech.xl.dataobj.tcORC.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.dataobj.util.tcOrderPackages.createProcessORC(Unknown Source) at com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(Unknown Source) at com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(Unknown Source) at com.thortech.xl.dataobj.tcOIU.provision(Unknown Source) at com.thortech.xl.dataobj.tcOIU.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.dataobj.tcUserProvisionObject.insertImplementation(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.provisionObject(Unknown Source) at com.thortech.xl.ejb.beans.tcUserOperationsSession.provisionObject(Unknown Source) at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.provisionObject(Unknown Source) at com.thortech.xl.ejb.beans.tcUserOperationsSession.provisionObject(Unknown Source) at com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.provisionObject(tcUserOperations_voj9p2_EOImpl.java:3413) at Thor.API.Operations.tcUserOperationsClient.provisionObject(Unknown Source) at sun.reflect.GeneratedMethodAccessor447.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 $Proxy65.provisionObject(Unknown Source) at com.thortech.xl.webclient.actions.DirectProvisionUserAction.handleVerifyResource(Unknown Source) at com.thortech.xl.webclient.actions.DirectProvisionUserAction.goNext(Unknown Source) at sun.reflect.GeneratedMethodAccessor299.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.CSRFFilter.doFilter(Unknown Source) 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:3588) 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:2200) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2106) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1428) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

    Users with the same issue

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