Skip to main content
Question

Update from 11.40 to 11.44 DBUpgrade Problem

  • Nov 13, 2026 7:54 AM UTC
  • 1 reply
  • 10 views

Forum|alt.badge.img

The Upgrade from 11.40 to 11.44 stop with DBUpgrade Problem: 
The TableScript\App_CloudVendorRegion.sql faild, the File is avalible

11/12/26 14:05:21    ## DBUpgrade::removeDBUpgradeSteps ## Removed upgrade steps for this DataBase [CommServ].11/12/26 14:09:01    ## INIFileProcessor::executeSQLList ## INFO: [... inserting Table: App_CloudVendorRegion] [RecNum:1, LineNum:37, Spid:86] INFO: [Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.] [RecNum:1, State:21000, NativeErr:512, RowNum:1, Severity:16, LineNum:110, Spid:86] 11/12/26 14:09:01    ## CVSimpleDB::SQLINFO ## INFO: [... inserting Table: App_CloudVendorRegion] [RecNum:1, LineNum:37, Spid:86] 11/12/26 14:09:01    ## CVSimpleDB::SQLINFO ## INFO: [Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.] [RecNum:1, State:21000, NativeErr:512, RowNum:1, Severity:16, LineNum:110, Spid:86] 11/12/26 14:09:01    ## INIFileProcessor::executeSQLList ## Execution of file [C:\Program Files\Commvault\ContentStore\Base\DBUpgrade\CommServer\MainUpgrade/TableScript\App_CloudVendorRegion.sql] failed11/12/26 14:09:01    ## INIFileProcessor::processPhase ## Failed to process Phase [TableScript]. ReturnCode [2]11/12/26 14:09:01    ## DBUpgrade::executePhase ## Failed to process Phase [MainUpgrade] for Config File [C:\Program Files\Commvault\ContentStore\Base\DBUpgrade\CommServer\DBConfig.ini].11/12/26 14:09:01    ## DBUpgrade::runMainUpgrade ## Failed to execute Phase [MainUpgrade] for Database [CommServ].11/12/26 14:09:01    ## DBUpgrade::runUpgrade ## Main Upgrade failed for Database [CommServ].

1 reply

Forum|alt.badge.img+17
  • Vaulter
  • Nov 13, 2026 8:34 AM UTC

HI ​@Thomas Trendel ,

The error is typically due to duplicate or inconsistent entries in related tables (such as ArchCopyAppRegionMap and App_CloudVendorZone), which cause the subquery to return more than one value.

The issue is resolved in latest MR. However, you may log support case to follow below resolution.

  1. Obtain the cleanup script CleanupAppCloudVendorRegionZoneTables.sqle and copy it to the CommServe machine.
  2. Run the script using the following command:
    qscript -f CleanupAppCloudVendorRegionZoneTables.sqle
    This will remove problematic entries from the ArchCopyAppRegionMap and App_CloudVendorZone tables.
  3. Resume the upgrade process. The upgrade should complete successfully.