1 Reply Latest reply on Apr 18, 2019 2:37 AM by alfaisal ahmed

    Error details not getting recorded in PMERR Table

    Sachin Shinde New Member

      Hello All,

       

      We are loading data from Informatica to salesforce and using PMERR tables to log the error details at database level.

      The record gets inserted into PMERR_SESS but not in any other tables. At Salesforce side Bulk load Option is disabled.

      This functionality was perfectly working when we were using Ingformatica 9 version but as we have upgraded to version 10, the error capturing is not working.

       

      Please advise.

       

      Below details are from Session Log file but still Error records are available at Session log file but Not in PMERR Tables.

       

      TM_6298 : DTM error log enabled at connection [STAGE_tgt]: database [infa_update_.xxxxxx.com], user [STAGE].

      TM_6682 : Warning: Since DTM Error Logging is enabled, row level errors will not be written to the session log. Please check the DTM Error Log for any row level errors.

      TM_6311 : DTM error log: using database table [STAGE.PMERR_SESS].

      TM_6311 : DTM error log: using database table [STAGE.PMERR_TRANS].

      TM_6311 : DTM error log: using database table [STAGE.PMERR_MSG].

      TM_6311 : DTM error log: using database table [STAGE.PMERR_DATA].

      TE_7022 : TShmWriter: Initialized

       

      Thanks,

      Sachin