Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Error while deploying NAV DB from SQL to Azure SQL

(1) ShareShare
ReportReport
Posted on by 35

Hello everyone,

I am having some difficulties with importing NAV DB from SQL Server to Azure SQL Server. I exported DB using Export Data-tier Application and trying to import it back using Import Data-tier Application. I googled the error but cannot find any solution. Does anyone familiar with this issue?

tpr4gfkrypmn.png

SQL Error:

Could not import package.
Warning SQL0: A project which specifies SQL Server 2016 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12.
Error SQL72014: .Net SqlClient Data Provider: Msg 208, Level 16, State 1, Procedure deadlock_report_ring_buffer_view, Line 3 Invalid object name 'sys.dm_xe_session_targets'.
Error SQL72045: Script execution error. The executed script:
CREATE VIEW dbo.deadlock_report_ring_buffer_view
AS
SELECT target_data AS event_raw_data
FROM sys.dm_xe_session_targets AS xt
INNER JOIN
sys.dm_xe_sessions AS xs
ON xs.address = xt.event_session_address
WHERE xs.name = N'..._deadlock_monitor'
AND xt.target_name = N'ring_buffer';

(Microsoft.SqlServer.Dac)

Thank you for your help.

Regards,
Ekin

*This post is locked for comments

  • RE: Error while deploying NAV DB from SQL to Azure SQL

    Looks like a good workaround until Microsoft hopefully will get it fixed in the next CU. Thank you!

  • Verified answer
    EkinGuner Profile Picture
    EkinGuner 35 on at
    RE: Error while deploying NAV DB from SQL to Azure SQL

    Hello,

    I've just removed SQL view called "deadlock_report_ring_buffer_view" from the database and successfully imported the DB, I've read some articles and apparently azure deals with deadlock by itself already. However, I don't know what the outcome will be.

    Regards,

    Ekin

  • EkinGuner Profile Picture
    EkinGuner 35 on at
    RE: Error while deploying NAV DB from SQL to Azure SQL

    I think it is related to the newest CU's, I've tried CU 14 and 15, both Demo Databases having the same issue while importing to Azure SQL. I've tried CU 6 and I was able to import it without any issue. The problem is I cannot downgrade because I just upgraded from CU 6 to CU 14. Its been 2 weeks and a lot of new data is already in.

  • RE: Error while deploying NAV DB from SQL to Azure SQL

    I have the exact same problem with a Business Central CU03 Cronus database. Haven't found a solution yet.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans