ONE Desktop ONE DQ&C ONE MDM ONE RDM ONE Runtime Server
latest (15.4.0) 15.3.0 15.2.0 15.1.0 14.5.x 13.9.x 13.8.x 13.7.x 13.6.x 13.5.0 13.4.x 13.3.x 13.2.x
User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Workflow and Scheduler Database Persistence Tables

This page lists all tables generated by a Workflow, Scheduler, and Notification Handler database persisters to store the Workflow, Scheduler, and Notification Handler log information.

Workflow database tables

WISP_ID_SEQ

Sequence ID generator. Counts workflow executions and adds a new row with each 100 executions and after the server restart.

Starts with value 1 in the first row and continues with the consecutive integer in the following row (that is, 1, 2, 3, and so on). The value in the last row is used to generate IDs of individual workflows that are stored in the WISP_WF_INSTANCES table.

workflow and scheduler database persistence tables WISP ID SEQ

WISP_WF_COMPTASKS

Contains states of the individual compensation tasks that were run when resuming the workflow.

WISP_WF_COMPTASKS example

WISP_WF_DEFERRED

Contains a list of deferred workflows waiting for execution.

WISP-WF-DEFERRED example

WISP_WF_INSTANCES

Contains information about workflow instances. Every workflow execution inserts a row with a unique ID. Other tables use it as a foreign key in the INST_ID column.

WISP-WF-INSTANCES example

WISP_WF_LNKEVAL

Contains states of links between tasks. These values are used to set the correct execution state when the workflow is about to be resumed.

WISP-WF-LNKEVAL example

WISP_WF_LOCVARS

Contains states of local variables in the moment when the workflow execution quits (either successfully or with a failure). These values are used to set the proper execution state when the workflow is resumed.

WISP-WF-LOCVARS example

WISP_WF_TASKS

Contains states of the individual tasks of the workflow.

workflow and scheduler database persistence tables WISP WF TASKS

WISP_ATCM_INLST_DATA_

An inList data table. Serves for fast matching of two large groups of values in a database.

The table is generated automatically by the SQL Layer but is not used by workflows and contains no data.

WISP_ATCM_INLST_TT_

A table with transaction information for the INLST_DATA table. The table is generated automatically by the SQL Layer but is not used by workflows and contains no data.

WISP_DICTIONARY

A generic dictionary table. The table is generated automatically by the SQL Layer but is not used by workflows and contains no data.

Scheduler database Tables

The same prefixes apply to the Notification Handler.

SCHDEF_ID_SEQ

Sequence ID generator. Counts schedule executions and adds a new row with each 100 executions and after the server restart. Starts with value 1 in the first row and continues with the consecutive integer in the following row (that is, 1, 2, 3, and so on). The value in the last row is used to generate IDs of individual schedules that are stored in the SCHDEF_JOB_EXEC_STATE table.

workflow and scheduler database persistence tables WISP ID SEQ

SCHDEF_JOB_EXEC_STATE

Contains information about all schedule executions. Every schedule execution inserts a row with a unique ID.

SCHDEF-JOB-EXEC-STATE example

SCHDEF_ATCM_INLST_DATA_

An inList data table. Serves for fast matching of two large groups of values in a database. The table is generated automatically by the SQL Layer but is not used by the scheduler and contains no data.

SCHDEF_ATCM_INLST_TT_

A table with transaction information for the INLST_DATA table. The table is generated automatically by the SQL Layer but is not used by the scheduler and contains no data.

SCHDEF_DICTIONARY

A generic dictionary table. The table is generated automatically by the SQL Layer but is not used by the scheduler and contains no data.

Was this page useful?