Hi Team,
ODBC exception encountered on random Monday mornings during batch job execution. Perform daily restarts of AX and IIS services in order to clear cache, as well as weekend maintenance jobs to reindex the table. Additionally, we ensured that CPU spikes weren't occurring and that server utilization was low. After multiple batch jobs were rerun, the job got completed.
Since our client is based on Australia, the following columns are country-specific. I'm wondering why below exception occurs only on Monday.
Below are the exception details, PFA file.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
Table Column Operation
BankAccounttable PRINTGIRO_FI Select
Custtrans BANKREMITTANCEFILEID Insert
It wWould be helpful if anyone could suggest some ideas to troubleshoot.
Thanks