Installing ODI 11.1.1.7.0 on Windows 7 64bit

Installing ODI 11.1.1.7.0 on Windows 7 64bit

Yesterday Sunday Afternoon I got a call from one of my old friend asking for help in ODI 11.1.7.0 Installation, where he could not move forward with Java error, The challenge was he could not start the installer due to Java Path Issue, So thought of posting this blog so that it might be helpful for others To overcome the JDK Issues always start the installation using command Prompt. Copy the path of JDK Location

Paste the copied JDK Path, and wait for some time the Oracle Installer starts and then continue with the further installation

BIAPPS

BIAPPS

ORA-01840: input value not long enough for date format

ODI Error While Running ODI Interface

ORA-01840: input value not long enough for date format

 

When checked all the Date columns in Source tables found that There are some dates with no time stamps and also some values of “0”.

Removed the 24hr Date format to 12 hour date format and used select Distinct

Select distinct

TO_DATE (substr(decode(ral.interface_line_attribute4,'0',null,ral.interface_line_attribute4),1,10),

                           'YYYY/MM/DD' )  from ra_customer_trx_lines_all

    

And Restarted the Load