Jump to content
  • 0

Scheduled Tasks: Exports truncated


abitaquest
 Share

Question

Hi. I have scheduled tasks that export a single table each day and upload it to a remote server as a zipped .csv file. It's been running for years without issue.  In the past two days, the upload has been happening, but the zipped file won't open. I thought I got around the problem by telling the system not to zip it first. (I can work with the raw .csv.) However, when that happens, I only get a small portion of the .csv records, not the full table. I think the two may be related, and that the exports are stopping before they're complete, resulting in incomplete .csv files as well as .zip files that can't be expanded. Running the scheduled tasks on demand produces the same results. I can get the data I need by going to the table and exporting directly from there. But since I need to automate this so that it runs twice daily, that's only a temporary solution, at best. (Note: This isn't happening with only single table, but with all similar tasks.)

Any ideas?

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...