Appliation Event Log:
Log Name: Application
Source: Backup Exec CatErrorHandler Server
Event ID: 34327
Task Category: None
Level: Error
Keywords: Classic
Description:
Update to catalog index (Catalog index database) failed.
Reason: [Microsoft][SQL Server Native Client 11.0][SQL Server]Catalog @CAT_ResourceContainerType = 16777216 @DisplayContainerName = Server1 CCatRecordSet::ExecuteBulkInsert
R:\TREASUREISLAND\1200.2536R\becat\segodbc\seg_odbc.cpp(2681)
sp_sproc_columns CatInsertContainerResourceAssociationProc
SGMON Log -
[CatInsertContainerResourceAssociationProc] ***** ERROR CatInsertContainerResourceAssociationProc: The formal parameter
"@CAT_SCF_TenantId" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.
ResourceContainerName=SERVER.DOM
Execute dbupgradebuildtobuild.sql on BEDB to ensure no ODBC errors are seen and backup sets show up fine in restore selection. The sets would show up if the catalog files of that set is present in Backup Exec Catalogs folder.
How to run dbupgradebuildtobuild.sql
1. Open a elevated command prompt to \Program Files\Symantec\Backup Exec folder.
2. Issue the following command (Case Sensitive)
osql -E -S
Example: Backup Exec default installation using default BKUPEXEC SQL server instance.
osql -E -S localhost\BKUPEXEC -d bedb -i dbupgradebuildtobuild.sql
NOTE: The Issue is fixed in Backup Exec 22.