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

[Gulzar Manuja2]

Hey Ashutosh,

Yes, I have shared a screenshot of the data source above. Please let me know in case of any queries.

Thanks & Regards,

Gulzar Manuja

[ttzeng]

I have the same issue.  Jakarta.  Is there any news on this problem?

[ttzeng]

I believe that this issue may be caused by using the "Insert and Stay" option when creating a Data Source.  The import table State choice list does not set the "Pending" state as the default.

The resolution seems to be to just set the default value to "pending".