My Oracle Support Banner

OBIA Execute the Domain Load Plan: ORA-01017: Invalid Username/password; Logon Denied (Doc ID 2551930.1)

Last updated on AUGUST 13, 2019

Applies to:

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

Symptoms

While attempting to execute the Domain Load Plan receiving an error on an metadata object:


ODI-1519: Serial step "Start Load Plan (InternalID:9500)" failed because child step "Global Variable Refresh (InternalID:10500)" is in error.
ODI-1529: Refresh of variable "BIAPPS.13P_CALENDAR_ID" failed :
select CASE WHEN 'Global Variable Refresh' in (select distinct group_code from C_PARAMETER_VALUE_FORMATTER_V where PARAM_CODE= '13P_CALENDAR_ID')
THEN (select param_value
from C_PARAMETER_VALUE_FORMATTER_V
where PARAM_CODE=  '13P_CALENDAR_ID'
and group_code='Global Variable Refresh'
and datasource_num_id = '#BIAPPS.WH_DATASOURCE_NUM_ID')
ELSE
(select param_value from C_GL_PARAM_VALUE_FORMATTER_V where PARAM_CODE=  '13P_CALENDAR_ID' and datasource_num_id = '#BIAPPS.WH_DATASOURCE_NUM_ID')
END
from Dual
0:72000:java.sql.SQLException: ORA-01017: invalid username/password; logon denied

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

    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 oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.executeVariableStep(LoadPlanProcessor.java:3059)
    at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.refreshVariables(LoadPlanProcessor.java:4296)
    at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.AddRunnableScenarios(LoadPlanProcessor.java:2286)
    at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.AddRunnableScenarios(LoadPlanProcessor.java:2309)
    at oracle.odi.runtime.agent.load

 

 

Analysis:

Checked that the all the data server's jdbc url/driver are valid.

ie. go to ODI Studio -> topology -> technology -> Oracle -> jdbc

Open all the data servers involved and confirm the jdbc connections by clicking "Test Connection" button.

Found the one that fails is:  BIAPPS_BIACOMP_IO

oracle.odi.runtime.agent.invocation.InvocationException: ORA-01017: invalid username/password; logon denied

at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:296)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:864)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:584)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$10(SnpsDialogTestConnet.java:581)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:558)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:1)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
at java.lang.Thread.run(Thread.java:745)


Also checked that the GUID is the same comparing the DB ->  SNP_USER entry with the entry we see in the ODI  -> Security -> User

 

Changes

 

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
References


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