Welcome to Kofax RPA > Management Console > Management Console Configuration and User Interface > Admin > Settings > RoboServer Log Database > Scripts for Creating Database Tables

Scripts for Creating Database Tables

The SQL scripts for creating and dropping tables in your database are located in the documentation\sql directory in your Kofax RPA installation directory. For example, C:\Program Files (x86)\Kofax RPA 11.0.0 x32\documentation\sql on the Windows system. The name of the script file includes the name of the database the script is intended for.

Note SQL scripts are installed together with Kofax RPA documentation and if you install Design Studio.
SQL Scripts for Database Tables

The sql directory contains four subdirectories with different scripts as follows:

  • altosoftsession: Scripts for creating and dropping tables for single sign on with Altosoft
  • logdb: Scripts for creating and dropping logdb tables
  • mc: Scripts for creating and dropping Management Console tables
  • statistics: Scripts for creating and dropping statistics tables required for producing reports in Kofax Analytics for RPA.

Important The IBM DB2 database must have a table space with a page size of at least 8192 KB to create all tables.

The Management Console uses a 3rd party scheduling component called Quartz. Quartz also requires a number of tables which must reside among the other platform tables. These tables are also created automatically when the Management Console starts, or may be created manually using the scripts.

The following is a Quartz verification script. 

select count(*) from QRTZ_SIMPLE_TRIGGERS;
select count(*) from QRTZ_BLOB_TRIGGERS;
select count(*) from QRTZ_CRON_TRIGGERS;
select count(*) from QRTZ_TRIGGER_LISTENERS;
select count(*) from QRTZ_CALENDARS;
select count(*) from QRTZ_FIRED_TRIGGERS;
select count(*) from QRTZ_LOCKS;
select count(*) from QRTZ_PAUSED_TRIGGER_GRPS;
select count(*) from QRTZ_SCHEDULER_STATE;
select count(*) from QRTZ_JOB_LISTENERS;
select count(*) from QRTZ_TRIGGERS;
select count(*) from QRTZ_JOB_DETAILS;