Skip to main content
Solved

Scheduled Export Scenario won't run until I manually run it first.


Forum|alt.badge.img+6

I have an Export scenario that updates a Magento store’s quantity values every hour. I created a GI that will show me the current qty available to ship of all inventory that was invoiced in the last hour.

At the start of the day, it will fail with the error: “Index was out of range. Must be non-negative and less than the side of the collection. Parameter name: index.”

If I run it manually in Export by Scenario by selecting Prepare & Export, I get the same error.

If I check “Discard Previous Result” and select Prepare & Export, then it will run. And for the rest of the day, the process will run on the hourly schedule I have it on.

Until tomorrow morning when it will need me to run it manually again.

Any ideas on how to troubleshoot this?

Best answer by Django

I filled in “Discard Previous Result” on the Export Scenario and that seems to have allowed it to run.

View original
Did this topic help you find an answer to your question?

4 replies

bwhite49
Pro III
Forum|alt.badge.img+1
  • Pro III
  • 104 replies
  • March 6, 2025

I find the Process Import Scenarios screen scheduler to be unreliable in the “prepare” stage when using Prepare and Import. Once it fails, it never tries to reprepare and requires manual intervention. This issue with the export screen sounds familiar. 

Does this export scenario work reliably when running it manually from the process export scenarios screen? Or do you need to go to the “Export by Scenarios” screen to run it? 

If it runs reliably from the process export scenarios screen, you could create a GI with 1 row. Does not matter what the row shows. Add 1 column. From there, you could create a business event from that GI which runs on a schedule (trigger by schedule). This would trigger an import scenario to run that single export scenario through the process export scenarios screen.


Forum|alt.badge.img+6
  • Author
  • Captain II
  • 562 replies
  • March 6, 2025

Unfortunately, it doesn’t run when selecting the one scenario on the Process Export Scenarios screen. I have to do one of two things:

Check “Discard Previous Result” and then run Prepare & Export, or

Click Prepare, then click Export.

 


Forum|alt.badge.img+6
  • Author
  • Captain II
  • 562 replies
  • Answer
  • March 10, 2025

I filled in “Discard Previous Result” on the Export Scenario and that seems to have allowed it to run.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2757 replies
  • March 11, 2025

Thank you for sharing your solution with the community ​@Django!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings