My Oracle Support Banner

OBIA Upgrade 'ODI-40430: Unknown Property' during 1st Incremental Load (Doc ID 2491891.1)

Last updated on AUGUST 14, 2019

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 and later
Information in this document applies to any platform.

Symptoms

In this case the upgrade is from 11.1.1.10.1 to 11.1.1.10.2.  Then on the incremental load received the following:

 

ODI-1217: Session SDE_ORAR122_ADAPTOR_SDE_ORA_PRODUCTMULTIPLECATEGORIES_UNSPSC_PS (365501) fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: ODI-1227: Task SrcSet0 (Loading) fails on the source FILE connection glfnsd02files.
Caused By: java.sql.SQLException: ODI-40430: Unknown property
ENCODING
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:74)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at com.sunopsis.sql.SnpsConnection.createConnection(SnpsConnection.java:390)
at com.sunopsis.sql.SnpsConnection.co => ORA-20942:
ORA-06512: at line 57

Changes

 OBIA upgrade

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 Importing Content into the 11.1.1.10.2 ODI Repository
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.