Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
376 questions
Error applying BT2020 CU6
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 30%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Klashorst, Marc van de
5
Reputation points
I'm trying to apply BT2020 CU6 to our servers, but I run into this error, and I have no clue where this goes wrong since it fails in one of the executables that comes with the update, not one of the SQL scripts:
Information: Remove tracking profile for assembly "Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35".
Error: SQL exception: "Cannot find either column "dbo" or the user-defined function or aggregate "dbo.dpl_fn_CountOrphanedProperties", or the name is ambiguous."
I seem to be the first person on the internet to run into this issue, but maybe here somebody has a clue? Running the failing CAWrapper command from the command-line gives the same result.
Full context from the upgrade log:
[02/13/25 10:28:12] Apply patch: Server="OTD-VSW-APL-039\SQLBTSDEV", Database="ont_BizTalkMgmtDb", Script="C:\ProgramData\Microsoft\E-Business Servers Updates\Updates\Uninstall5043408\CAWrapper.exe".
[02/13/25 10:28:12] "C:\ProgramData\Microsoft\E-Business Servers Updates\Updates\Uninstall5043408\CAWrapper.exe" 3 3.13.798.0 OTD-VSW-APL-039\SQLBTSDEV ont_BizTalkMgmtDb EXE "BtsDeploySystemAssemblyTask.exe /assembly:Microsoft.BizTalk.GlobalPropertySchemas" HRESULT=0
[02/13/25 10:28:12] Creating Process to execute script: "C:\ProgramData\Microsoft\E-Business Servers Updates\Updates\Uninstall5043408\CAWrapper.exe" 3 3.13.798.0 OTD-VSW-APL-039\SQLBTSDEV ont_BizTalkMgmtDb EXE "BtsDeploySystemAssemblyTask.exe /assembly:Microsoft.BizTalk.GlobalPropertySchemas" HRESULT=0
[02/13/25 10:28:20] Execution of Script "C:\ProgramData\Microsoft\E-Business Servers Updates\Updates\Uninstall5043408\CAWrapper.exe" 3 3.13.798.0 OTD-VSW-APL-039\SQLBTSDEV ont_BizTalkMgmtDb EXE "BtsDeploySystemAssemblyTask.exe /assembly:Microsoft.BizTalk.GlobalPropertySchemas" failed. HRESULT=0x80004005
[02-13-25 10:28:12] CAWrapper: Argument count: 6
[02-13-25 10:28:12] CAWrapper: cuNum: 3, btsVer: 3.13.798.0, servername: OTD-VSW-APL-039\SQLBTSDEV, databasename: ont_BizTalkMgmtDb, command: EXE
[02-13-25 10:28:12] CAWrapper: cmdArg#0: BtsDeploySystemAssemblyTask.exe /assembly:Microsoft.BizTalk.GlobalPropertySchemas
[02-13-25 10:28:12] CAWrapper: Entering isDbVersionLower
[02-13-25 10:28:12] CAWrapper: Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ont_BizTalkMgmtDb;Data Source=OTD-VSW-APL-039\SQLBTSDEV
[02-13-25 10:28:12] CAWrapper: No DB Version info found so assuming DB Version is lower.
[02-13-25 10:28:12] CAWrapper: DB Version in OTD-VSW-APL-039\SQLBTSDEV, ont_BizTalkMgmtDb is lower so need to run command.
[02-13-25 10:28:12] CAWrapper: Entering callEXE
[02-13-25 10:28:12] CAWrapper: Calling BtsDeploySystemAssemblyTask.exe with args /assembly:Microsoft.BizTalk.GlobalPropertySchemas
******************************* Processing Microsoft.BizTalk.GlobalPropertySchemas migration from Registry to Database *******************************
Server = OTD-VSW-APL-039\SQLBTSDEV Database = ont_BizTalkMgmtDb
Taking Backup of tables
Getting Id of Microsoft.BizTalk.GlobalPropertySchemas
Old Id of Assembly : 1
Clearing table [dbo].[bts_libreference]
Clearing table [dbo].[bts_itemreference]
Marking Microsoft.BizTalk.GlobalPropertySchemas as Non-System Assembly.
Executing BtsTask
Microsoft (R) BizTalk Application Deployment Utility Version 3.13.717.0
Copyright (c) Microsoft Corporation. All rights reserved.
Information: Adding resource (-Type="System.BizTalk:BizTalkAssembly" -Luid="Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35") to application "BizTalk.System"...
Serialized BizTalk assembly "Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" from "D:\Program Files (x86)\Microsoft BizTalk Server\Microsoft.BizTalk.GlobalPropertySchemas.dll".
Information: Validating resources (count=1)...
** Validating resource (-Type="System.BizTalk:BizTalkAssembly" -Luid="Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35")...*
Information: Performing change requests...
Information: Calling BeginTypeChangeRequest for all selected resource types...
PerformingBeginChangeRequest
Updating resource (-Type="System.BizTalk:BizTalkAssembly" -Luid="Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35") in store.
Information: * Performing change request on type "System.BizTalk:BizTalkAssembly" (count=1)...
Information: Reading binding information for assembly "Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35".
Information: Successfully selected binding information.
Information: Saved binding information to XML file "C:\Users\tab.klam2809\AppData\Roaming\Microsoft\BizTalk Server\Deployment\BindingFiles\Microsoft.BizTalk.GlobalPropertySchemas_3.0.1.0_neutral_31bf3856ad364e35.BindingInfo.xml".
Information: Assembly "Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is not used by any other assemblies. Skipping pre-update operations.
Information: Updating assembly "Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"...
Information: Reading binding information for assembly "Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35".
Information: Successfully selected binding information.
Information: Saved binding information to XML file "C:\Users\tab.klam2809\AppData\Roaming\Microsoft\BizTalk Server\Deployment\BindingFiles~Microsoft.BizTalk.GlobalPropertySchemas_3.0.1.0_neutral_31bf3856ad364e35.BindingInfo.xml".
Information: Updating binding information.
ConnectionString="Data Source=OTD-VSW-APL-039\SQLBTSDEV;Initial Catalog=ont_BizTalkMgmtDb;Integrated Security=Tru HRESULT=0 e;Enlist=True;Application Name=Microsoft.BizTalk.ApplicationDeployment.Engine"
Information: Updating send ports, send port groups, and receive ports...
Information: Updating parties and enlistments...
Information: Updating orchestration bindings...
Information: Successfully updated binding information.
Information: Successfully updated schedule Information (if required).
Information: Remove server="OTD-VSW-APL-039\SQLBTSDEV" database="ont_BizTalkMgmtDb" assembly="C:\Users\tab.klam2809\AppData\Local\Temp\BT\PID3924\BizTalkAssembly\ab635739269b8968f90509a0f8a3bf48\Microsoft.BizTalk.GlobalPropertySchemas.dll"
Information: No started orchestrations.
Information: Remove tracking profile for assembly "Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35".
Error: SQL exception: "Cannot find either column "dbo" or the user-defined function or aggregate "dbo.dpl_fn_CountOrphanedProperties", or the name is ambiguous."
Error: SQL exception: "Cannot find either column "dbo" or the user-defined function or aggregate "dbo.dpl_fn_CountOrphanedProperties", or the name is ambiguous."
Information: PerformingEndChangeRequestsWithRollBack
** Performing EndTypeChangeRequest for resource type "System.BizTalk:BizTalkAssembly".*
Error: Failed to add resource(s).
Change requests failed for some resources.
BizTalkAssemblyResourceManager failed to complete end type change request.
SQL exception: "Cannot find either column "dbo" or the user-defined function or aggregate "dbo.dpl_fn_CountOrphanedProperties", or the name is ambiguous."
Command failed with 1 errors, 0 warnings.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 62%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Paul Geldenhuys 0 Reputation points2025-02-20T11:44:15.46+00:00 We ran into the exact same issue on the 15th while trying to apply CU6 to our production BizTalk 2020 environment. Running the BTS2020-KB5043408-ENU.exe downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=106333 fails, but an earlier installation of CU6 on our QA environment (installation and configuration matching that of the production environment) succeeded.
Running a SDL comparison of the BizTalkMgmtDb in both the QA and production environments shows no differences in the dbo.dpl_fn_CountOrphanedProperties scalar-valued function, with both databases running on the same version of SQL (15.0.4410.1) and having the same collation.
Attempting to start the BizTalk host instances after the failed installation also failed with errors in the event log that seem to be relating to the BizTalkMsgBoxDb database, forcing a restore from the backups done prior to the start of the CU install.
Does anyone have an answer or solution to this issue?
-
Klashorst, Marc van de 5 Reputation points
2025-02-21T06:49:21.9633333+00:00 Did you come from CU5 or from CU4 (like us)? I'm contemplating installing CU5 first, but if you were already running that this might be fruitless.
Sign in to comment
Sign in to answer