Issue

The following error may appear when using Sage Pro ERP with a Microsoft SQL Server (SQL) database:

Allowed DO nesting level exceeded

This error usually indicates a problem with the connection between SQL and Sage Pro. As a result, the operation is not completed. Usually SQL has been stopped or interrupted for some reason, even momentarily.

This scenario can be reproduced by the steps below:

1. Login to Sage Pro and open any module in Company 99. At this point, do not do anything else in Sage Pro.
2. Stop SQL Server. This can be via the steps below:
   1. Open the SQL Enterprise Manager.
   2. Right-click the Registered SQL Server being used.
   3. Click Stop.
3. Re-start the server via the same steps as above except this time, click Start.
4. Switch to Sage Pro. No error appears at this point.
5. Try to enter a transaction via the Transaction menu.
6. The error appears even though SQL is currently running. This leads to an ungraceful exit from the program.
7. Re-enter Sage Pro.
8. Attempt to enter the transaction again.
9. The error does not appear. It will only occur if the SQL Server is stopped and re-started again while in the product.

Solution or Workaround

If this error occurs, ensure that SQL is running and connections can be made from all workstations. If this is a frequent error for one or more workstations, check cables and the network connections to the server.

The majority of technical support calls have found that this issue is SQL security related. However, this has been seen in a Microsoft Visual FoxPro installation if the program logic is incorrect. For example, a company was created and rules were copied in from another company but the data was not copied. It was appended in from an external source, however, this data had an account structure that was different from the company it was copied into. This results in the Allowed DO nesting level exceeded error message.

© Copyright Sage Software