Danam Fiji has upgraded Linksoft from V9 to V13.

They use the following TNA Method: 

1. Device:
   1. TI001 - HP IIngersoll Rand HP3000e (File)
   2. The locations of the respective folder are: 
   3. FileWatchLocation: D:\Timesheet\Watch
   4. FileProcessingLocation: D:\Timesheet\Processing
   5. FileCompletedLocation: D:\Timesheet\Completed
2. Process: ESS021 is set to run every 10 minutes
3. TNA Setup - the below Rules are Running
   1. A001 – Timesheet processing rules
   2. A002 – Use a "Time Buffer" when calculating "timesheet" hours
   3. R003 – Change multiple clock type "IN" to clock type "BREAK IN" for entries in a day. Shift "Start Time", "Buffer" settings are used to determine a day.
      For Example:
      1. Shift A starts at 8am, "Time Buffer" has 15 minutes before start and "New Entry Hours Buffer" is 19 hours, then a day is from 7:45am to 3:00am (next day)
      2. Shift B starts at 8pm and "Time Buffer" has 60 minutes before start and "New Entry Hours Buffer" is 19 hours, then a day is from 7:00pm to 3:00pm (next day)
   4. R004 – Approve time entries submitted from "Timesheet"
   5. R008 – Do not import timesheet entries for "Non-Timesheet" employees into payroll
   6. R009 – Mark entries exceeding maximum hours configuration as invalid

Issue:

1. The TNA file was placed in the Watch folder
2. Process ESS021 was executed successfully
3. The file moved from the Watch to the Processing folder
4. The file was stuck in the Processing folder
5. Upon verifying the event log – 2 errors were noted:
   1. Module: LT_ESS_TimesheetImport_Compute
      Error: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.
   2. Module: LBS_POS_Customer_All_Update
      Error: Cannot insert the value NULL into column 'Code', table 'LINKSOFT.dbo.LBS_POS_Customer_all'; column does not allow nulls. INSERT fails.

Notes:

1. These errors were not found in the training database in UAT
2. There was a patch executed as part of Case: T13988, Subject: Submitting a days TNA Record Times Out  – after that several files were imported and they were imported successfully

Environment Details: 

1. LinkQA8
2. Version: 13.40.0621.GA
3. URL: http://10.0.0.18/LinkWEB-Danam
4. Login: standard "admin" login
5. Files in Watch Folder
6. Moved to Process Folder
7. Upon verifying the event log – 2 errors were noted:
   1. Module: LT_ESS_TimesheetImport_Compute - Error: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.
   2. Module: LBS_POS_Customer_All_Update - Error: Cannot insert the value NULL into column 'Code', table 'LINKSOFT.dbo.LBS_POS_Customer_all'; column does not allow nulls. INSERT fails.

Meeting with Sanjay and Aarti

Error 1: Module: LT_ESS_TimesheetImport_Compute
Error: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.

Discussed: Sanjay has taken a trace of this error. He advised that he would rectify this and update

Error 2: Module: LBS_POS_Customer_All_Update
Error: Cannot insert the value NULL into column 'Code', table 'LINKSOFT.dbo.LBS_POS_Customer_all'; column does not allow nulls. INSERT fails.

Discussed: The customer table for POS and ESS are the same. Sanjay is looking at how best to handle this.