Partner Zone
Partner Zone

AE System Release Keeps Crashing - Since 2019 Update

Highlighted
IT_Dan_The_Man
4 Posts
User
IT_Dan_The_Man

4Posts

0Kudos

0Solutions

AE System Release Keeps Crashing - Since 2019 Update

Hi All,

 

We've been having issues with all users with MYOB AE's System Release crashing.

 

On the SQL Server, we're getting the following error each time system release closes unexpectingly.

 

MYOB ISSUE.PNG

 

This has been happening since the 2019 update a few weeks ago. Has anybody else come across this issue?

 

6 REPLIES 6
Super Partner Will_SolnX
763 Posts
Super Partner
New Zealand
Will_SolnX
Super Partner

763Posts

110Kudos

28Solutions

Re: AE System Release Keeps Crashing - Since 2019 Update

Hi @IT_Dan_The_Man ,

 

That Error screenshot doesn't seem to have come through correctly.  Can you try posting again?

 

(Note, I don't know AE at all, but I know Delphi apps, and I know MS SQL Server, so I might be able to help from general knowledge).

IT_Dan_The_Man
4 Posts
User
IT_Dan_The_Man

4Posts

0Kudos

0Solutions

Re: AE System Release Keeps Crashing - Since 2019 Update

Hi Will,


I've attached it to this post now.


Cheers

MYOB ISSUE.PNG
Super Partner Will_SolnX
763 Posts
Super Partner
New Zealand
Will_SolnX
Super Partner

763Posts

110Kudos

28Solutions

Re: AE System Release Keeps Crashing - Since 2019 Update

Hmm, unfamilair to me, though my general read is that it's disconnecting people for being inactive.  Is there a new profile setting around idle timeouts maybe?

MYOB Moderator MattN
725 Posts
MYOB Moderator
MattN
MYOB Moderator

725Posts

97Kudos

92Solutions

Re: AE System Release Keeps Crashing - Since 2019 Update

Hi @IT_Dan_The_Man,

 

there were no updates between 2018.1 and 2019.0 for the System Release application. 

 

The error you are seeing would indicate that the SR-DAL application (which provides a SQL database access to the System Release based applications) is no longer able to "talk" to the application at the specific IP address, and it terminated without closing the tables that it opened.

 

This would indicate that it crashed when (most likely) a Tax ledger was open.

 

To help troubleshoot the issue, I have some questions :

  • Does this occur on all workstations, or only the one?
  • Does it occur when you log into Windows as another user?
  • Does it happen when you launch System Release directly from the System Release folder (M:\SOL64 or equivalent, or MYOBAE\AESQL\TAX)

If this occurs for all users on this workstation, but no other workstations, then I would suggest performing a workstation uninstall, then reinstall (with AV off) to allow the installer to correctly register required DLLs etc.

 

If this is occuring for all users from all workstations, then it could be caused by something different - answers to the above would be helpful.

 

 


cheers,

Matt
Product and Technical Specialist
Practice Solutions
MYOB Australia Pty Ltd
IT_Dan_The_Man
4 Posts
User
IT_Dan_The_Man

4Posts

0Kudos

0Solutions

Re: AE System Release Keeps Crashing - Since 2019 Update

Hi @MattN 

 

It's happening for all users when they're editing properties on a client file. They will be in the client updating different fields and then the system release window will crash without error. That error I've attached will then show up in the event view logs on the sql server, not each individual endpoint.

MYOB Moderator MattN
725 Posts
MYOB Moderator
MattN
MYOB Moderator

725Posts

97Kudos

92Solutions

Re: AE System Release Keeps Crashing - Since 2019 Update

Hi @IT_Dan_The_Man 

 

Can you be a bit more specific about what is being edited?

 

Are you using AE Framework?  or is your site a System Release only site?

How are your users editing this client information?  What specific information is being changed?

 

by default, updating client info, such as Names, Addresses etc do not open system release (when changing these details in AE Framework)

 

I am fully aware that the error you showed is from the SQL server - and SR-DAL will report those types of errors, whenever a workstation is forcibly closed (either because of a system crash, or the machine being turned off etc, because SR-DAL expects to receive a "close tables" type of command once work is completed.

 

What specific errors show in the event logs on the actual workstations when System Release crashes?

What other windows updates have been installed recently?

What version of Tax did you upgrade from?

What OS is running on the server and workstations?

What version of SQL are you running?

 

The more information you can provide, the more helpful it will be in diagnosing the cause.


cheers,

Matt
Product and Technical Specialist
Practice Solutions
MYOB Australia Pty Ltd
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