Dynamics Community Forum Thread Details

Canadian Payroll - HR Applicant Hire

We have been using HR with Canadian Payroll for several years. We recently noticed that when we try to hire an applicant, we are receiving the following error:

A save operation on table "uprMstrAddress" (45)

[Microsoft][SQL Server Native Client 10.0][SQL Server]The transaction ended in the trigger. The batch has been aborted.

When I look at the dex log, I am seeing this:

/* Date: 02/08/2013 Time: 15:04:27
stmt(13839280):*/
BEGIN DECLARE @num int EXEC ATUM.dbo.zDP_UPR00102SI '####001', 'PRIMARY', '1 Test Street', '', '', 'Toronto', 'ON', 'M2X 1X1', '', 'Canada', '4161111111', '0000000000', '', '', 0, '', '', '', @num OUT SELECT @num END
/*
/* Date: 02/08/2013 Time: 15:04:27
SQLSTATE:(37000) Native Err:(3609) stmt(13839280):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]The transaction ended in the trigger. The batch has been aborted.*/

/* Date: 02/08/2013 Time: 15:04:27
stmt(13839280):*/
BEGIN INSERT INTO ATUM.dbo.UPR00102 (EMPLOYID, ADRSCODE, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, ZIPCODE, COUNTY, COUNTRY, PHONE1, PHONE2, PHONE3, FAX, Foreign_Address, Foreign_StateProvince, Foreign_Postal_Code, CCode) VALUES ( '#####001', 'PRIMARY', '1 Test Street', '', '', 'Toronto', 'ON', 'M2X 1X1', '', 'Canada', '4161111111', '0000000000', '', '', 0, '', '', '') ; SELECT @@IDENTITY ; END
/*
/* Date: 02/08/2013 Time: 15:04:27
SQLSTATE:(37000) Native Err:(3609) stmt(13839280):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]The transaction ended in the trigger. The batch has been aborted.*/

Any help is appreciated!

Quick Links

Leaderboard