java.sql.SQLException: user lacks privilege or object not found: EMPSCH.EMPSCHPK

Oracle Community | Revanth Tambisetty | 2 years ago
  1. 0

    ODI not able to detect primary/foreign keys from XML- user lacks privilege or object not found

    Oracle Community | 2 years ago | Revanth Tambisetty
    java.sql.SQLException: user lacks privilege or object not found: EMPSCH.EMPSCHPK
  2. 0

    XML import error while Load Data :user lacks privilege or object not found

    Oracle Community | 5 years ago | Abhishek
    java.sql.SQLException: user lacks privilege or object not found: FUSION_BEN_ELIGY_PRFL_ROW.C5_DESCRIPTION
  3. 0

    lack of privilege error when running a interface

    Oracle Community | 3 years ago | 901958
    java.sql.SQLException: user lacks privilege or object not found: C1_PRICEPROMOTIONORDER
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error loading  Oracle to XML: ODI 1228: unknown token

    Oracle Community | 5 years ago | 874943
    java.sql.SQLException: unknown token
  6. 0

    Error While viewing data on XML model- java.sql.SQLException: constante num

    Oracle Community | 5 years ago | 71218
    java.sql.SQLException: constante numérica mal escrita

  1. kjhdofjosvs 1 times, last 1 week ago
  2. andyglick 2 times, last 4 weeks ago
  3. marcbouvierdav 1 times, last 2 months ago
  4. WoodenDoors 67 times, last 8 months ago
87 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. org.hsqldb.HsqlException

    user lacks privilege or object not found: EMPSCH.EMPSCHPK

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Unknown Source)
    1 frame
  3. HSQLDB
    JDBCConnection.prepareStatement
    1. org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)
    2. org.hsqldb.QueryExpression.resolve(Unknown Source)
    3. org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    4. org.hsqldb.ParserCommand.compilePart(Unknown Source)
    5. org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    6. org.hsqldb.Session.compileStatement(Unknown Source)
    7. org.hsqldb.StatementManager.compile(Unknown Source)
    8. org.hsqldb.Session.execute(Unknown Source)
    9. org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
    10. org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    10 frames
  4. com.sunopsis.jdbc
    SnpsXmlConnection.prepareStatement
    1. com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.prepareStatement(SnpsXmlConnection.java:1232)
    1 frame
  5. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  6. oracle.odi.core
    OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke
    1. oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke(OnConnectOnDisconnectDataSourceAdapter.java:200)
    1 frame
  7. Unknown
    $Proxy2.prepareStatement
    1. $Proxy2.prepareStatement(Unknown Source)
    1 frame
  8. oracle.odi.runtime
    DataMovementTaskExecutionHandler.handleTask
    1. oracle.odi.runtime.agent.execution.sql.SQLCommand.doInitializeStatement(SQLCommand.java:83)
    2. oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:117)
    3. oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:111)
    4. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:81)
    5. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:1)
    6. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:70)
    6 frames
  9. com.sunopsis.dwg
    SnpSession.treatSession
    1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
    5 frames
  10. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
    1 frame
  11. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    1 frame
  12. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    5 frames
  13. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame