java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

Oracle Community | 793564 | 5 years ago
  1. 0

    get lookup decode values

    Oracle Community | 5 years ago | 793564
    java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
  2. 0

    Site Studio 11g--unable to get search results

    Oracle Community | 6 years ago | oim11guser
    java.sql.SQLSyntaxErrorException: ORA-00904: "CONTAINS": invalid identifier
  3. 0

    UCM starting problem

    Oracle Community | 5 years ago | 921791
    intradoc.common.ServiceException: !csSchemaUnableToPublishView,EBSDocClassView
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error while notifying on resource provisioning

    Oracle Community | 6 years ago | user1464585
    java.sql.SQLSyntaxErrorException: ORA-00936: manglende udtryk
  6. 0

    unable to access the url http:\\hostname:16300\urm "server unavailable"

    Oracle Community | 4 years ago | 753060
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

  1. bpbhat77 1 times, last 6 months ago
8 unregistered visitors
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-00907: missing right parenthesis

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OracleStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
    8. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
    9. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
    12. oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
    12 frames
  3. weblogic.jdbc.wrapper
    Statement.executeQuery
    1. weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:479)
    1 frame
  4. com.thortech.xl
    tcLookupOperations_u50o5o_ELOImpl.getLookupValuesForEncoded
    1. com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source)
    2. com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
    3. com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
    4. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
    5. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
    6. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
    7. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
    8. com.thortech.xl.ejb.beansimpl.tcLookupOperationsBean.getLookupValuesForEncoded(Unknown Source)
    9. com.thortech.xl.ejb.beans.tcLookupOperationsSession.getLookupValuesForEncoded(Unknown Source)
    10. com.thortech.xl.ejb.beans.tcLookupOperations_u50o5o_ELOImpl.getLookupValuesForEncoded(tcLookupOperations_u50o5o_ELOImpl.java:484)
    10 frames
  5. Thor.API.Operations
    tcLookupOperationsClient.getLookupValuesForEncoded
    1. Thor.API.Operations.tcLookupOperationsClient.getLookupValuesForEncoded(Unknown Source)
    1 frame
  6. com.thortech.xl
    tcFormInstanceOperations_2j82mm_EOImpl.setProcessFormData
    1. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpTESTGPADAPTER.GET(adpTESTGPADAPTER.java:137)
    2. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpTESTGPADAPTER.implementation(adpTESTGPADAPTER.java:62)
    3. com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)
    4. com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)
    5. com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source)
    6. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source)
    7. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    8. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    9. com.thortech.xl.dataobj.tcScheduleItem.insertResponseMilestones(Unknown Source)
    10. com.thortech.xl.dataobj.tcScheduleItem.eventPostUpdate(Unknown Source)
    11. com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
    12. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    13. com.thortech.xl.adapterfactory.events.tcAdpEvent.updateSchItem(Unknown Source)
    14. com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeProcessAdapter(Unknown Source)
    15. com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeAdapter(Unknown Source)
    16. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpADCSPTCREATEUSER.implementation(adpADCSPTCREATEUSER.java:105)
    17. com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)
    18. com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)
    19. com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source)
    20. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source)
    21. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    22. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    23. com.thortech.xl.dataobj.tcORC.insertNonConditionalMilestones(Unknown Source)
    24. com.thortech.xl.dataobj.tcORC.completeSystemValidationMilestone(Unknown Source)
    25. com.thortech.xl.dataobj.tcOrderItemInfo.completeCarrierBaseMilestone(Unknown Source)
    26. com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(Unknown Source)
    27. com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(Unknown Source)
    28. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    29. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    30. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    31. com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.setProcessFormData(Unknown Source)
    32. com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.setProcessFormData(Unknown Source)
    33. com.thortech.xl.ejb.beans.tcFormInstanceOperationsSession.setProcessFormData(Unknown Source)
    34. com.thortech.xl.ejb.beans.tcFormInstanceOperations_2j82mm_EOImpl.setProcessFormData(tcFormInstanceOperations_2j82mm_EOImpl.java:554)
    34 frames
  7. Thor.API.Operations
    tcFormInstanceOperationsClient.setProcessFormData
    1. Thor.API.Operations.tcFormInstanceOperationsClient.setProcessFormData(Unknown Source)
    1 frame
  8. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1549.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  9. Thor.API.Base
    SecurityInvocationHandler$1.run
    1. Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source)
    1 frame
  10. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  11. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  12. weblogic.security
    Security.runAs
    1. weblogic.security.Security.runAs(Security.java:41)
    1 frame
  13. Thor.API.Security
    weblogicLoginSession.runAs
    1. Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(Unknown Source)
    1 frame
  14. Thor.API.Base
    SecurityInvocationHandler.invoke
    1. Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source)
    1 frame
  15. Unknown
    $Proxy67.setProcessFormData
    1. $Proxy67.setProcessFormData(Unknown Source)
    1 frame
  16. com.thortech.xl
    DirectProvisionUserAction.goNext
    1. com.thortech.xl.webclient.actions.DirectProvisionUserAction.handleVerifyProcessData(Unknown Source)
    2. com.thortech.xl.webclient.actions.DirectProvisionUserAction.goNext(Unknown Source)
    2 frames
  17. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor646.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  18. struts
    DispatchAction.dispatchMethod
    1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
    1 frame
  19. com.thortech.xl
    tcAction.execute
    1. com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source)
    2. com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source)
    3. com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source)
    3 frames
  20. struts
    ActionServlet.doPost
    1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    3. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    4. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    4 frames
  21. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  22. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  23. com.thortech.xl
    SecurityFilter.doFilter
    1. com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
    1 frame
  24. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
    2 frames
  25. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  26. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  27. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
    3 frames
  28. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    2 frames