* INFO 2016-01-13 10:02:33,408 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, "idlevel1" integer, "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11), "idlevel3" integer, "uidlevel3" character(11)); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,483 Populate table content rows: 6 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,495 Create index SQL: create unique index in_orgunitstructure_organisationunituid_BI9T7 on _orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,535 Swapped resource table, done: _orgunitstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,628 Create table SQL: create table _categoryoptioncomboname_temp (categoryoptioncomboid integer not null primary key, categoryoptioncomboname varchar(255), approvallevel integer) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,687 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,699 Swapped resource table, done: _categoryoptioncomboname (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,743 Create table SQL: create table _categoryoptiongroupsetstructure_temp (categoryoptioncomboid integer not null, primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,798 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,803 Swapped resource table, done: _categoryoptiongroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,808 Create table SQL: create table _dataelementgroupsetstructure_temp (dataelementid integer not null, dataelementname varchar(230), primary key (dataelementid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,865 Populate table SQL: insert into _dataelementgroupsetstructure_temp select d.dataelementid as dataelementid, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,901 Swapped resource table, done: _dataelementgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,931 Create table SQL: create table _indicatorgroupsetstructure_temp (indicatorid integer not null, indicatorname varchar(230), primary key (indicatorid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,990 Populate table SQL: insert into _indicatorgroupsetstructure_temp select i.indicatorid as indicatorid, i.name as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,994 Swapped resource table, done: _indicatorgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,084 Create table SQL: create table _organisationunitgroupsetstructure_temp (organisationunitid integer not null, organisationunitname varchar(230), primary key (organisationunitid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,152 Populate table SQL: insert into _organisationunitgroupsetstructure_temp select ou.organisationunitid as organisationunitid, ou.name as organisationunitname from organisationunit ou (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,156 Swapped resource table, done: _organisationunitgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,206 Create table SQL: create table _categorystructure_temp (categoryoptioncomboid integer not null, categoryoptioncomboname varchar(230), "default" varchar(230), "l4m2ffDxjH3" character(11), primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,276 Populate table SQL: insert into _categorystructure_temp select coc.categoryoptioncomboid as cocid, coc.name as cocname, (select co.name from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "default", (select co.uid from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "l4m2ffDxjH3" from categoryoptioncombo coc (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,298 Swapped resource table, done: _categorystructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,330 Create table SQL: CREATE TABLE _dataelementstructure_temp (dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(230), datasetid INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(230), datasetapprovallevel INTEGER, periodtypeid INTEGER, periodtypename VARCHAR(230)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,431 Populate table content rows: 2 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,439 Create index SQL: create unique index in_dataelementstructure_dataelementuid_y2cZC on _dataelementstructure_temp(dataelementuid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,495 Create index SQL: create index in_dataelementstructure_datasetid_xG9KQ on _dataelementstructure_temp(datasetid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,560 Create index SQL: create index in_dataelementstructure_datasetuid_l98kM on _dataelementstructure_temp(datasetuid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,625 Create index SQL: create index in_dataelementstructure_periodtypeid_HBCLO on _dataelementstructure_temp(periodtypeid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,699 Swapped resource table, done: _dataelementstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,740 Create table SQL: CREATE TABLE _periodstructure_temp (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,919 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,928 Create index SQL: create unique index in_periodstructure_iso_NGEZy on _periodstructure_temp(iso) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,988 Swapped resource table, done: _periodstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:45,585 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, "idlevel1" integer, "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11), "idlevel3" integer, "uidlevel3" character(11)); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:45,660 Populate table content rows: 6 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,155 Create index SQL: create unique index in_orgunitstructure_organisationunituid_hylF7 on _orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,225 Swapped resource table, done: _orgunitstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,336 Create table SQL: create table _categoryoptioncomboname_temp (categoryoptioncomboid integer not null primary key, categoryoptioncomboname varchar(255), approvallevel integer) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,411 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,439 Swapped resource table, done: _categoryoptioncomboname (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,727 Create table SQL: create table _categoryoptiongroupsetstructure_temp (categoryoptioncomboid integer not null, primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,956 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,981 Swapped resource table, done: _categoryoptiongroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,028 Create table SQL: create table _dataelementgroupsetstructure_temp (dataelementid integer not null, dataelementname varchar(230), primary key (dataelementid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,100 Populate table SQL: insert into _dataelementgroupsetstructure_temp select d.dataelementid as dataelementid, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,120 Swapped resource table, done: _dataelementgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,192 Create table SQL: create table _indicatorgroupsetstructure_temp (indicatorid integer not null, indicatorname varchar(230), primary key (indicatorid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,255 Populate table SQL: insert into _indicatorgroupsetstructure_temp select i.indicatorid as indicatorid, i.name as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,263 Swapped resource table, done: _indicatorgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,273 Create table SQL: create table _organisationunitgroupsetstructure_temp (organisationunitid integer not null, organisationunitname varchar(230), primary key (organisationunitid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,351 Populate table SQL: insert into _organisationunitgroupsetstructure_temp select ou.organisationunitid as organisationunitid, ou.name as organisationunitname from organisationunit ou (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,356 Swapped resource table, done: _organisationunitgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,821 Create table SQL: create table _categorystructure_temp (categoryoptioncomboid integer not null, categoryoptioncomboname varchar(230), "default" varchar(230), "l4m2ffDxjH3" character(11), primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,999 Populate table SQL: insert into _categorystructure_temp select coc.categoryoptioncomboid as cocid, coc.name as cocname, (select co.name from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "default", (select co.uid from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "l4m2ffDxjH3" from categoryoptioncombo coc (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,019 Swapped resource table, done: _categorystructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,174 Create table SQL: CREATE TABLE _dataelementstructure_temp (dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(230), datasetid INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(230), datasetapprovallevel INTEGER, periodtypeid INTEGER, periodtypename VARCHAR(230)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,278 Populate table content rows: 2 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,286 Create index SQL: create unique index in_dataelementstructure_dataelementuid_PiXls on _dataelementstructure_temp(dataelementuid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,335 Create index SQL: create index in_dataelementstructure_datasetid_vYyQk on _dataelementstructure_temp(datasetid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,385 Create index SQL: create index in_dataelementstructure_datasetuid_X3Sui on _dataelementstructure_temp(datasetuid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,435 Create index SQL: create index in_dataelementstructure_periodtypeid_oxKH0 on _dataelementstructure_temp(periodtypeid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,516 Swapped resource table, done: _dataelementstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:49,054 Create table SQL: CREATE TABLE _periodstructure_temp (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:49,214 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:49,221 Create index SQL: create unique index in_periodstructure_iso_ZN0DD on _periodstructure_temp(iso) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:49,304 Swapped resource table, done: _periodstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 12:09:35,316 Create table SQL: create table _dateperiodstructure_temp (dateperiod date not null primary key, "daily" varchar(15), "weekly" varchar(15), "monthly" varchar(15), "bimonthly" varchar(15), "quarterly" varchar(15), "sixmonthly" varchar(15), "sixmonthlyapril" varchar(15), "yearly" varchar(15), "financialapril" varchar(15), "financialjuly" varchar(15), "financialoct" varchar(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 12:09:36,255 Populate table content rows: 18263 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 13:15:20,583 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, "idlevel1" integer, "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11), "idlevel3" integer, "uidlevel3" character(11)); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:21,140 Populate table content rows: 6 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:21,163 Create index SQL: create unique index in_orgunitstructure_organisationunituid_x79sT on _orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:21,221 Swapped resource table, done: _orgunitstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:21,981 Create table SQL: create table _categoryoptioncomboname_temp (categoryoptioncomboid integer not null primary key, categoryoptioncomboname varchar(255), approvallevel integer) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,049 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,054 Swapped resource table, done: _categoryoptioncomboname (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,162 Create table SQL: create table _categoryoptiongroupsetstructure_temp (categoryoptioncomboid integer not null, primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,249 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,268 Swapped resource table, done: _categoryoptiongroupsetstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,188 Create table SQL: create table _dataelementgroupsetstructure_temp (dataelementid integer not null, dataelementname varchar(230), primary key (dataelementid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,298 Populate table SQL: insert into _dataelementgroupsetstructure_temp select d.dataelementid as dataelementid, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,321 Swapped resource table, done: _dataelementgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,735 Create table SQL: create table _indicatorgroupsetstructure_temp (indicatorid integer not null, indicatorname varchar(230), primary key (indicatorid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,806 Populate table SQL: insert into _indicatorgroupsetstructure_temp select i.indicatorid as indicatorid, i.name as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,811 Swapped resource table, done: _indicatorgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,869 Create table SQL: create table _organisationunitgroupsetstructure_temp (organisationunitid integer not null, organisationunitname varchar(230), primary key (organisationunitid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,944 Populate table SQL: insert into _organisationunitgroupsetstructure_temp select ou.organisationunitid as organisationunitid, ou.name as organisationunitname from organisationunit ou (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,950 Swapped resource table, done: _organisationunitgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:24,083 Create table SQL: create table _categorystructure_temp (categoryoptioncomboid integer not null, categoryoptioncomboname varchar(230), "default" varchar(230), "l4m2ffDxjH3" character(11), primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:24,173 Populate table SQL: insert into _categorystructure_temp select coc.categoryoptioncomboid as cocid, coc.name as cocname, (select co.name from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "default", (select co.uid from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "l4m2ffDxjH3" from categoryoptioncombo coc (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:24,210 Swapped resource table, done: _categorystructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:24,627 Create table SQL: CREATE TABLE _dataelementstructure_temp (dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(230), datasetid INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(230), datasetapprovallevel INTEGER, periodtypeid INTEGER, periodtypename VARCHAR(230)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,025 Populate table content rows: 2 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,032 Create index SQL: create unique index in_dataelementstructure_dataelementuid_mxPfm on _dataelementstructure_temp(dataelementuid); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,263 Create index SQL: create index in_dataelementstructure_datasetid_UaluM on _dataelementstructure_temp(datasetid); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,550 Create index SQL: create index in_dataelementstructure_datasetuid_KvxNa on _dataelementstructure_temp(datasetuid); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,730 Create index SQL: create index in_dataelementstructure_periodtypeid_V9R6C on _dataelementstructure_temp(periodtypeid); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,804 Swapped resource table, done: _dataelementstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:26,843 Create table SQL: CREATE TABLE _periodstructure_temp (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:26,920 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:26,922 Create index SQL: create unique index in_periodstructure_iso_ByMOH on _periodstructure_temp(iso) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:27,006 Swapped resource table, done: _periodstructure (JdbcResourceTableStore.java [taskScheduler-2])