Corrupt Employee Card
I have run a TANDA export to MYOB and one employee failed - I have gone into MYOB and the employee file is corrupt and the system shuts down when I try to go into that employee. It doesn't do it for other employees. Can someone please run the script to fix this.
Here is the errorlog
AccountRight Application Error Report
=====================================
Application Version: 2024.2.1.3
Application File Version: 2024.2.1.3
Incident Id: a259c99a-4a8d-45e5-bff6-0551079a9373
Time: Monday, 25 March 2024 11:54:42 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 = 3092
at mscorlib!0x0600586c!System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27
at mscorlib!0x06005877!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1b3
at Huxley.Service.Gateway!0x06001a2d!MYOB.Huxley.Service.Gateway.API.IGatewayService.Dispatch(String name, Object[] arguments)
at Huxley.Service.Proxy!0x06000339!MYOB.Huxley.Service.Proxy.Services.ProxyCardContainerService.GetContainerObjectByType(IEnumerable`1 objectSetVersions, CardType cardType, Int32 id) +0x0
at Huxley.UI.Decorators!0x06002af5!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!0x0600405f!MYOB.Huxley.UI.Model.Context.CardContext.<>c__DisplayClass7_0.<GetContainerObjectByType>b__0() +0x0
at Huxley.UI.Model!0x06003adc!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x60
at Huxley.UI.Model!0x06003845!MYOB.Huxley.UI.Model.Context.CardContext.GetContainerObjectByType(CardType cardType, Int32 id) +0x34
at Huxley.UI.Controllers!0x060021de!MYOB.Huxley.UI.Controllers.Cards.CardDetailController.GetDataObject() +0x0
at Huxley.UI.Controllers!0x0600117d!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33
at Huxley.UI.Forms!0x06001bcc!MYOB.Huxley.UI.Forms.Cards.DetailContainers.CardDetail.SetupContainer() +0x63
at Huxley.UI.Forms!0x060026c8!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1e9
at Huxley.UI.Forms!0x06002721!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x228
at Huxley.UI.Forms!0x0600271d!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xa
at Huxley.UI.Forms!0x0600235a!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.InitializeForm(UIViewType ViewType, IUIViewPresenter uiViewPresenter, String containerResourceID, IUICompanyFile companyFile, EntityInfo eInfo, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x122
at Huxley.UI.Framework!0x06000175!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x88
at Huxley.UI.Framework!0x06000174!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.Show(IUIViewPresenter presenter, UIViewType viewType, Boolean showDialog, EntityInfo eInfo, IUIContext context, Boolean visible, BeginNotificationRefreshMethod refreshMethod) +0xaa
at Huxley.UI.Framework!0x06000193!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0x4a
--- End of inner exception stack trace ---
at Huxley.UI.Framework!0x06000193!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0xa3
at Huxley.UI.Forms!0x06001a6e!MYOB.Huxley.UI.Forms.Cards.CardsGrid.OnCustomNavigationEvent(UIViewType uiViewType, EntityInfo eInfo, Boolean showAsDialog, BeginNotificationRefreshMethod refreshMethod) +0x0
at Huxley.UI.Forms!0x060026dd!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.RaiseNavigationEvent(UIViewType uiViewType, EntityInfo eInfo, Boolean showAsDialog, Boolean causeRefresh) +0x33
at Huxley.UI.Forms!0x06001aa4!MYOB.Huxley.UI.Forms.Cards.CardsGrid.LaunchDetail(UICardSummary editCard) +0x3b
at Huxley.UI.Forms!0x06001a7a!MYOB.Huxley.UI.Forms.Cards.CardsGrid.grdvCardsList_DrillDownClicked(Object sender, DrilldownClickedArgs e) +0x16
at Huxley.UI.Controls!0x0600047e!MYOB.Huxley.UI.Controls.External.ExtGridView.InvokeDrillDownClicked(Object row) +0x21
at Huxley.UI.Controls!0x060004a2!MYOB.Huxley.UI.Controls.External.ExtGridView.ExtGridView_Click(Object sender, EventArgs e) +0xe8
at DevExpress.XtraGrid.v17.1!0x060004a5!DevExpress.XtraGrid.Views.Base.BaseView.RaiseClick(EventArgs e) +0x19
at DevExpress.XtraGrid.v17.1!0x06000117!DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnClick(MouseEventArgs ev) +0x7
at DevExpress.Utils.v17.1!0x06002738!DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args) +0x8e
at DevExpress.XtraGrid.v17.1!0x060000e8!DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.ProcessEvent(EventType etype, Object args) +0x22
at DevExpress.XtraGrid.v17.1!0x0600216d!DevExpress.XtraGrid.GridControl.OnClick(EventArgs ev) +0x33
at System.Windows.Forms!0x06000f04!System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) +0xf2
at System.Windows.Forms!0x06000f14!System.Windows.Forms.Control.WndProc(Message& m) +0x49f
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!0x0600572a!System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) +0x0
at System.Windows.Forms!0x0600572d!System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) +0x8e
at System.Windows.Forms!0x06002df3!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=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:c1a55a0db83f4aa69e7696034a1118e4; A:1
MODULE: Huxley.Service.Proxy => Huxley.Service.Proxy, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:ca56ab238f8f4935bf40e5e37732ee02; A:1
MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:20971d0ee6c140cdb9cbe7614dd6ff4c; A:1
MODULE: Huxley.UI.Controls => Huxley.UI.Controls, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:9de0d53070f44330931b26ea439b4a8b; A:1
MODULE: Huxley.UI.Decorators => Huxley.UI.Decorators, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:3e84abe4f4af413d9bb6b35a2677b0c6; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:221a66c1577647d988c8d366fb1b6d68; A:1
MODULE: Huxley.UI.Framework => Huxley.UI.Framework, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:bbf1a4d2e9d7487f89246e39f6b32372; A:1
MODULE: Huxley.UI.Model => Huxley.UI.Model, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:0a743ceb90de4e88b2e27504d37e8f35; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:7dc184f4902d4b6fa44f3e6eaeed3dfe; A:2
MODULE: System.Windows.Forms => System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:543c9eec2a3d4078aab81f89e0020776; A:1
----------------------------------------
2 : MYOB.Huxley.API.HuxleyApplicationException
----------------------------------------
MYOB.Huxley.API.HuxleyApplicationException: (DataNotUniqueError): More than one EmployeePayrollDetails exists for employeeId = 3092
at mscorlib!0x0600586c!System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27
at mscorlib!0x06005877!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1b3
at Huxley.Service.Gateway!0x06001a2d!MYOB.Huxley.Service.Gateway.API.IGatewayService.Dispatch(String name, Object[] arguments)
at Huxley.Service.Proxy!0x06000339!MYOB.Huxley.Service.Proxy.Services.ProxyCardContainerService.GetContainerObjectByType(IEnumerable`1 objectSetVersions, CardType cardType, Int32 id) +0x0
at Huxley.UI.Decorators!0x06002af5!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!0x0600405f!MYOB.Huxley.UI.Model.Context.CardContext.<>c__DisplayClass7_0.<GetContainerObjectByType>b__0() +0x0
at Huxley.UI.Model!0x06003adc!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x60
at Huxley.UI.Model!0x06003845!MYOB.Huxley.UI.Model.Context.CardContext.GetContainerObjectByType(CardType cardType, Int32 id) +0x34
at Huxley.UI.Controllers!0x060021de!MYOB.Huxley.UI.Controllers.Cards.CardDetailController.GetDataObject() +0x0
at Huxley.UI.Controllers!0x0600117d!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33
at Huxley.UI.Forms!0x06001bcc!MYOB.Huxley.UI.Forms.Cards.DetailContainers.CardDetail.SetupContainer() +0x63
at Huxley.UI.Forms!0x060026c8!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1e9
at Huxley.UI.Forms!0x06002721!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x228
at Huxley.UI.Forms!0x0600271d!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xa
at Huxley.UI.Forms!0x0600235a!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.InitializeForm(UIViewType ViewType, IUIViewPresenter uiViewPresenter, String containerResourceID, IUICompanyFile companyFile, EntityInfo eInfo, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x122
at Huxley.UI.Framework!0x06000175!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x88
at Huxley.UI.Framework!0x06000174!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.Show(IUIViewPresenter presenter, UIViewType viewType, Boolean showDialog, EntityInfo eInfo, IUIContext context, Boolean visible, BeginNotificationRefreshMethod refreshMethod) +0xaa
at Huxley.UI.Framework!0x06000193!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0x4a
==========
MODULE: Huxley.Service.Gateway => Huxley.Service.Gateway, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:c1a55a0db83f4aa69e7696034a1118e4; A:1
MODULE: Huxley.Service.Proxy => Huxley.Service.Proxy, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:ca56ab238f8f4935bf40e5e37732ee02; A:1
MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:20971d0ee6c140cdb9cbe7614dd6ff4c; A:1
MODULE: Huxley.UI.Decorators => Huxley.UI.Decorators, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:3e84abe4f4af413d9bb6b35a2677b0c6; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:221a66c1577647d988c8d366fb1b6d68; A:1
MODULE: Huxley.UI.Framework => Huxley.UI.Framework, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:bbf1a4d2e9d7487f89246e39f6b32372; A:1
MODULE: Huxley.UI.Model => Huxley.UI.Model, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:0a743ceb90de4e88b2e27504d37e8f35; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:7dc184f4902d4b6fa44f3e6eaeed3dfe; A:2
Thank you.