Is your server running slowly? Check with SolarWinds ipMonitor.
Get your free evaluation copy of ipMonitor
here
IPAM will assist
you in managing IP addresses.
To let you into a secret, this utilities is fun to use, even if you
don't have a pressing need to calculate your IP address space.
Get a free evaluation copy of
Orion IPAM
Examples of CSVDE Error MessagesThe purpose of this page is to give you examples of CSVDE error
messages.
Problems can arise with the spreadsheet, or with syntax of the CSVDE command. As ever look at the very error message for a clue whether to start at Excel, CMD or Active Directory.
CSVDE -k switch If the error persists or is not serious, try CSVDE -k. Here
are the errors that it ignores: "Object already exists," "Constraint violation," and "Attribute or value already exists."
When you
try a CSVDE import and you get "Add error on line 2:" the hidden meaning is that there maybe something wrong with every object that you are importing. Whereas, if you get an error on line 15 the
nuance is that the first 14 lines were processed correctly, therefore there is something specifically wrong with line 15. Have you typed the
name correctly? For example, are you in the correct folder? Solution try the DIR command. Follow up by trying a different filename.
Probably a blank Column in your spreadsheet. Check Row one for
missing LDAP values or no LDAP values. For example, Column F = sn, Column G= (blank), Column H= phone.
You are probably trying CSVDE from an XP machine. The solution is to add -s servername.
Guy Recommends: SolarWinds Engineer's Toolset v10
The Engineer's Toolset v10 provides a
comprehensive console of utilities for troubleshooting computer problems. Guy says
it helps me monitor what's occurring on the network, and the tools
teaches me more about how the system literally operates.
There are so many good gadgets, it's like having free rein of a
sweetshop. Thankfully the utilities are displayed logically: monitoring, discovery, diagnostic, and Cisco tools.
Download your copy of the Engineer's Toolset v 10
The Parameter is incorrect - In my experience, this caused by an error in the DN or
possibly sAMAccountName. Check Active Directory Users and Computers. In
particular, check the DN attribute, make sure that the OU exists. For example, CN=Jon Morris,OU=Cowbridge,dc=cp,dc=com. Is there really a Cowbridge OU? I got this error when I made a mistake with CN=Users. So, if you create objects in the default container it's CN=USERS not OU=USERS. Check Active Directory Users and Computers,
if necessary try running Find against the CN= Guy Thomas, or the sAMAccountName cn = guyt. What has happened is that you are running the script for the second time and the users already exist.
For example, the cn must be unique to the OU.
The DN must be unique. Also the RDN must be unique in the OU. For example, you cannot have two Guy Thomas accounts in the Newport OU. However, you could have a Guy Thomas in Newport and
another Guy Thomas in the Cowbridge OU. The server side error is "Unable to update the password." The value provided
for the new password does not meet the length, complexity, or history requirement of the domain." Solution change userAccountControl to be = 514.
 If this change does not cure the problem, then launch Active Directory Users and
Computers, and adjust the Default Domain Group Policy, Password Policy and disable Password Complexity and set minimum password length to zero. A referral was returned from the server. In this example check the spelling of your dc=xyz, dc=com. When you run CSVDE -i, the syntax of DN in the spreadsheet was
wrong. See if the DN column needs an extra dc= element. For example,
CN=Jon Morris,OU=Newport,dc=cp
CN=Jon Morris,OU=Newport,dc=cp,dc=com For me, this error was caused by a CSVDE import with an incorrect
sAMAccountName. Instead of plain guyt, the spreadsheet had an extra cn, for example: cn=guyt.
Note if you do not see a solution to your problem try troubleshooting CSVDE here.
There is a clue in the CSVDE error message, observer the phrase 'DN syntax'. When I ran CSVDE there was a mistake in the DN column. I had foolishly added an extra comma at
the beginning. For example:
,cn=Jamie Dun,OU=Newport,DC=cp,dc=com. Instead of plain
cn=Jamie Dun,OU=Newport,DC=cp,dc=com. Your trying to add an LDAP property with a CSVDE import, however the property itself unsuitable. For example the user object does not have a location attribute. (Whereas a printer does
have the location attribute). So if you try and add LDAP properties that do not exist are not supported, this is the error message that you get.
I once had this error when I omitted a bracket in a -r filter.
When you troubleshoot CSVDE, pay close attention to the precise error message. Once you have the error text then search my site
for examples.
See Also
|
Save
hours of frustration and buy Guy's eBook. The extra features include:
detailed instructions on how to import and export user accounts, ten new pages
of worked CSVDE examples.