Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

2,153 views
Skip to first unread message

Sam

unread,
May 25, 2005, 9:41:28 PM5/25/05
to

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


Dmitri Gavrilov [MSFT]

unread,
May 25, 2005, 9:50:19 PM5/25/05
to
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:%2340WKQZ...@TK2MSFTNGP12.phx.gbl...

Sam

unread,
May 25, 2005, 10:50:25 PM5/25/05
to
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]" <dmi...@online.microsoft.com> wrote in message
news:eIlYGVZY...@TK2MSFTNGP14.phx.gbl...

Sam

unread,
May 29, 2005, 7:41:21 PM5/29/05
to
Dear Dmitri,

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

Best regars,

Sam


"Sam" <s...@estella.com> wrote in message

news:%233wUx2Z...@TK2MSFTNGP15.phx.gbl...

kcaselman

unread,
Jul 7, 2009, 11:21:57 AM7/7/09
to

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

0 new messages