/
Invalid Column name error in Time and Attendance

Invalid Column name error in Time and Attendance

Description of Issue

Issue occurs after a refresh. The following error message pops up in the server.log file:

Invalid column name 'add_split_entries_on_top'. [Failed SQL: (207) IF EXISTS

Context
  • Time and Attendance

  • SQL

  • server.log

  • Invalid Column

Cause

Missing values in the database during a refresh or an upgrade cause the error to appear.

Resolution

Upgrade to v2024.1.2 via Tyler Deploy to resolve this error.

Additional Information

 

Related content

Time and Attendance Upgrade failed to v2024.1.1 on Wait for EAR Deployment
Time and Attendance Upgrade failed to v2024.1.1 on Wait for EAR Deployment
More like this
Condensed Timecard View Causing Processing Error
Condensed Timecard View Causing Processing Error
More like this
Time and Attendance Unreachable Due to Locked Database
Time and Attendance Unreachable Due to Locked Database
More like this
SQL error can occur if Workflow Step rule is configured with attributes
SQL error can occur if Workflow Step rule is configured with attributes
More like this
Job Cost Splitting Can Cause A Processing Error If The Start Date Is Not A Valid Value
Job Cost Splitting Can Cause A Processing Error If The Start Date Is Not A Valid Value
More like this
Time and Attendance Processing error Entity with identifier value does not exist
Time and Attendance Processing error Entity with identifier value does not exist
More like this