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 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
Cool working for us
It is amazing to visit your site. Thanks for sharing this information, this is useful to me…
Microsoft Dynamics AX Training
MS Dynamics AX Training
MS Dynamics Training in Hyderabad
Microsoft Dynamics AX Technical Training
Microsoft Dynamics AX Technical Training in Hyderabad
MS Dynamics Technical Online Training
MS Dynamics AX Technical Training in Hyderabad
MS Dynamics AX Online Training
D365 AX Online Training
It's really helpful thanks for sharing. Are you looking for good navision consultant