web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Distribution schedule
Microsoft Dynamics AX (Archived)

Distribution schedule

(0) ShareShare
ReportReport
Posted on by Ethan Ong

Anyone can help me with this weird stuff?

This is when I tried to run Distribution schedule after creating new employee with new login password. Recently was due to warning "Multiple register".

Error Message (04:31:09 pm) Cannot execute the required database operation.
The SQL database has issued an error.
Error Message (04:31:09 pm) Object Server 01:
Error Message (04:31:09 pm) [Microsoft][SQL Server Native Client 11.0][SQL Server]Change tracking is not enabled on table
'CUSTPARAMETERS'.
Error Message (04:31:09 pm) INSERT INTO [tempdb]..t101652_76DAC936B46F4E2DBFD846C6232DB73A (REFTABLEID, [PK1], [PK2], PARTITION)
SELECT 67, CT.[KEY_], CT.[DATAAREAID], 5637144576
FROM CHANGETABLE(CHANGES [CUSTPARAMETERS], 13133) AS CT
WHERE CT.SYS_CHANGE_OPERATION = 'D' AND CT.[PARTITION] = 5637144576;
Error Message (04:31:09 pm) session 13 (AdminBRM)
Error Message (04:31:09 pm) Error happened during scheduler job execution. Check infolog for details.
Error Message (04:31:09 pm) Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.
   at Dynamics.Ax.Application.RetailCDXDataSync.sync(Object[] params) in RetailCDXDataSync.sync.xpp:line 85
   at RetailCDXDataSync::sync(Object[] )
   at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
   at Dynamics.Ax.Application.SysDictClass.invokeStaticMethod(Object[] _params) in SysDictClass.invokeStaticMethod.xpp:line 26
   at SysDictClass::invokeStaticMethod(Object[] )
   at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
   at Microsoft.Dynamics.Ax.Xpp.PredefinedFunctions.runAsInvoke(String className, String staticMethodName, Object[] parms, Object[]& exportInfolog)

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Malcolm Burtt Profile Picture
    Malcolm Burtt 1,475 on at

    Hi Ethan

    You don't say whether this had previously been working and has since failed or if this is your first attempt at running the job.

    The CDX synch engine in R3 uses SQL change tracking and this needs to be enabled for each table that is synched. Some solutions also use change tracking for AIF interfaces and there is an AIF method can enable and disable change tracking on a table...but it doesn't take into account whether Retail needs change tracking enabled on that table so we have suffered the problem you are experiencing when some AIF code decided it no longer needed change tracking on tables used by Retail.

    If I remember correctly, running retail Initialise (Retail -> Setup ->Parameters -> Retail Parameters: Initialize button) should fix it.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Did you enable change tracking on the table?

  • Ethan Ong Profile Picture
    Ethan Ong on at

    Hi Malcolm,

    Yes I have initialised it. This is a demo installed but currently I had created new employee and assigned to Seattle outlet. - USRT.

    What I did was created job assigned to position and associate to the employee.

    What comes next was to run the distribution schedule the job is 1060 Staff - and I set to Bilateral instead of download.

    Once I did, the staff exist.

    However I encounter the issue when comes to multiple registry.

    I had enabled the POS permission as Manager which allows multiple registry.

    But is still not working....

    Any other configuration I had missed out?

  • Ethan Ong Profile Picture
    Ethan Ong on at

    Currently I just realised after Distribution Schedule I tried all staff (including demo) encounter the same issue with "multiple registry issue". What did I do? I am not sure. ;(

  • Clive Richard Profile Picture
    Clive Richard on at

    Run Generate Classes on the Retail Schema (Retail Scheduler > Retail Schema) for AX2012 R3 (which ever AX version You are in) and then initialize and run the Job again.

  • Community Member Profile Picture
    Community Member on at

    Thank you very much!

    It runs for me.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Volodya Profile Picture

Volodya 2

#2
tgudwanski Profile Picture

tgudwanski 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans