Problem using dbimpexp for import of one users data, error

All replies

• 

  

  0

  Sign in to vote

  Well the obvious reason would be the case sensitivity.

   

  I found this requirement for the /user: switch quite interesting:

  The user portion of the URI must be exactly the same as the user portion of the SIP URI stored in Active Directory and the host portion of the URI must be entirely in lowercase.

   

  I haven't worked with this command before but perhaps the order of the switches is important? Try using /user: before the /sqlserver switch.

   

  Sincerely,

  Tonino Bruno

   

  Monday, October 20, 2008 7:36 PM
• 

  

  0

  Sign in to vote

  Ok, I will try to change the order of switches.

  What is the host, it the sip-domain right?

   

  I just enter the users sip address after /user:

   

  Example: /user:Firstname.Lastname@domain.com

   

  And off course i enter the user part case sensetive and the domain name in lower case.

   

  /Magnus

   

  Tuesday, October 21, 2008 6:36 AM
• 

  

  0

  Sign in to vote

  Nope, still doesn´t work.

   

  /M

   

  Tuesday, October 21, 2008 10:37 AM
• 

  

  0

  Sign in to vote

  the host-portion would be the sip domain as in @domain.com

   

  Could it be that there is something wrong with your XML file? Perhaps it got corrupted? Do you have permissions to access the file and read it?

   

  I don't have a clue otherwise. I mean if you can find the user in the XML file manually and the user exists in OCS then it should work.

   

  Sincerely,

  Tonino Bruno

  Tuesday, October 21, 2008 5:53 PM
• 

  

  0

  Sign in to vote

  Thanks for reply!

   

  I do the following:

   

  dbimpexp.exe /hrxmlfile:\test3.xml /sqlserverebrosql03\ocs

   

  Look at the xml in IE, no errors.

   

  dbimpexp.exe /import /hrxmlfile:\test3.xml /sqlserverebrosql03\ocs /user:Testuser05@domain.com
  dbVersion: 26
  User Data Schema Version : 21
  Importing Homed Resources into database...
  1 Homed Resource(s) imported.
  Error: The specified user was not found in the XML file.

   

  Really strange. The users SIP is in the xml file. Tested this on an std server i test environment too

  ,same issue. 

   

  Can anyone please test this, it´s a really fast test.

   

  /Magnus

  Wednesday, October 22, 2008 11:06 AM
• 

  

  0

  Sign in to vote

  Haha... Just noticed that the import works fine, but the error always shows up when I select to import one users contact. Sorry for taking up your time

   

  /Magnus 

   

  Wednesday, October 22, 2008 11:33 AM