R04901A - Generate As Of AP running long and/or erroring

James Monroe

Active Member
We are on tools 9.1.4.7, apps 9.0.

The Generate As Of AP job usually runs about an hour, most of that is the SQL running it seem, then in the last 5 or 10 minutes, the data is being written to the As Of table F0411A.

However, recently the job has been running longer, and sometimes we have to cancel it. Yesterday it errored out after running with an SQL error.

I had thought that perhaps if others were entering or posting vouchers while R4901A was running, this could affect the SQL performance. However last evening it errored out and there were no activity going on i dont believe.

The log is below. Any one else have issues with this job running long or have a suggestion as to how to attack it?
 

Attachments

  • R04901A_RUS00001_698743_PDF.txt
    6.9 KB · Views: 3
Top