Posted on
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,
Mail ID: pandit.umesh@hotmail.com
Skype ID: pandit.umesh

3 Replies to “Error while importing the Azure DB to Cloud Hosted Environment”

Leave a Reply

Your email address will not be published. Required fields are marked *