Error viewing calendar: String was not recognised as a valid TimeSpan

This error occurs when trying to open the Individual or Team Calendar. It is often caused by an absence record (or multiple records) not having a start time and/or end time against them.

To identify the erroneous records, follow the steps below.

In the Admin Tool, click Import/export data.
Click Create an export definition.
Click Select the data to export.
From the Database drop-down menu, select Select HR.
Click the SQL tab then delete Select*.
Copy the following SQL data into the blank space:

Select 
  Person.Snapshot.[Informal Name], 
  Person.Snapshot.[Effective Status], 
  Absence.History.[Created Date], 
  Absence.History.[Absence Start Date], 
  Absence.History.[Start Time], 
  Absence.History.[Absence End Date], 
  Absence.History.[End Time], 
  Absence.History.[Total Days], 
  Absence.History.[Total Hours], 
  Absence.History.[Absence Type], 
  Absence.History.Workflow 
From 
  Absence.History 
  Inner Join Person.Snapshot On Person.Snapshot.[Person Number] = Absence.History.[Person Number] 
Where 
  (
    Absence.History.[Start Time] Is Null
  ) 
  Or (
    Absence.History.[End Time] Is Null
  )

Error when creating or amending or deleting the career history record: The current transaction cannot be committed and cannot support operations

Audit: Identify changes made to an Absence History record using an Audit Export in the Admin Tool

Data Export: Pending/Outstanding holiday requests for employees

Error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.

Error: Value cannot be null. Parameter name: first