Import Set records are not processing....

[basantsoni]

Hello Friends,

We are trying to load records almost 7k via import set tables into target table. But it's in running status from last 10 hours. Some of the records has been processed but some are in progress.

Can anyone please us on this. From where and how we can start our investigation on these type of issues.

Thanks,

Basant

[Ankur Bawiskar]

Hi Basant,

In left nav you can type Import Sets and open the import set and check the logs and other details.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[Ankur Bawiskar]

Hi Basant,

Any update on this?

Can you mark my answer as correct, helpful and hit like if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards

Ankur

[basantsoni]

Hi Ankur,

thanks for your reply. to fix this issue we have been suggested by service now to disable OTB BR Maintain Catalog Category M2M Item in transform map.

Can you please let us know what could be the impact/dependencies of this BR if we'll disable this.

Thx,

Basant

[Ankur Bawiskar]

Hi Basant,

I am not sure what relation this business rule on RITM table has with your import sets?

Are you loading some data to RITM table through transform map? If yes then this business rule on RITM must be triggering on every row transformation insert/update and may be going in some loop causing performance impact. You can always go with solution given by ServiceNow since you must have raised a hi ticket and it should be documented in the hi ticket as well that they suggested to disable that BR.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur