When running xp_viewcontents, information of backups created from other servers could not be retrieved.
e.g.
exec master.dbo.xp_view_tsmcontents
@tsmclientnode = 'ClientNode'
, @tsmclientownerpwd= '***'
, @tsmfilespace= 'LiteSpeed'
, @tsmconfigfile= 'C:\dsm.opt'
, @logging = 2
14:20:55.001 14964 Main TsmEnvironment::checkVersion calling dsmQueryApiVersionEx
14:20:55.001 14964 Main TsmEnvironment::checkVersion TSM API Library Version = 5.5.3.0 unicode
14:20:55.048 14964 Main TsmEnvironment::init dsmSetup ok
14:20:55.048 14964 Main TsmConnection::connect Doing sign on for node ClientNode
14:20:55.048 14964 Main TsmConnection::connect calling dsmInitEx
14:20:55.079 14964 Main TsmConnection::connect Connected to server version 5.4.4.0
14:20:55.079 14964 Main TsmConnection::connect Handle on return = 1
14:20:55.079 14964 Main TsmConnection::connect calling dsmQuerySessInfo
14:20:55.079 14964 Main TsmQuery::queryBackups malloc query.objName & query.owner
14:20:55.079 14964 Main TsmQuery::queryBackups calling dsmBeginQuery
14:20:55.079 14964 Main TsmQuery::queryBackups calling dsmGetNextQObj: 0
14:20:55.110 14964 Main TsmQuery::queryBackups dsmGetNextQObj error DSM_RC_UNKNOWN_FORMAT: Object skipped
14:20:55.110 14964 Main TsmQuery::queryBackups calling dsmGetNextQObj: 1
14:20:55.110 14964 Main TsmQuery::queryBackups dsmGetNextQObj error DSM_RC_UNKNOWN_FORMAT: Object skipped
…
…
14:20:58.632 14964 Main TsmQuery::queryBackups calling dsmGetNextQObj: 18583
14:20:58.632 14964 Main TsmQuery::queryBackups dsmGetNextQObj error DSM_RC_UNKNOWN_FORMAT: Object skipped
14:20:58.632 14964 Main TsmQuery::queryBackups calling dsmGetNextQObj: 18584
14:20:58.632 14964 Main TsmQuery::queryBackups dsmGetNextQObj error DSM_RC_UNKNOWN_FORMAT: Obj
TSM API Library Version on the problem box was not identical with other servers
Server with higher version of TSM API LIbrary always be able to view the backups from server with lower version of TSM API Library.
To ensure the backups from different servers is viewable from each other, Same version of TSM Client has to be installed on the servers as well as TSM API Library version has to be the same.
The line that displays the version number in the resulting log file will say:
TsmConnection::connect Connected to server version 6.2.2.34 (whatever the version is for the TSM API client)
Verify the values from the source server vs. the destination server.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy