SQL Server 2000 Stored Proc error

I have a Sql Server2000 stored proc that compliles OK and has been running fine for months. But today its suddenly gives the following error:

Location:       recbase.cpp:1371
Expression:       m_nVars > 0
SPID:             55
Process ID:       772
Msg 3624, Level 20, State 1, Procedure MyStoredProc, Line 51

Why? Please advise a fix.
Thanks.
 
ksfokAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rockyboy123Commented:
This problem occurs because an access violation occurs that was caused by an assertion in the RecBase::ResizeVar function. The access violation causes a fatal exception. The fatal exception causes the exception handler to put a user database in suspect status.

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 (http://support.microsoft.com/kb/290211/) How to obtain the latest SQL Server 2000 service pack

http://support.microsoft.com/kb/825197

Let me if it works or not .

Rakesh
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ksfokAuthor Commented:
Meanwhile, I ran DBCC CHECKDB('mydb', REPAIR_ALLOW_DATA_LOSS) and got this output:

Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.
DBCC results for 'POSYS2'.
DBCC results for 'sysobjects'.
There are 357 rows in 5 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 481 rows in 27 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 2091 rows in 39 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 424 rows in 181 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 278 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 22 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 2 rows in 1 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 1140 rows in 7 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 1 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 512, index ID 869, page ID (1:61491). The PageId in the page header = (512:60921088).
        The error has been repaired.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 512)' (object ID 512).
CHECKDB fixed 0 allocation errors and 1 consistency errors in table '(Object ID 512)' (object ID 512).
DBCC results for 'CancelLog'.
There are 5657 rows in 57 pages for object 'CancelLog'.
DBCC results for 'temp_delme'.
There are 0 rows in 0 pages for object 'temp_delme'.
DBCC results for 'POSystemSettings'.
There are 6 rows in 1 pages for object 'POSystemSettings'.
DBCC results for 'xapinpcdt_delfromBND_unmatchedfor11'.
There are 886 rows in 37 pages for object 'xapinpcdt_delfromBND_unmatchedfor11'.
DBCC results for 'Users_ADUsers'.
There are 1769 rows in 34 pages for object 'Users_ADUsers'.
DBCC results for 'xapinpcdt_delfromBND_unmatchedforBND'.
There are 2057 rows in 86 pages for object 'xapinpcdt_delfromBND_unmatchedforBND'.
DBCC results for 'invBundleItems'.
There are 29 rows in 2 pages for object 'invBundleItems'.
DBCC results for 'xapinpcdt_delfromBND_apinpchg_deleted'.
There are 112 rows in 5 pages for object 'xapinpcdt_delfromBND_apinpchg_deleted'.
DBCC results for 'xapinpcdt_delfrom11_apinpchg_deleted'.
There are 0 rows in 1 pages for object 'xapinpcdt_delfrom11_apinpchg_deleted'.
DBCC results for 'apbranch_descr_updates'.
There are 363 rows in 7 pages for object 'apbranch_descr_updates'.
DBCC results for 'CERProcessing'.
There are 71 rows in 4 pages for object 'CERProcessing'.
DBCC results for 'counters'.
There are 1 rows in 1 pages for object 'counters'.
DBCC results for 'AdminBranchCodes'.
There are 31 rows in 1 pages for object 'AdminBranchCodes'.
DBCC results for 'InvClass'.
There are 12 rows in 1 pages for object 'InvClass'.
DBCC results for 'Next_PR'.
There are 1 rows in 1 pages for object 'Next_PR'.
DBCC results for 'PRHDR'.
There are 126150 rows in 7019 pages for object 'PRHDR'.
DBCC results for 'PRLIN'.
Msg 8928, Level 16, State 1, Line 2
Object ID 597577167, index ID 0: Page (1:79795) could not be processed. See other errors for details.
        The error has been repaired.
Msg 8941, Level 16, State 102, Line 2
Table error: Object ID 597577167, index ID 0, page (1:79795). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 26, offset 0x18 is invalid.
        The error has been repaired.
Msg 8942, Level 16, State 101, Line 2
Table error: Object ID 597577167, index ID 0, page (1:79795). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x1a overlaps with the prior row.
        The error has been repaired.
Msg 8928, Level 16, State 1, Line 2
Object ID 597577167, index ID 0: Page (1:133771) could not be processed. See other errors for details.
        The error has been repaired.
Msg 8941, Level 16, State 102, Line 2
Table error: Object ID 597577167, index ID 0, page (1:133771). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 37, offset 0x1 is invalid.
        The error has been repaired.
Msg 8942, Level 16, State 101, Line 2
Table error: Object ID 597577167, index ID 0, page (1:133771). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x25 overlaps with the prior row.
        The error has been repaired.
Msg 8928, Level 16, State 1, Line 2
Object ID 597577167, index ID 0: Page (1:140519) could not be processed. See other errors for details.
        The error has been repaired.
Msg 8944, Level 16, State 17, Line 2
Table error: Object ID 597577167, index ID 0, page (1:140519), row 34. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 174 and 171.
        The error has been repaired.
Msg 8928, Level 16, State 1, Line 2
Object ID 597577167, index ID 0: Page (1:145999) could not be processed. See other errors for details.
        The error has been repaired.
Msg 8941, Level 16, State 102, Line 2
Table error: Object ID 597577167, index ID 0, page (1:145999). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 37, offset 0x29 is invalid.
        The error has been repaired.
Msg 8942, Level 16, State 101, Line 2
Table error: Object ID 597577167, index ID 0, page (1:145999). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x25 overlaps with the prior row.
        The error has been repaired.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 1. Page (1:79795) was not seen in the scan although its parent (1:79426) and previous (1:79794) refer to it. Check any previous errors.
        The error has been repaired.
Msg 8978, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 1. Page (1:79796) is missing a reference from previous page (1:79795). Possible chain linkage problem.
        The error has been repaired.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 1. Page (1:133771) was not seen in the scan although its parent (1:133250) and previous (1:133770) refer to it. Check any previous errors.
        The error has been repaired.
Msg 8978, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 1. Page (1:133772) is missing a reference from previous page (1:133771). Possible chain linkage problem.
        The error has been repaired.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 1. Page (1:140519) was not seen in the scan although its parent (1:140364) and previous (1:140518) refer to it. Check any previous errors.
        The error has been repaired.
Msg 8978, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 1. Page (1:140520) is missing a reference from previous page (1:140519). Possible chain linkage problem.
        The error has been repaired.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 1. Page (1:145999) was not seen in the scan although its parent (1:145596) and previous (1:145998) refer to it. Check any previous errors.
        The error has been repaired.
Msg 8978, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 1. Page (1:146000) is missing a reference from previous page (1:145999). Possible chain linkage problem.
        The error has been repaired.
Msg 8928, Level 16, State 1, Line 2
Object ID 597577167, index ID 7: Page (1:29547) could not be processed. See other errors for details.
        The error has been repaired.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 7. Page (1:29547) was not seen in the scan although its parent (1:29770) and previous (1:29546) refer to it. Check any previous errors.
        The error has been repaired.
Msg 8944, Level 16, State 13, Line 2
Table error: Object ID 597577167, index ID 7, page (1:29547), row 81. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2261 and 24.
        The error has been repaired.
Msg 8978, Level 16, State 1, Line 2
Table error: Object ID 597577167, index ID 7. Page (1:29548) is missing a reference from previous page (1:29547). Possible chain linkage problem.
        The error has been repaired.
Repair: Page (1:79795) has been deallocated from object ID 597577167, index ID 0.
Repair: Page (1:133771) has been deallocated from object ID 597577167, index ID 0.
Repair: Page (1:140519) has been deallocated from object ID 597577167, index ID 0.
Repair: Page (1:145999) has been deallocated from object ID 597577167, index ID 0.
Clustered index successfully restored for object 'dbo.PRLIN' in database 'POSYS2'.
Non-Clustered index successfully restored for object 'dbo.PRLIN, IX_PRLIN_1' in database 'POSYS2'.
Repair: Page (1:29547) has been deallocated from object ID 597577167, index ID 7.
There are 1638655 rows in 39987 pages for object 'PRLIN'.
CHECKDB found 0 allocation errors and 23 consistency errors in table 'PRLIN' (object ID 597577167).
CHECKDB fixed 0 allocation errors and 23 consistency errors in table 'PRLIN' (object ID 597577167).
DBCC results for 'qryQtyOrderedRpt'.
Msg 8928, Level 16, State 1, Line 2
Object ID 613577224, index ID 0: Page (1:19555) could not be processed. See other errors for details.
        The error has been repaired.
Msg 8941, Level 16, State 102, Line 2
Table error: Object ID 613577224, index ID 0, page (1:19555). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 6, offset 0x40 is invalid.
        The error has been repaired.
Msg 8942, Level 16, State 101, Line 2
Table error: Object ID 613577224, index ID 0, page (1:19555). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x6 overlaps with the prior row.
        The error has been repaired.
Msg 8928, Level 16, State 1, Line 2
Object ID 613577224, index ID 0: Page (1:29155) could not be processed. See other errors for details.
        The error has been repaired.
Msg 8941, Level 16, State 102, Line 2
Table error: Object ID 613577224, index ID 0, page (1:29155). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 6, offset 0x26 is invalid.
        The error has been repaired.
Msg 8942, Level 16, State 101, Line 2
Table error: Object ID 613577224, index ID 0, page (1:29155). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x6 overlaps with the prior row.
        The error has been repaired.
Repair: Page (1:19555) has been deallocated from object ID 613577224, index ID 0.
Repair: Page (1:29155) has been deallocated from object ID 613577224, index ID 0.
There are 609022 rows in 10601 pages for object 'qryQtyOrderedRpt'.
CHECKDB found 0 allocation errors and 6 consistency errors in table 'qryQtyOrderedRpt' (object ID 613577224).
CHECKDB fixed 0 allocation errors and 6 consistency errors in table 'qryQtyOrderedRpt' (object ID 613577224).
DBCC results for 'apbranch_descr_updates2'.
There are 363 rows in 4 pages for object 'apbranch_descr_updates2'.
DBCC results for 'Receipts'.
There are 0 rows in 0 pages for object 'Receipts'.
DBCC results for 'TempTopItem'.
There are 105445 rows in 744 pages for object 'TempTopItem'.
DBCC results for 'TEMPOFFICE'.
There are 430 rows in 6 pages for object 'TEMPOFFICE'.
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 673215329, index ID 26723, page ID (1:13875). The PageId in the page header = (10552:909521440).
        The error has been repaired.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 673215329)' (object ID 673215329).
CHECKDB fixed 0 allocation errors and 1 consistency errors in table '(Object ID 673215329)' (object ID 673215329).
DBCC results for 'BlockVendorItem'.
There are 172 rows in 2 pages for object 'BlockVendorItem'.
DBCC results for 'TEMPOFFICEITEMS'.
There are 2646 rows in 50 pages for object 'TEMPOFFICEITEMS'.
DBCC results for 'AdminSub'.
There are 49 rows in 1 pages for object 'AdminSub'.
DBCC results for 'apuserregions'.
There are 9 rows in 1 pages for object 'apuserregions'.
DBCC results for 'OrderDetails'.
There are 552 rows in 8 pages for object 'OrderDetails'.
DBCC results for 'branch_conversion_lookup'.
There are 255 rows in 3 pages for object 'branch_conversion_lookup'.
DBCC results for 'CommodityMapping$'.
There are 188 rows in 2 pages for object 'CommodityMapping$'.
DBCC results for 'UOM_Mapping$'.
There are 520 rows in 5 pages for object 'UOM_Mapping$'.
DBCC results for 'tblLocations'.
There are 480 rows in 30 pages for object 'tblLocations'.
DBCC results for 'epicor_fix_log'.
There are 7096 rows in 87 pages for object 'epicor_fix_log'.
DBCC results for 'EmailLog'.
There are 66825 rows in 1022 pages for object 'EmailLog'.
DBCC results for 'EMAILLOG_ERR'.
There are 4047 rows in 22 pages for object 'EMAILLOG_ERR'.
DBCC results for 'Results'.
There are 46 rows in 1 pages for object 'Results'.
DBCC results for 'FaxQueue'.
Msg 8928, Level 16, State 1, Line 2
Object ID 1028198713, index ID 0: Page (1:59099) could not be processed. See other errors for details.
        The error has been repaired.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 1028198713, index ID 1. Page (1:59099) was not seen in the scan although its parent (1:59086) and previous (1:59098) refer to it. Check any previous errors.
        The error has been repaired.
Msg 8978, Level 16, State 1, Line 2
Table error: Object ID 1028198713, index ID 1. Page (1:59100) is missing a reference from previous page (1:59099). Possible chain linkage problem.
        The error has been repaired.
Msg 8928, Level 16, State 1, Line 2
Object ID 1028198713, index ID 2: Page (1:61491) could not be processed. See other errors for details.
        The error has been repaired.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 1028198713, index ID 2. Page (1:61491) was not seen in the scan although its parent (1:61098) and previous (1:61490) refer to it. Check any previous errors.
        The error has been repaired.
Msg 8978, Level 16, State 1, Line 2
Table error: Object ID 1028198713, index ID 2. Page (1:61492) is missing a reference from previous page (1:61491). Possible chain linkage problem.
        The error has been repaired.
Repair: Page (1:59099) has been deallocated from object ID 1028198713, index ID 0.
Clustered index successfully restored for object 'dbo.FaxQueue' in database 'POSYS2'.
Repair: Page (1:61491) has been deallocated from object ID 1028198713, index ID 2.
There are 124354 rows in 2128 pages for object 'FaxQueue'.
CHECKDB found 0 allocation errors and 6 consistency errors in table 'FaxQueue' (object ID 1028198713).
CHECKDB fixed 0 allocation errors and 6 consistency errors in table 'FaxQueue' (object ID 1028198713).
Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 1065025536, index ID 48, page ID (1:59099). The PageId in the page header = (0:0).
        The error has been repaired.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1065025536)' (object ID 1065025536).
CHECKDB fixed 0 allocation errors and 1 consistency errors in table '(Object ID 1065025536)' (object ID 1065025536).
DBCC results for 'AdminLinks'.
There are 29 rows in 1 pages for object 'AdminLinks'.
DBCC results for '355_codes'.
There are 794 rows in 6 pages for object '355_codes'.
DBCC results for 'SpecialRQ'.
There are 8574 rows in 366 pages for object 'SpecialRQ'.
DBCC results for 'SpecialRQitem'.
There are 16027 rows in 153 pages for object 'SpecialRQitem'.
DBCC results for 'zbudgetDTS'.
There are 311 rows in 6 pages for object 'zbudgetDTS'.
DBCC results for 'BudgetSpent'.
There are 1230 rows in 26 pages for object 'BudgetSpent'.
DBCC results for 'OMaxLinks'.
There are 12859 rows in 154 pages for object 'OMaxLinks'.
DBCC results for 'BudgetHist'.
There are 68007 rows in 1060 pages for object 'BudgetHist'.
DBCC results for 'Force_PO_Approval'.
There are 107 rows in 1 pages for object 'Force_PO_Approval'.
DBCC results for 'cartD'.
There are 0 rows in 0 pages for object 'cartD'.
DBCC results for 'budget'.
There are 370 rows in 7 pages for object 'budget'.
DBCC results for 'cartSR'.
There are 25 rows in 1 pages for object 'cartSR'.
DBCC results for 'temp_specOrderDetail'.
There are 0 rows in 0 pages for object 'temp_specOrderDetail'.
DBCC results for 'Users'.
There are 830 rows in 11 pages for object 'Users'.
DBCC results for 'xcart_rest'.
There are 3770 rows in 42 pages for object 'xcart_rest'.
DBCC results for 'UserAccess'.
There are 3477 rows in 19 pages for object 'UserAccess'.
DBCC results for 'SpecOrderLog'.
There are 0 rows in 0 pages for object 'SpecOrderLog'.
DBCC results for 'cart'.
There are 3755 rows in 46 pages for object 'cart'.
DBCC results for 'AuditFaxqueueDateSent'.
There are 1143 rows in 8 pages for object 'AuditFaxqueueDateSent'.
DBCC results for 'SpecOrderDetail'.
There are 0 rows in 0 pages for object 'SpecOrderDetail'.
DBCC results for 'InvComCode'.
There are 267 rows in 2 pages for object 'InvComCode'.
DBCC results for 'PrintingSpec'.
There are 5 rows in 1 pages for object 'PrintingSpec'.
DBCC results for 'NeedUpdate'.
There are 2819 rows in 7 pages for object 'NeedUpdate'.
DBCC results for 'FaxQueue20060920'.
Msg 8928, Level 16, State 1, Line 2
Object ID 1556200594, index ID 0: Page (1:13875) could not be processed. See other errors for details.
        The error has been repaired.
Repair: Page (1:13875) has been deallocated from object ID 1556200594, index ID 0.
There are 59574 rows in 987 pages for object 'FaxQueue20060920'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'FaxQueue20060920' (object ID 1556200594).
CHECKDB fixed 0 allocation errors and 1 consistency errors in table 'FaxQueue20060920' (object ID 1556200594).
DBCC results for 'ToCancel'.
There are 0 rows in 0 pages for object 'ToCancel'.
DBCC results for 'InvSubCategories'.
There are 574 rows in 6 pages for object 'InvSubCategories'.
DBCC results for 'TransferLog'.
There are 12766 rows in 129 pages for object 'TransferLog'.
DBCC results for 'APBranch_home_changes'.
There are 48 rows in 1 pages for object 'APBranch_home_changes'.
DBCC results for 'fixed_matches_bnow'.
There are 429 rows in 1 pages for object 'fixed_matches_bnow'.
DBCC results for 'FaxQueueError'.
There are 64952 rows in 929 pages for object 'FaxQueueError'.
DBCC results for 'tblMarkets'.
There are 28 rows in 1 pages for object 'tblMarkets'.
DBCC results for 'vendor_codes_xref'.
There are 134 rows in 3 pages for object 'vendor_codes_xref'.
DBCC results for 'WebErrorLog'.
There are 0 rows in 0 pages for object 'WebErrorLog'.
DBCC results for 'TempHouAuBranches'.
There are 64 rows in 1 pages for object 'TempHouAuBranches'.
DBCC results for 'Sheet1$'.
There are 5 rows in 2 pages for object 'Sheet1$'.
DBCC results for 'zPrintingItems'.
There are 222 rows in 7 pages for object 'zPrintingItems'.
DBCC results for 'FaxStats'.
There are 13219 rows in 173 pages for object 'FaxStats'.
DBCC results for 'Subcat List$'.
There are 22 rows in 2 pages for object 'Subcat List$'.
DBCC results for 'FaxQueueWrk'.
There are 0 rows in 0 pages for object 'FaxQueueWrk'.
DBCC results for 'InternalComm'.
There are 69025 rows in 794 pages for object 'InternalComm'.
DBCC results for 'invNew'.
There are 16735 rows in 264 pages for object 'invNew'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'invNew2'.
There are 908 rows in 13 pages for object 'invNew2'.
CHECKDB found 0 allocation errors and 39 consistency errors in database 'POSYS2'.
CHECKDB fixed 0 allocation errors and 39 consistency errors in database 'POSYS2'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.




0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.