Export Set not working. File attachment is created, but transfer to MID server doesn't work

[Bob D]

[Madrid]

I have created an Export Set to transfer some CMDB data to my MID server as .csv file .  If I run the "Test Export 20 Records" test, the .csv shows up in the proper place on the MID server.  But when I run the full Export Data, the .csv file rarely shows up. 

I say "rarely" because sometimes it does transfer properly.  If I run the export several times I don't get the .csv file, but the next time...it shows up.  It's random.  The file is not large - about 200 rows of data and 400kb in size.    If I check the MID Server Attachment table, I can see the .csv file is being properly created and attached to the table record.   If I look at the System Logs, I can see an entry that says the file is being transferred to the MID server....but no file shows up (most of the time) and I don't see any obvious error messages.

What can explain this behavior and how can I make this work consistently?   thanks

[Bob D · Accepted solution]

I have figured this out.  My MID Server is load balanced, and even though I configured the export set to use a specific MID/agent, it appears the export job is being placed in any available agent's ECC queue.   The export files are showing up on the MID server - just not where I expected them to be.