0 Replies Latest reply on Nov 7, 2015 6:18 AM by 1008490

    obia load plan execution error: A login timeout occured while connecting to the database.

    1008490

      Hi,

       

      I am installed obia 11.1.1.7.1, while running the loadplan i am getting below error:

       

      ODI-1217: Session SDE_ORAR1213_ADAPTOR_SDE_ORA_KEYFLEXFIELD_COLUMN (352500) fails with return code 7000.

      ODI-1226: Step SDE_ORA_KeyFlexfield_Column.W_ORA_FLX_COLUMN_TMP fails after 1 attempt(s).

      ODI-1240: Flow SDE_ORA_KeyFlexfield_Column.W_ORA_FLX_COLUMN_TMP fails while performing a Loading operation. This flow loads target table W_FLEX_COLUMN_GS.

      ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection EBSVISION.

      Caused By: oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database.

       

      i tried changed timeout parameter in odi studio but no use.

       

      Can you please suggest

       

      Thanks in Advance.