Import set state as Processed but in import set rows records are showing Pending(not all)

[Ranjita Hegde1]

Hi Everyone,

I have transform map which is automatically executing when data loaded.

But, I can see that import set state as Processed but some import set rows records are showing in  'Pending' state(not all the records).

Could anybody please help me to troubleshoot this?

Thanks & Regards,

Ranjita Hegde

[Sulabh Garg]

Hello Ranjita,

Has your transform map stopped in between? that means records added in import set table but not transformed completely. It can be due to restart of nodes due to patch upgrade or some instance related activity.

Import set rows are showing in "Pending" state means rows are ready to be processed/transformed but transformation stopped in between resulting into the "pending" state.

As an alternate, you can go to the import set where import set rows are "pending" and click on the "Reprocess" UI action, it will process the "pending" records.

Hope it helps.!!

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[Ranjita Hegde1]

Hi Sulabh,

Thanks for your reply.

I see transform map processed successfully. Target record created.

Still see the import set state is "pending".

Thanks & Regards,

Ranjita Hegde

[Sulabh Garg]

Hi Ranjita,

If the import set state is Pending then it could be due to node restart when your transform map is running, so to avoid any descrepancy you can click on "Reprocess" related UI link to process the pending records on import set form.

Hope it helps.

[Ankur Bawiskar]

Hi,

Is this happening always?

Can you share screenshot of the import set record?

Regards
Ankur