LP140 Error

 0 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Katy Prince
Advanced Member Send Private Message
Posts: 27
Advanced Member

I get this error when trying to run the LP140:

-------------------------------------------------------------------------------- User:               Job: LP140-4         Queue: ********** -------------------------------------------------------------------------------- BEGIN:  Job Submitted:  Fri Oct 28 13:42:16 2016   Step  1:  LP140 Started. . . . . .:  Fri Oct 28 13:42:17 2016             Token Command. . . . . .:  D:\lsfprod\law\prod\obj\LP140.gnt             Executable Command . . .:  D:\NetExpress51\Base\bin\WIN64\run.exe D:\lsfprod\law\prod\obj\LP140.gnt prod NT00000019 LP140-4 1              Process ID . . . . . . .:  8184             Running as Account . . .:                      Program Messages: ** Creating .prt and .dtl files Processing LP140 - Employee Absence Plan Calculation File PROD/TAEMPTRANS. tsStoreDBRec error is Duplicate record (9).  COMPANY        = 0050  EMPLOYEE       = 000002610  PLAN           = PERSONAL  EMPLOYEE-GROUP = PRS7.5SEPT  POSITION       =  DATE           = 20160502  SEQ-NBR        = 0001 Additional Text is: StoreSqlRec(dbo."TAEMPTRANS") CMsfSPSqlStatement::Execute(INSF0005_V00) -   SQL Server Error Code: 3621, Source: Microsoft OLE DB Provider for SQL Server, Description: The statement has been terminated.   SQL Server Error Code: 2627, Source: Microsoft OLE DB Provider for SQL Server, Description: Violation of PRIMARY KEY constraint 'TTRSET1'. Cannot insert duplicate key in object 'dbo.TAEMPTRANS'.             Elapsed Time . . . . . .:  00:12:54   ERROR:    Stopped On Exit 1.   Elapsed Time:  00:12:55 END:    Job Ended:  Fri Oct 28 13:55:12 2016