Skip to main content
Skip table of contents

Error: "Cannot insert duplicate key row in object 'dbo.TaxSbrSender_ActivityStatementAgent' ..."

This support note applies to:

  • AO Tax (AU)
  • AE Tax Series 6 & 8 (AU)
  • AE Tax (AU)
Article ID: 38732

In MYOB Accountants Enterprise (AE) and Accountants Office (AO) Tax, you may experience the error "Cannot insert duplicate key row in object 'dbo.TaxSbrSender_ActivityStatementAgent' with unique index 'IX_TaxSbrSender_ActivityStatementAgent_AgentAbn_AgentNumber'. The duplicate key value is (-1, HealthCheck)." in the Server Event Log after installing AE/AO Tax 2017.0.

This issue occurs only affects prefilling and the Activity Statement Lodgement Report (ASLR) homepage where the PLS health check indicator will be red.

To resolve this issue restart the MYOB SBR Sender Server Service. For information on how to restart the SBR Sender Service refer to Restarting the MYOB Tax SBR Sender Server

PLS Lodgment will not be affected by this issue.
MYOB Internal Notes:
This issue may appear for all clients on 2017.0 but only affects Activity Statement pilot clients only. It will not affect the current PLS lodgment.

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.