Error while importing the Azure DB to Cloud Hosted Environment

Error while importing the Azure DB to Cloud Hosted Environment

Error while importing the Azure DB to Cloud Hosted Environment, Error while importing .bacpac file

*** Error importing database:Could not import package.
Error SQL72014: .Net SqlClient Data Provider: Msg 208, Level 16, State 1, Procedure SYSSQLRESOURCESTATSVIEW, Line 1 Invalid object name 'sys.dm_db_resource_stats'.
Error SQL72045: Script execution error. The executed script:
CREATE VIEW SYSSQLRESOURCESTATSVIEW
AS
SELECT 1010 AS RECID,
end_time AS ENDTIME,
avg_cpu_percent AS AVGCPUPERCENT,
avg_data_io_percent AS AVGDATAIOPERCENT,
avg_log_write_percent AS AVGLOGWRITEPERCENT,
avg_memory_usage_percent AS AVGMEMUSAGEPERCENT,
xtp_storage_percent AS XTPSTORAGEPERCENT,
max_worker_percent AS MAXWORKERPERCENT,
max_session_percent AS MAXSESSIONPERCENT,
dtu_limit AS DTULIMIT
FROM sys.dm_db_resource_stats;

Error Message:

Error SQL72014: Core .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Procedure AXPerf_UpdateStats, Line 1 Invalid column name 'has_persisted_sample'.

Error SQL72045: Script execution error.  The executed script:

CREATE PROCEDURE AXPerf_UpdateStats

@ExecuteStats BIT=1

Cause: PROCEDURE AXPerf_UpdateStats.

Resolution: Drop PROCEDURE AXPerf_UpdateStats.

On the Environment where you are taking the backup UAT, please kindly follow the steps mentioned or run the script with 2 queries below, then move on with steps 2-4:

a. Find the Stored Procedure in the DB tree -> AX database (name depending per customer) -> Programmability -> Stored Procedures – search for 'AXPerf_UpdateStats'

b. Right click on it -> “Script Stored Procedure as” -> CREATE TO -> New Query Editor Window;  Then backup the script to a file (CTRL+S).

c. Run the following query after point (b.) : DROP PROCEDURE AXPerf_UpdateStats;

Happy D365FO!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit