Saturday, 5 May 2018

ODI-1405: Agent OracleDIAgent start failure: the agent is not defined in the topology for master repository.


After successful installation of the standalone agent when I try to run it. it gives error
ODI-1405: Agent OracleDIAgent start failure: the agent is not defined in the topology for master repository.
This error comes when the repositories are not configured properly. Before standalone agent, we were using local agent and repositories that were created during installation of ODI studio and we try to create standalone agent under those repositories. instead of this try to create standalone agent under those repositories that were created during installation of standalone agent and then start the agent 

For this 
1 ) first create the master repository login 

2) provide the details
user-----> name of the repository that was created during installation of standalone agent (Default = DEV1_ODI_REPO) 
password----> provide the password
DBA User----> sys as sysdba
password-----> sys

3) use ODI Authentication 
provide a password for SUPERVISOR User (this is ODI USER)

after successful completion 
4)click on connect to repository and Click on + button


5) Oracle data integration connection 
Provide login name
User= SUPERVISOR 
Password for supervisor
Database connection(Master Repository )
user= provide user name/repository name that was created during installation of standalone agent (Default = DEV1_ODI_REPO) 
provide JDBC connection
Work Repository
click on master Repository only
test connection 
after successful create work repository with same username repository name that was created during installation of standalone agent (Default = DEV1_ODI_REPO) 
then disconnect
again connect to ODI studio this time click on work Repository
click ok
after this step create standalone agent and start it  



Thursday, 3 May 2018

Security tab in ODI is not showing

I encountered an issue where Security tab in ODI was not showing after multiple attempts I decided to clear the cache for ODI studio here are the steps

Close ODI Studio.

Navigate to C:\Users\<username>\AppData\Roaming\odi directory
Delete the “system<ODI version>” folder, Corresponding to your version of ODI.

Start ODI Studio.

A new folder system<ODI version> will be created.
After this Security, window start showing in ODI studio


This is the common approach whenever you have some Glitches in ODI studio UI

Wednesday, 2 May 2018

Result contains more than the "Operator display limit (0 = no limit)" of 100 records.

Result contains more than the "Operator display limit (0 = no limit)" of 100 records.

(To change the "Operator display limit (0 = no limit)" or disable this dialog, please see "Preferences" in the Tools main menu.)


Do you want to display all records?  




One may not found this as an absolute error but this might be extremely annoying. This happens when no of execution exceeds its default values(100). you have to manually change the value to higher limit or alternately delete executions from Agents and Users as well


To change the Value 

Go to Tools--------->Preferences--------->ODI--------->User interface--------->Operator


Load data From one database to another database or one schema to another schema within the database

Load data From one database to another database or one schema to another schema within the database 1) define the data servers under top...