3 Replies Latest reply on Jun 21, 2021 10:42 PM by Jharana Patra

    How to load a file into Anaplan Process from IICS?

    Dinesh Ponnusamy New Member

      Hi,

       

      We are trying to load an Anaplan Process using Informatica Cloud. The Informatica job runs successfully but it is not loading the source file into the target.

       

      Every time, uploaded file in Anaplan is getting loaded, please let me know if anyone worked on IICS Anaplan integration or used Anaplan Process in data load.

       

      Thanks,

      Dinesh P

        • 1. Re: How to load a file into Anaplan Process from IICS?
          Krishna Kumar Support Moderators

          Hi Dinesh,

           

          Could you please share the session log of the job for our analysis?

           

          Thanks,

          Krishna

          • 2. Re: How to load a file into Anaplan Process from IICS?
            Dinesh Ponnusamy New Member

            Hi Krishna ,

             

            Below are the information

             

            06/14/2021 07:55:36 **** Importing Connection: TargConn_017W660B000000000007 ...

            06/14/2021 07:55:36 **** Importing Source Definition: Material_Components_csv ...

            06/14/2021 07:55:36 **** Importing Target Definition: PROCESS##58_##32_Test##32_for##32_IICS ...

            06/14/2021 07:55:36 **** Importing SessionConfig: cfg_s_dss_017W660I000000000016 ...

                <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  Material_Components_csv...

                Validating Target Definition  PROCESS##58_##32_Test##32_for##32_IICS...

            06/14/2021 07:55:36 **** Importing Mapping: m_dss_017W660I000000000016 ...

            Validating transformations of mapping m_dss_017W660I000000000016...

            Validating mapping variable(s).

            06/14/2021 07:55:36 **** Importing Workflow: wf_dss_017W660I000000000016 ...

                <Warning> :  Invalid value Optimize throughout for attribute Concurrent read partitioning. Will use the default value Optimize throughput    [Session< s_dss_017W660I000000000016 >  --> 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_dss_017W660I000000000016].  Starting repository sequence id is [210102938]

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

            DIRECTOR> VAR_27085 [2021-06-14 07:55:37.125] Parameter file [C:\Program Files\Informatica Cloud Secure Agent\apps\Data_Integration_Server\data\parameters\s_dss_017W660I000000000016.param] is opened for [session [wf_dss_017W660I000000000016.s_dss_017W660I000000000016]].

            DIRECTOR> VAR_27062 [2021-06-14 07:55:37.128] Warning! Cannot find section for worklet [wf_dss_017W660I000000000016] and folder [] in parameter file [C:\Program Files\Informatica Cloud Secure Agent\apps\Data_Integration_Server\data\parameters\s_dss_017W660I000000000016.param].

            DIRECTOR> VAR_27028 [2021-06-14 07:55:37.129] Use override value [s_dss_017W660I000000000016_1_error.csv] for user-defined workflow/worklet variable:[$ErrorFileName].

            DIRECTOR> VAR_27028 [2021-06-14 07:55:37.129] Use override value ['1970-01-01'] for user-defined workflow/worklet variable:[$LastRunDate].

            DIRECTOR> VAR_27028 [2021-06-14 07:55:37.129] Use override value ['1970-01-01 00:00:00'] for user-defined workflow/worklet variable:[$LastRunTime].

            DIRECTOR> VAR_27028 [2021-06-14 07:55:37.129] Use override value [s_dss_017W660I000000000016_6_14_2021_11_55_success.csv] for user-defined workflow/worklet variable:[$SuccessFileName].

            DIRECTOR> TM_6014 [2021-06-14 07:55:37.129] Initializing session [s_dss_017W660I000000000016] at [Mon Jun 14 07:55:37 2021].

            DIRECTOR> TM_6683 [2021-06-14 07:55:37.129] Repository Name: [XMLRepository]

            DIRECTOR> TM_6684 [2021-06-14 07:55:37.129] Server Name: [rDTM]

            DIRECTOR> TM_6686 [2021-06-14 07:55:37.129] Folder: []

            DIRECTOR> TM_6685 [2021-06-14 07:55:37.129] Workflow: [wf_dss_017W660I000000000016] Run Instance Name: [] Run Id: [0]

            DIRECTOR> TM_6101 [2021-06-14 07:55:37.129] Mapping name: m_dss_017W660I000000000016.

            DIRECTOR> TM_6964 [2021-06-14 07:55:37.130] Date format for the Session is [MM/DD/YYYY HH24:MI:SS]

            DIRECTOR> TM_6703 [2021-06-14 07:55:37.132] Session [s_dss_017W660I000000000016] is run by 64-bit Integration Service  [], version [9.1.0 HotFix1], build [0627].

            MANAGER> PETL_24058 [2021-06-14 07:55:38.473] Running Partition Group [1].

            MANAGER> PETL_24000 [2021-06-14 07:55:38.474] Parallel Pipeline Engine initializing.

            MANAGER> PETL_24001 [2021-06-14 07:55:38.474] Parallel Pipeline Engine running.

            MANAGER> PETL_24003 [2021-06-14 07:55:38.475] Initializing session run.

            MAPPING> CMN_1569 [2021-06-14 07:55:38.489] Server Mode: [UNICODE]

            MAPPING> CMN_1570 [2021-06-14 07:55:38.489] Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]

            MAPPING> TM_6151 [2021-06-14 07:55:38.489] The session sort order is [Binary].

            MAPPING> TM_6185 [2021-06-14 07:55:38.489] Warning. Code page validation is disabled in this session.

            MAPPING> CMN_65084 [2021-06-14 07:55:38.489] Current Timezone:[UTC -5:0]

            MAPPING> CMN_65085 [2021-06-14 07:55:38.489] Current Process ID:[8936]

            MAPPING> TM_6155 [2021-06-14 07:55:38.489] Using HIGH precision processing.

            MAPPING> TM_6180 [2021-06-14 07:55:38.489] Deadlock retry logic will not be implemented.

            MAPPING> TM_6181 [2021-06-14 07:55:38.489] Session source-based commit interval is [5000].

            MAPPING> PMJVM_42020 [2021-06-14 07:55:38.605] [INFO] Loaded library : C:\PROGRA~1\INFORM~1\jdk\jre\bin\server\jvm.dll.

            MAPPING> PMJVM_42014 [2021-06-14 07:55:38.631] [DEBUG] The value specified for option JVMOption2 is not valid and will be ignored.

            MAPPING> PMJVM_42014 [2021-06-14 07:55:38.631] [DEBUG] The value specified for option JVMOption3 is not valid and will be ignored.

            MAPPING> PMJVM_42014 [2021-06-14 07:55:38.632] [DEBUG] The value specified for option JVMOption4 is not valid and will be ignored.

            MAPPING> PMJVM_42014 [2021-06-14 07:55:38.632] [DEBUG] The value specified for option JVMOption5 is not valid and will be ignored.

            MAPPING> PMJVM_42009 [2021-06-14 07:55:39.354] [INFO] Created Java VM successfully.

            MAPPING> SDKS_38029 [2021-06-14 07:55:41.756] Loaded plug-in 900210: [plugin description].

            MAPPING> SDKS_38024 [2021-06-14 07:55:41.870] Plug-in 900210 initialization complete.

            MAPPING> SDKS_38017 [2021-06-14 07:55:41.870] Writer SDK plug-in intialization complete.

            MAPPING> CCI_GroupOperation_1000 [2021-06-14 07:56:13.080] [INFO] Adapter Id of Runtime Adapter in CCI - com.anaplan.adapter.anaplanv2

            MAPPING> CCI_GroupOperation_1000 [2021-06-14 07:56:13.080] [INFO] Native Metadata Object Type of Runtime Adapter in CCI - actions

            MAPPING> CCI_GroupOperation_1000 [2021-06-14 07:56:13.080] [INFO] Operation Type of Runtime Adapter in CCI - ActionsWrite

            MAPPING> CCI_GroupOperation_1000 [2021-06-14 07:56:13.704] [INFO] Partition Index for Runtime Adapter in CCI - 0

            MAPPING> CCI_GroupOperation_1000 [2021-06-14 07:56:13.704] [INFO] Partition Count for Runtime Adapter in CCI - 1

            MAPPING> SDKS_38509 [2021-06-14 07:56:13.722] SDK target and group initialization complete.

            MAPPING> TM_6308 [2021-06-14 07:56:13.722] DTM error log using code page UTF-8.

            MAPPING> TM_6310 [2021-06-14 07:56:13.722] DTM error log enabled at file [C:\PROGRA~1\INFORM~1\apps\Data_Integration_Server\data\error\s_dss_017W660I000000000016_1_error.csv].

            MAPPING> TM_6682 [2021-06-14 07:56:13.722] 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.

            MAPPING> TM_6701 [2021-06-14 07:56:13.724] Warning: The data column delimiter for DTM Error logging and the flat file delimiter are the same [','].

            MAPPING> TE_7022 [2021-06-14 07:56:13.724] TShmWriter: Initialized

            MAPPING> DBG_21491 [2021-06-14 07:56:13.725] Source-based commit interval based on rows from Source Qualifier [SQ_Material_Components_csv]

            MAPPING> DBG_21244 [2021-06-14 07:56:13.726] Initializing Load Order Group [1]. Source Qualifier is [SQ_Material_Components_csv]

            MAPPING> TM_6007 [2021-06-14 07:56:13.726] DTM initialized successfully for session [s_dss_017W660I000000000016]

            DIRECTOR> PETL_24033 [2021-06-14 07:56:13.726] All DTM Connection Info: [<NONE>].

            MANAGER> PETL_24004 [2021-06-14 07:56:13.727] Starting pre-session tasks. : (Mon Jun 14 07:56:13 2021)

            MANAGER> PETL_24027 [2021-06-14 07:56:13.901] Pre-session task completed successfully. : (Mon Jun 14 07:56:13 2021)

            DIRECTOR> PETL_24006 [2021-06-14 07:56:13.901] Starting data movement.

            MAPPING> TM_6660 [2021-06-14 07:56:13.902] Total Buffer Pool size is 21065728 bytes and Block size is 1168096 bytes.

            READER_1_1_1> DBG_21437 [2021-06-14 07:56:13.968] Reader: Source is a file-based source.

            READER_1_1_1> FR_3118 [2021-06-14 07:56:13.969] source [SQ_Material_Components_csv] code page: [UTF-8 encoding of Unicode]

            READER_1_1_1> FR_3071 [2021-06-14 07:56:13.969] Maximum Line sequential buffer length is 2830.

            READER_1_1_1> BLKR_16003 [2021-06-14 07:56:13.969] Initialization completed successfully.

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:14.083] [DEBUG] API Base URL: https://api.anaplan.com, Major Version: 1, Minor Version: 3, Max RetryCount: 2, useApiBasedMetadata: true

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:14.085] [DEBUG] API End Point: https://api.anaplan.com/1/3/workspaces/8a81b01075ed34970176a956b0a66734/models/1806BAD7A7624971BAA60F6B099189C0/files

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:15.635] [DEBUG] API Base URL: https://api.anaplan.com: Major Version: 1: Minor Version: 3

            WRITER_1_*_1> GENERIC_WRITER_10036 [2021-06-14 07:56:15.757] [WARNING] Success file directory is empty or starts with a $. Defaulting it to $PMTargetFileDir.

            WRITER_1_*_1> GENERIC_WRITER_10037 [2021-06-14 07:56:15.757] [WARNING] Error file directory is empty or starts with a $. Defaulting it to $PMBadFileDir.

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:15.787] [INFO] Adapter Id of Runtime Adapter in CCI - com.anaplan.adapter.anaplanv2

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:15.787] [INFO] Native Metadata Object Type of Runtime Adapter in CCI - actions

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:15.787] [INFO] Operation Type of Runtime Adapter in CCI - ActionsWrite

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:15.788] [INFO] Creating Connection for Runtime Data Adapter in CCI

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:15.788] [INFO] Connection Successfully created for Runtime Data Adapter in CCI

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:15.789] [DEBUG] API Base URL: https://api.anaplan.com, Major Version: 1, Minor Version: 3, Max RetryCount: 2, useApiBasedMetadata: true

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:15.790] [DEBUG] API End Point: https://api.anaplan.com/1/3/workspaces/8a81b01075ed34970176a956b0a66734/models/1806BAD7A7624971BAA60F6B099189C0/files

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:16.492] [DEBUG] API Base URL: https://api.anaplan.com: Major Version: 1: Minor Version: 3

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.492] [INFO] Connection established successfully with the data source.

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.496] [INFO] Creating Data Adapter in CCI

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.499] [INFO] Data Adapter created Successfully in CCI

            WRITER_1_*_1> WRT_8270 [2021-06-14 07:56:16.501] Target connection group #1 consists of target(s) [PROCESS##58_##32_Test##32_for##32_IICS: Partition 1]

            WRITER_1_*_1> WRT_8324 [2021-06-14 07:56:16.501] Warning: Target Connection Group's connection doesn't support transactions. Targets [PROCESS##58_##32_Test##32_for##32_IICS: Partition 1] may not be loaded according to specified transaction boundary rules!

            WRITER_1_*_1> WRT_8003 [2021-06-14 07:56:16.501] Writer initialization complete.

            READER_1_1_1> BLKR_16007 [2021-06-14 07:56:16.501] Reader run started.

            WRITER_1_*_1> WRT_8005 [2021-06-14 07:56:16.501] Writer run started.

            WRITER_1_*_1> WRT_8158 [2021-06-14 07:56:16.501]

             

             

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

             

             

            Load Start Time: Mon Jun 14 07:56:15 2021

             

             

            Target tables:

             

             

                 PROCESS##58_##32_Test##32_for##32_IICS: Partition 1

             

             

             

             

            READER_1_1_1> FR_3076 [2021-06-14 07:56:16.502] Skipped over [1] lines.

            READER_1_1_1> DBG_21430 [2021-06-14 07:56:16.502] Reading data from input source file [D:\cccbl restricted\INBOX\Material Components.csv] : (Mon Jun 14 07:56:16 2021)

            READER_1_1_1> BLKR_16019 [2021-06-14 07:56:16.502] Read [100] rows, read [0] error rows for source table [Material_Components_csv] instance name [Material_Components_csv]

            READER_1_1_1> BLKR_16008 [2021-06-14 07:56:16.502] Reader run completed.

            TRANSF_1_1_1> DBG_21216 [2021-06-14 07:56:16.503] Finished transformations for Source Qualifier [SQ_Material_Components_csv]. Total errors [0]

            WRITER_1_*_1> WRT_8167 [2021-06-14 07:56:16.503] Start loading table [PROCESS##58_##32_Test##32_for##32_IICS: Partition 1] at: Mon Jun 14 07:56:15 2021

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.506] [INFO] Initializing Data Adapter in CCI

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.506] [INFO] Current Thread Name for CCI - Thread-5

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.509] [INFO] write:chunkSize: 1

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.509] [INFO] write:uploadOnlyImport: false

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.509] [INFO] Oct-2019 version-01

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:16.509] [DEBUG] AnaplanV2ActionsDataAdapter:initDataSession:: useApiBasedMetadata - true

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:16.563] [DEBUG] AnaplanActionsDataAdapter:initDataSession:: extn.getFileSeparator()=

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.564] [INFO] Data Adapter successfully initialized in CCI

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.566] [INFO] Initiating Write Data Session with the Data Adapter in CCI

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.566] [INFO] PROCESS Case Executing..

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.566] [INFO] Inside doProcess()

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:16.566] [INFO] Action ID:118000000009

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:17.172] [DEBUG] AnaplanTaskService::executeWithRetry: GET https://api.anaplan.com/1/3/workspaces/8a81b01075ed34970176a956b0a66734/models/1806BAD7A7624971BAA60F6B099189C0/processes/118000000009/tasks/629C48B71B1E4FBA947D43E09AF741C8 for PROCESS

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:17.172] [DEBUG] AnaplanTaskService::executeWithRetry: startTime - 1623671777172

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:17.172] [DEBUG] AnaplanTaskService::executeWithRetry: About to wait for 0 ms.

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:17.173] [DEBUG] AnaplanTaskService::executeWithRetry: Calculated next wait time - 1000 ms.

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:17.700] [DEBUG] TR-- anaplanTaskState : TaskStatus [currentStep=Applying model changes, progress=1.0, result=null, taskId=629C48B71B1E4FBA947D43E09AF741C8, taskState=IN_PROGRESS]

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:17.700] [DEBUG] AnaplanTaskService::executeWithRetry: taskState - IN_PROGRESS

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:17.700] [DEBUG] AnaplanTaskService::executeWithRetry: About to wait for 1000 ms.

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:18.715] [DEBUG] AnaplanTaskService::executeWithRetry: Calculated next wait time - 2000 ms.

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:19.224] [DEBUG] TR-- anaplanTaskState : TaskStatus [currentStep=Complete., progress=1.0, result=ExportTaskResult [failureDumpAvailable=false, nestedResults=[TaskResult [details=[ResultDetail [localMessageText=Test IICS: 100 (0/100) rows successful, 0 ignored , occurrences=0, type=hierarchyRowsProcessed, values=[hierarchyName, Test IICS, successRowCount, 100, successCreateCount, 0, successUpdateCount, 100, warningsRowCount, 0, warningsCreateCount, 0, warningsUpdateCount, 0, failedCount, 0, ignoredCount, 0, totalRowCount, 100, totalCreateCount, 0, totalUpdateCount, 100, invalidCount, 0, updatedCount, 100, renamedCount, 100, createdCount, 0]]], failureDumpAvailable=false, objectId=112000000141, objectName=null, successful=true], TaskResult [details=[ResultDetail [localMessageText=Plant cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Plant, rowCount, 100]], ResultDetail [localMessageText=Material No. cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Material No., rowCount, 100]], ResultDetail [localMessageText=Material Type cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Material Type, rowCount, 100]], ResultDetail [localMessageText=Procurement Type cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Procurement Type, rowCount, 100]], ResultDetail [localMessageText=MRP2–Special Procurement Txt cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, MRP2–Special Procurement Txt, rowCount, 100]], ResultDetail [localMessageText=X-Plant Status cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, X-Plant Status, rowCount, 100]], ResultDetail [localMessageText=Material Status at Plant level cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Material Status at Plant level, rowCount, 100]], ResultDetail [localMessageText=Costing – Special Procurement cells: 100, occurrences=0, type=lineItemRowsProcessed, val

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:19.224] [DEBUG] ues=[lineItemName, Costing – Special Procurement, rowCount, 100]], ResultDetail [localMessageText=Flag Material for Deletion at Plant Level cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Flag Material for Deletion at Plant Level, rowCount, 100]], ResultDetail [localMessageText=Key cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Key, rowCount, 100]]], failureDumpAvailable=false, objectId=112000000142, objectName=null, successful=true]], objectId=118000000009, successful=true], taskId=629C48B71B1E4FBA947D43E09AF741C8, taskState=COMPLETE]

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:19.224] [DEBUG] AnaplanTaskService::executeWithRetry: taskState - COMPLETE

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:19.224] [DEBUG] AnaplanTaskService::executeWithRetry: PROCESS is COMPLETE or CANCELLED. Stopping retry.

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:19.224] [DEBUG] AnaplanTaskService::executeWithRetry: Exiting method at - 1623671779224, Elapsed - 2052 ms.

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:19.224] [INFO] Process Task Response JSON: TaskStatus [currentStep=Complete., progress=1.0, result=ExportTaskResult [failureDumpAvailable=false, nestedResults=[TaskResult [details=[ResultDetail [localMessageText=Test IICS: 100 (0/100) rows successful, 0 ignored , occurrences=0, type=hierarchyRowsProcessed, values=[hierarchyName, Test IICS, successRowCount, 100, successCreateCount, 0, successUpdateCount, 100, warningsRowCount, 0, warningsCreateCount, 0, warningsUpdateCount, 0, failedCount, 0, ignoredCount, 0, totalRowCount, 100, totalCreateCount, 0, totalUpdateCount, 100, invalidCount, 0, updatedCount, 100, renamedCount, 100, createdCount, 0]]], failureDumpAvailable=false, objectId=112000000141, objectName=null, successful=true], TaskResult [details=[ResultDetail [localMessageText=Plant cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Plant, rowCount, 100]], ResultDetail [localMessageText=Material No. cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Material No., rowCount, 100]], ResultDetail [localMessageText=Material Type cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Material Type, rowCount, 100]], ResultDetail [localMessageText=Procurement Type cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Procurement Type, rowCount, 100]], ResultDetail [localMessageText=MRP2–Special Procurement Txt cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, MRP2–Special Procurement Txt, rowCount, 100]], ResultDetail [localMessageText=X-Plant Status cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, X-Plant Status, rowCount, 100]], ResultDetail [localMessageText=Material Status at Plant level cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Material Status at Plant level, rowCount, 100]], ResultDetail [localMessageText=Costing – Special Procurement cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Costing – Special Procurement, rowCount, 100]], ResultDetail [localMessageText=Flag Material for Deletion at Plant Level cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Flag Material for Deletion at Plant Level, rowCount, 100]], ResultDetail [localMessageText=Key cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Key, rowCount, 100]]], failureDumpAvailable=false, objectId=112000000142, objectName=null, successful=true]], objectId=118000000009, successful=true], taskId=629C48B71B1E4FBA947D43E09AF741C8, taskState=COMPLETE]

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:19.225] [DEBUG] TR-- Process Task Response JSON: TaskStatus [currentStep=Complete., progress=1.0, result=ExportTaskResult [failureDumpAvailable=false, nestedResults=[TaskResult [details=[ResultDetail [localMessageText=Test IICS: 100 (0/100) rows successful, 0 ignored , occurrences=0, type=hierarchyRowsProcessed, values=[hierarchyName, Test IICS, successRowCount, 100, successCreateCount, 0, successUpdateCount, 100, warningsRowCount, 0, warningsCreateCount, 0, warningsUpdateCount, 0, failedCount, 0, ignoredCount, 0, totalRowCount, 100, totalCreateCount, 0, totalUpdateCount, 100, invalidCount, 0, updatedCount, 100, renamedCount, 100, createdCount, 0]]], failureDumpAvailable=false, objectId=112000000141, objectName=null, successful=true], TaskResult [details=[ResultDetail [localMessageText=Plant cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Plant, rowCount, 100]], ResultDetail [localMessageText=Material No. cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Material No., rowCount, 100]], ResultDetail [localMessageText=Material Type cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Material Type, rowCount, 100]], ResultDetail [localMessageText=Procurement Type cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Procurement Type, rowCount, 100]], ResultDetail [localMessageText=MRP2–Special Procurement Txt cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, MRP2–Special Procurement Txt, rowCount, 100]], ResultDetail [localMessageText=X-Plant Status cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, X-Plant Status, rowCount, 100]], ResultDetail [localMessageText=Material Status at Plant level cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Material Status at Plant level, rowCount, 100]], ResultDetail [localMessageText=Costing – Special Procurement cells: 100, occurrences=0, type=lineItemRowsProce

            WRITER_1_*_1> JAVA PLUGIN_1762 [2021-06-14 07:56:19.225] [DEBUG] ssed, values=[lineItemName, Costing – Special Procurement, rowCount, 100]], ResultDetail [localMessageText=Flag Material for Deletion at Plant Level cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Flag Material for Deletion at Plant Level, rowCount, 100]], ResultDetail [localMessageText=Key cells: 100, occurrences=0, type=lineItemRowsProcessed, values=[lineItemName, Key, rowCount, 100]]], failureDumpAvailable=false, objectId=112000000142, objectName=null, successful=true]], objectId=118000000009, successful=true], taskId=629C48B71B1E4FBA947D43E09AF741C8, taskState=COMPLETE]

            WRITER_1_*_1> WRT_8168 [2021-06-14 07:56:19.227] End loading table [PROCESS##58_##32_Test##32_for##32_IICS: Partition 1] at: Mon Jun 14 07:56:18 2021

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:19.229] [INFO] Stopping the Data session for the Data Adapter in CCI

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:19.229] [INFO] Data Session successfully stopped for the Data Adapter in CCI

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:19.229] [INFO] Deinitializing the Data Session for Data Adapter in CCI

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:19.229] [INFO] endDataSession:begin

            WRITER_1_*_1> CCI_WRITER_1000 [2021-06-14 07:56:19.229] [INFO] Successfully Deinitialized the data session for Data Adapter in CCI

            WRITER_1_*_1> WRT_8035 [2021-06-14 07:56:19.230] Load complete time: Mon Jun 14 07:56:18 2021

             

             

            LOAD SUMMARY

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

             

             

            WRT_8036 Target: PROCESS##58_##32_Test##32_for##32_IICS: Partition 1 (Instance Name: [PROCESS__Test_for_IICS])

            WRT_8038 Inserted rows - Requested: 100        Applied: 2          Rejected: 0          Affected: 100     

             

             

             

             

            WRITER_1_*_1> WRT_8043 [2021-06-14 07:56:19.230] *****END LOAD SESSION*****

            WRITER_1_*_1> WRT_8006 [2021-06-14 07:56:19.230] Writer run completed.

            MANAGER> PETL_24031 [2021-06-14 07:56:19.231]

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

            Thread [READER_1_1_1] created for [the read stage] of partition point [SQ_Material_Components_csv] 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 [SQ_Material_Components_csv] has completed. The total run time was insufficient for any meaningful statistics.

            Thread [WRITER_1_*_1] created for [the write stage] of partition point [PROCESS__Test_for_IICS] has completed.

            Total Run Time = [2.727182] secs

            Total Idle Time = [0.000000] secs

            Busy Percentage = [100.000000]

             

             

            MANAGER> PETL_24005 [2021-06-14 07:56:19.338] Starting post-session tasks. : (Mon Jun 14 07:56:19 2021)

            MANAGER> PETL_24029 [2021-06-14 07:56:19.415] Post-session task completed successfully. : (Mon Jun 14 07:56:19 2021)

            MAPPING> SDKS_38510 [2021-06-14 07:56:19.415] SDK target and group deinitialized with status [0].

            MAPPING> SDKS_38025 [2021-06-14 07:56:20.654] Plug-in 900210 deinitialized and unloaded with status [0].

            MAPPING> SDKS_38019 [2021-06-14 07:56:20.654] Writer SDK plug-ins deinitialized with status [0].

            MAPPING> TM_6315 [2021-06-14 07:56:20.654] DTM error log: file log [C:\PROGRA~1\INFORM~1\apps\Data_Integration_Server\data\error\s_dss_017W660I000000000016_1_error.csv], rows inserted [0].

            MAPPING> TM_6018 [2021-06-14 07:56:20.654] The session completed with [0] row transformation errors.

            MANAGER> PETL_24002 [2021-06-14 07:56:20.942] Parallel Pipeline Engine finished.

            DIRECTOR> PETL_24012 [2021-06-14 07:56:21.005] Session run completed successfully.

            DIRECTOR> TM_6022 [2021-06-14 07:56:21.005]

             

             

            SESSION LOAD SUMMARY

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

             

             

            DIRECTOR> TM_6252 [2021-06-14 07:56:21.005] Source Load Summary.

            DIRECTOR> CMN_1740 [2021-06-14 07:56:21.005] Table: [SQ_Material_Components_csv] (Instance Name: [SQ_Material_Components_csv])

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

            DIRECTOR> TM_6253 [2021-06-14 07:56:21.005] Target Load Summary.

            DIRECTOR> CMN_1740 [2021-06-14 07:56:21.005] Table: [PROCESS##58_##32_Test##32_for##32_IICS] (Instance Name: [PROCESS__Test_for_IICS])

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

            DIRECTOR> TM_6023 [2021-06-14 07:56:21.005]

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

             

             

            DIRECTOR> TM_6020 [2021-06-14 07:56:21.005] Session [s_dss_017W660I000000000016] completed at [Mon Jun 14 07:56:21 2021].

            • 3. Re: How to load a file into Anaplan Process from IICS?
              Jharana Patra Guru

              Hi Dinesh ,

               

              In the given log looks like the rows are applied and also sent as output

               

               

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

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

               

              If you are inserting records outside Informatica are they successful ?

              You can also use a flatfile in between and check if the file is getting loaded or not.