java.sql.SQLSyntaxErrorException: ORA-00904: "UD_DB_ORA_P_KEY": invalid identifier

Oracle Community | 952827 | 4 years ago
  1. 0

    Error granting privileges and roles with a cloned DBUM connector oim11g

    Oracle Community | 4 years ago | 952827
    java.sql.SQLSyntaxErrorException: ORA-00904: "UD_DB_ORA_P_KEY": invalid identifier
  2. 0

    UCM starting problem

    Oracle Community | 5 years ago | 921791
    intradoc.common.ServiceException: !csSchemaUnableToPublishView,EBSDocClassView
  3. 0

    Error request using dataset which contains child form

    Oracle Community | 4 years ago | TimBenga
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Site Studio 11g--unable to get search results

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

    Error while notifying on resource provisioning

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

  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-00904: "UD_DB_ORA_P_KEY": invalid identifier

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OracleStatementWrapper.executeQuery
    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.executeForDescribe(T4CStatement.java:919)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1668)
    12. oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:432)
    12 frames
  3. weblogic.jdbc.wrapper
    Statement.executeQuery
    1. weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:487)
    1 frame
  4. com.thortech.xl
    tcDataObj.save
    1. com.thortech.xl.util.JDBCUtils.executeQuery(JDBCUtils.java:159)
    2. com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:728)
    3. com.thortech.xl.dataobj.tcDataBase.readPartialStatement(tcDataBase.java:271)
    4. com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:935)
    5. com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1523)
    6. com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:903)
    7. com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1490)
    8. com.thortech.xl.adapterfactory.events.tcAdpEvent.getChildTableFieldValue(tcAdpEvent.java:2261)
    9. com.thortech.xl.adapterfactory.events.tcAdpEvent.getRunTimeValue(tcAdpEvent.java:806)
    10. com.thortech.xl.adapterfactory.events.tcAdpEvent.getRunTimeValue(tcAdpEvent.java:680)
    11. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpBBDORAADDUSERTOGROUP.implementation(adpBBDORAADDUSERTOGROUP.java:50)
    12. com.thortech.xl.client.events.tcBaseEvent.run(tcBaseEvent.java:196)
    13. com.thortech.xl.dataobj.tcDataObj.runEvent(tcDataObj.java:2492)
    14. com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(tcScheduleItem.java:2917)
    15. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(tcScheduleItem.java:547)
    16. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
    17. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
    18. com.thortech.xl.dataobj.tcOrderItemInfo.processChildTableChange(tcOrderItemInfo.java:655)
    19. com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(tcOrderItemInfo.java:184)
    20. com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:235)
    21. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
    22. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
    23. com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
    24. com.thortech.xl.dataobj.tcUDProcess.addUDChildData(tcUDProcess.java:1867)
    25. com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:363)
    26. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
    27. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
    28. com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
    29. com.thortech.xl.dataobj.tcORC.autoDOBSave(tcORC.java:3002)
    30. com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(tcOrderPackages.java:526)
    31. com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(tcOrderPackages.java:177)
    32. com.thortech.xl.dataobj.tcOIU.provision(tcOIU.java:527)
    33. com.thortech.xl.dataobj.tcOIU.eventPostInsert(tcOIU.java:303)
    34. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
    35. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
    36. com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
    37. com.thortech.xl.dataobj.tcUserProvisionObject.insertImplementation(tcUserProvisionObject.java:283)
    38. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:591)
    39. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
    39 frames
  5. oracle.iam.accesspolicy
    ProvisionAccountActionHandler.execute
    1. oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:104)
    2. oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:35)
    2 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor2179.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  7. oracle.iam.platform
    EventHandlerDynamicProxy.invoke
    1. oracle.iam.platform.kernel.impl.EventHandlerDynamicProxy.invoke(EventHandlerDynamicProxy.java:30)
    1 frame
  8. Unknown
    $Proxy250.execute
    1. $Proxy250.execute(Unknown Source)
    1 frame
  9. oracle.iam.platform
    OrchestrationEngineImpl.orchestrate
    1. oracle.iam.platform.kernel.impl.OrchProcessData.runActionEvents(OrchProcessData.java:1036)
    2. oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:644)
    3. oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:227)
    4. oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:739)
    5. oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.process(OrchestrationEngineImpl.java:499)
    6. oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.orchestrate(OrchestrationEngineImpl.java:444)
    7. oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.orchestrate(OrchestrationEngineImpl.java:378)
    7 frames
  10. oracle.iam.accesspolicy
    AccessPolicyServiceEJB.evalutePoliciesForUserx
    1. oracle.iam.accesspolicy.impl.AccessPolicyServiceImpl.evalutePoliciesForUser(AccessPolicyServiceImpl.java:182)
    2. oracle.iam.accesspolicy.api.AccessPolicyServiceEJB.evalutePoliciesForUserx(Unknown Source)
    2 frames
  11. 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
  12. 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
  13. weblogic.ejb.container
    EnvironmentInterceptorCallbackImpl.callback
    1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
    1 frame
  14. 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
  15. Unknown
    $Proxy388.evalutePoliciesForUserx
    1. $Proxy388.evalutePoliciesForUserx(Unknown Source)
    1 frame
  16. oracle.iam.accesspolicy
    AccessPolicyService_vb2s0z_AccessPolicyServiceRemoteImpl.__WL_invoke
    1. oracle.iam.accesspolicy.api.AccessPolicyService_vb2s0z_AccessPolicyServiceRemoteImpl.__WL_invoke(Unknown Source)
    1 frame
  17. weblogic.ejb.container
    SessionRemoteMethodInvoker.invoke
    1. weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
    1 frame
  18. oracle.iam.accesspolicy
    AccessPolicyService_vb2s0z_AccessPolicyServiceRemoteImpl.evalutePoliciesForUserx
    1. oracle.iam.accesspolicy.api.AccessPolicyService_vb2s0z_AccessPolicyServiceRemoteImpl.evalutePoliciesForUserx(Unknown Source)
    1 frame
  19. 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
  20. weblogic.ejb.container
    RemoteBusinessIntfProxy.invoke
    1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
    1 frame
  21. Unknown
    $Proxy208.evalutePoliciesForUserx
    1. $Proxy208.evalutePoliciesForUserx(Unknown Source)
    1 frame
  22. 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
  23. 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
  24. Unknown
    $Proxy387.evalutePoliciesForUserx
    1. $Proxy387.evalutePoliciesForUserx(Unknown Source)
    1 frame
  25. oracle.iam.accesspolicy
    AccessPolicyServiceDelegate.evalutePoliciesForUser
    1. oracle.iam.accesspolicy.api.AccessPolicyServiceDelegate.evalutePoliciesForUser(Unknown Source)
    1 frame
  26. oracle.iam.identity
    RoleGrantPostProcessActionHandler.execute
    1. oracle.iam.identity.rolemgmt.impl.handlers.grantrole.RoleGrantPostProcessActionHandler.evaluateAccessPolicies(RoleGrantPostProcessActionHandler.java:186)
    2. oracle.iam.identity.rolemgmt.impl.handlers.grantrole.RoleGrantPostProcessActionHandler.execute(RoleGrantPostProcessActionHandler.java:116)
    3. oracle.iam.identity.rolemgmt.impl.handlers.grantrole.RoleGrantPostProcessActionHandler.execute(RoleGrantPostProcessActionHandler.java:68)
    3 frames
  27. oracle.iam.platform
    MessageReceiver.onMessage
    1. oracle.iam.platform.kernel.impl.OrchProcessData.runPostProcessEvents(OrchProcessData.java:1167)
    2. oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:711)
    3. oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:227)
    4. oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:749)
    5. oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:780)
    6. oracle.iam.platform.kernel.impl.OrhestrationAsyncTask.execute(OrhestrationAsyncTask.java:129)
    7. oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:101)
    8. oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:71)
    9. oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
    9 frames
  28. 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
  29. com.bea.core
    JdkDynamicAopProxy.invoke
    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.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    5. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    6. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    7. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    8. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    9. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    9 frames
  30. Unknown
    $Proxy386.onMessage
    1. $Proxy386.onMessage(Unknown Source)
    1 frame
  31. weblogic.ejb.container
    MDListener.onMessage
    1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:574)
    2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:477)
    3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:379)
    3 frames
  32. weblogic.jms.client
    JMSSession$UseForRunnable.run
    1. weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
    2. weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
    3. weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
    4. weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
    5. weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
    5 frames
  33. weblogic.work
    ExecuteThread.run
    1. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
    2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
    3. weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
    3 frames