I am unable to process a payroll that should have been completed hours ago, because an employee card is coming up with an error. This has happened before and I know MYOB need to runa script, however I have been on hold for OVER 2 hours now and am hoping this post might get it solved quicker or 30 staff are going to be very unhappy!
Hi Hayden,
It is working YAY!!! I can't believe I was on hold for nearly 3 hours and got it done quicker on here!!!
Also, do you know what has been affected?
Thank you so much for your help.
Great to hear NatToni
As for what specifically was affected I wouldn't know as the query only returns the COUNT of what was affected not necessarily the details of which record was affected.
That said, what the script does is remove any duplicated background values that might exist where there shouldn't be. You wouldn't be seeing those unless you looked in the background like I did and as this only deletes duplicates you should not have lost any information based on that script.
Hi NatToni
The error you mentioned rings a bell, could you elaborate on what error you get when trying to process Payroll?
If you are getting a "Something's gone wrong" error, this usually contains error details in the Error Log that tells us what's going wrong, if this is indeed the error can you please click View Error Details on the error itself:
If you can copy the details in this log and paste it as a reply to this thread, we can take a look.
Hi Hayden,
Thank you for the prompt response, as I am still on hold. See below error (this also pops up when trying to roll the financial year over because of the employee card).
AccountRight Application Error Report
=====================================
Application Version: 2019.2.22.2609
Application File Version: 2019.2.22.5066
Incident Id: 5ed1b8d1-f9ca-4172-9224-6094bc0f5091
Time: Thursday, 4 July 2019 2:45:33 PM
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 = 1606
at mscorlib!0x0600570f!System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27
at mscorlib!0x0600571a!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1b3
at Huxley.Service.Gateway!0x060017ce!MYOB.Huxley.Service.Gateway.API.IGatewayService.Dispatch(String name, Object[] arguments)
at Huxley.Service.Proxy!0x060002cf!MYOB.Huxley.Service.Proxy.Services.ProxyCardContainerService.GetContainerObjectByType(IEnumerable`1 objectSetVersions, CardType cardType, Int32 id) +0x0
at Huxley.UI.Decorators!0x060029d1!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!0x06003f9a!MYOB.Huxley.UI.Model.Context.CardContext.<>c__DisplayClass3_0.<GetContainerObjectByType>b__0() +0x0
at Huxley.UI.Model!0x06003a28!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x60
at Huxley.UI.Model!0x060037a3!MYOB.Huxley.UI.Model.Context.CardContext.GetContainerObjectByType(CardType cardType, Int32 id) +0x34
at Huxley.UI.Controllers!0x060013f6!MYOB.Huxley.UI.Controllers.Cards.CardDetailController.GetDataObject() +0x0
at Huxley.UI.Controllers!0x060015ca!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33
at Huxley.UI.Forms!0x06002218!MYOB.Huxley.UI.Forms.Cards.DetailContainers.CardDetail.SetupContainer() +0x70
at Huxley.UI.Forms!0x06003130!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1e9
at Huxley.UI.Forms!0x06003188!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x228
at Huxley.UI.Forms!0x06003184!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xa
at Huxley.UI.Forms!0x06002dca!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!0x06000189!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x88
at Huxley.UI.Framework!0x06000188!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.Show(IUIViewPresenter presenter, UIViewType viewType, Boolean showDialog, EntityInfo eInfo, IUIContext context, Boolean visible, BeginNotificationRefreshMethod refreshMethod) +0xa4
at Huxley.UI.Framework!0x060001a7!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0x4a
--- End of inner exception stack trace ---
at Huxley.UI.Framework!0x060001a7!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0xa3
at Huxley.UI.Forms!0x060020ba!MYOB.Huxley.UI.Forms.Cards.CardsGrid.OnCustomNavigationEvent(UIViewType uiViewType, EntityInfo eInfo, Boolean showAsDialog, BeginNotificationRefreshMethod refreshMethod) +0x0
at Huxley.UI.Forms!0x06003145!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.RaiseNavigationEvent(UIViewType uiViewType, EntityInfo eInfo, Boolean showAsDialog, Boolean causeRefresh) +0x33
at Huxley.UI.Forms!0x060020f2!MYOB.Huxley.UI.Forms.Cards.CardsGrid.LaunchDetail(UICardSummary editCard) +0x3b
at Huxley.UI.Forms!0x060020c8!MYOB.Huxley.UI.Forms.Cards.CardsGrid.grdvCardsList_DrillDownClicked(Object sender, DrilldownClickedArgs e) +0x16
at Huxley.UI.Controls!0x06000474!MYOB.Huxley.UI.Controls.External.ExtGridView.InvokeDrillDownClicked(Object row) +0x21
at Huxley.UI.Controls!0x06000498!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!0x06000e58!System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) +0xf2
at System.Windows.Forms!0x06000e68!System.Windows.Forms.Control.WndProc(Message& m) +0x66f
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!0x06005503!System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) +0x0
at System.Windows.Forms!0x06005506!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=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:5ef7241c616c4983b97432ea57b4a1b7; A:1
MODULE: Huxley.Service.Proxy => Huxley.Service.Proxy, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:d1caccd24ab0496f9e22dfb26d066d03; A:1
MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:57bb5c09645147beb154a96202bdf542; A:1
MODULE: Huxley.UI.Controls => Huxley.UI.Controls, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:93f6603aa8e64c4db0b7f963f30641bd; A:1
MODULE: Huxley.UI.Decorators => Huxley.UI.Decorators, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:aa5653f3fbab45c99c013ab6a2f55759; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:bd59ce3997e64164ac8e1bdba5b900e6; A:1
MODULE: Huxley.UI.Framework => Huxley.UI.Framework, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:0cb579c66f9b4e2a92653ede8a39ae5e; A:1
MODULE: Huxley.UI.Model => Huxley.UI.Model, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:9f3797dcda734142bfbdb50ba9c1c509; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:770de44134264924b92f0c55201b01bb; A:2
MODULE: System.Windows.Forms => System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:199b31db99b1448abbbf936be78a06de; A:1
----------------------------------------
2 : MYOB.Huxley.API.HuxleyApplicationException
----------------------------------------
MYOB.Huxley.API.HuxleyApplicationException: (DataNotUniqueError): More than one EmployeePayrollDetails exists for employeeId = 1606
at mscorlib!0x0600570f!System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27
at mscorlib!0x0600571a!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1b3
at Huxley.Service.Gateway!0x060017ce!MYOB.Huxley.Service.Gateway.API.IGatewayService.Dispatch(String name, Object[] arguments)
at Huxley.Service.Proxy!0x060002cf!MYOB.Huxley.Service.Proxy.Services.ProxyCardContainerService.GetContainerObjectByType(IEnumerable`1 objectSetVersions, CardType cardType, Int32 id) +0x0
at Huxley.UI.Decorators!0x060029d1!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!0x06003f9a!MYOB.Huxley.UI.Model.Context.CardContext.<>c__DisplayClass3_0.<GetContainerObjectByType>b__0() +0x0
at Huxley.UI.Model!0x06003a28!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x60
at Huxley.UI.Model!0x060037a3!MYOB.Huxley.UI.Model.Context.CardContext.GetContainerObjectByType(CardType cardType, Int32 id) +0x34
at Huxley.UI.Controllers!0x060013f6!MYOB.Huxley.UI.Controllers.Cards.CardDetailController.GetDataObject() +0x0
at Huxley.UI.Controllers!0x060015ca!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33
at Huxley.UI.Forms!0x06002218!MYOB.Huxley.UI.Forms.Cards.DetailContainers.CardDetail.SetupContainer() +0x70
at Huxley.UI.Forms!0x06003130!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1e9
at Huxley.UI.Forms!0x06003188!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x228
at Huxley.UI.Forms!0x06003184!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xa
at Huxley.UI.Forms!0x06002dca!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!0x06000189!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x88
at Huxley.UI.Framework!0x06000188!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.Show(IUIViewPresenter presenter, UIViewType viewType, Boolean showDialog, EntityInfo eInfo, IUIContext context, Boolean visible, BeginNotificationRefreshMethod refreshMethod) +0xa4
at Huxley.UI.Framework!0x060001a7!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0x4a
==========
MODULE: Huxley.Service.Gateway => Huxley.Service.Gateway, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:5ef7241c616c4983b97432ea57b4a1b7; A:1
MODULE: Huxley.Service.Proxy => Huxley.Service.Proxy, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:d1caccd24ab0496f9e22dfb26d066d03; A:1
MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:57bb5c09645147beb154a96202bdf542; A:1
MODULE: Huxley.UI.Decorators => Huxley.UI.Decorators, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:aa5653f3fbab45c99c013ab6a2f55759; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:bd59ce3997e64164ac8e1bdba5b900e6; A:1
MODULE: Huxley.UI.Framework => Huxley.UI.Framework, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:0cb579c66f9b4e2a92653ede8a39ae5e; A:1
MODULE: Huxley.UI.Model => Huxley.UI.Model, Version=2019.2.22.2609, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:9f3797dcda734142bfbdb50ba9c1c509; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:770de44134264924b92f0c55201b01bb; A:2
----------------------------------------
Thanks for the details NatToni, I knew this rang a bell. This error can be corrected by running a script over the company file.
I'm assuming your company file is online, if so can you please post:
This way I can find the file on the server and be able to run the script over it myself.
Let me know if the file is offline.
Hi Hayden,
The file is online at the moment.
Serial # 6048
Company ID: 15
Please let me know if you need me to close out, or do anything else for you to start this.
