Dynamics Community Forum Thread Details

Start-NAVAppDataUpgrade Error

Start-NAVAppDataUpgrade -ServerInstance BC220 -Name /Base Application/ -Version 22.1.240992.0
Get-Date

Wednesday, April 10, 2024 1:15:46 AM
Start-NAVAppDataUpgrade : Could not upgrade the extension 'Base Application'
by 'Microsoft' from version '22.1.240373.0' to '22.1.240992.0' for tenant
'default' and company 'RLS Inc' due to the following error: 'A connection to
SQL Server is no longer usable.
This could be caused by one of the following reasons:
* The server has been shut down manually or because of an error.
* The SQL Server connection settings are not correct.
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer.' and AL
stack trace:
/Update VAT Date Field/(CodeUnit 104051).UpdateBlankGLEntries line 21 - Base
Application by Microsoft
/Update VAT Date Field/(CodeUnit 104051).OnUpgradePerCompany line 13 - Base
Application by Microsoft
/Upgrade Triggers/(CodeUnit 2000000008).OnUpgradePerCompany(Event) line 2
At line:2 char:1
+ Start-NAVAppDataUpgrade -ServerInstance BC220 -Name /Base Application ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [Start-NAVAppDataUpgrade],
InvalidOperationException
+ FullyQualifiedErrorId : MicrosoftDynamicsNavServer$BC220/default,Microso
ft.Dynamics.Nav.Apps.Management.Cmdlets.StartNavAppDataUpgrade

Below error captured in the events:

Statement: DECLARE @RCount INT;UPDATE /17/ SET /17/./VAT Reporting Date/=/17/./Posting Date/ FROM /SQLDATABASE/.dbo./CURRENTCOMPANY$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972/ /17/ WHERE (/17/./VAT Reporting Date/=@2)SET @RCount = IIF(@@ROWCOUNT < @RCount, @RCount, @@ROWCOUNT);SELECT @RCount;

AppObjectType: CodeUnit

AppObjectId: 104051

AL CallStack: /Update VAT Date Field/(CodeUnit 104051).UpdateBlankGLEntries line 21 - Base Application by Microsoft

/Update VAT Date Field/(CodeUnit 104051).OnUpgradePerCompany line 13 - Base Ap

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS