Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Commerce forum / Getting Error while De...
Commerce forum
Answered

Getting Error while Deploying Retail Package to both UAT and DEV

Posted on by 392

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)

Categories:
  • Verified answer
    Ramshenkar Profile Picture
    Ramshenkar on at
    RE: Getting Error while Deploying Retail Package to both UAT and DEV

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans