cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot catalog backups from earlier Version

Henry_Schlarb
Level 2

I am currently running Backup Exec 10d using Backup to Disk backups

One job in one folder is allowing restores without issue

Another folder cannot restore files from backup files present returning error The query for media sequence number -13119 of this media family was unsuccessful.
Ensure that all media in the family have been inventoried and cataloged.
 

The backups are not protected with a password

I have reviewed all of the technotes on the issue and followed through on all of the suggestions

- unchecked the "Use Storage based Catalogs"

- rebuilt the catalog

- created new folders and housed new backup jobs in those folders

   - these too fail

- moved the files to another Drive and recataloged

Symantec acknowleges that this is an issue for this version and all others up to Backup Exec 12.5 but will not fix it. I accept that.

I have now installed a trial version of Backup Exec 14.1 on another server and imported the files to that server with the hope that their statement that the issue is resolved in this new version includes the addition of routines that assist in resolving issues like mine.

So far

-Inventory jobs run fine

-Catalog jobs return the error

        Final error: 0xe0008105 - Invalid Physical Volume Library Media Identifier.
        Final error category: Job Errors

        For additional information regarding this error refer to link V-79-57344-33029

- the error appears when I uncheck the "Use Storage based Catalogs" as well

I have also rebuilt the catalogs on the 14.1: At one point in my adventure, it did read part of one file when I unchecked "Request all media in sequence". No other attemps show any change in the catalog state.

SGMon shows that it is reading all of the files but also refers to the dreaded {00000000-0000-0000-0000-000000000000}:


48370 BECAT 3692 2/13/2015 1:04:14 PM 3944 [4]   [SQLQuery::~SQLQuery::101] SQLQuery (InsertMedia) Time Spend = 0 ms - ReturnedCount (0)
48371 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [CAT_RSQLFreeConnect::695] free connection (000000000277E800) - # of connections (1)
48372 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [SQLQueryConnectionMgr::RemoveConnection::1214] SQLQueryConnectionMgr::RemoveConnection(000000000277E800)
48373 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [SQLQueryConnectionMgr::RemoveConnection::1221] odbcConn - 000000000277E800
48374 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [CAT_RSQLFreeConnect::701] free connection (0000000000000000) - # of connections (0) - done
48378 BECAT 3692 2/13/2015 1:04:14 PM 4652 [5]   [CAT_RSQLAllocConnect::393] 000000000277E800 - # of connections : 1
48382 BECAT 3692 2/13/2015 1:04:14 PM 4652 [5]   [SQLQueryConnectionMgr::RegisterConnection::1200] odbcConn (000000000277E800) - add to map
48383 BECAT 3692 2/13/2015 1:04:14 PM 3944 [5]   [SQLQuery::Prepare] szSqlStr : ({call InsertMedia(?,?,?,?,?,?)}) , cbSqlStr : (31)
48384 BECAT 3692 2/13/2015 1:04:14 PM 5188 [3]  [RPC::CAT_RSQLExecuteEx] Enter ...  ClientPrincipalName:CTSDOMAIN1\labyron  ClientPID:3248
48385 BECAT 3692 2/13/2015 1:04:14 PM 5188 [3]   [SQLMetaCatalog::CreateSet::997]  ###  Procedure:InsertMedia  ###  Type:VIEW  ###  class InsertMedia  ###
48386 BECAT 3692 2/13/2015 1:04:14 PM 5188 [3]   [SQLQuery::Execute::586] Input Parameters for "InsertMedia" : [001:MediaGuid]({C2584C14-5318-42D6-A11B-88A3B6F4F662}),[002:MediaSide](1),[003:FamilyId](1088489939),[004:FamilyGuid]({E0CB033D-166E-4F56-BB14-017F62D221FF}),[005:MediaNumber](51643),[010:MediaType](15),[006:DeviceGuid]({BB57B57B-09E1-4518-A539-80808AA2EC72}),[011:MediaSetGuid]({00000000-0000-0000-0000-000000000000}),[013:]({2B5D8D29-6A4C-45A7-9466-F7E60ED548E1})
48387 BECAT 3692 2/13/2015 1:04:14 PM 3900 [5]   [OdbcStatement::ExecDirect::959] hStatement=0x55eb4d0  ErrorCode(0)  szSqlStr="select * from ControlInfo "
48388 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2367] SQL_GUID: {C2584C14-5318-42D6-A11B-88A3B6F4F662}
48389 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2357] SQL_INTEGER: 1
48390 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2357] SQL_INTEGER: 1088489939
48391 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2367] SQL_GUID: {E0CB033D-166E-4F56-BB14-017F62D221FF}
48392 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2357] SQL_INTEGER: 51643
48393 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2357] SQL_INTEGER: 0
48394 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2357] SQL_INTEGER: 0
48395 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2380] SqlType(-9):
48396 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2380] SqlType(-9): B2D029801
48397 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2357] SQL_INTEGER: 15
48398 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2367] SQL_GUID: {BB57B57B-09E1-4518-A539-80808AA2EC72}
48399 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2380] SqlType(-9):
48400 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2380] SqlType(-9):
48401 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2367] SQL_GUID: {00000000-0000-0000-0000-000000000000}48402 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::BindParameter::2367] SQL_GUID: {2B5D8D29-6A4C-45A7-9466-F7E60ED548E1}
48403 BECAT 3692 2/13/2015 1:04:14 PM 3900 [3]   [CCatRecordSet::Open::1860]
48404 BECAT 3692 2/13/2015 1:04:14 PM 3900 [5]   [OdbcStatement::ExecDirect::959] hStatement=0x55eb4d0  ErrorCode(0)  szSqlStr="{CALL UpdateCatMedia(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }"
48405 BECAT 3692 2/13/2015 1:04:14 PM 5188 [3]   [SQLQuery::ProcessOutputBindingParameters::542] InOut Parameters for InsertMedia : No values
48406 BECAT 3692 2/13/2015 1:04:14 PM 5188 [3]   [SQLQuery::ProcessOutputBindingParameters::543] Output Parameters for InsertMedia : No values
48407 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [SQLQuery::Execute::618] m_sqlqueryTTL(0)
48408 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [SQLQuery::Execute::691] return 0
48409 BECAT 3692 2/13/2015 1:04:14 PM 5188 [3]  [RPC::CAT_RSQLExecuteEx] Exit ... 0
48410 BECAT 3692 2/13/2015 1:04:14 PM 3944 [4]   [SQLQuery::~SQLQuery::101] SQLQuery (InsertMedia) Time Spend = 0 ms - ReturnedCount (0)
48411 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [CAT_RSQLFreeConnect::695] free connection (000000000277E800) - # of connections (1)
48412 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [SQLQueryConnectionMgr::RemoveConnection::1214] SQLQueryConnectionMgr::RemoveConnection(000000000277E800)
48413 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [SQLQueryConnectionMgr::RemoveConnection::1221] odbcConn - 000000000277E800
48414 BECAT 3692 2/13/2015 1:04:14 PM 5188 [5]   [CAT_RSQLFreeConnect::701] free connection (0000000000000000) - # of connections (0) - done
48418 BECAT 3692 2/13/2015 1:04:14 PM 4652 [5]   [CAT_RSQLAllocConnect::393] 000000000277E800 - # of connections : 1


Any information on how to move forward and get this process to work will result in much happiness at Symantec.

 

2 REPLIES 2

Colin_Weaver
Moderator
Moderator
Employee Accredited Certified

Hmm well the media sequence number is bascially the order at which media was used in a family and a family is a sequence of media that starts with an overwrite operation but then continues with jobs that span from 1st media to second media etc. As such a single job that is bigger than one piece of media will of course create a media family that contains multiple media however regulary using jobs that start as append (which do not sart a new family) will also create large (in fact potentialy infinite) families 

 

If you have at somepoint got the same bkf file name - but because of media handling on the server actually got hold of a newer or older version of the same file (or even a version from a different media server if you have moved the files to another active media server) than the current family then it can break the sequence numbers and cause issues. Especially if the backup sets span from one media file to another. You might be able to use the option that runs a catalog but only against the one media item and not link them together (sorry I can't remember the exact title of the setting but it should be found in the same dialog as the "Use Storage based Catalogs" setting)

 

These sorts of problems are why we do not suggest taking flat file copies of Backup to disk storage locations, and additionally why for disk storage we suggested always starting jobs as overwrites and not appends (in fact the latest BE versions do not give the append option when disk storage is used)

 

For more info on why you can have poblems see http://www.symantec.com/docs/TECH176061

 

Henry_Schlarb
Level 2

Thank you for this explanation and the corresponding link.

Can I sidestep this issue by always retiring backup files instead of recycling them? This would then generate unique ids for the entire body of backups. I acknowledge that this proposal is not best practice but it would allow some manuverability until we move to BE14+. I currently hold 12 months worth on weekly full backups, some locally and some in offsite storage, amounting to 15 Tb of data.