Friday, 4 September 2015

ODI Agent Restart Failed: ODI-1405

Error:

ODI-1405 : Agent localagent; start failure: the agent is not defined in the topology.

Cause: 

Below command has been executed to restart the agent.

agent -NAME=localagent;

If you notice mistakenly this command has ";" at end. Here , ";" also considered as agent name. 




Resolution:

Remove the ";" from end and try to restart. It should work fine.

Enjoy and stay well !! :)


ODI Agent Restart Failed : ORA-12505

Sometime we used to get below error while restarting the ODI agent.

ORA-12505: TNS: Listener does not currently know of SID given in correct descriptor 






Please check whether Oracle Database is up an running or not. If DB is up and running , then we need to restart the DB service and listener too. Once you restarted the DB service and listener , then try to restart the ODI agent again. It should be up now.





Enjoy and Stay Well !! :)


Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps. 1. Open Report Query Editor Mode. 2. Clink on Get Data -> Blank...