Guest

Preview Tool

Cisco Bug: CSCvs87517 - TMS upgrade to 15.10 fails with Valuespace_changes_for_CE_detetion.sql FAIL in Databaselog.txt

Last Modified

Apr 10, 2020

Products (1)

  • Cisco TelePresence Management Server

Known Affected Releases

15.10

Description (partial)

Symptom:
Upgrade fails with theses errors in databaselog.txt

Valuespace_changes_for_CE_detetion.sql................................................. FAIL

Error Code 547 at line 1: The DELETE statement conflicted with the REFERENCE constraint "FK_objSystemTemplateItem_objSystemTemplateItemTemplate". The conflict occurred in database "tmsng", table "dbo.objSystemTemplateItem", column 'objSystemTemplateItemTemplate_Id'.
Error Code 547 at line 3: The DELETE statement conflicted with the REFERENCE constraint "FK_objSystemTemplateItem_objSystemTemplateItemTemplate". The conflict occurred in database "tmsng", table "dbo.objSystemTemplateItem", column 'objSystemTemplateItemTemplate_Id'.
Error Code 3621 at line 1: The statement has been terminated.
Error Code 3621 at line 3: The statement has been terminated.

2020-01-28T14:28:39 Unhandled Error in UpgradeDatabase
2020-01-28T14:28:39 #### Script error(s): ####
2020-01-28T14:28:39    * Line 1: Error Code 547 at line 1: The DELETE statement conflicted with the REFERENCE constraint "FK_objSystemTemplateItem_objSystemTemplateItemTemplate". The conflict occurred in database "tmsng", table "dbo.objSystemTemplateItem", column 'objSystemTemplateItemTemplate_Id'.
2020-01-28T14:28:39    * Line 3: Error Code 547 at line 3: The DELETE statement conflicted with the REFERENCE constraint "FK_objSystemTemplateItem_objSystemTemplateItemTemplate". The conflict occurred in database "tmsng", table "dbo.objSystemTemplateItem", column 'objSystemTemplateItemTemplate_Id'.
2020-01-28T14:28:39    * Line 1: Error Code 3621 at line 1: The statement has been terminated.
2020-01-28T14:28:39    * Line 3: Error Code 3621 at line 3: The statement has been terminated.
2020-01-28T14:28:39    at RiddimCore.SqlTools.SafelyExecuteGoSeparatedSqlScript(SqlCommand command, String script)
   at RiddimCore.SynchObject.<>c__DisplayClass1.<MakeFromNameAndContents>b__0(SqlCommand x)
   at RiddimCore.SqlServerDatabaseManager.CreateSqlCommandAndExecutePatch(SynchObject synchObject)
   at RiddimCore.SqlServerDatabaseManager.ApplyPatch(SynchObject synchObject)
   at RiddimCore.DbSynchronizer.ApplyPatches(List`1 patchesToApply)
   at RiddimCore.DbSynchronizer.SynchronizeSchemaPatches(Boolean forceChecksums)
   at RiddimCore.DbSynchronizer.RunSchemaSynchronization(Boolean forceChecksums)
   at RiddimInstallerSupport.DatabaseInstaller.UpgradeDatabase(Int32 commandTimeoutSeconds)
   at TMSInstallationUtilNet.Functions.UpgradeDatabase(String logPath, Int32 sqlTimeout, String connectionString)

Conditions:
There was a code change in CE for "Audio KeyClickDetector Attenuate" and "Audio KeyClickDetector Enabled" for them to be true/false values instead of on/off values. There is a database patch in 15.10 that tries to delete old system template items and create the new ones. If the TMS has a system template  that is currently configured to use these items, the patch is unable to remove the old template items.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.