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***

Symptoms


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


ERROR
-----------------------

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

STEPS
-----------------------
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.

Cause

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