Actvie Directory Database Corruption >Event ID 467 > Index of table datatable is corrupted

microsoft.public.windows.server.active_directory

26 May 2005 1:41 AM

Sam

Dear All,

We are asking for help with our Windows 2003 Small Business Server with
Active Directory database problem.

We have an Active Directory Database Corruption Error coming up as Event ID
= 467 in the Event Viewer Log :

Category : Database Corruption
Event ID : 467

Description :
NTDS [696] NTDSA : Index INDEX_00020078 of table datatable is corrupted [0]

-----------------------------------------

We have tried the following method but it did not work :

1) Boot into Active Directory Restore Mode

2) Run ntdsutil.exe from a command prompt

3) > File > integrity

4) After integrity check, the screens shows that :

Database is CORRUPTED.
Operation terminated with error -1206 ( JET_errDatabaseCorrupted, Non
database file or corrupted db)
Spawned Process Exit code 0xfffffb4a(-1206)

5) We tried to run " ntdsutil > file > recover "
The screen said :

Operation completed successfully in 1.2 seconds.
Spawned Process Exit code 0x0(0)

6) When we run 'integrity' again, result is still the same as above in 4).

7) We tried to run "repair" (as recommended by some literature), but NO such
a command exists under the menu inside : ntdsutil > file

8) We then run > ntdsutil > semantic database analysis, with screen as
follows:

> semantic checker : verbose on

Verbose mode enabled
semantic checker:go
Fixup mode is turned off
Opening database [Current] ... Done
Getting record count... 7333 records
Getting security descriptor count... 163 security descriptors
Writing summary into log file dsdit.dmp.0
SDs scanned: 7333
Processing records..

Error : Inconsistent SD refcounts detected !!!

Done.

-------------------------------------------------

We would like to get help from all the experts whether there are any ways to
fix the Active Directory database corruption problem.

Also we are wondering why the 'repair' option inside ntdsutil.exe does not
seems to exist in out Windows 2003 Small Business server. Could anyone give
some insight into the use of 'repair' command ?

Many Thanks for everyone who could send helps of any kind.

Best regards

Sam Tsui

26 May 2005 1:50 AM

Dmitri Gavrilov [MSFT]

Do an offline defrag (an option in ntdsutil). That should repair the index.

--
Dmitri Gavrilov
SDE, Active Directory Core

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Show quoteHide quote

"Sam" <s**@estella.com> wrote in message
news:%2340WKQZYFHA.1412@TK2MSFTNGP12.phx.gbl...
>
> Dear All,
>
> We are asking for help with our Windows 2003 Small Business Server with
> Active Directory database problem.
>
> We have an Active Directory Database Corruption Error coming up as Event
> ID
> = 467 in the Event Viewer Log :
>
>
> Category : Database Corruption
> Event ID : 467
>
> Description :
> NTDS [696] NTDSA : Index INDEX_00020078 of table datatable is corrupted
> [0]
>
> -----------------------------------------
>
> We have tried the following method but it did not work :
>
> 1) Boot into Active Directory Restore Mode
>
> 2) Run ntdsutil.exe from a command prompt
>
> 3) > File > integrity
>
> 4) After integrity check, the screens shows that :
>
> Database is CORRUPTED.
> Operation terminated with error -1206 ( JET_errDatabaseCorrupted, Non
> database file or corrupted db)
> Spawned Process Exit code 0xfffffb4a(-1206)
>
>
> 5) We tried to run " ntdsutil > file > recover "
> The screen said :
>
> Operation completed successfully in 1.2 seconds.
> Spawned Process Exit code 0x0(0)
>
> 6) When we run 'integrity' again, result is still the same as above in 4).
>
> 7) We tried to run "repair" (as recommended by some literature), but NO
> such
> a command exists under the menu inside : ntdsutil > file
>
> 8) We then run > ntdsutil > semantic database analysis, with screen as
> follows:
>> semantic checker : verbose on
> Verbose mode enabled
> semantic checker:go
> Fixup mode is turned off
> Opening database [Current] ... Done
> Getting record count... 7333 records
> Getting security descriptor count... 163 security descriptors
> Writing summary into log file dsdit.dmp.0
> SDs scanned: 7333
> Processing records..
>
> Error : Inconsistent SD refcounts detected !!!
>
> Done.
>
> -------------------------------------------------
>
> We would like to get help from all the experts whether there are any ways
> to
> fix the Active Directory database corruption problem.
>
> Also we are wondering why the 'repair' option inside ntdsutil.exe does not
> seems to exist in out Windows 2003 Small Business server. Could anyone
> give
> some insight into the use of 'repair' command ?
>
> Many Thanks for everyone who could send helps of any kind.
>
> Best regards
>
> Sam Tsui
>
>
>
>
>
>

26 May 2005 2:50 AM

Sam

Dear Dmitri,

Thank you very much for your help.
Will try to defrag the acirve directory database offline and let you know
whether this can fix the problem.

Best regards,

Sam Tsui

Show quoteHide quote

"Dmitri Gavrilov [MSFT]" <dmit***@online.microsoft.com> wrote in message
news:eIlYGVZYFHA.2572@TK2MSFTNGP14.phx.gbl...
> Do an offline defrag (an option in ntdsutil). That should repair the
index.
>
> --
> Dmitri Gavrilov
> SDE, Active Directory Core
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "Sam" <s**@estella.com> wrote in message
> news:%2340WKQZYFHA.1412@TK2MSFTNGP12.phx.gbl...
> >
> > Dear All,
> >
> > We are asking for help with our Windows 2003 Small Business Server with
> > Active Directory database problem.
> >
> > We have an Active Directory Database Corruption Error coming up as Event
> > ID
> > = 467 in the Event Viewer Log :
> >
> >
> > Category : Database Corruption
> > Event ID : 467
> >
> > Description :
> > NTDS [696] NTDSA : Index INDEX_00020078 of table datatable is corrupted
> > [0]
> >
> > -----------------------------------------
> >
> > We have tried the following method but it did not work :
> >
> > 1) Boot into Active Directory Restore Mode
> >
> > 2) Run ntdsutil.exe from a command prompt
> >
> > 3) > File > integrity
> >
> > 4) After integrity check, the screens shows that :
> >
> > Database is CORRUPTED.
> > Operation terminated with error -1206 ( JET_errDatabaseCorrupted, Non
> > database file or corrupted db)
> > Spawned Process Exit code 0xfffffb4a(-1206)
> >
> >
> > 5) We tried to run " ntdsutil > file > recover "
> > The screen said :
> >
> > Operation completed successfully in 1.2 seconds.
> > Spawned Process Exit code 0x0(0)
> >
> > 6) When we run 'integrity' again, result is still the same as above in
4).
> >
> > 7) We tried to run "repair" (as recommended by some literature), but NO
> > such
> > a command exists under the menu inside : ntdsutil > file
> >
> > 8) We then run > ntdsutil > semantic database analysis, with screen as
> > follows:
> >> semantic checker : verbose on
> > Verbose mode enabled
> > semantic checker:go
> > Fixup mode is turned off
> > Opening database [Current] ... Done
> > Getting record count... 7333 records
> > Getting security descriptor count... 163 security descriptors
> > Writing summary into log file dsdit.dmp.0
> > SDs scanned: 7333
> > Processing records..
> >
> > Error : Inconsistent SD refcounts detected !!!
> >
> > Done.
> >
> > -------------------------------------------------
> >
> > We would like to get help from all the experts whether there are any
ways
> > to
> > fix the Active Directory database corruption problem.
> >
> > Also we are wondering why the 'repair' option inside ntdsutil.exe does
not
> > seems to exist in out Windows 2003 Small Business server. Could anyone
> > give
> > some insight into the use of 'repair' command ?
> >
> > Many Thanks for everyone who could send helps of any kind.
> >
> > Best regards
> >
> > Sam Tsui
> >
> >
> >
> >
> >
> >
>
>

29 May 2005 11:41 PM

Sam

Dear Dmitri,

Yes you are correct the problem is now solve.
Many thanks for all your helps.

Best regars,

Sam

Show quoteHide quote

"Sam" <s**@estella.com> wrote in message
news:%233wUx2ZYFHA.2128@TK2MSFTNGP15.phx.gbl...
> Dear Dmitri,
>
> Thank you very much for your help.
> Will try to defrag the acirve directory database offline and let you know
> whether this can fix the problem.
>
> Best regards,
>
> Sam Tsui
>
>
>
> "Dmitri Gavrilov [MSFT]" <dmit***@online.microsoft.com> wrote in message
> news:eIlYGVZYFHA.2572@TK2MSFTNGP14.phx.gbl...
> > Do an offline defrag (an option in ntdsutil). That should repair the
> index.
> >
> > --
> > Dmitri Gavrilov
> > SDE, Active Directory Core
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > Use of included script samples are subject to the terms specified at
> > http://www.microsoft.com/info/cpyright.htm
> >
> > "Sam" <s**@estella.com> wrote in message
> > news:%2340WKQZYFHA.1412@TK2MSFTNGP12.phx.gbl...
> > >
> > > Dear All,
> > >
> > > We are asking for help with our Windows 2003 Small Business Server
with
> > > Active Directory database problem.
> > >
> > > We have an Active Directory Database Corruption Error coming up as
Event
> > > ID
> > > = 467 in the Event Viewer Log :
> > >
> > >
> > > Category : Database Corruption
> > > Event ID : 467
> > >
> > > Description :
> > > NTDS [696] NTDSA : Index INDEX_00020078 of table datatable is
corrupted
> > > [0]
> > >
> > > -----------------------------------------
> > >
> > > We have tried the following method but it did not work :
> > >
> > > 1) Boot into Active Directory Restore Mode
> > >
> > > 2) Run ntdsutil.exe from a command prompt
> > >
> > > 3) > File > integrity
> > >
> > > 4) After integrity check, the screens shows that :
> > >
> > > Database is CORRUPTED.
> > > Operation terminated with error -1206 ( JET_errDatabaseCorrupted, Non
> > > database file or corrupted db)
> > > Spawned Process Exit code 0xfffffb4a(-1206)
> > >
> > >
> > > 5) We tried to run " ntdsutil > file > recover "
> > > The screen said :
> > >
> > > Operation completed successfully in 1.2 seconds.
> > > Spawned Process Exit code 0x0(0)
> > >
> > > 6) When we run 'integrity' again, result is still the same as above in
> 4).
> > >
> > > 7) We tried to run "repair" (as recommended by some literature), but
NO
> > > such
> > > a command exists under the menu inside : ntdsutil > file
> > >
> > > 8) We then run > ntdsutil > semantic database analysis, with screen as
> > > follows:
> > >> semantic checker : verbose on
> > > Verbose mode enabled
> > > semantic checker:go
> > > Fixup mode is turned off
> > > Opening database [Current] ... Done
> > > Getting record count... 7333 records
> > > Getting security descriptor count... 163 security descriptors
> > > Writing summary into log file dsdit.dmp.0
> > > SDs scanned: 7333
> > > Processing records..
> > >
> > > Error : Inconsistent SD refcounts detected !!!
> > >
> > > Done.
> > >
> > > -------------------------------------------------
> > >
> > > We would like to get help from all the experts whether there are any
> ways
> > > to
> > > fix the Active Directory database corruption problem.
> > >
> > > Also we are wondering why the 'repair' option inside ntdsutil.exe does
> not
> > > seems to exist in out Windows 2003 Small Business server. Could anyone
> > > give
> > > some insight into the use of 'repair' command ?
> > >
> > > Many Thanks for everyone who could send helps of any kind.
> > >
> > > Best regards
> > >
> > > Sam Tsui
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>

7 Jul 2009 3:21 PM

kcaselman

For those who are having this issue and event ID 476 an offline defrag http://support.microsoft.com/?kbid=232122 fixed our active directory issues when ndtsutil recover and integrity checks did not work. ...be advised running the offline defrag is very dangerous if you don't have another domain controller in your domain. We are still not sure if the derag fixed the corruption, or if deleting the log files which were rolling forward entering corrupt data fixed our issue, but either way it fixed the issue. Keith Caselman SOAPware, Inc. 'www.soapware.com' (http://www.soapware.com) Below is entered for Googlejuice Event Type: Warning Event Source: NTDS KCC Event Category: Knowledge Consistency Checker Event ID: 1014 Date:7/6/2009 Time:5:41:42 PM User:NT AUTHORITY\ANONYMOUS LOGON Computer: xxx Description: The Knowledge Consistency Checker (KCC) failed to update the replication topology for the local domain controller. The KCC will attempt to update the replication topology at the following scheduled interval. KCC update interval: 900 By default, updates occur every 15 minutes. User Action If this continues to occur, restart the local domain controller. Additional Data Error value: 8409 A database error has occurred. Internal ID: f020866 =========================== Event Type: Warning Event Source: NTDS KCC Event Category: Knowledge Consistency Checker Event ID: 1435 Date:7/6/2009 Time:5:41:42 PM User:NT AUTHORITY\ANONYMOUS LOGON Computer: xxx Description: The Knowledge Consistency Checker (KCC) encountered an unexpected error while performing an Active Directory operation. Operation type: KccModifyEntry Object distinguished name: CN=dbfb56fd-e0e5-448f-bfed-98dd2e086875,CN=NTDS Settings,CN=xxx,CN=Servers,CN=Default-First-Site-Name,CN=Sites,CN=Config uration,DC=xxx,DC=com The operation will be retried at the next KCC interval. Additional Data Error value: 5 000020EF: SvcErr: DSID-02080490, problem 5012 (DIR_ERROR), data -1414 Internal ID: f020865 ======================== Event Type: Error Event Source: NTDS ISAM Event Category: Database Corruption Event ID: 467 Date:7/6/2009 Time:5:41:42 PM User:N/A Computer: xxx Description: NTDS (460) NTDSA: Index INDEX_00020078 of table datatable is corrupted (0). ============================ Event Type: Information Event Source: NTDS General Event Category: Service Control Event ID: 1394 Date:7/6/2009 Time:5:37:12 PM User:NT AUTHORITY\ANONYMOUS LOGON Computer: xxx Description: All problems preventing updates to the Active Directory Database have been cleared. New updates to the Active Directory database are succeeding. The Net Logon service has restarted. -- kcaselman ------------------------------------------------------------------------ kcaselman's Profile: http://forums.techarena.in/members/112345.htm View this thread: http://forums.techarena.in/active-directory/183415.htm http://forums.techarena.in