4 Replies Latest reply on Apr 14, 2015 1:14 AM by Pawel Wancerz

    TE_7017     Internal error. Failed to initialize transformation [lkp_T_CONTACT_CTC{{BLD}}]. Contact Informatica Global Customer Support.

    Pawel Wancerz New Member

      Dear All,

       

      I have a problem with a session. It frows out the error:

       

      TE_7017    Internal error. Failed to initialize transformation [lkp_T_CONTACT_CTC{{BLD}}]. Contact Informatica Global Customer Support.

       

      I am using SQL Server as a target database.

      Lookup override doesn't seem to have any problem in the override (also order is ok):

       

      SELECT min(T_CONTACT_CTC.CTC_ID) as CTC_ID, T_CONTACT_CTC.CTC_DATA_SOURCE_CONTACT_BINARY_ID as CTC_DATA_SOURCE_CONTACT_BINARY_ID,T_CONTACT_CTC.CTC_DATA_SOURCE as CTC_DATA_SOURCE FROM T_CONTACT_CTC(NOLOCK) WHERE T_CONTACT_CTC.CTC_DATA_SOURCE  $$R129_SOURCE_DWH

      GROUP BY  CTC_DATA_SOURCE_CONTACT_BINARY_ID,CTC_DATA_SOURCE

       

      $$R129 (even from the log) is IN ('USD R129')

       

      Can you please advice where to look for problem solution?