java.sql.SQLException: user lacks privilege or object not found: SHIPORDER.SHIPORDERPK

Oracle Community | 3162137 | 10 months ago
  1. 0

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

    Oracle Community | 10 months ago | 3162137
    java.sql.SQLException: user lacks privilege or object not found: SHIPORDER.SHIPORDERPK
  2. 0

    Issue while writing xml file

    Oracle Community | 2 years ago | 2655429
    java.sql.SQLException: unexpected token: C$_COMMDAILY required: (
  3. 0

    error loading mutiple xml files in odi 11g

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

    Automated exception search integrated into your IDE

  5. 0

    Date data load error while loading xml data to oracle db

    Oracle Community | 4 years ago | user705850
    java.sql.SQLException: user lacks privilege or object not found: TO_DATE
  6. 0

    odi 11g - malformed numeric constant thru view data

    Oracle Community | 3 years ago | user645637
    java.sql.SQLException: malformed numeric constant

  1. WoodenDoors 10 times, last 7 months ago
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.SQLException

    user lacks privilege or object not found: SHIPORDER.SHIPORDERPK

    at org.hsqldb.jdbc.Util.sqlException()
  2. HSQLDB
    JDBCConnection.prepareStatement
    1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    2. org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
    3. org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    3 frames
  3. com.sunopsis.jdbc
    SnpsXmlConnection.prepareStatement
    1. com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.prepareStatement(SnpsXmlConnection.java:1192)
    1 frame
  4. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor172.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  5. oracle.odi.core
    OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke
    1. oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke(OnConnectOnDisconnectDataSourceAdapter.java:200)
    1 frame
  6. Unknown
    $Proxy2.prepareStatement
    1. $Proxy2.prepareStatement(Unknown Source)
    1 frame
  7. oracle.odi.runtime
    SQLCommand.doInitializeStatement
    1. oracle.odi.runtime.agent.execution.sql.SQLCommand.doInitializeStatement(SQLCommand.java:83)
    1 frame