Monthly Archives: August 2017

Oracle Data Integrator: Error ODI-1134 ODI-1217 ODI-1226

service de rencontre gratuit badoo site gratuit de rencontres amoureuses http://inter-actions.fr/bilobrusuy/2400 look at this site why is radioactive dating wrong http://nielsborchjensen.com/martys/1997 https://www.luas.gov.my/kms/lifre/4306 eine andere seite kennenlernen englisch free dating sites middlesbrough like it Error

ERROR ODI-1134 Agent  encountered an error: ODI-1217: Session INT_EX_FT-RT (5001) fails with return code 904. Caused by: ODI-1226: Step INT_EX_FT-RT fails after 1 attempt(s).

insert into ODI_STAGE.I$_TRG_SALES_PERSON
(
SALES_PERSON_ID,
FIRST_NAME,
LAST_NAME,
DATE_HIRED,
DATE_UPDATED,
IND_UPDATE
)
select
SRC.C1 C1_SALES_PERSON_ID,
C2_FIRST_NAME,
C3_LAST_NAME,
C4_DATE_HIRED,
C5_DATE_UPDATED,

‘I’ IND_UPDATE

from ODI_STAGE.C$_0TRG_SALES_PERSON
where (1=1)

Reason

The source datastore has been modified in midway of building an interface and the metadata is stored inappropriately.

Resolution

Re-build the interface and it should work as expected

Oracle BIAPPS: ODI Agent ORA-28001: the password has expired

 

java.sql.SQLException: ORA-28001: the password has expired

at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1125)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:163)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$4(SnpsDialogTestConnet.java:159)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$4.doInBackground(SnpsDialogTestConnet.java:519)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$4.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:662)
Caused by: java.sql.SQLException: ORA-28001: the password has expired

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.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
… 1 more
Caused by: java.sql.SQLException: ORA-28001: the password has expired

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:689)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:455)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:387)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:814)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:418)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:410)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:386)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:353)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:332)
… 7 more

Resolution:

alter user PTS_DW identified by pwd account unlock;

alter user PTS_BIACOMP identified by Admin123 account unlock;

alter user PTS_BIACM_IO identified by Admin123 account unlock;

alter user PTS_BIA_ODIREPO  identified by Admin123 account unlock;

alter user PTS_MDS identified by Admin123 account unlock;

alter user PTS_BIPLATFORM identified by Admin123 account unlock;