java.sql.SQLSyntaxErrorException: ORA-01741: identificador de longitud cero no válido[[

Oracle Community | 971772 | 4 years ago
  1. 0

    DBUM 9.1.0.4.0 add role task rejected

    Oracle Community | 4 years ago | 971772
    java.sql.SQLSyntaxErrorException: ORA-01741: identificador de longitud cero no válido[[
  2. 0

    Cant provision user using AD connector (9.1.1.7.2) in OIM (11.1.1.5.0)

    Oracle Community | 5 years ago | user10233157
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  3. 0

    invalid character when running liquibase script

    Stack Overflow | 3 years ago | Marthin
    java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-00933 When trying to insert space followed by "n" Character

    Stack Overflow | 2 years ago | Slettal
    com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 12: INSERT INTO TEST (TEST) VALUES ( ' n');
  6. 0

    Executing SQL Script via Ant

    Stack Overflow | 2 years ago | user1259318
    java.sql.SQLSyntaxErrorException: ORA-00922: Fehlende oder ungültige Option

    3 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-01741: identificador de longitud cero no válido[[

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.execute
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
      8. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1074)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
      10. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2224)
      11. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2168)
      12. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:333)
      12 frames
    3. oracle.iam.connectors
      DBUMProvisionManager.executeQuery
      1. oracle.iam.connectors.dbum.common.db.util.DBUtil.executeQuery(Unknown Source)
      2. oracle.iam.connectors.dbum.common.db.util.DBUtil.executeQuery(Unknown Source)
      3. oracle.iam.connectors.dbum.operation.DBUMDatabaseOperation.executeQuery(Unknown Source)
      4. oracle.iam.connectors.dbum.integration.DBUMProvisionProxyManager.executeQuery(Unknown Source)
      5. oracle.iam.connectors.dbum.integration.DBUMProvisionManager.executeQuery(Unknown Source)
      5 frames
    4. 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
    5. com.thortech.xl
      tcFormInstanceOperationsBean.addProcessFormChildData
      1. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpDBUMEXECUTEQUERY.EXECUTEQUERY(adpDBUMEXECUTEQUERY.java:178)
      2. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpDBUMEXECUTEQUERY.implementation(adpDBUMEXECUTEQUERY.java:87)
      3. com.thortech.xl.client.events.tcBaseEvent.run(tcBaseEvent.java:196)
      4. com.thortech.xl.dataobj.tcDataObj.runEvent(tcDataObj.java:2492)
      5. com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(tcScheduleItem.java:2917)
      6. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(tcScheduleItem.java:547)
      7. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
      8. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
      9. com.thortech.xl.dataobj.tcOrderItemInfo.processChildTableChange(tcOrderItemInfo.java:655)
      10. com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(tcOrderItemInfo.java:184)
      11. com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:234)
      12. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
      13. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
      14. com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
      15. com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.addProcessFormChildData(tcFormInstanceOperationsBean.java:1929)
      16. com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.addProcessFormChildData(tcFormInstanceOperationsBean.java:1593)
      16 frames
    6. Thor.API.Operations
      tcFormInstanceOperationsIntfEJB.addProcessFormChildDatax
      1. Thor.API.Operations.tcFormInstanceOperationsIntfEJB.addProcessFormChildDatax(Unknown Source)
      1 frame
    7. 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
    8. com.bea.core
      MethodInvocationVisitorImpl.visit
      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.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      7. com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
      7 frames
    9. weblogic.ejb.container
      EnvironmentInterceptorCallbackImpl.callback
      1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
      1 frame
    10. com.bea.core
      JdkDynamicAopProxy.invoke
      1. com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
      2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      3. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      4. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      6. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      7. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      8. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      8 frames
    11. Unknown
      $Proxy352.addProcessFormChildDatax
      1. $Proxy352.addProcessFormChildDatax(Unknown Source)
      1 frame
    12. Thor.API.Operations
      tcFormInstanceOperationsIntfEJB_h6wb8n_tcFormInstanceOperationsIntfRemoteImpl.__WL_invoke
      1. Thor.API.Operations.tcFormInstanceOperationsIntfEJB_h6wb8n_tcFormInstanceOperationsIntfRemoteImpl.__WL_invoke(Unknown Source)
      1 frame
    13. weblogic.ejb.container
      SessionRemoteMethodInvoker.invoke
      1. weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
      1 frame
    14. Thor.API.Operations
      tcFormInstanceOperationsIntfEJB_h6wb8n_tcFormInstanceOperationsIntfRemoteImpl.addProcessFormChildDatax
      1. Thor.API.Operations.tcFormInstanceOperationsIntfEJB_h6wb8n_tcFormInstanceOperationsIntfRemoteImpl.addProcessFormChildDatax(Unknown Source)
      1 frame
    15. 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
    16. weblogic.ejb.container
      RemoteBusinessIntfProxy.invoke
      1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
      1 frame
    17. Unknown
      $Proxy175.addProcessFormChildDatax
      1. $Proxy175.addProcessFormChildDatax(Unknown Source)
      1 frame
    18. 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
    19. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
      2 frames
    20. Unknown
      $Proxy351.addProcessFormChildDatax
      1. $Proxy351.addProcessFormChildDatax(Unknown Source)
      1 frame
    21. Thor.API.Operations
      tcFormInstanceOperationsIntfDelegate.addProcessFormChildData
      1. Thor.API.Operations.tcFormInstanceOperationsIntfDelegate.addProcessFormChildData(Unknown Source)
      1 frame
    22. com.thortech.xl
      DirectProvisionUserAction.goNext
      1. com.thortech.xl.webclient.actions.DirectProvisionUserAction.handleVerifyProcessData(DirectProvisionUserAction.java:2093)
      2. com.thortech.xl.webclient.actions.DirectProvisionUserAction.goNext(DirectProvisionUserAction.java:363)
      2 frames
    23. 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
    24. struts
      DispatchAction.dispatchMethod
      1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
      1 frame
    25. com.thortech.xl
      tcAction.execute
      1. com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(tcLookupDispatchAction.java:133)
      2. com.thortech.xl.webclient.actions.tcActionBase.execute(tcActionBase.java:894)
      3. com.thortech.xl.webclient.actions.tcAction.execute(tcAction.java:213)
      3 frames
    26. Struts Core
      ActionCommandBase.execute
      1. org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
      2. org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
      3. org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
      3 frames
    27. Commons Chain
      ChainBase.execute
      1. org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
      2. org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
      3. org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
      3 frames
    28. Struts Core
      ComposableRequestProcessor.process
      1. org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
      1 frame
    29. struts
      ActionServlet.doPost
      1. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
      2. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
      2 frames
    30. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2 frames
    31. 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:300)
      4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      5 frames
    32. com.thortech.xl
      CSRFFilter.doFilter
      1. com.thortech.xl.webclient.security.CSRFFilter.doFilter(CSRFFilter.java:76)
      1 frame
    33. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    34. oracle.iam.platform
      PwdMgmtNavigationFilter.doFilter
      1. oracle.iam.platform.auth.web.PwdMgmtNavigationFilter.doFilter(PwdMgmtNavigationFilter.java:121)
      1 frame
    35. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    36. oracle.iam.platform
      OIMAuthContextFilter.doFilter
      1. oracle.iam.platform.auth.web.OIMAuthContextFilter.doFilter(OIMAuthContextFilter.java:107)
      1 frame
    37. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    38. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
      1 frame
    39. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    40. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
      3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
      4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
      5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      5 frames
    41. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    42. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
      1 frame
    43. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
      3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
      5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
      5 frames
    44. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    45. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    46. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
      2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
      3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
      3 frames
    47. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
      2 frames