Transform map is running infinite loop for 10 records present in excel sheet in CSM

[Abhishek Kumar8]

Hi,

I am trying to load 50 records at a time using the excel sheet through the transform map. Data is inserted/updated but the transform map is running in an infinite loop.

Target table : User account relationship

field map :

Transform script : OnAfter

Error :

any help on this is really appreciated.

Thanks,

Abhishek

[BharathChintala]

@Abhishek Kumar8  can you tell me the process how you are loading data?

[Abhishek Kumar8]

Hi @BharathChintala ,

I have loaded the data using a transform map.

System Import Sets --> Load Data

Select files as excel and Load them.

Thanks,

Abhishek

[BharathChintala]

@Abhishek Kumar8 How many rows data you have in excel you are loading?

It should not fall into loop as transform maps are intend run for the rows we load and can you clean import set table and load freshly and try once again

once you load data like below screen shot hom many records it is showing?

[Harshal Aditya]

Hi @Abhishek Kumar8 ,

Hope you are doing good.

Could you please check the excel file that you are loading maybe it contains extra rows. Try pasting your data into a different excel sheet and remove extra rows.

Please Mark My Response as Correct/Helpful based on Impact

Regards,
Harshal