cancel
Showing results for 
Search instead for 
Did you mean: 

Update to catalog index failed

Norbert_PORSCHE
Level 3
Hi all,

I have to catalog old DAT-Tapes to duplicate them to new SDLT-Tapes.
For some of these old tapes I get the following error messages:

EventID: 34327
Update to catalog index (Catalog index database) failed.
Reason: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Frag_Media'. cat_RecordSet::Open()
e:\caicosmp1\5520r\becat\beplugins\beimage\catfragment.cpp(81)

and

EventID:
Backup Exec Alert: Catalog Error
(Server: "SZG-SV-009") ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.

For each set on the tape I receive the above errors twice.

I am working with:
Backup Exec Server v10, b5520, r00
Windows Server 2003 Version 5.2 Build 3790

I already tried to:
* rename the catalogsfolder and create an empty new one - create new catalogs
The catalogfile are getting created but do not show up in BackupExec
* repair the BE-Database and rebuild the indices using BEutility -> no difference

Has anyone an idea how to resolve this?

regards
Norbert
7 REPLIES 7

Gauri_Ketkar
Level 6
Hi,

-Does inventory jobs on these DAT-tapes run successfully ?
-Please check and update us if any related event id generated ?


Update us on the same and revert for any further Query
Hope this will help you


Thank you
Gauri

Additional Information :
For information on the recent VERITAS Backup Exec security vulnerabilities, including links to the downloads for the necessary hotfixes, please refer to the following document:
Patch summary for Security Advisories VX05-001, VX05-002, VX05-003, VX05-005, VX05-006, VX05-007

http://seer.support.veritas.com/docs/277429.htm



NOTE : If we do not receive your reply within two business days, this post would be marked "assumed answered" and would be moved to "answered questions" pool.

Norbert_PORSCHE
Level 3
The Inventory gives the above mentioned ODBC-errors in the eventlog.
But the media shows up in the drive and the Imported Media.

Trying to catalog gives me 2 errors for each saveset on the tape.
Also the catalog files get created and the catalog job ends succesfully, the catalogs do not show up in the list!

I dont know what I can tell you more!?

kind regards
Norbert

Deepali_Badave
Level 6
Employee
Hello,

Before inventory launch the sgmon.

How to create SGMON.LOG
<<>>

NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to answered questions pool.

Norbert_PORSCHE
Level 3
Hallo,
here is the SGMON.LOG as requested:

beserver: 04/07/06 17:11:02 -1 Job Manager: LoadJob() request completed
cqmghost: pdhResult of first call for ReadBuffer = -2147481646
cqmghost: pdhResult of first call for WriteBuffer = -2147481646
cqmghost: ReadBuffer = 0.002198
cqmghost: WriteBuffer = 0.010394
cqmghost: AvgDisksecPerReadx10000 = 0
cqmghost: AvgDisksecPerWritex10000 = 0
cqmghost: ReadBuffer = 0.000000
cqmghost: WriteBuffer = 0.000000
cqmghost: AvgDisksecPerReadx10000 = 1
cqmghost: AvgDisksecPerWritex10000 = 1
cqmghost: ReadBuffer = 0.000000
cqmghost: WriteBuffer = 0.000000
cqmghost: AvgDisksecPerReadx10000 = 2
cqmghost: AvgDisksecPerWritex10000 = 2
cqmghost: ReadBuffer = 0.000000
cqmghost: WriteBuffer = 0.000000
cqmghost: AvgDisksecPerReadx10000 = 3
cqmghost: AvgDisksecPerWritex10000 = 3
cqmghost: ReadBuffer = 0.000000
cqmghost: WriteBuffer = 0.000000
cqmghost: AvgDisksecPerReadx10000 = 4
cqmghost: AvgDisksecPerWritex10000 = 4
cqmghost: ReadBuffer = 0.002198
cqmghost: WriteBuffer = 0.010394
cqmghost: AvgDisksecPerReadx10000 = 5
cqmghost: AvgDisksecPerWritex10000 = 5
beserver: 04/07/06 17:11:06 12 AdammAdminBO::Query() - Parent = NULL , Entity = MACHINE
pvlsvr: 04/07/06 17:11:06 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = MACHINE_ENTITY_TYPE
EntityGuid = {E02CD957-E4C4-4816-9AAA-3281A0DEA99B}
EntityName = ""
EntityFlags = 0x00008000
beserver: 04/07/06 17:11:06 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - Parent = NULL , Entity = DEVICE_POOL
pvlsvr: 04/07/06 17:11:07 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = DEVICE_POOL_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00008000
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - Parent = MACHINE , Entity = DRIVE
pvlsvr: 04/07/06 17:11:07 PvlEntityDatabase::QueryEntity()
ParentEntityType = MACHINE_ENTITY_TYPE
ParentEntityGuid = {E02CD957-E4C4-4816-9AAA-3281A0DEA99B}
EntityType = DRIVE_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00008000
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - Parent = MACHINE , Entity = BACKUP_TO_DISK
pvlsvr: 04/07/06 17:11:07 PvlEntityDatabase::QueryEntity()
ParentEntityType = MACHINE_ENTITY_TYPE
ParentEntityGuid = {E02CD957-E4C4-4816-9AAA-3281A0DEA99B}
EntityType = BACKUP_TO_DISK_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00008000
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - Parent = MACHINE , Entity = DRIVE_POOL_DRIVE
pvlsvr: 04/07/06 17:11:07 PvlEntityDatabase::QueryEntity()
ParentEntityType = MACHINE_ENTITY_TYPE
ParentEntityGuid = {E02CD957-E4C4-4816-9AAA-3281A0DEA99B}
EntityType = DRIVE_POOL_DRIVE_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00008000
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - Parent = MACHINE , Entity = CHANGER
pvlsvr: 04/07/06 17:11:07 PvlEntityDatabase::QueryEntity()
ParentEntityType = MACHINE_ENTITY_TYPE
ParentEntityGuid = {E02CD957-E4C4-4816-9AAA-3281A0DEA99B}
EntityType = LIBRARY_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00008000
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:07 -1 ActiveState::doDispatch( :( 'Inventory Drive 00164'
beserver: 04/07/06 17:11:07 -1 LocalSvr, runTask():{74dd2dcb-1b4b-41e0-8db2-4307591b7ddb}
beserver: 04/07/06 17:11:07 17 CJobManagerBO::Query QUERY_JOBSETUP_MONITOR
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Get() - Parent = NULL , Entity = DEVICE
pvlsvr: 04/07/06 17:11:07 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = DEVICE_ENTITY_TYPE
EntityGuid = {2A82DA98-B583-42F2-AFD4-28601AA6B026}
EntityName = ""
EntityFlags = 0x00000000
beserver: 04/07/06 17:11:07 12 AdammAdminBO::Get() - hr = 0x0
beserver: 04/07/06 17:11:07 11 LocalSvr, RunTask: EngineHandedJob SUCCESS, jobid:{74dd2dcb-1b4b-41e0-8db2-4307591b7ddb}.
beserver: 04/07/06 17:11:09 -1 UtilityJobThread - started
beserver: 04/07/06 17:11:09 12 AdammAdminBO::Query() - Parent = NULL , Entity = MACHINE
pvlsvr: 04/07/06 17:11:09 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = MACHINE_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00000000
beserver: 04/07/06 17:11:09 12 AdammAdminBO::Query() - hr = 0x0
pvlsvr: 04/07/06 17:11:09 AdammSession::Execute( ADAMM_SESSION_EXECUTE_SESSION_SET_JOB_INFO )
Session = {1C373A92-F4BD-4B7D-83E5-49CC6A0D92A4}
Job = {74DD2DCB-1B4B-41E0-8DB2-4307591B7DDB}, "Inventory Drive 00164"
beserver: 04/07/06 17:11:09 -1 Start Inventory
pvlsvr: 04/07/06 17:11:09 AdammSession::Execute( ADAMM_SESSION_EXECUTE_INVENTORY_READ_MEDIA_HEADER )
Session = {1C373A92-F4BD-4B7D-83E5-49CC6A0D92A4}
Device = {2A82DA98-B583-42F2-AFD4-28601AA6B026}, "DAT 3"
pvlsvr: 04/07/06 17:11:11 AdammSession::MediaUtilityThreadProc( ADAMM_SESSION_EXECUTE_INVENTORY_READ_MEDIA_HEADER )
Session = {C728DCC8-425E-4E90-BD12-602AB33E2D77}
Job = {74DD2DCB-1B4B-41E0-8DB2-4307591B7DDB}, "Inventory Drive 00164"
Drive = {2A82DA98-B583-42F2-AFD4-28601AA6B026}, "DAT 3"
Slot = 0000
Side = 0000
pvlsvr: 04/07/06 17:11:11 PvlDrive::MountMedia()
Session = {C728DCC8-425E-4E90-BD12-602AB33E2D77}
Drive = {2A82DA98-B583-42F2-AFD4-28601AA6B026}, "DAT 3"
Slot = 0000
Side = 0001
beserver: 04/07/06 17:11:12 17 CJobManagerBO::Query QUERY_JOBSETUP_MONITOR
beserver: 04/07/06 17:11:25 -1 SQLLog(8638):AgeSession m_threadMap: SessionThreadID:17c0, CurrentThreadID:aa0
pvlsvr: 04/07/06 17:11:48 AdammSession::MediaUtilityThreadProc( ADAMM_SESSION_EXECUTE_INVENTORY_READ_MEDIA_HEADER )
Session = {C728DCC8-425E-4E90-BD12-602AB33E2D77}
Library = {00000000-0000-0000-0000-000000000000}
Slot = 0000
Barcode = ""
Drive = {2A82DA98-B583-42F2-AFD4-28601AA6B026}, "DAT 3"
Media = {935F5824-0070-4350-810A-7BC09A7988AA}, "#1F3346AB-001"
SUCCESS!
pvlsvr: 04/07/06 17:11:48 PvlDrive::DismountMedia()
Session = {C728DCC8-425E-4E90-BD12-602AB33E2D77}
Drive = {2A82DA98-B583-42F2-AFD4-28601AA6B026}, "DAT 3"
Slot = 0000
Side = 4294967295
beserver: 04/07/06 17:11:48 12 AdammAdminBO::Query() - Parent = DRIVE , Entity = MEDIA
pvlsvr: 04/07/06 17:11:48 PvlEntityDatabase::QueryEntity()
ParentEntityType = DRIVE_ENTITY_TYPE
ParentEntityGuid = {2A82DA98-B583-42F2-AFD4-28601AA6B026}
EntityType = MEDIA_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00000000
pvlsvr: 04/07/06 17:11:48 PvlEntityDatabase::QueryEntity() : SUCCESS!
beserver: 04/07/06 17:11:48 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:48 12 AdammAdminBO::Query() - Parent = DRIVE , Entity = MEDIA
pvlsvr: 04/07/06 17:11:48 PvlEntityDatabase::QueryEntity()
ParentEntityType = DRIVE_ENTITY_TYPE
ParentEntityGuid = {3C1DE8A9-64C2-4C82-AC9B-354FE830F4D4}
EntityType = MEDIA_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00000000
pvlsvr: 04/07/06 17:11:48 PvlEntityDatabase::QueryEntity() : SUCCESS!
beserver: 04/07/06 17:11:48 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:48 12 AdammAdminBO::Query() - Parent = NULL , Entity = MEDIA
pvlsvr: 04/07/06 17:11:48 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = MEDIA_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x000000C2
pvlsvr: 04/07/06 17:11:48 PvlEntityDatabase::QueryEntity() : SUCCESS!
beserver: 04/07/06 17:11:48 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:48 12 AdammAdminBO::Query() - Parent = NULL , Entity = MEDIA
pvlsvr: 04/07/06 17:11:48 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = MEDIA_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x000000C2
pvlsvr: 04/07/06 17:11:48 PvlEntityDatabase::QueryEntity() : SUCCESS!
beserver: 04/07/06 17:11:48 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:50 12 AdammAdminBO::Query() - Parent = DRIVE , Entity = MEDIA
pvlsvr: 04/07/06 17:11:50 PvlEntityDatabase::QueryEntity()
ParentEntityType = DRIVE_ENTITY_TYPE
ParentEntityGuid = {2A82DA98-B583-42F2-AFD4-28601AA6B026}
EntityType = MEDIA_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00000000
pvlsvr: 04/07/06 17:11:50 PvlEntityDatabase::QueryEntity() : SUCCESS!
beserver: 04/07/06 17:11:50 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:50 12 AdammAdminBO::Query() - Parent = DRIVE , Entity = MEDIA
pvlsvr: 04/07/06 17:11:50 PvlEntityDatabase::QueryEntity()
ParentEntityType = DRIVE_ENTITY_TYPE
ParentEntityGuid = {3C1DE8A9-64C2-4C82-AC9B-354FE830F4D4}
EntityType = MEDIA_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00000000
pvlsvr: 04/07/06 17:11:50 PvlEntityDatabase::QueryEntity() : SUCCESS!
beserver: 04/07/06 17:11:50 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:50 12 AdammAdminBO::Query() - Parent = NULL , Entity = MEDIA
pvlsvr: 04/07/06 17:11:50 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = MEDIA_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x000000C2
pvlsvr: 04/07/06 17:11:50 PvlEntityDatabase::QueryEntity() : SUCCESS!
beserver: 04/07/06 17:11:50 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:51 12 AdammAdminBO::Query() - Parent = NULL , Entity = MEDIA
pvlsvr: 04/07/06 17:11:51 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = MEDIA_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x000000C2
pvlsvr: 04/07/06 17:11:51 PvlEntityDatabase::QueryEntity() : SUCCESS!
beserver: 04/07/06 17:11:51 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:53 -1 End Inventory
beserver: 04/07/06 17:11:53 -1 UtilityJobThread - catalog
beserver: 04/07/06 17:11:53 -1 Client requested key.
beserver: 04/07/06 17:11:53 -1 Client 'SZG-SV-009' connected('','GCS\bkupadm'): 0x6383fc0
beserver: 04/07/06 17:11:53 18 Alert Catalog Error, Notify: No, EventLog: Yes, Trap: No
beserver: 04/07/06 17:11:53 -1 Client 'SZG-SV-009' Disconnected:0x6383fc0
beserver: 04/07/06 17:11:53 -1 UtilityJobThread - log file
beserver: 04/07/06 17:11:53 12 AdammAdminBO::Query() - Parent = NULL , Entity = DRIVE
pvlsvr: 04/07/06 17:11:53 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = DRIVE_ENTITY_TYPE
EntityGuid = {00000000-0000-0000-0000-000000000000}
EntityName = ""
EntityFlags = 0x00000000
beserver: 04/07/06 17:11:53 12 AdammAdminBO::Query() - hr = 0x0
beserver: 04/07/06 17:11:53 12 AdammAdminBO::Get() - Parent = NULL , Entity = DRIVE
pvlsvr: 04/07/06 17:11:53 PvlEntityDatabase::QueryEntity()
ParentEntityType = NULL_ENTITY_TYPE
ParentEntityGuid = {00000000-0000-0000-0000-000000000000}
EntityType = DRIVE_ENTITY_TYPE
EntityGuid = {2A82DA98-B583-42F2-AFD4-28601AA6B026}
EntityName = ""
EntityFlags = 0x00000000
beserver: 04/07/06 17:11:53 12 AdammAdminBO::Get() - hr = 0x0
beserver: 04/07/06 17:11:53 -1 UtilityJobThread - status
beserver: 04/07/06 17:11:53 -1 UtilityJobThread - EndJob:success
beserver: 04/07/06 17:11:53 17 JobManager::HandleEndJob() called
beserver: 04/07/06 17:11:53 -1 UtilityJobThread - end
beserver: 04/07/06 17:11:53 -1 ActiveState::doEndEvent( :( 'Inventory Drive 00164'
pvlsvr: 04/07/06 17:11:53 AdammSession::Release()
Session = {1C373A92-F4BD-4B7D-83E5-49CC6A0D92A4}
beserver: 04/07/06 17:11:53 17 JobManager::DoJobCompletionTasks(Inventory Drive 00164): GetFinalJobStatus()=19
beserver: 04/07/06 17:11:54 17 JobManager: Flagging 'Inventory Drive 00164' for deletion
beserver: 04/07/06 17:11:54 -1 ActiveState::doEndEvent( :( CJobManager::DoJobCompletionTasks() returned 0x0
beserver: 04/07/06 17:11:54 -1 Released virtual array rowset(567).
beserver: 04/07/06 17:11:54 -1 Released virtual array rowset(566).
beserver: 04/07/06 17:11:54 -1 Registered virtual array rowset(568): Client:SZG-SV-009, Type:MD_OBJTYPE_JOBHISTORYVIEW
beserver: 04/07/06 17:11:54 -1 Registered virtual array rowset(569): Client:GEO901, Type:MD_OBJTYPE_JOBHISTORYVIEW
beserver: 04/07/06 17:11:57 17 CJobManagerBO::Query QUERY_JOBSETUP_MONITOR
beserver: 04/07/06 17:11:57 17 CJobManagerBO::Query QUERY_JOBSETUP_MONITOR

Ashutosh_Tamhan
Level 6
Hello Nobert !

Please try reloading your backup exec database from base and running the catalog operation with the catalog folder renamed.

We recommend you to first dump your existing database so that you can always go back to it.

Check out the following technotes:
http://seer.support.veritas.com/docs/254014.htm
http://seer.support.veritas.com/docs/268315.htm

Regards,
Ashutosh

NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to answered questions pool.

Norbert_PORSCHE
Level 3
As soon as my daily backup tasks will allow it,
I will try out your suggestions.
From my point of view, this is a too common problem to be solved that way.
I stopped counting the times where I had to recatalog all my tapes.
This makes the idea of catalogs rather useless.
regards
Norbert

Shilpa_pawar_2
Level 6
Hi,

Additionally refer these points:

Un-check the option "Use storage media-based catalogs" under "TOOLS| OPTIONS| CATLAOG and rerun the catalog.

Go through these documents:
http://support.veritas.com/docs/272886
http://support.veritas.com/docs/242633

NOTE : If we do not receive your reply within two business days, this post would be marked "assumed answered" and would be moved to "answered questions" pool.