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

Abhishek Kumar8
Tera Contributor

‎03-02-2023 11:02 PM

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 :

AbhishekKumar8_0-1677826847927.png

Transform script : OnAfter

Error :

AbhishekKumar8_1-1677826907541.png

any help on this is really appreciated.

 

Thanks,

Abhishek

0 Helpfuls
  • 667 Views
6 REPLIES 6

Abhishek Kumar8
Tera Contributor
In response to Harshal Aditya

‎03-03-2023 02:40 AM

Hi @Harshal Aditya , I have copied the data into a new excel sheet and loaded them but it's running in infinite loop.

 

Thanks,

Abhishek

0 Helpfuls

Rush B
Tera Contributor

‎03-03-2023 02:50 AM

Hi @Abhishek Kumar8

Try to review your encoded query and loop condition once, need to see the logic you written in the Transform Script to comment on the issue. Also check below article for best practices.

https://www.servicenow.com/community/developer-blog/transform-map-best-practices/ba-p/2276233 

 

Thanks & Mark Answer Correct or Hit Thumbs Up. If my comments helped you!
Rush B

0 Helpfuls