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