DronaBlog

Thursday, August 24, 2023

How to fix error : SDKC_37015 Plug-in Error: Invalid index for transformation type [0]: Should range from [0] to [-1]

 The error message - SDKC_37015 Plug-in Error: Invalid index for transformation type [0]: Should range from [0] to [-1] normally occurs when we try to execute Ingress or egress job in Informatica IDMC ( Intelligent Data Management Cloud ).





a) Error Message:

In order to investigate this issue, we need to check session logs. The session logs will have entry like this -

WRITER_1_*_1> SDKC_37015 [2023-08-17 12:17:24.732] Plug-in Error: Invalid index for transformation type [0]: Should range from [0] to [-1]

WRITER_1_*_1> MDM_10000 [2023-08-17 12:17:25.030] [INFO] JobInstanceId recieved from taskflow is $$jobInstanceId

WRITER_1_*_1> CMN_1761 [2023-08-17 12:17:25.031] Timestamp Event: [Mon Aug 17 12:17:25 2022]

WRITER_1_*_1> MDM_10000 [2023-08-17 12:17:25.031] [ERROR] jobInstanceId is empty or has default value, hence quitting

WRITER_1_*_1> MDM_10000 [2023-08-17 12:17:25.031] [WARNING] Failed to establish connection with the Data Souce.

WRITER_1_*_1> CMN_1761 [2023-08-17 12:17:25.031] Timestamp Event: [Mon Aug 17 12:17:25 2022]

WRITER_1_*_1> MDM_10000 [2023-08-17 12:17:25.031] [ERROR] Connection failed for CCI Client


Notice that there is error related to JobInstanceId - j



obInstanceId recieved from taskflow is $$jobInstanceId


b) How to fix it?

As the issue is related to jobInstanceId, we need to make sure job instance id is available at the below location -

1. Mapping Level - Make sure Inout Parameter jobInstanceId is defined.

2. Mapping Task Level - Make sure Inout Parameter jobInstanceId will be automatically picked from Mapping

3. Taskflow Level - Verify that jobInstanceId has added on both Start and Data Task


Once you fix the jobInstanceId in all these 3 levels, the issue will be resolved. 


Learn more about Informatica MDM Cloud (SaaS) here





No comments:

Post a Comment

Please do not enter any spam link in the comment box.

What is Glue Job in AWS?

An AWS Glue job is a managed ETL (Extract, Transform, Load) job used to process data in AWS. AWS Glue makes it easy to discover, prepare, an...