Our company uses JMP Live, version 19.0.2
We make use of JMP Live's event scheduler to automatically refresh reports via SQL queries. Typically our data refresh jobs <1 minute to complete with a handful that take 2-3 minutes at most.
However, at least once a week, our scheduled refresh pool becomes "stuck". Data refreshes and reports which usually take seconds to complete instead stay active in the event queue for hours forcing the system to lock up, preventing further jobs from completing.
The only way to resolve this issue is to ask our IT team to restart the JMP Live server.
Check list of things we've already tried:
- Reduced "Pool session elapsed time" to 15 minutes
- Dropped the Pool session default memory to 8000MB (recommended by JMP Technical)
- Spacing out our data refreshes
- Looked for a common script causing the issue - no dice
- Manually kill events and pools - makes no difference
Has anyone experienced these issue with JMP Live before and did you have a fix?
