Autodesk Vault Automated Backups

[Anonymous]

I am trying to make a batch file to automate the vault backups. I am following the directions listed and using the -VU and -VP switches but I keep getting the error. Username and/or password incorrect or I get Unable to use default user name and password.

I'm not sure whats going on here or what username and password this switch is looking for because it's not taking any of the username/passwords entered into the vault users.

[Anonymous]

The VU and VP switches specify the vault user to run the operation under. It
should be a user with the 'administrator' role.

Could you post an example of the your command line and the exact message or
dialog you are seeing? That would help narrow things down.

Thanks,

Paul Gunn


wrote in message news:6336908@discussion.autodesk.com...
I am trying to make a batch file to automate the vault backups. I am
following the directions listed and using the -VU and -VP switches but I
keep getting the error. Username and/or password incorrect or I get Unable
to use default user name and password.

I'm not sure whats going on here or what username and password this switch
is looking for because it's not taking any of the username/passwords entered
into the vault users.

[Anonymous]

This is the CMD Line

"D:\SystemApps\Autodesk\Data Management Server 2008\ADMS Console\Connectivity.ADMSConsole.exe" -Obackup -B\\mw.na.cat.com\spbu_dfs$\ox_grp_shares\ox_Systems\VaultBackup -VUAdministrator -VP(PasswordRemoved) -DBSC -S -LC:\VAULTLOG.txt

This is the LOG returned

2/16/2010 9:20:32 AM ==================================================================
2/16/2010 9:20:32 AM Logging initiated: Core server version 12.1.145.0
2/16/2010 9:20:32 AM ==================================================================
2/16/2010 9:20:32 AM
2/16/2010 9:20:32 AM -Obackup -B"\\mw.na.cat.com\spbu_dfs$\ox_grp_shares\ox_Systems\VaultBackup" -VU[username] -VP[password] -DBSC -S -L"C:\VAULTLOG.txt"
2/16/2010 9:20:32 AM Unable to use default database login. You must specify database username and password. Edited by: leegrisham2500 on Feb 16, 2010 3:26 PM

[Anonymous]

I think you also need to specify the database user and password via the -DBU
and -DBP options. The error in the log indicates that the database admin
(usually "sa") password is not the default.

When running the console interactively, you are prompted for this (if the
defaults don't work) when you invoke a command (such as backup) that needs
administrative privileges in the database.

Dave Mink
Autodesk / Data Management

[Anonymous]

Is there a way to change the sa password then? or add another user with equal rights. I have taken over a system to which I do not know for sure the password to the sa account.

[Anonymous]

Do you have SQL management studio installed? The sa password can be set from
there if you connect as a windows administrator. If you're using sql
express, Microsoft does have a free download of Management Studio for sql
express available [for both sql 2005 and 2008]

You would connect to .\autodeskvault using windows authentication. Then
navigate to Security -> Logins . Getting properties on the sa account there
would allow you to reset the password.

Hope this helps,

Paul

wrote in message news:6337310@discussion.autodesk.com...
Is there a way to change the sa password then? or add another user with
equal rights. I have taken over a system to which I do not know for sure
the password to the sa account.

[Anonymous]

I was able to change the sa password, so now I may be able to run the backups

but today my users are unable to get drawings from the vault, the error says::


Operation failed. System error. Please consult your administrator.
ALSO when checking out items it says
Some items in original selection set are no longer available in Vault. Please refresh and try performing the operation again.

Are these two related? Did my changing the SA password create this error in checking out / looking at drawings in the vault client? This is an urgent issue if we can't use the vault. Edited by: leegrisham2500 on Feb 17, 2010 10:25 PM

[Anonymous]

I can't imagine that would cause the problem - vault doesn't save the sa
password or use it in normal operations at all.

Is there any more information on the error in the server vlogs? They are
usually located at:
C:\Documents and Settings\All Users\Application
Data\Autodesk\VaultServer\FileStore

Paul

[Anonymous]

Hey, I have attached the logs and copy and pasted a few lines from the file into my post.

EDIT: I'm adding some additional information about the server it's running on:

MSSQL 2005 Express
Windows Server 03

I also found this in the knowledge base ID: TS1059334 but I'm not sure how much it applies since my server is running MSSQL2005EXPRESS. I looked through the solution explained and I have very few files in the...\80\ folder but all the files in the ...\90\Shared folder.

2/18/2010 3:05:14 PM mid: 634021023142399224 code: 0 , Connectivity.Core.Exceptions.SysErrCodes.UnspecifiedSystemException System.NullReferenceException: Object reference not set to an instance of an object.
at Connectivity.Web.Services.DocumentService.GetFileAssociationsByIds(Int64[] fileIds, AssociationRelationEnum relation, Boolean recurse, Boolean includeHidden)


2/18/2010 3:05:37 PM mid: 634021023372866499 code: 0 , Connectivity.Core.Exceptions.SysErrCodes.UnspecifiedSystemException System.NullReferenceException: Object reference not set to an instance of an object.
at Connectivity.Web.Services.DocumentService.GetFileAssociationsByIds(Int64[] fileIds, AssociationRelationEnum relation, Boolean recurse, Boolean includeHidden)



2/18/2010 3:05:51 PM mid: 634021023513646848 code: 109 , Connectivity.Core.Exceptions.CoreErrCodes.DatabaseError System.Data.SqlClient.SqlException: Failed to load Msxmlsql.dll.
Could not find prepared statement with handle 0.
sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
The statement has been terminated.
at Connectivity.Core.Database.TransactionContext.OnSqlException(SqlException e)
at Connectivity.Core.Database.SqlAccess.ExecuteReaderInternal(SqlCommand cmd)
at Connectivity.Core.Database.SqlAccess.ExecuteReader(CommandType commandType, String commandText, SqlParameter[] commandParameters, Int32 commandTimeout)
at Connectivity.Core.DataAccess.Director.InvokeSproc()
at Connectivity.Core.DataAccess.Director.ExecuteSQL()
at Connectivity.Core.DataAccess.Director.Execute(Options options)
at Connectivity.Core.DataAccess.Director.Execute()
at Connectivity.Document.DataAccess.Files.GetLatestFilesByMasterIds(Int64[] masterIds)
at Connectivity.Document.Services.FileService.GetLatestFilesByMasterIds(Int64[] fileMasterIds)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) Edited by: leegrisham2500 on Feb 18, 2010 9:49 PM

[Anonymous]

I googled on "Failed to load Msxmlsql.dll" and here is a possible solution:

http://support.microsoft.com/kb/941105

Failing that, I would try and repair your sql instance in add/remove
programs. This is definitely a sql issue.

Hope this helps,

Paul

[Anonymous]

Installing SQL Server SP2 seemed to have fixed the problem we were having with the Vault.

Now I'll finish making a backup script.