Status of Import Set rows is Empty instead of 'Pending' when 'Load All Records' UI Action is used from Data Sources

[Gulzar Manuja2]

Dear All,

I hope all of you are doing well. I have come across a problem when I was trying to perform IDL using Data Sources. I was able to load the data(57,958 rows to be precise) successfully in the import set table using 'Load All Records' UI action in the Data Source as shown below:

   

Then I used 'Run Transform' feature to transform and load the data to the target table which completed successfully(at least as per the status shown below):

However, when I checked the transform history, I was startled to see that not even a single row was processed depicted as follows:

Per my understanding, only those rows are transformed successfully whose state is set to 'Pending' in the import set. Therefore, I checked the loaded data in the import set. To my dismay, State of these rows was not set to 'Pending' somehow, it was empty for all 50,000+ rows.

I would be extremely grateful if someone could help me understand why State was not set to 'Pending' and how to resolve this issue.

Thanks a lot !!!!

Regards,

Gulzar Manuja

[Ashutosh Munot1]

HI Manuja,

This is actually strange. Anything imported in this should go to pending first. Please show you data source SNAPSHOT.

Thank you,

Ashutosh

[Gulzar Manuja2]

Hey Ashutosh,

Thanks for your response !!!!

It is bizarre indeed !!!! Please find below screenshot of the data source:

Kindly let me know if any other information is required from my end.

Regards,

Gulzar Manuja

[Gulzar Manuja2]

Can anybody help me with this please ?

Thanks & Regards,

Gulzar Manuja

[Ashutosh Munot1]

Is data source created?