x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 9 replies
  • Subscribers 45 subscribers
  • Views 6196 views
  • Users 0 members are here
Browse Forums
Announcements
152
topics
130
replies
General Discussion
371
topics
735
replies
Sage HRMS Training
139
topics
97
replies
MelanieL

SQL Database Error while calculating Payroll in HRMS.

Posted By

Hello!  I have an issue with calculating payroll and it has existed since I first implemented HRMS two year ago.  Therefore this issue has existed in all 3 versions I have tried.  The last thing support had me try was to completely wipe out my HRMS install, and do a fresh install and then restore my company databases.  I recently did this, installed a new copy of 2015 on a brand new machine, restored my databases from backups, and yet I still have the issue.

The problem is that only master users can calculate payroll.  When a non master user calculates payroll they get this error:  

1 E Employee. Database error (operation=UPDATE, error=523). [Microsoft][SQL
Server Native Client 10.0][SQL Server]A trigger returned a resultset and/or was
running with SET NOCOUNT OFF while another outstanding result set was active.
Please refer this error to your database administrator or see your database
documentation for further assistance.
10:35:08
2 E An error has occurred during the processing of Calculate Payroll. The error returned
was 1202. The operation being performed was a viewUpdate call to Employees.
UpdateEmpEntrySeq-20

I have tried EVERYTHING I can think of.  It is not linked to the security groups, or to a specific company (we have 8 and this happens in all of them).  Has anyone had this happen at all or have any experience with it?  I have had Sage Support look at it 3 times...and even sent them my databases, which they claim were fine on their end.  I'm at a loss and it's really detrimental to me as I have a user that needs to calculate payroll but should not have access to one of the companies that she does when in the master group.

Thank you in advance!

Melanie

Parents
  • 0
    Hello Melanie.

    I'm not sure if this will help but it sounds to me like it's a SQL security problem. We experienced similar errors with calculating payroll for non "master" user's that started in HRMS 2012. We ended up having to create explicit user accounts in SQL Server Management Studio Security , assigning all users to the public and sysadmin server roles, otherwise, calculate pay would not work for us either unless you were a master. I don't know if this is the same message, but it sounds like a similar problem.

    Hope this helps.

    Terry
Reply
  • 0
    Hello Melanie.

    I'm not sure if this will help but it sounds to me like it's a SQL security problem. We experienced similar errors with calculating payroll for non "master" user's that started in HRMS 2012. We ended up having to create explicit user accounts in SQL Server Management Studio Security , assigning all users to the public and sysadmin server roles, otherwise, calculate pay would not work for us either unless you were a master. I don't know if this is the same message, but it sounds like a similar problem.

    Hope this helps.

    Terry
Children

*Community Hub is the new name for Sage City