Tuesday, September 8, 2015

Trial Ledger Balance Error

Trial Ledger Balance Error AX 2012

Error Message:

Cannot Execute the required database operation. Cannot attach to connection since the buffer is in use. Use another buffer or clear the buffer by assigning NULL



Resolution

1. Kill all the user sessions. System Administration > online users> Select users and Kill
2. Reset Usage data. System Administration > users> options> usage data > Reset.
(All the personalization would be lost but will solve the problem)

Keywords: Trial Balance, AX 2012, Buffer size, Connection in use, Clear the buffer.