July 3, 2008 at 9:52 am
Having upgraded our MS SQL Server 2000 to MS SQL Server 2005, then running DBCC CHECKDB, we got the following messages in the middle of the log:
"SQLGetDiagRec failed"
Following, we show part of the log
.
.
.
DBCC results for 'PS_PSA_WHERE2_AET'.
DBCC results for 'PS_SPL_VIDRV_TAO4'.
There are 0 rows in 0 pages for object "PS_PSA_WHERE2_AET".
There are 0 rows in 0 pages for object "PS_SPL_VIDRV_TAO4".
DBCC results for 'PS_VRA_STG_T12'.
DBCC results for 'PS_EE_PO1_TMP3'.
There are 0 rows in 0 pages for object "PS_VRA_STG_T12".
SQLGetDiagRec failed
SQLGetDiagRec failed
SQLGetDiagRec failed
SQLGetDiagRec failed
.
.
.
SQLGetDiagRec failed
SQLGetDiagRec failed
DBCC results for 'PS_PC_TIP_STG_WRK'.
There are 11 rows in 1 pages for object "PS_PC_TIP_STG_WRK".
DBCC results for 'PS_CM_CR_LN_TMP9'.
There are 0 rows in 0 pages for object "PS_CM_CR_LN_TMP9".
DBCC results for 'PS_PYCYCL_N04_DATA'.
There are 0 rows in 0 pages for object "PS_PYCYCL_N04_DATA".
DBCC results for 'PS_EXD_DR_AC_TMP26'.
There are 0 rows in 0 pages for object "PS_EXD_DR_AC_TMP26".
DBCC results for 'PS_TAX_LOCATION2'.
There are 0 rows in 0 pages for object "PS_TAX_LOCATION2".
DBCC results for 'PS_IN_FL_LOT_TAO2'.
There are 0 rows in 0 pages for object "PS_IN_FL_LOT_TAO2".
DBCC results for 'PS_OMH_PCST_TAO2'.
There are 0 rows in 0 pages for object "PS_OMH_PCST_TAO2".
DBCC results for 'PS_PO_DF_SID_ITM9'.
There are 0 rows in 0 pages for object "PS_PO_DF_SID_ITM9".
DBCC results for 'PS_PYT_MLT_TAO4'.
There are 0 rows in 0 pages for object "PS_PYT_MLT_TAO4".
DBCC results for 'PS_TRA_ACCTG_TM24'.
There are 0 rows in 0 pages for object "PS_TRA_ACCTG_TM24".
CHECKDB found 0 allocation errors and 0 consistency errors in database
'FIN89INI'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
DBCC CHECKDB
Is there anything wrong? Do we have to check anything else?
Thanks
Gustavo
July 18, 2008 at 7:35 am
What service pack do you have? The following link may provide info on your error. May it help.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply