* INFO  2015-06-23 17:26:57,701 Login success for user: 'admin', ip: '127.0.0.1'
 (DefaultUserAuditService.java [http-apr-8085-exec-10])
* INFO  2015-06-23 17:27:01,196 Information schema analytics SQL: select table_n
ame from information_schema.tables where table_name like 'analytics%' and table_
type = 'BASE TABLE' (JdbcPartitionManager.java [http-apr-8085-exec-7])
* INFO  2015-06-23 17:30:23,518 [Level: INFO, category: DATAMART, time: Tue Jun
23 17:30:23 BDT 2015, message: Analytics table update process started] (InMemory
Notifier.java [taskScheduler-1])
* INFO  2015-06-23 17:30:23,519 [Level: INFO, category: DATAMART, time: Tue Jun
23 17:30:23 BDT 2015, message: Updating resource tables] (InMemoryNotifier.java
[taskScheduler-1])
* INFO  2015-06-23 17:30:23,534 Using 6 organisation unit levels for org unit st
ructure table (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-06-23 17:30:23,534 Create organisation unit structure table SQL: CR
EATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY,
organisationunituid CHARACTER(11), level INTEGER, "idlevel1" INTEGER, "uidlevel1
" CHARACTER(11), "idlevel2" INTEGER, "uidlevel2" CHARACTER(11), "idlevel3" INTEG
ER, "uidlevel3" CHARACTER(11), "idlevel4" INTEGER, "uidlevel4" CHARACTER(11), "i
dlevel5" INTEGER, "uidlevel5" CHARACTER(11), "idlevel6" INTEGER, "uidlevel6" CHA
RACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-06-23 17:31:06,513 Organisation unit structure table generated (Def
aultResourceTableService.java [taskScheduler-1])
* INFO  2015-06-23 17:31:06,711 Create category option combo name table SQL: CRE
ATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIM
ARY KEY, categoryoptioncomboname VARCHAR(250), approvallevel INTEGER ) (JdbcReso
urceTableStore.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,516 Category option combo name table generated (Defa
ultResourceTableService.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,576 Create category option group set table SQL: CREA
TE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NU
LL, PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryOptionGroupSetTableSt
atement.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,632 Category option group set table generated (Defau
ltResourceTableService.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,639 Create data element group set table SQL: CREATE
TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelemen
tname VARCHAR (250), "EPI Program" VARCHAR (250), "fqBqT0HAoi0" CHARACTER(11), "
HIV AIDS Program" VARCHAR (250), "Y3oMQmo1eaG" CHARACTER(11), PRIMARY KEY ( data
elementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,639 Populate data element group set structure SQL: i
nsert into _dataelementgroupsetstructure select d.dataelementid as dataelementid
, d.name as dataelementname, (select deg.name from dataelementgroup deg inner jo
in dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgrou
pid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = de
gm.dataelementgroupid and degsm.dataelementgroupsetid = 51086 where degm.dataele
mentid = d.dataelementid limit 1) as "EPI Program", (select deg.uid from dataele
mentgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid
 = deg.dataelementgroupid inner join dataelementgroupsetmembers degsm on degsm.d
ataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 51
086 where degm.dataelementid = d.dataelementid limit 1) as "fqBqT0HAoi0", (selec
t deg.name from dataelementgroup deg inner join dataelementgroupmembers degm on
degm.dataelementgroupid = deg.dataelementgroupid inner join dataelementgroupsetm
embers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dat
aelementgroupsetid = 50188 where degm.dataelementid = d.dataelementid limit 1) a
s "HIV AIDS Program", (select deg.uid from dataelementgroup deg inner join datae
lementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid inne
r join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.datae
lementgroupid and degsm.dataelementgroupsetid = 50188 where degm.dataelementid =
 d.dataelementid limit 1) as "Y3oMQmo1eaG" from dataelement d (JdbcResourceTable
Store.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,917 Data element group set table generated (DefaultR
esourceTableService.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,946 Create indicator group set table SQL: CREATE TAB
LE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VAR
CHAR (250), "Facility Based Indicator Group" VARCHAR (250), "KIhvYzjKOr0" CHARAC
TER(11), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.ja
va [taskScheduler-1])
* INFO  2015-06-23 17:31:12,954 Populate indicator group set structure SQL: inse
rt into _indicatorgroupsetstructure select i.indicatorid as indicatorid, i.name
as indicatorname, (select ig.name from indicatorgroup ig inner join indicatorgro
upmembers igm on igm.indicatorgroupid = ig.indicatorgroupid inner join indicator
groupsetmembers igsm on igsm.indicatorgroupid = igm.indicatorgroupid and igsm.in
dicatorgroupsetid = 1 where igm.indicatorid = i.indicatorid limit 1) as "Facilit
y Based Indicator Group", (select ig.uid from indicatorgroup ig inner join indic
atorgroupmembers igm on igm.indicatorgroupid = ig.indicatorgroupid inner join in
dicatorgroupsetmembers igsm on igsm.indicatorgroupid = igm.indicatorgroupid and
igsm.indicatorgroupsetid = 1 where igm.indicatorid = i.indicatorid limit 1) as "
KIhvYzjKOr0" from indicator i (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,967 Indicator group set table generated (DefaultReso
urceTableService.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,982 Create organisation unit group set table SQL: CR
EATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT N
ULL, organisationunitname VARCHAR (250), "Administrative unit" VARCHAR (250), "S
KATQ8yboF7" CHARACTER(11), "Govt. organization type" VARCHAR (250), "WwnvrXqGyQl
" CHARACTER(11), "Ownership" VARCHAR (250), "ns6fqlm8lqM" CHARACTER(11), "Progra
ms" VARCHAR (250), "h178IEscavG" CHARACTER(11), "Type" VARCHAR (250), "le7YcfUsd
1c" CHARACTER(11), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitG
roupSetTableStatement.java [taskScheduler-1])
* INFO  2015-06-23 17:31:12,982 Populate organisation unit group set structure S
QL: insert into _organisationunitgroupsetstructure select ou.organisationunitid
as organisationunitid, ou.name as organisationunitname, (select oug.name from or
gunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitgroupid = oug.
orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.orgunitgroupid =
 ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 541127 where ougm.organisatio
nunitid = ou.organisationunitid limit 1) as "Administrative unit", (select oug.u
id from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitgrou
pid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.orguni
tgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 541127 where ougm.o
rganisationunitid = ou.organisationunitid limit 1) as "SKATQ8yboF7", (select oug
.name from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitg
roupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.org
unitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 1 where ougm.org
anisationunitid = ou.organisationunitid limit 1) as "Govt. organization type", (
select oug.uid from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm
.orgunitgroupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on
ougsm.orgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 1 where
 ougm.organisationunitid = ou.organisationunitid limit 1) as "WwnvrXqGyQl", (sel
ect oug.name from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.o
rgunitgroupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ou
gsm.orgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 2 where o
ugm.organisationunitid = ou.organisationunitid limit 1) as "Ownership", (select
oug.uid from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orguni
tgroupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.o
rgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 2 where ougm.o
rganisationunitid = ou.organisationunitid limit 1) as "ns6fqlm8lqM", (select oug
.name from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitg
roupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.org
unitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 719485 where oug
m.organisationunitid = ou.organisationunitid limit 1) as "Programs", (select oug
.uid from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitgr
oupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.orgu
nitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 719485 where ougm
.organisationunitid = ou.organisationunitid limit 1) as "h178IEscavG", (select o
ug.name from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orguni
tgroupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.o
rgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 720968 where o
ugm.organisationunitid = ou.organisationunitid limit 1) as "Type", (select oug.u
id from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitgrou
pid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.orguni
tgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 720968 where ougm.o
rganisationunitid = ou.organisationunitid limit 1) as "le7YcfUsd1c" from organis
ationunit ou (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-06-23 17:31:17,851 Organisation unit group set table generated (Def
aultResourceTableService.java [taskScheduler-1])
* INFO  2015-06-23 17:31:17,871 Create category structure table SQL: CREATE TABL
E _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncom
boname VARCHAR (250), "Sex" VARCHAR (250), "mc2ceK4TjB6" CHARACTER(11), PRIMARY
KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskSchedule
r-1])
* INFO  2015-06-23 17:31:17,879 Populate category structure SQL: insert into _ca
tegorystructure select coc.categoryoptioncomboid as cocid, con.categoryoptioncom
boname as cocname, (select co.name from categoryoptioncombos_categoryoptions coc
co inner join dataelementcategoryoption co on cocco.categoryoptionid = co.catego
ryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cc
o.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid
 and cco.categoryid = 2 limit 1) as "Sex", (select co.uid from categoryoptioncom
bos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categ
oryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on c
o.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocc
o.categoryoptioncomboid and cco.categoryid = 2 limit 1) as "mc2ceK4TjB6" from ca
tegoryoptioncombo coc inner join _categoryoptioncomboname con on coc.categoryopt
ioncomboid = con.categoryoptioncomboid (JdbcResourceTableStore.java [taskSchedul
er-1])
* INFO  2015-06-23 17:31:17,938 Category table generated (DefaultResourceTableSe
rvice.java [taskScheduler-1])
* INFO  2015-06-23 17:31:30,393 Create data element structure SQL: CREATE TABLE
_dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementu
id CHARACTER(11), dataelementname VARCHAR(250), datasetid INTEGER, datasetuid CH
ARACTER(11), datasetname VARCHAR(250), datasetapprovallevel INTEGER, periodtypei
d INTEGER, periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [taskSched
uler-1])
* INFO  2015-06-23 17:31:52,892 Data element table generated (DefaultResourceTab
leService.java [taskScheduler-1])
* INFO  2015-06-23 17:31:52,987 Create period structure SQL: CREATE TABLE _perio
dstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, day
sno INTEGER NOT NULL, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCH
AR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(1
5), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHA
R(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTab
leStore.java [taskScheduler-1])
* INFO  2015-06-23 17:31:54,115 Date period table generated (DefaultResourceTabl
eService.java [taskScheduler-1])
* INFO  2015-06-23 17:31:54,131 Create date period structure SQL: CREATE TABLE _
dateperiodstructure (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), "financ
ialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-06-23 17:31:58,060 [Level: ERROR, category: DATAMART, time: Tue Jun
 23 17:31:58 BDT 2015, message: Process failed: PreparedStatementCallback; SQL [
insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: dupli
cate key value violates unique constraint "_dateperiodstructure_pkey"
  Detail: Key (dateperiod)=(2009-12-31) already exists.; nested exception is org
.postgresql.util.PSQLException: ERROR: duplicate key value violates unique const
raint "_dateperiodstructure_pkey"
  Detail: Key (dateperiod)=(2009-12-31) already exists.] (InMemoryNotifier.java
[taskScheduler-1])
* ERROR 2015-06-23 17:31:58,140 Unexpected error occurred in scheduled task. (Ta
skUtils.java [taskScheduler-1])
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [i
nsert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplic
ate key value violates unique constraint "_dateperiodstructure_pkey"
  Detail: Key (dateperiod)=(2009-12-31) already exists.; nested exception is org
.postgresql.util.PSQLException: ERROR: duplicate key value violates unique const
raint "_dateperiodstructure_pkey"
  Detail: Key (dateperiod)=(2009-12-31) already exists.
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d
oTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:73)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
660)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
673)
        at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j
ava:989)
        at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(Bat
chUpdateUtils.java:32)
        at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j
ava:1039)
        at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j
ava:1034)
        at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(J
dbcResourceTableStore.java:102)
        at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDateP
eriodTable(DefaultResourceTableService.java:450)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:201)
        at com.sun.proxy.$Proxy100.generateDatePeriodTable(Unknown Source)
        at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.generateRe
sourceTables(DefaultAnalyticsTableService.java:184)
        at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTa
bleTask.java:131)
        at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
e.run(DelegatingErrorHandlingRunnable.java:54)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violate
s unique constraint "_dateperiodstructure_pkey"
  Detail: Key (dateperiod)=(2009-12-31) already exists.
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2198)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1927)
        at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.
java:1130)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:396)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc
2Statement.java:2892)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
oxyPreparedStatement.java:1723)
        at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(Jd
bcTemplate.java:1005)
        at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(Jd
bcTemplate.java:989)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
644)
        ... 25 more