Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 309 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
BC17 Upgrade fails on Database Conversion
detlef
Member Posts: 38
Doing an upgrade from V15.5 to V17.0 and it fails doing the database conversion with an SQL timeout after 1 minute.
This is on an Azure VM ( Standard E4s v3 (4 vcpus, 32 GiB memory) ) connected to an Azure SQL db (31GB).
Steps followed from here:
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v15-to-v17
I have increased the DTUs to 200 and run exec sp_updatestats on the database. Still fails:
PS C:\windows\system32> Invoke-NAVApplicationDatabaseConversion -DatabaseServer "sql04.database.windows.net" -DatabaseName "BCTest" -ApplicationDatabaseCredentials (Get-Credential)
cmdlet Get-Credential at command pipeline position 1
Supply values for the following parameters:
Credential
sql04.database.windows.net
If you convert the database 'BCTest' on the 'sql04.database.windows.net' server, you will no longer be able
to open it with older versions of Dynamics 365 Business Central.
We strongly recommended that you make a database or transaction log backup in SQL Server before the conversion.
Note that the conversion removes any modifications that you have made to system tables.
Do you want to continue?
[Y] Yes [N] No Suspend [?] Help (default is "Y"):
Invoke-NAVApplicationDatabaseConversion : The database create operation failed due to the following error returned by
SQL Server:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not
responding.
The statement has been terminated.
At line:1 char:1
+ Invoke-NAVApplicationDatabaseConversion -DatabaseServer "sql04.dat ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (0:Int32) [Invoke-NAVApplicationDatabaseConversion], NavCommandException
+ FullyQualifiedErrorId : sql04.database.windows.net,Microsoft.Dynamics.Nav.Management.Cmdlets.InvokeNAVApplica
tionDatabaseConversion
Does anyone have an idea, how to make this work?
Cheers
Detlef
This is on an Azure VM ( Standard E4s v3 (4 vcpus, 32 GiB memory) ) connected to an Azure SQL db (31GB).
Steps followed from here:
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v15-to-v17
I have increased the DTUs to 200 and run exec sp_updatestats on the database. Still fails:
PS C:\windows\system32> Invoke-NAVApplicationDatabaseConversion -DatabaseServer "sql04.database.windows.net" -DatabaseName "BCTest" -ApplicationDatabaseCredentials (Get-Credential)
cmdlet Get-Credential at command pipeline position 1
Supply values for the following parameters:
Credential
sql04.database.windows.net
If you convert the database 'BCTest' on the 'sql04.database.windows.net' server, you will no longer be able
to open it with older versions of Dynamics 365 Business Central.
We strongly recommended that you make a database or transaction log backup in SQL Server before the conversion.
Note that the conversion removes any modifications that you have made to system tables.
Do you want to continue?
[Y] Yes [N] No Suspend [?] Help (default is "Y"):
Invoke-NAVApplicationDatabaseConversion : The database create operation failed due to the following error returned by
SQL Server:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not
responding.
The statement has been terminated.
At line:1 char:1
+ Invoke-NAVApplicationDatabaseConversion -DatabaseServer "sql04.dat ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (0:Int32) [Invoke-NAVApplicationDatabaseConversion], NavCommandException
+ FullyQualifiedErrorId : sql04.database.windows.net,Microsoft.Dynamics.Nav.Management.Cmdlets.InvokeNAVApplica
tionDatabaseConversion
Does anyone have an idea, how to make this work?
Cheers
Detlef
0
Answers
I am facing the same challenge you raised here. Did you find a solution for this? How did you resolve this issue?
Regards,
Chenjerai Madziwa
how big is your database?
I have experienced like this before.
last time my customer had a lot of entities...
then I separate become 2 databases
once converted then re-import entities become 1 database