Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-06-11 : 08:47:40
|
| I have a Integrity Checks Job for DB Maintenance Plan 'Reindexing and shrinking' that failed. I looked at the log. But i can't see any error. Anyone know how to troubleshoot it?p.s. This job has been created by the wizard.EXECUTE master.dbo.xp_sqlmaint N'-PlanID 41A03C18-EA63-49FE-A29B-40EE0D681017 -Rpt "D:\Program Files\Microsoft SQL Server\MSSQL\LOG\Reindexing and shrinking2.txt" -DelTxtRpt 2WEEKS -WriteHistory -CkDB '=============================http://www.sqlserverstudy.com |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-11 : 09:21:13
|
| Don't use maintenance plans?Has the plan failed or is it the calling of the plan that has problems.Try running the tasks manually and see if they work.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-06-11 : 10:11:32
|
| (71 row(s) affected)Server: Msg 22029, Level 16, State 1, Line 0sqlmaint.exe failed.=============================http://www.sqlserverstudy.com |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-11 : 11:15:53
|
| Have you looked at job history, sql server log and windows event logs.Think you can set the plan to log progress.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-06-11 : 12:05:00
|
| You need to enable the report file for this job and also check the job history to see if that will shed some light on why the job failed. the integrity check steps can fail because you actually have data corruption. you need to run a DBCC CHECKDB on all your databases to make sure that that is not the case.The optimization steps can fail for many reasons, most of the time this is because sqlmaint is buggy. indexed views and computed columns give sqlmaint problems. try changing out your sqlmaint jobs for the replacement jobs Tara has created (check her weblog).ec |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-06-11 : 13:30:21
|
| [3] Database dcovel_db: Check Data and Index Linkage...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 2537: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764328), row 7. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9. The following errors were found:[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764328), row 7. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764328), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764329), row 3. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764330), row 54. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764332), row 117. Record check (Valid SqlVariant) failed. Values are 6 and 0.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764333), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764335), row 32. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764337), row 45. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764338), row 126. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764341), row 90. Record check (Valid SqlVariant) failed. Values are 6 and 0.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764343), row 9. Record check (Valid SqlVariant) failed. Values are 6 and 0.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764343), row 94. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764344), row 19. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764344), row 80. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764345), row 24. Record check (Valid SqlVariant) failed. Values are 6 and 0.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764345), row 109. Record check (Valid SqlVariant) failed. Values are 6 and 0.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764346), row 77. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764347), row 14. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764347), row 14. Record check (Valid SqlVariant) failed. Values are 6 and 0.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764347), row 48. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 488705317, index ID 0, page (1:4764347), row 48. Record check (Valid SqlVariant) failed. Values are 6 and 0.[Microsoft][ODBC SQL Server Driver][SQL Server]Too many errors found (201) for object ID 488705317. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS".[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 58422 consistency errors in table 'CLAIMS_AUDIT_TRAIL' (object ID 488705317).[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 58422 consistency errors in database 'dyacovel_db'.[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (dyacovel_db ). ** Execution Time: 0 hrs, 9 mins, 47 secs **=============================http://www.sqlserverstudy.com |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-12 : 11:23:32
|
| Did you run 'dbcc checkdb' manually to double check? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
|
|
Maintenance job failed