Imported data is missing in the table

[taqdeer]

Hi All,

I have imported data into a table 7 days ago. I see that data is missing now. Table has become empty. I understand that there will be schedule cleanup for import sets once in a wee. but that is to delete the import set information not the data right? Can any one please tell me what would have been happened?

[Joshton1 · Accepted solution]

Hello Taqdeer,

The data in the import set table is also cleaned,

You can refer the script include - "ImportSetCleaner "called from the Scheduled job - Import set Deleter .

The clean() Function called, queries the import sets first and then if import set is available it also has a call for removeData and then that calls TableClean,

--------------------------

clean : function() {
var isets = this._queryIsets();

while(isets.length > 0) {
this._removeData(isets);

-------------------------

So to conclude yes the data is also cleaned form the import set extended table which is your staging table. 

Thanks,

Joshton

[taqdeer]

Thanks Joshton... 🙂

[Karim Kabbara]

Hi,

Is there a way to just delete the “Import Set Rows" and retain “Sets” and “Import Set Runs”?

Thanks in advance!

Karim