This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.

Issue

For out of office issues, a good first troubleshooting step is to verify that the configuration that is set up using the K2 management or worklist controls, is properly stored and reflected in the database. The following query pulls information from the tables that house the out of office configuration and presents it in a reader friendly manner for quick verification.

Symptoms

N/A

Troubleshooting Steps

Run the following query against the K2 database:
USE K2 Select 'OOF Setup FOR: [' + [A1].ActionerName + '] TO: [' + [A2].ActionerName + ']' as OOF, '[' + [A1].ActionerName + '] Status is: ' + CASE WHEN [A1].Status = 1 THEN '[OUT of Office]' ELSE '[IN Office]' END as Status From [Server].[Actioner] [A1] Join [Server].[ActionerShare] [AS] On [AS].ActionerID = [A1].[ID] Join [Server].[ActionerShareWorktype] [ASWT] On [ASWT].ActionerShareID = [AS].[ID] Join [Server].[Worktype] [WT] On [WT].[ID] = [ASWT].WorktypeID Join [Server].[WorktypeShare] [WTS] On [WTS].WorktypeID = [WT].[ID] Join [Server].[Actioner] [A2] On [A2].[ID] = [WTS].ActionerID order by OOF
This returns ouput in the following format for quick comparison/reading of the configured out of office settings:

OOF Status
OOF Setup FOR: [K2:DENALLIX\Administrator] TO: [K2:DENALLIX\BOB] [K2:DENALLIX\Administrator] Status is: [IN Office]
OOF Setup FOR: [K2:DENALLIX\Joe] TO: [K2:DENALLIX\BOB] [K2:DENALLIX\Joe] Status is: [OUT of Office]
OOF Setup FOR: [K2:DENALLIX\JONNO] TO: [K2:DENALLIX\Administrator] [K2:DENALLIX\JONNO] Status is: [OUT of Office]
OOF Setup FOR: [K2:DENALLIX\JONNO] TO: [K2:DENALLIX\CODI] [K2:DENALLIX\JONNO] Status is: [OUT of Office]