How do I find the source of imp_location table?

[iamkurt]

PFA screenshots.

I am having an issue wherein garbage location records are being created daily with names like ",,BC" and ",,ON" - with single and double commas. The record count just keeps on increasing daily. I suspect these location records are being created whenever a Consumer User class record gets updated.

I checked transform maps and there is one with source table as imp_location and target table as cmn_location

I am trying to figure out the source of the source table here viz. imp_location. Where does it gets its records from?

When I checked imp_location table, its completely blank.

How can I figure out where is the data being fetched from to populated on imp_location table?

Any help here would be appreciated.

Thanks

[ShubhamGarg]

Hello @iamkurt ,

To start off with troubleshooting, few things I would have done in such scenarios -
1. Try to reproduce the issue by activating Script Debugger.
2. Check if there is any 'Connection URL' defined in 'Data source' record.
3. Do a studio search for any given clue you got.
4. Similar thing can be done with Inbound/Outbound Integration logs.
5. Download Node log > Split it and read it (Time Consuming).

Kindly mark this as Accepted Solution/Helpful if above info. helps in any way and help in closing this thread.

Regards,

Shubham