4 Replies Latest reply on Jun 14, 2021 8:21 AM by Thomas Kennedy

    No output after successful run of mapping

    Thomas Kennedy Active Member

      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

        • 1. Re: No output after successful run of mapping
          Jharana Patra Guru

          Hi Thomas,

           

          The target will be empty without error if its logical issue .

          The default error file path is $PMBadFileDir file s_mtt_010TF60Z000000000023_4_error.csv.

           

          Let us know if this helps.

          • 2. Re: No output after successful run of mapping
            Thomas Kennedy Active Member

            Hello Jharana,

             

            Thank you for your response. Yes, I understand your response and it helps. Is there a way I can trace through my logic to find where that error(s) maybe occurring?

             

            Tom

            • 3. Re: No output after successful run of mapping
              Krishna Kumar Support Moderators

              Hi Thomas,

               

              As per the session log, it seems you are using Intelligent Structure Parser to parse the source data, and it seems to be parsing the data to target.

               

              Please ensure that you have selected the right output group to the target, and also try creating a copy of the job and select the target connection as Flatfile with right output group mapped and run it. This should help to isolate the issue.

               

              Thanks,

              Krishna

              • 4. Re: No output after successful run of mapping
                Thomas Kennedy Active Member

                Hello Krishna,

                 

                Thank you for your response…that was a great idea to use a
                flat file as the target, which I did. After confirming the parser Output which
                is below:



                I re-ran mapping which ran successfully but still no output
                in my target file. Job run is below:

                 

                I re-examine the Properties of the Structured parser
                starting with the Field Mapping which is below:


                The field is mapped to Field 1 which is a reference file to the
                source file and it appeared to be correct. So, I verified the Incoming Fields
                which are below:


                I could not find anything wrong here either but I am not certain
                as I as new to the parser. I looked over my Source again and what I saw is below:


                I have assumed here, my Field 1 reference is correct since
                its origin is the PathFile.csv. I verified the path which is below (I’ve
                removed some sensitive info but it should be readable):

                \\infor.xxx.xxx.xxx\informatica\xxxxxxx\dropbox\XXXX_Banner_export_Intell.txt

                And finally I review the Target which is below:



                I’ve tried to create a real visual representation of the way
                my mapping is setup in hope that a closer look may reveal that which I am missing.


                Again, thank you for your response.

                 

                Best regards,

                Tom