community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Server Knowledge Base

Definitive answers from Server experts.

Error: Schedules Forecast page does not display all scheduled jobs in Server UI Admin

KenL
Alteryx
Alteryx
Created

‎05-03-2023 01:49 AM

Error: Schedules Forecast page does not display all scheduled jobs in Server UI Admin

 

Environment Details

 

When opening the Schedules Forecast page in the Server UI Admin interface, not all scheduled jobs appear as expected. When this behavior is observed, the Gallery logs show this error:

The combination of the seed date/time and the forumla passed in cannot correctly find a next run date/time
 
  • Alteryx Server
    • 2022.1
  • Schedules appear as per normal in the Server UI Admin > Jobs page


Cause

 

There was a number of corrupt Schedules in the Server environment



Resolution

 

 

  1. Inspect the 'AlteryxService.AS_Schedules' collection using a MongoDB UI. You can use Robo 3T or build a Designer workflow using the MongoDB Input tool .
  2. Filter records where the Status attribute contains 'Corrupt'.
    1. If using Robo 3T or some other MongoDB UI, run this MongoDB query: 
      db.getCollection('AS_Schedules').find({"Status":{ $regex: /Corrupt/i}})
    2. If using a Designer workflow with the MongoDB Input tool, apply the above filter using a Filter tool
    3. Some examples of Status values of the corrupt Schedules:
      1. Corrupt: Date was in an invalid format. Use YYYY-MM-DD HH:mm:ss
      2. Corrupt: AlteryxService_RetrieveSecureData failed
  3. The corrupt Schedules can be identified by their name in the 'LC_ScheduleName' attribute. From the Server UI, delete and recreate these Schedules.
    image.pngimage.png
  4. If the Schedules don't have names in the 'LC_ScheduleName' attribute, their corresponding workflow or Analytic App in Server can be identified from cross-referencing the 'AS_Application_ID' attribute in the 'AlteryxService.AS_Schedules' collection to the '_id' attribute in the 'AlteryxService.AS_Applications' collection. In the 'AlteryxService.AS_Applications' collection, the workflow or Analytic App name is in the 'ModuleName' attribute. With the workflow or Analytic App identified, go to Server UI, then delete and recreate its associated Schedule.
    image.pngimage.png


Additional Resources

0 Likes