Data Not Loading Into Hdowner Schema When Running Load Data To Hd

(Doc ID 1307332.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Oct-2012***


When attempting to Load Data to HD from the UI, the following error is seen in the E_KPI_LOAD_LOG.


1031 : 42000 : java.sql.SQLException: ORA-01031: insufficient privileges  java.sql.SQLException: ORA-01031: insufficient privileges   at oracle.jdbc.driver.DatabaseError.throwSqlException( at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4C8Oall.receive( at oracle.jdbc.driver.T4CPreparedStatement.doOall8( at oracle.jdbc.driver.T

The issue can be reproduced at will with the following steps:
1. Log into OTM as DBA.ADMIN.
2. Go to Transportation Intelligence > Process Management
3. Click "Run ETL."
4. Review the E_KPI_LOAD_LOG.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms