How to check which ODI repository component/version is created?
HOT SQL:
SELECT COMP_ID,COMP_NAME,OWNER,VERSION FROM SCHEMA_VERSION_REGISTRY;
Maiquel.
Category: ODI
ODI – Import(ANT) Modes
Oracle introduce in Data Integrator 12c an spectacular way to avoid object duplication (10g/11g users will bad remember)
With “Global ID”, ODI repository will generate special HASH to each object created on the repository (sometimes it will be updated).
This internal ID should be available on “Version” tab as below:
So, why this global id makes sense?
According oracle docs, “read carefully this section in order to determine the import mode you need.”
Changing ODI import modes, will be able to import/customize duplicated objects, generated by devops scripts.
Let’s understand the Import Modes:
ODI 10gR1: Connection to Repository Failed after Database Descriptor Change
After migrating database to another host, port or SID, the error below started to happen when running a scenario.
“Of course” all mapped connection was right setted on Topology… But environment is complex, it’s possible something is missing…
java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:361) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:151) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595) at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java) at com.sunopsis.sql.SnpsConnection.c(SnpsConnection.java) at com.sunopsis.sql.h.run(h.java)
Ok, so something really is missing… But where?
Try to check this:
More“ODI 10gR1: Connection to Repository Failed after Database Descriptor Change”
Failure to create ODI schedule
Hi,
Today, as in another normal days, I found a problem with ODI schedule in the newly created enviroment. While creating a schedule to scenario execution, then clicked in update schedule in Topology > Agents > OracleDIAgent, I received an exception:
ODI-1274: Agent Exception Caused by: Could not find the AgentScheduler instance in order to process 'OdiComputePlanning' request
Oracle support has a solution for this exception, but only for ODI 12c, it happens that my enviroment is ODI 11.1.1.6, in community oracle, has the same question, but, without answer.