Hi,
Would like to know how to troubleshoot these kind of errors from Batch Server: `Request ### cannot be launched with this status`
Sage X3: v12p31 (planning to push up but cannot at the moment due to customization issues from X3 pu9).
Setup: Each Sage X3 component service has its own dedicated server linked internally with 10 Gbps physical network line.
Context:
- Application X3 Server and Database server are on separated server with dedicated 10 Gbps physical network line.
- For Database server, there was a full server restart at around 12:00am - 1:00am due to Windows Update monthly maintenance run. No service and server restart occurs after that; all services are active.
From Syracuse log, there are multiple recurring tasks failure observed around 12:00am - 1:00am due to unable to access the SQL Server (it was restarting).
From Syracuse log, issue seems to occurs around 5:00am as start of issue where Batch Server cannot be started. No additional error notes provided.
```
2023-10-22T21:14:17.741Z | | | | batch.server | error | [SAGEX3] startController Cannot start the batch server.
```
From Batch Server, issue seems to occurs around 7:00am with one of the Accounting Task query returning Error.
At around 8:00am, observed error. Client has turned off Accounting Task and turned it back on. The Batch Server automatically resolved itself.
Checked from syracuse's node log:
```
2023-10-23T00:13:25.435Z | 77105891d41d | | | batch.x3Query | error | BatchServer_SAGEX3_Query_2949442__representation_Batch request 2949442_runSdataRequestx3Client_[x3Client BatchServer_SAGEX3_Query_2949442 x3Pid=20364 sessionCreated batchQuery alive]_runtime_x:20100 result 406 - [
{
"$severity": "error",
"$message": "Request 2949442 cannot be launched with this status"
}
]
2023-10-23T00:13:25.436Z | 77105891d41d | | | batch.server | error | BatchServer_SAGEX3 Request 2949442 cannot be launched with this status
2023-10-23T00:13:25.507Z | 77105891d41d | | | batch.server | error | BatchServer_SAGEX3 An error occurred on executing query 2949442: Request 2949442 cannot be launched with this status Request 2949442 cannot be launched with this status
```