Rebuild Framework Query, stuck in loop and not completing (no errors)

It has been found that the Rebuild Framework query can get stuck in an infinite loop.

If you run the rebuild framework query group in Geobank, and it produces a timeout error, the best thing to do to address the issue would be to log into the SQL Server Management Studio and run the stored procedure from there.

This stored procedure can be found in your database.

Expand the database node and scroll down to expand the programmability node, when expanded you will see the stored procedures node.

Please expand that node and scroll down to the rebuild framework procedure.

From there we will run the procedure with the following inputs.

Click ok to run the procedure.

If you find that the procedure still only goes in a loop.

It will run, but not produce any error message, and will not finish running.

Then you have the loop error.

We only run the rebuild framework procedure when new tables are added to the database so there should be 1 or a few new tables.

Please check that all of the tables have correct and working foreign keys.

If any table has a foreign key pointing to itself, this will cause the problem.

Please fix the key problem and try again.

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access