Thanks for your replies.
I removed the user from the sql database using the delete function, disabled automatic enabling, and reran the provisioning task. I still get a lot of errors. There are 33 users with this issue. Each user generates 5 errors (see below) and does not repopulate the database.
Event Type: Error
Event Source: Enterprise Vault
Event Category: Directory Service
Event ID: 13360
Date: 29/09/2011
Time: 7:49:09 AM
User: N/A
Computer: server
Description:
An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: CADODataAccess::ExecuteSQLCommand .\ADODataAccess.cpp [lines {1407,1409,1424,1461}], built Mar 14 10:54:54 2011):
Description:
String or binary data would be truncated.
SQL Command:
INSERT ExchangeMailboxEntry (ExchangeMailboxEntryId, LegacyMbxDN, MbxDisplayName, MbxAlias, MbxNTUser, MbxNTDomain, MbxArchivingState, MbxExchangeState, ExchangeMbxType, MbxWarningLimit, MbxSendLimit, MbxReceiveLimit, MbxSize, MbxItemCount, DefaultVaultId, City, Company, Country, Department, EmployeeType, FirstName, LastName, Office, State, Title, UseQuota, LastModified, PolicyEntryId, PSTPolicyEntryId, PolicyTargetGroupEntryId, PolicyTargetMemberEntryId, ADMbxDN, ExchMbxGUID, MbxStoreIdentity, ADMbxFlags, DesktopPolicyEntryId) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for SQL Server
Number: 0x80040e57
SQL State: 22001
Native Error: 00008152
HRESULT 0x80040e57
For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp
Event Type: Error
Event Source: Enterprise Vault
Event Category: Directory Service
Event ID: 13360
Date: 29/09/2011
Time: 7:49:09 AM
User: N/A
Computer: server
Description:
An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: CADODataAccess::ExecuteSQLCommand .\ADODataAccess.cpp [lines {1407,1409,1424,1461}], built Mar 14 10:54:54 2011):
Description:
The statement has been terminated.
SQL Command:
INSERT ExchangeMailboxEntry (ExchangeMailboxEntryId, LegacyMbxDN, MbxDisplayName, MbxAlias, MbxNTUser, MbxNTDomain, MbxArchivingState, MbxExchangeState, ExchangeMbxType, MbxWarningLimit, MbxSendLimit, MbxReceiveLimit, MbxSize, MbxItemCount, DefaultVaultId, City, Company, Country, Department, EmployeeType, FirstName, LastName, Office, State, Title, UseQuota, LastModified, PolicyEntryId, PSTPolicyEntryId, PolicyTargetGroupEntryId, PolicyTargetMemberEntryId, ADMbxDN, ExchMbxGUID, MbxStoreIdentity, ADMbxFlags, DesktopPolicyEntryId) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Additional Microsoft supplied information:
Source: Microsoft OLE DB Provider for SQL Server
Number: 0x80040e57
SQL State: 01000
Native Error: 00003621
HRESULT 0x80040e57
For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp
Event Type: Error
Event Source: Enterprise Vault
Event Category: Directory Service
Event ID: 8391
Date: 29/09/2011
Time: 7:49:09 AM
User: N/A
Computer: server
Description:
The EnterpriseVault.DirectoryService object reported an error.
Continuing will cancel the connections.
For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp
Event Type: Error
Event Source: Enterprise Vault
Event Category: Exchange Provisioning Task
Event ID: 8390
Date: 29/09/2011
Time: 7:49:09 AM
User: N/A
Computer: server
Description:
The EnterpriseVault.DirectoryConnection object reported an error.
Continuing will cancel the connections.
Internal references:
Error 0x80040e57
CDirectoryConnectionObject::CreateEntry .\DirectoryConnectionObject.cpp [lines {123,149,150,151,165}], built Mar 14 10:55:02 2011
For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp
Event Type: Error
Event Source: Enterprise Vault
Event Category: Exchange Provisioning Task
Event ID: 41111
Date: 29/09/2011
Time: 7:49:09 AM
User: N/A
Computer: server
Description:
The Exchange mailbox provisioning task failed during processing of a mailbox. The task is continuing.
Task: Exchange Provisioning Task for afp.le
User: CN=doe\, John,OU=Nat,OU=Nat1,DC=domain,DC=local
Mailbox: /o=domain/ou=National/cn=Recipients/cn=jdoe
Provisioning group: Whole Exchange Organization
Group member: Whole Exchange Organization
Error: Failed to insert a record:The EnterpriseVault.DirectoryConnection object reported an error.
Continuing will cancel the connections.
For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp
Trace: at KVS.EnterpriseVault.Common.DirEntry.CreateRecord()
at KVS.EnterpriseVault.ExchangePolicySync.ExchangePolicySynchronization.CreateMailboxEntry(UserProperties userProps, PolicyTargetInfo targetInfo, Int32 storeID, String defaultVaultId, String& newMbxEntryId)
at KVS.EnterpriseVault.ExchangePolicySync.ExchangePolicySynchronization.ProcessCreateOrUpdateMailboxEntry(UserProperties userProps, PolicyTargetInfo targetInfo)
at KVS.EnterpriseVault.ExchangePolicySync.ExchangePolicySynchronization.WorkerThreadFunc()
For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp