6 Replies Latest reply on Jun 23, 2021 7:23 AM by Thomas Kennedy

    No output after successful run of mapping

    Thomas Kennedy Seasoned Veteran

      I created a mapping that ran successfully but my target was not updated. If possible could you look at my session log below and possibly interpret where the error is. By the way my test file had 5 test records in it.

       

      Task Name: Mapping9

      Agent Group Id: 010TF625000000000002

      Agent Group Name: informatica

      Agent Id: 010TF608000000000002

      Agent Name: informatica

      06/11/2021 08:43:24 **** Importing Connection: Conn_010TF60B00000000000N ...

      06/11/2021 08:43:24 **** Importing Source Definition: PathFile_csv ...

      06/11/2021 08:43:24 **** Importing Target Definition: Contact ...

      06/11/2021 08:43:24 **** Importing SessionConfig: default_session_config ...

          <Warning> :  The Error Log DB Connection value should have Relational: as the prefix.

          <Warning> :  Invalid value  for attribute Error Log DB Connection. Will use the default value

          Validating Source Definition  PathFile_csv...

          Validating Target Definition  Contact...

      06/11/2021 08:43:24 **** Importing Mapping: Mapping0 ...

          <Warning> :  transformation: DMSB_Banner_Export - Invalid value  for attribute Output is repeatable. Will use the default value Never    [transformation< DMSB_Banner_Export > ]

      Validating transformations of mapping Mapping0...

      Validating mapping variable(s).

      06/11/2021 08:43:24 **** Importing Workflow: wf_mtt_010TF60Z000000000023 ...

          <Warning> :  invalid attribute Header Options for element ATTRIBUTE    [Session< s_mtt_010TF60Z000000000023 >  --> SalesForce Writer_New< SalesForce Writer_New > ]

          <Warning> :  invalid attribute Append if Exists for element ATTRIBUTE    [Session< s_mtt_010TF60Z000000000023 >  --> SalesForce Writer_New< SalesForce Writer_New > ]

          <Warning> :  invalid attribute Output Type for element ATTRIBUTE    [Session< s_mtt_010TF60Z000000000023 >  --> SalesForce Writer_New< SalesForce Writer_New > ]

          <Warning> :  Invalid value Optimize throughout for attribute Concurrent read partitioning. Will use the default value Optimize throughput    [Session< s_mtt_010TF60Z000000000023 >  --> File Reader< File Reader > ]

          <Warning> :  The value entered is not a valid integer.

          <Warning> :  Invalid value NO for attribute Fail task after wait time. Will use the default value

      Successfully extracted session instance [s_mtt_010TF60Z000000000023].  Starting repository sequence id is [293396702]

      ======================================================================

      DIRECTOR> VAR_27085 [2021-06-11 08:43:24.656] Parameter file [C:\Program Files\Informatica Cloud Secure Agent\apps\Data_Integration_Server\data\parameters\s_mtt_010TF60Z000000000023.param] is opened for [session [wf_mtt_010TF60Z000000000023.s_mtt_010TF60Z000000000023]].

      DIRECTOR> VAR_27062 [2021-06-11 08:43:24.657] Warning! Cannot find section for worklet [wf_mtt_010TF60Z000000000023] and folder [] in parameter file [C:\Program Files\Informatica Cloud Secure Agent\apps\Data_Integration_Server\data\parameters\s_mtt_010TF60Z000000000023.param].

      DIRECTOR> VAR_27028 [2021-06-11 08:43:24.657] Use override value [s_mtt_010TF60Z000000000023_4_error.csv] for user-defined workflow/worklet variable:[$ErrorFileName].

      DIRECTOR> VAR_27028 [2021-06-11 08:43:24.657] Use override value [2021-06-11] for user-defined workflow/worklet variable:[$LastRunDate].

      DIRECTOR> VAR_27028 [2021-06-11 08:43:24.657] Use override value [2021-06-11 12:38:33] for user-defined workflow/worklet variable:[$LastRunTime].

      DIRECTOR> VAR_27028 [2021-06-11 08:43:24.657] Use override value [s_mtt_010TF60Z000000000023_6_11_2021_12_43_success.csv] for user-defined workflow/worklet variable:[$SuccessFileName].

      DIRECTOR> TM_6014 [2021-06-11 08:43:24.658] Initializing session [s_mtt_010TF60Z000000000023] at [Fri Jun 11 08:43:24 2021].

      DIRECTOR> TM_6683 [2021-06-11 08:43:24.658] Repository Name: [XMLRepository]

      DIRECTOR> TM_6684 [2021-06-11 08:43:24.658] Server Name: [rDTM]

      DIRECTOR> TM_6686 [2021-06-11 08:43:24.658] Folder: []

      DIRECTOR> TM_6685 [2021-06-11 08:43:24.658] Workflow: [wf_mtt_010TF60Z000000000023] Run Instance Name: [] Run Id: [0]

      DIRECTOR> TM_6101 [2021-06-11 08:43:24.658] Mapping name: Mapping0.

      DIRECTOR> TM_6964 [2021-06-11 08:43:24.658] Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US]

      DIRECTOR> TM_6703 [2021-06-11 08:43:24.661] Session [s_mtt_010TF60Z000000000023] is run by 64-bit Integration Service  [], version [9.1.0 HotFix1], build [0627].

      MANAGER> PETL_24058 [2021-06-11 08:43:25.699] Running Partition Group [1].

      MANAGER> PETL_24000 [2021-06-11 08:43:25.699] Parallel Pipeline Engine initializing.

      MANAGER> PETL_24001 [2021-06-11 08:43:25.699] Parallel Pipeline Engine running.

      MANAGER> PETL_24003 [2021-06-11 08:43:25.699] Initializing session run.

      MAPPING> CMN_1569 [2021-06-11 08:43:25.702] Server Mode: [UNICODE]

      MAPPING> CMN_1570 [2021-06-11 08:43:25.702] Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]

      MAPPING> TM_6151 [2021-06-11 08:43:25.702] The session sort order is [Binary].

      MAPPING> TM_6185 [2021-06-11 08:43:25.702] Warning. Code page validation is disabled in this session.

      MAPPING> CMN_65084 [2021-06-11 08:43:25.702] Current Timezone:[UTC -5:0]

      MAPPING> CMN_65085 [2021-06-11 08:43:25.702] Current Process ID:[7628]

      MAPPING> TM_6155 [2021-06-11 08:43:25.702] Using HIGH precision processing.

      MAPPING> TM_6180 [2021-06-11 08:43:25.702] Deadlock retry logic will not be implemented.

      MAPPING> TM_6187 [2021-06-11 08:43:25.702] Session target-based commit interval is [10000].

      MAPPING> PMJVM_42020 [2021-06-11 08:43:25.709] [INFO] Loaded library : C:\PROGRA~1\INFORM~1\apps\jdk\1.8.0_275_SA\jre\bin\server\jvm.dll.

      MAPPING> PMJVM_42014 [2021-06-11 08:43:25.710] [DEBUG] The value specified for option JVMOption1 is not valid and will be ignored.

      MAPPING> PMJVM_42014 [2021-06-11 08:43:25.710] [DEBUG] The value specified for option JVMOption2 is not valid and will be ignored.

      MAPPING> PMJVM_42014 [2021-06-11 08:43:25.710] [DEBUG] The value specified for option JVMOption3 is not valid and will be ignored.

      MAPPING> PMJVM_42014 [2021-06-11 08:43:25.710] [DEBUG] The value specified for option JVMOption4 is not valid and will be ignored.

      MAPPING> PMJVM_42014 [2021-06-11 08:43:25.710] [DEBUG] The value specified for option JVMOption5 is not valid and will be ignored.

      MAPPING> PMJVM_42009 [2021-06-11 08:43:25.789] [INFO] Created Java VM successfully.

      MAPPING> SDKS_38029 [2021-06-11 08:43:25.883] Loaded plug-in 500100: [plugin description].

      MAPPING> SDKS_38024 [2021-06-11 08:43:25.943] Plug-in 500100 initialization complete.

      MAPPING> SDKS_38017 [2021-06-11 08:43:25.943] Writer SDK plug-in intialization complete.

      MAPPING> SDKS_38509 [2021-06-11 08:43:26.557] SDK target and group initialization complete.

      MAPPING> TM_6307 [2021-06-11 08:43:26.557] DTM error log disabled.

      MAPPING> TE_7022 [2021-06-11 08:43:26.561] TShmWriter: Initialized

      MAPPING> JAVA PLUGIN_1762 [2021-06-11 08:43:27.175] [DEBUG] - INFO  com.informatica.atlantic - VERSION: Branch=release12_12.5.0-IICSR36.2021.05.S-build-all, DateTime=Sun 04/11/2021 10:04:14.90, Build Number=8, ChangeListNumber=11142366, aModelVersion=1.9, aModelComment=ML

      MAPPING> TM_6007 [2021-06-11 08:43:27.210] DTM initialized successfully for session [s_mtt_010TF60Z000000000023]

      DIRECTOR> PETL_24033 [2021-06-11 08:43:27.210] All DTM Connection Info: [<NONE>].

      MANAGER> PETL_24004 [2021-06-11 08:43:27.210] Starting pre-session tasks. : (Fri Jun 11 08:43:27 2021)

      MANAGER> PETL_24027 [2021-06-11 08:43:27.275] Pre-session task completed successfully. : (Fri Jun 11 08:43:27 2021)

      DIRECTOR> PETL_24006 [2021-06-11 08:43:27.275] Starting data movement.

      MAPPING> TM_6660 [2021-06-11 08:43:27.275] Total Buffer Pool size is 9617440 bytes and Block size is 532080 bytes.

      READER_1_1_1> DBG_21437 [2021-06-11 08:43:27.278] Reader: Source is a file-based source.

      READER_1_1_1> FR_3118 [2021-06-11 08:43:27.278] source [DMSB_Banner_Export] code page: [UTF-8 encoding of Unicode]

      READER_1_1_1> FR_3071 [2021-06-11 08:43:27.279] Maximum Line sequential buffer length is 1026.

      READER_1_1_1> BLKR_16003 [2021-06-11 08:43:27.279] Initialization completed successfully.

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:35.349] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@@@@ AtlanticExecutor :: OUTPUT_TYPE -> RELATIONAL

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:35.454] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@@@@ AtlanticExecutor :: Plan was created...

      WRITER_1_*_1> SalesforceConnection_10057 [2021-06-11 08:43:35.543] [INFO] No proxy information set.

      WRITER_1_*_1> SalesforceConnection_100480 [2021-06-11 08:43:36.590] [INFO] Account[tkennedy@moore.sc.edu.txsandbox] logged on salesforce.com at [https://test.salesforce.com/services/Soap/u/49.0].

      WRITER_1_*_1> SalesforceConnection_10147 [2021-06-11 08:43:36.591] [INFO] Logged on salesforce.com in [Standard] mode.

      WRITER_1_*_1> SFDC_WRITER_10072 [2021-06-11 08:43:36.600] [INFO] The UseExternalId attribute is set. The Integration Service will use external Id [TargetX_SRMb__SRM_ETL_ID__c] for upsert operations.

      WRITER_1_*_1> SFDC_WRITER_10065 [2021-06-11 08:43:36.600] [INFO] Inserted Target Batch Size [200].

      WRITER_1_*_1> GENERIC_WRITER_10036 [2021-06-11 08:43:36.604] [WARNING] Success file directory is empty or starts with a $. Defaulting it to $PMTargetFileDir.

      WRITER_1_*_1> GENERIC_WRITER_10037 [2021-06-11 08:43:36.604] [WARNING] Error file directory is empty or starts with a $. Defaulting it to $PMBadFileDir.

      WRITER_1_*_1> WRT_8270 [2021-06-11 08:43:36.606] Target connection group #1 consists of target(s) [Contact: Partition 1]

      WRITER_1_*_1> WRT_8003 [2021-06-11 08:43:36.606] Writer initialization complete.

      READER_1_1_1> BLKR_16007 [2021-06-11 08:43:36.606] Reader run started.

      WRITER_1_*_1> WRT_8005 [2021-06-11 08:43:36.606] Writer run started.

      WRITER_1_*_1> WRT_8158 [2021-06-11 08:43:36.606]

       

       

      *****START LOAD SESSION*****

       

       

      Load Start Time: Fri Jun 11 08:43:35 2021

       

       

      Target tables:

       

       

           Contact: Partition 1

       

       

       

       

      READER_1_1_1> DBG_21430 [2021-06-11 08:43:36.607] Reading data from input source file [C:\Informatica\TargetX\dropbox\PathFile.csv] : (Fri Jun 11 08:43:36 2021)

      READER_1_1_1> BLKR_16019 [2021-06-11 08:43:36.607] Read [1] rows, read [0] error rows for source table [PathFile_csv] instance name [PathFile_csv]

      READER_1_1_1> BLKR_16008 [2021-06-11 08:43:36.607] Reader run completed.

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.849] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - Execution Summary for Atlantic Parser Mapping execution:

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.849] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - Structure Discovery processed <1> files / executions for this mapping task.

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.850] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - Structure Discovery successfully processed <0> records for this mapping task. This number is shown in the Success Rows field in the Activity Log.

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.850] [DEBUG] - WARN  com.informatica.isd.plugin.executors.AtlanticExecutor - Approximately <5> records were unidentified in this mapping task.

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.850] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: executeTime = 228

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.850] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: executeFirstTime = 0

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.850] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: executeProcessTime = 211

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.850] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: executeProcessParsedTime = 211

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.850] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: executeProcessNonRelationalTime = 0

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.850] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: executeNonAtlanticParse = 7

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.850] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: createPlanTime = 17

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.851] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: executeCount = 1

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.851] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: executeFirstCount = 0

      TRANSF_1_1_1> JAVA PLUGIN_1762 [2021-06-11 08:43:36.851] [DEBUG] - INFO  com.informatica.isd.plugin.executors.AtlanticExecutor - @@@ AtlanticExecutor :: executeProcessCount = 1

      TRANSF_1_1_1> DBG_21216 [2021-06-11 08:43:36.851] Finished transformations for Source Qualifier [DMSB_Banner_Export]. Total errors [0]

      WRITER_1_*_1> WRT_8167 [2021-06-11 08:43:36.851] Start loading table [Contact: Partition 1] at: Fri Jun 11 08:43:36 2021

      WRITER_1_*_1> WRT_8168 [2021-06-11 08:43:36.851] End loading table [Contact: Partition 1] at: Fri Jun 11 08:43:36 2021

      WRITER_1_*_1> WRT_8035 [2021-06-11 08:43:36.853] Load complete time: Fri Jun 11 08:43:36 2021

       

       

      LOAD SUMMARY

      ============

       

       

      WRT_8036 Target: Contact: Partition 1 (Instance Name: [Contact])

      WRT_8044 No data loaded for this target

       

       

       

       

       

       

      WRITER_1_*_1> WRT_8043 [2021-06-11 08:43:36.853] *****END LOAD SESSION*****

      WRITER_1_*_1> WRT_8006 [2021-06-11 08:43:36.853] Writer run completed.

      MANAGER> PETL_24031 [2021-06-11 08:43:36.854]

      ***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****

      Thread [READER_1_1_1] created for [the read stage] of partition point [DMSB_Banner_Export] has completed. The total run time was insufficient for any meaningful statistics.

      Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [DMSB_Banner_Export] has completed. The total run time was insufficient for any meaningful statistics.

      Thread [WRITER_1_*_1] created for [the write stage] of partition point [Contact] has completed. The total run time was insufficient for any meaningful statistics.

       

       

      MANAGER> PETL_24005 [2021-06-11 08:43:36.947] Starting post-session tasks. : (Fri Jun 11 08:43:36 2021)

      MANAGER> PETL_24029 [2021-06-11 08:43:37.010] Post-session task completed successfully. : (Fri Jun 11 08:43:37 2021)

      MAPPING> SDKS_38510 [2021-06-11 08:43:37.010] SDK target and group deinitialized with status [0].

      MAPPING> SDKS_38025 [2021-06-11 08:43:37.010] Plug-in 500100 deinitialized and unloaded with status [0].

      MAPPING> SDKS_38019 [2021-06-11 08:43:37.010] Writer SDK plug-ins deinitialized with status [0].

      MAPPING> TM_6018 [2021-06-11 08:43:37.011] The session completed with [0] row transformation errors.

      MANAGER> PETL_24002 [2021-06-11 08:43:37.757] Parallel Pipeline Engine finished.

      DIRECTOR> PETL_24012 [2021-06-11 08:43:37.788] Session run completed successfully.

      DIRECTOR> TM_6022 [2021-06-11 08:43:37.788]

       

       

      SESSION LOAD SUMMARY

      ================================================

       

       

      DIRECTOR> TM_6252 [2021-06-11 08:43:37.788] Source Load Summary.

      DIRECTOR> CMN_1740 [2021-06-11 08:43:37.788] Table: [DMSB_Banner_Export] (Instance Name: [DMSB_Banner_Export])

      Output Rows [1], Affected Rows [1], Applied Rows [1], Rejected Rows [0]

      DIRECTOR> TM_6253 [2021-06-11 08:43:37.788] Target Load Summary.

      DIRECTOR> CMN_1740 [2021-06-11 08:43:37.788] Table: [Contact] (Instance Name: [Contact])

      Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]

      DIRECTOR> TM_6023 [2021-06-11 08:43:37.788]

      ===================================================

       

       

      DIRECTOR> TM_6020 [2021-06-11 08:43:37.788] Session [s_mtt_010TF60Z000000000023] completed at [Fri Jun 11 08:43:37 2021].

       

      Thank you,

      Tom