Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data row does not have a matching index row in index

Dear All,

While checking Database Consistency, i m getting following error.

Please Advice

reagrds,

Hiten.

_______________________________________________________________________________________

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)

Apr 14 2006 01:12:25

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Msg 8951, Sev 16, State 1, Line 17 : Table error: Table 'fsg.JEST' (ID 451949132). Data row does not have a matching index row in index 'JEST~I' (ID 2). Possible missing or invalid keys for the index row matching: [SQLSTATE 42000]

Msg 8955, Sev 16, State 1, Line 17 : Data row (3:3447709:85) identified by (MANDT = '009' and OBJNR = 'OR015000015467' and STAT = 'I0010') with index values (MANDT = '009' and STAT = 'I0010' and INACT = ' ' and OBJNR = 'OR015000015467'). [SQLSTATE 42000]

Msg 8951, Sev 16, State 1, Line 17 : Table error: Table 'fsg.JEST' (ID 451949132). Data row does not have a matching index row in index 'JEST~I' (ID 2). Possible missing or invalid keys for the index row matching: [SQLSTATE 42000]

Msg 8955, Sev 16, State 1, Line 17 : Data row (4:3526223:65) identified by (MANDT = '009' and OBJNR = 'OV000005347300000001' and STAT = 'I0010') with index values (MANDT = '009' and STAT = 'I0010' and INACT = ' ' and OBJNR = 'OV000005347300000001'). [SQLSTATE 42000]

Msg 8951, Sev 16, State 1, Line 17 : Table error: Table 'fsg.JEST' (ID 451949132). Data row does not have a matching index row in index 'JEST~I' (ID 2). Possible missing or invalid keys for the index row matching: [SQLSTATE 42000]

Msg 8955, Sev 16, State 1, Line 17 : Data row (4:3526223:66) identified by (MANDT = '009' and OBJNR = 'OV000005347300000001' and STAT = 'I0052') with index values (MANDT = '009' and STAT = 'I0052' and INACT = ' ' and OBJNR = 'OV000005347300000001'). [SQLSTATE 42000]

Msg 8951, Sev 16, State 1, Line 17 : Table error: Table 'fsg.S022' (ID 1022587377). Data row does not have a matching index row in index 'S022~A' (ID 2). Possible missing or invalid keys for the index row matching: [SQLSTATE 42000]

Msg 8990, Sev 16, State 1, Line 17 : CHECKDB found 0 allocation errors and 3 consistency errors in table 'fsg.JEST' (object ID 451949132). [SQLSTATE 01000]

Msg 8955, Sev 16, State 1, Line 17 : Data row (3:3369530:8) identified by (MANDT = '009' and SSOUR = ' ' and VRSIO = '000' and SPMON = '000000' and SPTAG = '20080913' and SPWOC = '000000' and SPBUP = '000000' and WERKS = '7100' and ARBPL = 'METALST4' and KAPAR = '003' and MATNR = 'JGR0500236G0WL8JH' and AUFNR = '015000015467' and PLNUM = '00000000' and POSNR = '0001' and PLNFL = '000000' and VORNR = '0020') with index values (MANDT = '009' and SSOUR = ' ' and VRSIO = '000' and WERKS = '7100' and ARBPL = 'MMsg 8951, Sev 16, State 1, Line 17 : Table error: Table 'fsg.AFRU' (ID 1166000397). Data row does not have a matching index row in index 'AFRU~ZA1' (ID 31). Possible missing or invalid keys for the index row matching: [SQLSTATE 42000]

Msg 8955, Sev 16, State 1, Line 17 : Data row (3:3409400:2) identified by (MANDT = '009' and RUECK = '0000223395' and RMZHL = '00000001') with index values (MANDT = '009' and BUDAT = '20080913' and ARBID = '10000042' and AUFPL = '0000053473' and AUFNR = '015000015467' and STOKZ = ' ' and STZHL = '00000000' and RUECK = '0000223395' and RMZHL = '00000001'). [SQLSTATE 42000]

Msg 8990, Sev 16, State 1, Line 17 : CHECKDB found 0 allocation errors and 1 consistency errors in table 'fsg.S022' (object ID 1022587377). [SQLSTATE 01000]

Msg 8990, Sev 16, State 1, Line 17 : CHECKDB found 0 allocation errors and 1 consistency errors in table 'fsg.AFRU' (object ID 1166000397). [SQLSTATE 01000]

Msg 8989, Sev 16, State 1, Line 17 : CHECKDB found 0 allocation errors and 5 consistency errors in database 'FSG'. [SQLSTATE 01000]

Msg 8958, Sev 16, State 1, Line 17 : repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (FSG). [SQLSTATE 01000]

Job 'SAP CCMS Check Database FSG [20080802184156]' : Step 1, 'Step1' : Began Executing 2008-09-16 03:00:39

DBCC CHECKDB (FSG) started at Sep 16 2008 3:00AM with Logfile: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\CCMS_CHECK_DB_HIST_2008.txt [SQLSTATE 01000]

Former Member
Not what you were looking for? View more on this topic or Ask a question