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

Oracle Community | 952827 | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 7 years ago | oim11guser
    java.sql.SQLSyntaxErrorException: ORA-00904: "CONTAINS": invalid identifier
  6. 0

    Error while notifying on resource provisioning

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

  1. bpbhat77 1 times, last 10 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