Configure the Analyst Service to specify a single audit database for exception management tasks.
An exception management task is an instance of a Human task. When you run a workflow that contains a Human task, the Data Integration Service that the Analyst Service specifies creates instances of the Human task. Analyst tool users can update the data in the task instances. The exception management audit database stores a record of the work that the Analyst tool users perform.
To configure the audit database, identify a database connection and a schema for the audit tables. Set the options on the Human task properties of the Analyst Service in the Administrator tool. Or, run the infacmd as updateServiceOptions command.
If you run infacmd as updateServiceOptions, set the following options:
After you set the connection name and schema, create the audit database contents. To create the database contents, use the
menu options for the Analyst Service in the Administrator tool, Or, run the infacmd as createExceptionAuditTables command.
You can also use the
menu options to delete the database contents. Or, you can run the infacmd as deleteExceptionAuditTables command.
If you specify a connection and schema and you do not create the database contents, Analyst tool users cannot open the task instances.
If you do not specify a connection and schema, the Analyst Service creates audit tables for each task instance in the database that stores the task instance data. If the Human task data resides in multiple databases, the Analyst Service writes the audit data to the respective databases.