Unity 7.0.2 - Cobra import error - SQL conversion & No DirectoryID for user found in VM database -

Unanswered Question
Nov 23rd, 2009
User Badges:

Hi,


I have a little problem with Unity and Cobra...


I have an Active directory & Exchange 2003 link with a Unity 5.x  I have run a Cobra export on 3 users to import that on a new Unity 7.0.2 with a new AD and new Exchange 08.


I have some error in cobra during the import, this cause some problem.  After the import I can list the new subscribers, but if I click on them I can't access their configuration.  ( there is no error in the eventvwr log of windows during SQL /Ad sync )


here is the error during the cobra import


No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete




9 6:25:07 PM:         Restoring alternate contact rule
11/20/2009 6:25:07 PM: (error) -2147217913 ([Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors des limites des valeurs de date et d'heure.) in procedure RestoreContactRule of Form frmImportObjects
11/20/2009 6:25:07 PM:         Restoring standard contact rule
11/20/2009 6:25:07 PM: (error) -2147217913 ([Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors des limites des valeurs de date et d'heure.) in procedure RestoreContactRule of Form frmImportObjects
11/20/2009 6:25:07 PM:         Restoring off hours contact rule
11/20/2009 6:25:07 PM: (error) -2147217913 ([Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors des limites des valeurs de date et d'heure.) in procedure RestoreContactRule of Form frmImportObjects


11/20/2009 6:25:07 PM: (error) -2147217913 ([Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors des limites des valeurs de date et d'heure.) in procedure RestoreContactRule of Form frmImportObjects
11/20/2009 6:25:07 PM:         Restoring standard contact rule
11/20/2009 6:25:07 PM: (error) -2147217913 ([Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors des limites des valeurs de date et d'heure.) in procedure RestoreContactRule of Form frmImportObjects
11/20/2009 6:25:07 PM:         Restoring off hours contact rule
11/20/2009 6:25:07 PM: (error) -2147217913 ([Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors des limites des valeurs de date et d'heure.) in procedure RestoreContactRule of Form frmImportObjects
11/20/2009 6:25:07 PM:         Restoring 1 key menu entry
11/20/2009 6:25:07 PM:         Restoring 2 key menu entry
11/20/2009 6:25:07 PM:         Restoring 3 key menu entry
11/20/2009 6:25:07 PM:         Restoring 4 key menu entry
11/20/2009 6:25:07 PM:         Restoring 5 key menu entry
11/20/2009 6:25:07 PM:         Restoring 6 key menu entry
11/20/2009 6:25:07 PM:         Restoring 7 key menu entry
11/20/2009 6:25:07 PM:         Restoring 8 key menu entry
11/20/2009 6:25:07 PM:         Restoring 9 key menu entry
11/20/2009 6:25:07 PM:         Restoring 0 key menu entry
11/20/2009 6:25:07 PM:         Restoring # key menu entry
11/20/2009 6:25:07 PM:         Restoring * key menu entry
11/20/2009 6:25:07 PM:         Restoring alternate messaging rule
11/20/2009 6:25:07 PM:     No greeting recorded for this messaging rule
11/20/2009 6:25:07 PM:         Restoring standard messaging rule
11/20/2009 6:25:07 PM:     Greeting file restored to:d:\unity_bin\Stream Files\mathisandre.lachance_Greeting_Standard_{75F88070-0156-4E8F-9765-B865FB0B91F0}.wav
11/20/2009 6:25:07 PM:         Restoring error messaging rule
11/20/2009 6:25:07 PM:     No greeting recorded for this messaging rule
11/20/2009 6:25:08 PM:         Restoring busy messaging rule
11/20/2009 6:25:08 PM:     No greeting recorded for this messaging rule
11/20/2009 6:25:08 PM:         Restoring off hours messaging rule
11/20/2009 6:25:08 PM:         Restoring internal messaging rule
11/20/2009 6:25:08 PM:     Restoring alternate extensions for subscriber with alias=mathisandre.lachance
11/20/2009 6:25:08 PM:         No alternate extensions found for this subscriber.
11/20/2009 6:25:08 PM:     Restoring MWI devices for subscriber with alias=mathisandre.lachance
11/20/2009 6:25:08 PM:         Adding MWI=X
11/20/2009 6:25:08 PM:         Modifying existing MWI device=X
11/20/2009 6:25:08 PM:     Restoring active notification devices for subscriber with alias=mathisandre.lachance
11/20/2009 6:25:08 PM:     No active notification devices found for this subscriber in the backup.
11/20/2009 6:25:08 PM:     Subscriber updates complete, requesting directory sync
11/20/2009 6:25:08 PM: (error) -2147217913 ([Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors des limites des valeurs de date et d'heure.) in procedure RequestSync of Module Module1
11/20/2009 6:25:08 PM: **** Second Pass Interview Handler Creation Start ****              The conversion of the type of data of a CHAR in type DATETIME give a value that cross the limit of the value of the date and hour. 
11/20/2009 6:25:08 PM:     No interview handlers selected for restore
11/20/2009 6:25:08 PM: **** Second Pass Distribution List Creation Start ****
11/20/2009 6:25:08 PM:     No distribution lists selected for restore that need to have subscribers added
11/20/2009 6:25:08 PM: **** Restoring Routing Rules ****
11/20/2009 6:25:08 PM:         No routing rules selected for restore.
11/20/2009 6:25:08 PM: **** Message Restoration ****
11/20/2009 6:25:08 PM:     [1 of 3] lucas.saintpierre, {275E8A15-40EF-432C-9805-6D1DB17FF5B4}
11/20/2009 6:25:08 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:25:38 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:26:08 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:26:38 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:27:08 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:27:38 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:28:08 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:28:38 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:29:08 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:29:38 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete
11/20/2009 6:30:08 PM:         No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete




for this error :

]La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors des limites des valeurs de date et d'heure.) in procedure RequestSync of Module Module1

Traduction :

The conversion of a char data type to DATETIME has a value beyond the limits of date values and time.) RequestSync in procedure of Module Module1



this is the problem for each users..

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
lindborg Mon, 11/23/2009 - 14:19
User Badges:
  • Cisco Employee,

the DirectoryId issue is outside of COBRAS power to do anything about - if there's no directory Id being put into the database by the SQLSyncSvr process than any tool that uses it (DiRT, GSM, COBRAS, BulkDelete etc...) cannot act on the user - that means they are not propelry/fully created in AD.  so you will need to solve that problem seperately (almost always a permissions/configuration issue in Unity - the tools have no bearing on this and never, ever connect directly to AD for any operation - it's all done through Unity services).  Always start by looking in the SQLSyncSvrxxx log found in the commserver logs folder - SQLSyncSvr never logs errors in the event log so far as I know.


The other errors there look like time/date format issues - I'm guessing based on the text of the output that the locale is causing issues - if you want to send the backup MDB file to me (no messages, just the directory backup MDB file) I can run some tests in house - I'll need to know details about what you're restoring to (version and locales installed) and I can test it in debug mode in the lab here to see if I can run that down at any rate.


you can ping me off line at lindborg at cisco dot com.

lindborg Mon, 11/23/2009 - 15:10
User Badges:
  • Cisco Employee,

oh and I just noticed your new configuration is Exchange 2008 - I'm guessing the problem is these users were not already created wth mailboxes in your directory prior to import, correct?  Unity cannot create new users and/or new mailboxes on the fly in 2008 - they have to exist already.  COBRAS uses the Unity services so must stick to the same restrictions, of course.  So if during import you were "creating new" subscribers then what your seeing with respect to the directory Id not being generated is expected behavior.


Again, COBRAS never connects to AD and does not know which version of Exchange you're running against necessarily and will happily let you do whatever you want - with 2008 though you can't create new users, it just wont fly.


I'm going through an import with your databse now on a Exchange 2003 system with US English and US locale - I did find one issue with interview handlers on the conflict resolution page which I'll fix but other than that the import ran clean (1 warning about a missing admin link which is probably correct).


I'll run again with different locale's forced on my dev box to see if I can repro the time/date stamp issues.

philippe.cousineau Mon, 11/23/2009 - 17:58
User Badges:

thanks a lot for the quick answer !!


Actually in the import wizzard I check "create new" but the user was allready create in the new AD with the new exchange mail box.

phillips.chris Thu, 03/25/2010 - 00:56
User Badges:

Jeff, knows COBRAS far better than I... but I did encounter this exact same error


"No DirectoryID for user found in VM database - waiting 30 seconds for sync to complete"


It showed up on a very small sub-set of my users on a 2700+ user Unity 4 -> 7 Migration with COBRAS in a very complex AD where Unity had permissions on only a very limited sub-set of the User OU's. They had been created in Exchange 07, prior to the integration, and their mailboxes were in every other way fully functional.

It turned out that the 5 or so users I was getting this error on existed in OU's that Unity had not been granted permissions to and the solution was to either move them to an OU Unity could access, or to add that OU to the list and re-run the Permissions Wizard.


Good Luck!

Liz Bentler Mon, 05/24/2010 - 13:01
User Badges:

We are essentially using Cobras to perform the exact same migration and Chris is correct.  Make sure you run permissions wizard or check to make sure Unity has permissions to all message stores impacted by your user changes.  When this happened to us initially we had to delete those users and add them again.  If you have problems accessing the users via the subscriber page use bulk edit to locate and delete the user(s) in question. Hope this helps

Actions

This Discussion