I have an update regarding this post -- The original ticket Support case 00887944 - Opened April 23, ended without resolution as the Customer that opened the ticket stopped responding to find root cause. They ended up applying a few registry values that allowed Application Aware processing to work again, but they couldn't get SQL Log truncation to work.
I have worked with a Customer who opened a ticket recently for a similar issue who referenced back to this ticket, and they are on Version 9 (OC was V8 when issue was worked on) and the suggested registry key fix resolved Application Aware Processing as well as SQL Log Truncation it seems so far. We are monitoring right now, but the registry key suggested seems to have worked well.
The newer ticket with the noted fix is Case 0181928. If you feel you are experiencing a similar issue, please feel free to open a Support Ticket and reference Case 01819282 or this forum post and our Support Team can provide the suggested fix.