LP140 Error

 0 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Katy Prince
Advanced Member
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