01-18-2013 08:51 AM - edited 03-19-2019 06:08 AM
Hi been asked to produce a report by one of our customers which from searching the Web I should be able to get from using User Data Dump or Subscriber information dump.
I have installed both on a Windows XP SP3 machine with the IBM drivers.
When I try to run Subscriber Information Dump it says I can't run it on this version of Windows
While with User Data Dump is gives System error 27001
Which is either wrong username or password. Having checked through all the trouble shooting and what needs to be done for it to work I am sure that I am using the right username and password with the right permissions and right services running.
Anyone got any ideas of where I can look or try to get this one resolved?
Thanks
Rick
01-18-2013 08:55 AM
Subscriber Information Dump is for Unity and it needs to run on the Unity box itself (Windows based) - so presumably you're trying to run that on another client box which is what it's complaining about there - expected behavior.
User Data Dump is for attaching to a remote Connection server, that's the guy you want. The help file has a section on troubleshooting remote connection that goes through common issues - making sure the port is not blocked by a firewall, making sure the ODBC proxy is turned on and running, ensuring your account with remote access configured does not have their password set to reset at next login and a few other common issues to look for.
01-21-2013 03:52 AM
Explains why I could not get subscriber to work, I have checked all that on User Data Dump and it is still not working.
I have been trying from an XP workstation, do I need to try it from an actual Windows Server?
Thanks
Rick
01-21-2013 06:07 AM
Hi Rick,
You should be just fine running CUDD from an XP workstation
Did you go through these steps
For installations of 7.0(1) and later you need to use the database proxy service for access to the database from off box for any DB tool including User Data Dump.
Out of the box the database proxy service is not running and if you try to start the service it will shut down right away. First you need to set the “Database Proxy: Service Shutdown Timer” value found in the System Settings -> Advanced -> Connection Administration section of the Cisco Unity Connection Administration page. By default this is 0. You can set it to as high as 999 days if you like. After the number of days configured here the remote database proxy service will shut down. This is useful if you want to do some migration work, for instance, and don’t want to forget to have the service disabled for security reasons.
NOTE: If you restart the server, the remote database proxy service will remain shut off. After a system restart you have to go in and manually turn on the service again (see step 3)
Once you’ve started the proxy service you can connect with any tool that needs off box database access using the user name, web administration password and port “20532”.
NOTE: The service will automatically shut down after the number of days configured in step 2 above or if you restart the server.
When you first start User Data Dump, you will see a login dialog box that will be empty except for port 20532 filled in as the default for the port. You must provide the server name or IP address for the “Server” field and provide the login and password for the database connection account. Use the alias and web administration password of the database user created above for the login and password fields.
User Data Dump will remember your entries including the password (which is stored in a secure hash). Each time you run User Data Dump it will load the settings of the last connection you made. Every server you’ve successfully connected to in the past will be listed in the drop down list in the order in which you connected to it last – most recent to least recent.
NOTE: The login and password information is stored along with the local Windows login name. Only those servers that have been attached to successfully using the current Windows login will be listed. If you are logging into the same Windows server with different users you will only see servers connected to with that particular Windows login.
NOTE: Providing the wrong password or login will fail quickly and give you a chance to try a different pair. Providing an incorrect server or port, however, results in a 60 second timeout while UDD waits for the Informix driver to return. Unfortunately this cannot be shorted. Type carefully.
http://www.ciscounitytools.com/Applications/CxN/UserDataDump/Help/UserDataDump.htm#_Toc320093148
Cheers!
Rob
"Spend your life waiting,
for a moment that just don't come,
Well, don't waste your time waiting"
-Springsteen
01-21-2013 08:26 AM
Hi Rob,
The above is what I followed when we set up User Dump, however it still refuses to work.
I am thinking that I have missed something in the setting up of the Informix drivers, but am at a lost to see what is wrong with the setup of the drivers
Thanks
Rick
01-22-2013 03:56 AM
I have now gone back to trying to use cudli first, when I run it I get the following:
Any ideas what I have done wrong?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide