MYOBCommunity
Partner Zone
|
|
Partner Zone

"Data Not Unique" Error when trying to amend an employee card

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
LJRyan
3 Posts
Cover User
Australia
LJRyan
Cover User

3Posts

0Kudos

0Solutions

Solved: Go to Solution

"Data Not Unique" Error when trying to amend an employee card

Hi,

I think I need technical support with this issue. I have one employee card that keeps returning an error when I try and open it. Please see below for the error log. Any help or solutions will be greatfully received.

 

Thank you

AccountRight Application Error Report
=====================================
Application Version: 2018.2.20.8598
Application File Version: 2018.2.21.806
Incident Id: e54f9a34-757f-4e40-88fd-94ba3f885f53
Time: Thursday, 10 January 2019 11:45:44 AM

Code:
Unknown (0)


Message:
(Unknown): ShowUIView(CardDetail,...,...)


Stack Trace
----------------------------------------
1 : MYOB.Huxley.API.HuxleyApplicationException
----------------------------------------
MYOB.Huxley.API.HuxleyApplicationException: (Unknown): ShowUIView(CardDetail,...,...) ---> MYOB.Huxley.API.HuxleyApplicationException: (DataNotUniqueError): More than one EmployeePayrollDetails exists for employeeId = 407
at mscorlib!0x060056ec!System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27
at mscorlib!0x060056f7!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1b3
at Huxley.Service.Gateway!0x06000001!MYOB.Huxley.Service.Gateway.API.IGatewayService.Dispatch(String name, Object[] arguments)
at Huxley.Service.Proxy!0x060002af!MYOB.Huxley.Service.Proxy.Services.ProxyCardContainerService.GetContainerObjectByType(IEnumerable`1 objectSetVersions, CardType cardType, Int32 id) +0x0
at Huxley.UI.Decorators!0x060002a2!MYOB.Huxley.UI.Decorators.Services.DecoratorServiceMYOBHuxleyApplicationServicesContainerAPIICardContainerService.MYOB.Huxley.ApplicationServices.Container.API.ICardContainerService.GetContainerObjectByType(IEnumerable`1 objectSetVersions, CardType cardType, Int32 id) +0x54
at Huxley.UI.Model!0x06003bc8!MYOB.Huxley.UI.Model.Context.CardContext.<>c__DisplayClass1.<GetContainerObjectByType>b__0() +0x0
at Huxley.UI.Model!0x060000b3!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x5f
at Huxley.UI.Model!0x060004e9!MYOB.Huxley.UI.Model.Context.CardContext.GetContainerObjectByType(CardType cardType, Int32 id) +0x34
at Huxley.UI.Controllers!0x06001a40!MYOB.Huxley.UI.Controllers.Cards.CardDetailController.GetDataObject() +0x0
at Huxley.UI.Controllers!0x06000066!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33
at Huxley.UI.Forms!0x06001f46!MYOB.Huxley.UI.Forms.Cards.DetailContainers.CardDetail.BindContainer() +0x0
at Huxley.UI.Forms!0x06000009!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1f2
at Huxley.UI.Forms!0x0600005f!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x248
at Huxley.UI.Forms!0x0600005b!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xa
at Huxley.UI.Forms!0x06000658!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.InitializeForm(UIViewType ViewType, IUIViewPresenter uiViewPresenter, String containerResourceID, IUICompanyFile companyFile, EntityInfo eInfo, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x121
at Huxley.UI.Framework!0x060001b3!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x87
at Huxley.UI.Framework!0x060001b2!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.Show(IUIViewPresenter presenter, UIViewType viewType, Boolean showDialog, EntityInfo eInfo, IUIContext context, Boolean visible, BeginNotificationRefreshMethod refreshMethod) +0xa1
at Huxley.UI.Framework!0x060001d5!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0x69
--- End of inner exception stack trace ---
at Huxley.UI.Framework!0x060001d5!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0xa7
at Huxley.UI.Forms!0x06001e01!MYOB.Huxley.UI.Forms.Cards.CardsGrid.OnCustomNavigationEvent(UIViewType uiViewType, EntityInfo eInfo, Boolean showAsDialog, BeginNotificationRefreshMethod refreshMethod) +0x0
at Huxley.UI.Forms!0x0600001e!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.RaiseNavigationEvent(UIViewType uiViewType, EntityInfo eInfo, Boolean showAsDialog, Boolean causeRefresh) +0x33
at Huxley.UI.Forms!0x06001e37!MYOB.Huxley.UI.Forms.Cards.CardsGrid.LaunchDetail(UICardSummary editCard) +0x3d
at Huxley.UI.Forms!0x06001e0d!MYOB.Huxley.UI.Forms.Cards.CardsGrid.grdvCardsList_DrillDownClicked(Object sender, DrilldownClickedArgs e) +0x16
at Huxley.UI.Controls!0x06000597!MYOB.Huxley.UI.Controls.External.ExtGridView.InvokeDrillDownClicked(Object row) +0x23
at Huxley.UI.Controls!0x06000592!MYOB.Huxley.UI.Controls.External.ExtGridView.ExtGridView_DoubleClick(Object sender, EventArgs e) +0x56
at DevExpress.XtraGrid.v17.1!0x060004a6!DevExpress.XtraGrid.Views.Base.BaseView.RaiseDoubleClick(EventArgs e) +0x19
at DevExpress.XtraGrid.v17.1!0x06000118!DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnDoubleClick(MouseEventArgs ev) +0x7
at DevExpress.Utils.v17.1!0x06002738!DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args) +0x9f
at DevExpress.XtraGrid.v17.1!0x060000e8!DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.ProcessEvent(EventType etype, Object args) +0x22
at DevExpress.XtraGrid.v17.1!0x0600216e!DevExpress.XtraGrid.GridControl.OnDoubleClick(EventArgs ev) +0xb3
at System.Windows.Forms!0x06000e58!System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) +0x13c
at System.Windows.Forms!0x06000e68!System.Windows.Forms.Control.WndProc(Message& m) +0x4e2
at DevExpress.XtraEditors.v17.1!0x06001445!DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m) +0x67
at DevExpress.XtraGrid.v17.1!0x0600214e!DevExpress.XtraGrid.GridControl.WndProc(Message& m) +0xbb
at System.Windows.Forms!0x06005502!System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) +0x0
at System.Windows.Forms!0x06005505!System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) +0x8e
at System.Windows.Forms!0x06002cd8!System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) +0x25
==========
MODULE: DevExpress.Utils.v17.1 => DevExpress.Utils.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:b8c34c059b804930811d5f6d50999b6c; A:1
MODULE: DevExpress.XtraEditors.v17.1 => DevExpress.XtraEditors.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6df94e55f5bd4444b910d4b2a37076a4; A:1
MODULE: DevExpress.XtraGrid.v17.1 => DevExpress.XtraGrid.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6a6f2858c181409aa7c4eb6bd501ac5f; A:1
MODULE: Huxley.Service.Gateway => Huxley.Service.Gateway, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:ab04cd8294a04273b81ae660652f4d4d; A:1
MODULE: Huxley.Service.Proxy => Huxley.Service.Proxy, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:7d10411c1bac4e17bc9453afb465e5cc; A:1
MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:78bcd4898b8248e6997dee412557d9e0; A:1
MODULE: Huxley.UI.Controls => Huxley.UI.Controls, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:a474b636e70c40139938430601b3fc5d; A:1
MODULE: Huxley.UI.Decorators => Huxley.UI.Decorators, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:2c1a001a76d24dc294ccdc2fe9424642; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:eccb8ea2d6d948a49d7f5dc1fac5c65c; A:1
MODULE: Huxley.UI.Framework => Huxley.UI.Framework, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:aa626a781b5d4c0da480a2aaec9ce891; A:1
MODULE: Huxley.UI.Model => Huxley.UI.Model, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:dd8ecb68a2ea401c8560da7b71b1d309; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:8903d6559b1f47bfb7410ed669ce5593; A:2
MODULE: System.Windows.Forms => System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:07667ddda7a34870953e6ec99264e277; A:1

----------------------------------------

2 : MYOB.Huxley.API.HuxleyApplicationException
----------------------------------------
MYOB.Huxley.API.HuxleyApplicationException: (DataNotUniqueError): More than one EmployeePayrollDetails exists for employeeId = 407
at mscorlib!0x060056ec!System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27
at mscorlib!0x060056f7!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1b3
at Huxley.Service.Gateway!0x06000001!MYOB.Huxley.Service.Gateway.API.IGatewayService.Dispatch(String name, Object[] arguments)
at Huxley.Service.Proxy!0x060002af!MYOB.Huxley.Service.Proxy.Services.ProxyCardContainerService.GetContainerObjectByType(IEnumerable`1 objectSetVersions, CardType cardType, Int32 id) +0x0
at Huxley.UI.Decorators!0x060002a2!MYOB.Huxley.UI.Decorators.Services.DecoratorServiceMYOBHuxleyApplicationServicesContainerAPIICardContainerService.MYOB.Huxley.ApplicationServices.Container.API.ICardContainerService.GetContainerObjectByType(IEnumerable`1 objectSetVersions, CardType cardType, Int32 id) +0x54
at Huxley.UI.Model!0x06003bc8!MYOB.Huxley.UI.Model.Context.CardContext.<>c__DisplayClass1.<GetContainerObjectByType>b__0() +0x0
at Huxley.UI.Model!0x060000b3!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x5f
at Huxley.UI.Model!0x060004e9!MYOB.Huxley.UI.Model.Context.CardContext.GetContainerObjectByType(CardType cardType, Int32 id) +0x34
at Huxley.UI.Controllers!0x06001a40!MYOB.Huxley.UI.Controllers.Cards.CardDetailController.GetDataObject() +0x0
at Huxley.UI.Controllers!0x06000066!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33
at Huxley.UI.Forms!0x06001f46!MYOB.Huxley.UI.Forms.Cards.DetailContainers.CardDetail.BindContainer() +0x0
at Huxley.UI.Forms!0x06000009!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1f2
at Huxley.UI.Forms!0x0600005f!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x248
at Huxley.UI.Forms!0x0600005b!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xa
at Huxley.UI.Forms!0x06000658!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.InitializeForm(UIViewType ViewType, IUIViewPresenter uiViewPresenter, String containerResourceID, IUICompanyFile companyFile, EntityInfo eInfo, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x121
at Huxley.UI.Framework!0x060001b3!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x87
at Huxley.UI.Framework!0x060001b2!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.Show(IUIViewPresenter presenter, UIViewType viewType, Boolean showDialog, EntityInfo eInfo, IUIContext context, Boolean visible, BeginNotificationRefreshMethod refreshMethod) +0xa1
at Huxley.UI.Framework!0x060001d5!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0x69
==========
MODULE: Huxley.Service.Gateway => Huxley.Service.Gateway, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:ab04cd8294a04273b81ae660652f4d4d; A:1
MODULE: Huxley.Service.Proxy => Huxley.Service.Proxy, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:7d10411c1bac4e17bc9453afb465e5cc; A:1
MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:78bcd4898b8248e6997dee412557d9e0; A:1
MODULE: Huxley.UI.Decorators => Huxley.UI.Decorators, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:2c1a001a76d24dc294ccdc2fe9424642; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:eccb8ea2d6d948a49d7f5dc1fac5c65c; A:1
MODULE: Huxley.UI.Framework => Huxley.UI.Framework, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:aa626a781b5d4c0da480a2aaec9ce891; A:1
MODULE: Huxley.UI.Model => Huxley.UI.Model, Version=2018.2.20.8598, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:dd8ecb68a2ea401c8560da7b71b1d309; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:8903d6559b1f47bfb7410ed669ce5593; A:2

----------------------------------------

 

 

5 REPLIES 5
Super Partner Will_Focus
751 Posts
Super Partner
New Zealand
Will_Focus
Super Partner

751Posts

106Kudos

26Solutions

Re: "Data Not Unique" Error when trying to amend an employee card

Hi @LJRyan,

 

You could try deleting any standard pay information you have set up, it seems to be saying that they've got 2+ sets of Payroll information and AccountRight has gotten badly confused:

More than one EmployeePayrollDetails exists for employeeId = 407

MYOB Moderator Neil_M
11,034 Posts
MYOB Moderator
Neil_M
MYOB Moderator

11034Posts

1251Kudos

1555Solutions

Re: "Data Not Unique" Error when trying to amend an employee card

Hi @LJRyan

 

This error can sometimes be caused by adding an entitlement to an employee’s card during the pay run itself rather than through the card file.

 

That being said we do have a script that we can run over the file that is designed to correct this error. To be able to do so we need you to confirm the following:

 

File location: Is the file online or stored locally?

What are the last 4 digits of the serial number

What is the company file ID number (found under Help >> About)

Regards,
Neil

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

LJRyan
3 Posts
Cover User
Australia
LJRyan
Cover User

3Posts

0Kudos

0Solutions

Re: "Data Not Unique" Error when trying to amend an employee card

Thank you Neil, thank would be great if you could correct it.

The file is online.

The last 4 digits of the serial number are 3070

The Company File ID is 1

 

Kind Regards,

Loretta Ryan

MYOB Moderator Neil_M
11,034 Posts
MYOB Moderator
Neil_M
MYOB Moderator

11034Posts

1251Kudos

1555Solutions

Accepted Solution Solved Solution

Re: "Data Not Unique" Error when trying to amend an employee card

Hi @LJRyan

 

Not a problem, I’ve run that script across your company file. So that the script can take full effect, please log out of your company file and restart AccountRight.

 

Tip: to help avoid this error again, please ensure that all payroll entitlements are added to the relevant employee through that employee’s card file.

Regards,
Neil

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

LJRyan
3 Posts
Cover User
Australia
LJRyan
Cover User

3Posts

0Kudos

0Solutions

Re: "Data Not Unique" Error when trying to amend an employee card

Thanks so very much Neil. It's working fine now.

 

Regards

Loretta Ryan

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post