Jump to content
  • 0
abitaquest

Scheduled Tasks: Exports truncated

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?

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi @abitaquest,

I know that file size limit for scheduled task and manual export is different.

The scheduled task export/import: file should be 50 Mb or less. 

Manual export: file should be 1Gb or less. 

Make sure that your table fits the size limit.

ef86c360c5fc.png

Hope this helps.

Regards,

vitalikssssss

 

Share this post


Link to post
Share on other sites

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...

×
×
  • Create New...