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