You’re offline. This is a read only version of the page.
396
Hi All,
Trust, all are doing well....
We are getting below error while deploying RetailPackage to both UAT and DEV. Could you please suggest how can we resolve this issue?
9/26/2020 7:58:52 AM: ############### Error occurred: ###############
9/26/2020 7:58:52 AM: An error occurred when running the customization script K:\DeployablePackages\bb0677a4-6bdc-4c3d-8fdd-3627f9ad7918\RetailServer\Data\Upgrade\Custom\1_TBL_LOGISTICSPOSTALADDRESS.sql against AxDB. Exception calling "ExecuteSqlText" with "1" argument(s): "The INSERT permission was denied on the object 'DbSyncChangeLog', database 'AxDB', schema 'dbo'. Near statement: IF (SELECT OBJECT_ID('[ext].[LOGISTICSPOSTALADDRESS]')) IS NULL
BEGIN
CREATE TABLE [ext].[LOGISTICSPOSTALADDRESS](
[RECID] [bigint] NOT NULL,
[LTARABICSTOREADDRESS] [nvarchar](250) NOT NULL... "
9/26/2020 7:58:52 AM: ############### Error occurred: ###############
9/26/2020 7:58:52 AM: AxDB - An error occurred when deploying customizations for database. Deployment will continue for other databases, but this deployment will be marked as failed.
9/26/2020 7:58:52 AM: ############### Error occurred: ###############
9/26/2020 7:58:52 AM:
PSMessageDetails :
Exception : System.Management.Automation.MethodInvocationException: Exception calling "ExecuteSqlText" with "1" argument(s): "The INSERT permission was denied on the object 'DbSyncChangeLog', database 'AxDB', schema 'dbo'. Near statement: IF (SELECT OBJECT_ID('[ext].[LOGISTICSPOSTALADDRESS]')) IS NULL
BEGIN
CREATE TABLE [ext].[LOGISTICSPOSTALADDRESS](
[RECID] [bigint] NOT NULL,
[LTARABICSTOREADDRESS] [nvarchar](250) NOT NULL... " ---> System.Exception: The INSERT permission was denied on the object 'DbSyncChangeLog', database 'AxDB', schema 'dbo'. Near statement: IF (SELECT OBJECT_ID('[ext].[LOGISTICSPOSTALADDRESS]')) IS NULL
BEGIN
CREATE TABLE [ext].[LOGISTICSPOSTALADDRESS](
[RECID] [bigint] NOT NULL,
[LTARABICSTOREADDRESS] [nvarchar](250) NOT NULL... ---> System.Data.SqlClient.SqlException: The INSERT permission was denied on the object 'DbSyncChangeLog', database 'AxDB', schema 'dbo'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Dynamics365.Commerce.Tools.DacValidator.Database.Execute(IDictionary parameters, String[] sqlCommands)
--- End of inner exception stack trace ---
at Microsoft.Dynamics365.Commerce.Tools.DacValidator.Database.Execute(IDictionary parameters, String[] sqlCommands)
at CallSite.Target(Closure , CallSite , Object , Object )
--- End of inner exception stack trace ---
at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
Hi Pankaj,
The table DbSyncChangeLog populate temporary during the database synchronization. Usually if you try resume the deployment it works and and complete the deployment successfully.
Regards,
Ram
Share
Report
All responses (
Answers (
