Hi All,
I have a view which joins 6 small tables together. Table size is small and the total count is around 37K records and select runs in less than 7 seconds. Tables are selected with no lock hints.
There is not much change in data or in volume.
But sometimes SQL is terminating the view saying "Internal Error: Text manager cannot continue with the current statement. Run DBCC CHECKTABLE"
There are frequent executions of this view and its immediate runs get successful.(Next schedule ran after 2 min)
Based on the error messages, we are did run DBCC CHECKTABLE and couldn't find any issues. we did CHECKDB as well.
But this happens intermittently
Can this be due to any specific data in the table?
Also, How do we troubleshoot this issue?
There are no other errors logged in the same server and also in its AG replica.
Thanks,
ACDBA