how to install and run DHIS2 2.24 on window with tomcat from XAMP and restore a sql data base file with psql command

Hi Everyone,

I'm a newbie in DHIS2 and want to use its on window. I'm looking for the way to install the server by using Tomcat embeded in XAMP and restore a sql data base backup file (not a dump) in postgresql. Everything I tried send me error message.

Thanks.

Can you share the print screen of thus errors.

Lamin B. Jawara

Ministry of Health & Social Welfare
Tel: +220 9907404 / 7229017
Email: lbjawara@yahoo.com

Web: http://lbjawara.wordpress.com

···

On Friday, September 30, 2016 2:58 PM, ekialongo vundalon@gmail.com wrote:

Hi Everyone,

I’m a newbie in DHIS2 and want to use its on window. I’m looking for the
way to install the server by using Tomcat embeded in XAMP and restore a
sql data base backup file (not a dump) in postgresql. Everything I tried
send me error message.

Thanks.


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

What error?

···

On 30 Sep 2016 5:05 p.m., “ekialongo” vundalon@gmail.com wrote:

Hi Everyone,

I’m a newbie in DHIS2 and want to use its on window. I’m looking for the way to install the server by using Tomcat embeded in XAMP and restore a sql data base backup file (not a dump) in postgresql. Everything I tried send me error message.

Thanks.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Knut, Lamin and everybody,

sorry for late responding due to personal matter.

Here are the error message for Tomcat and psql db import:

  1. Tomcat :

java.lang.UnsatisfiedLinkError: C:\xampp\tomcat\bin\tcnative-1.dll: Can’t load I

A 32-bit .dll on a AMD 64-bit platform

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1941)

at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1857)

at java.lang.Runtime.loadLibrary0(Runtime.java:870)

at java.lang.System.loadLibrary(System.java:1122)

at org.apache.tomcat.jni.Library.(Library.java:40)

at org.apache.tomcat.jni.Library.initialize(Library.java:172)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.catalina.core.AprLifecycleListener.init(AprLifecycleListen

er.java:194)

at org.apache.catalina.core.AprLifecycleListener.isAprAvailable(AprLifec

ycleListener.java:99)

at org.apache.catalina.connector.Connector.setProtocol(Connector.java:59

at org.apache.catalina.connector.Connector.(Connector.java:66)

at org.apache.catalina.startup.ConnectorCreateRule.begin(ConnectorCreate

Rule.java:62)

at org.apache.tomcat.util.digester.Digester.startElement(Digester.java:1

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startEle

ment(AbstractSAXParser.java:509)

at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.

emptyElement(AbstractXMLDocumentParser.java:182)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp

l.scanStartElement(XMLDocumentFragmentScannerImpl.java:1339)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp

l$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2784)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(X

MLDocumentScannerImpl.java:602)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp

l.scanDocument(XMLDocumentFragmentScannerImpl.java:505)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X

ML11Configuration.java:841)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X

ML11Configuration.java:770)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.

java:141)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Ab

stractSAXParser.java:1213)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.p

arse(SAXParserImpl.java:643)

at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)

at org.apache.catalina.startup.Catalina.load(Catalina.java:615)

at org.apache.catalina.startup.Catalina.load(Catalina.java:663)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:280)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:454)

Sep 30, 2016 4:57:50 PM org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performanc

e in production environments was not found on the java.library.path: C:\Program

Files\Java\jdk1.8.0_102\bin;C:\windows\Sun\Java\bin;C:\windows\system32;C:\windo

ws;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\

;C:\Program Files\Intel\iCLS Client;C:\windows\system32;C:\windows;C:\windows\S

ystem32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\

Intel\Intel® Management Engine Components\DAL;C:\Program Files\Intel\Intel®

Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel® Managemen

t Engine Components\IPT;C:\Program Files\Intel\Intel® Management Engine Compon

ents\IPT;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program

Files\Intel\WiFi\bin;C:\Program Files\Common Files\Intel\WirelessCommon;C:\Pro

gram Files (x86)\Common Files\Lenovo;C:\ProgramData\Lenovo\ReadyApps;C:\Program

Files (x86)\Skype\Phone;C:\Program Files (x86)\Gow\bin;C:\Program Files\Java\jd

k1.8.0_102\bin;C:\Program Files\PostgreSQL\9.4\bin;C:\Program Files (x86)\Calibr

e2;.

Sep 30, 2016 4:57:55 PM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler [“http-bio-8080”]

Sep 30, 2016 4:57:55 PM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler [“ajp-bio-8009”]

Sep 30, 2016 4:57:55 PM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 7609 ms

Sep 30, 2016 4:57:56 PM org.apache.catalina.core.StandardService startInternal

INFO: Starting service Catalina

Sep 30, 2016 4:57:56 PM org.apache.catalina.core.StandardEngine startInternal

INFO: Starting Servlet Engine: Apache Tomcat/7.0.56

Sep 30, 2016 4:57:56 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive C:\xampp\tomcat\webapps\dhis.war

  • INFO 2016-09-30 16:59:47,284 System property dhis2.home not set (DefaultLocat

ionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,293 Environment variable DHIS2_HOME points to C:\DHI

S2_HOME (DefaultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,343 File C:\DHIS2_HOME\dhis.conf does not exist (Def

aultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,355 File C:\DHIS2_HOME\dhis-google-auth.json does no

t exist (DefaultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,357 Could not find dhis-google-auth.json (DefaultDhi

sConfigurationProvider.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,358 File C:\DHIS2_HOME\dhis-google-auth.json does no

t exist (DefaultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,359 Could not find dhis-google-auth.json (DefaultDhi

sConfigurationProvider.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:52,871 Hibernate configuration loaded, using dialect: o

rg.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.ja

va [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,814 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,816 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,817 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,819 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,862 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,863 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,931 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,952 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,955 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,989 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,990 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,992 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,993 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,994 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • INFO 2016-09-30 17:00:50,730 Detected apps: [] (DefaultAppManager.java [local

host-startStop-1])

  • INFO 2016-09-30 17:00:53,032 Found the following message senders: [org.hisp.d

his.message.EmailMessageSender@337c3622, org.hisp.dhis.sms.config.SmsMessageSend

er@67c3f067] (DefaultMessageService.java [localhost-startStop-1])

  • INFO 2016-09-30 17:00:55,165 File store configured with provider ‘filesystem’

and container ‘files’. (JCloudsFileResourceContentStore.java [localhost-startS

top-1])

  • INFO 2016-09-30 17:00:57,532 Following listners are registered: [org.hisp.dhi

s.sms.listener.DataValueSMSListener@199b8ff9, org.hisp.dhis.sms.listener.J2MEDat

aValueSMSListener@4e8d6285, org.hisp.dhis.sms.listener.UnregisteredSMSListener@3

b54861f, org.hisp.dhis.sms.listener.DhisMessageAlertListener@2dc20d58, org.hisp.

dhis.sms.listener.TrackedEntityRegistrationSMSListener@6863bb5e, org.hisp.dhis.s

ms.listener.SingleEventListener@4ddf759d] (SmsConsumerThread.java [localhost-sta

rtStop-1])

  • INFO 2016-09-30 17:00:57,813 SMS consumer started (DefaultSmsConsumerService.

java [localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,977 Added logger: org.hisp.dhis.resourcetable using

file: C:\DHIS2_HOME\logs\dhis-analytics-table.log (Log4JLogConfigInitializer.jav

a [localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,978 Added logger: org.hisp.dhis.analytics.table usin

g file: C:\DHIS2_HOME\logs\dhis-analytics-table.log (Log4JLogConfigInitializer.j

ava [localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,979 Added logger: org.hisp.dhis.dxf2 using file: C:\

DHIS2_HOME\logs\dhis-data-exchange.log (Log4JLogConfigInitializer.java [localhos

t-startStop-1])

  • INFO 2016-09-30 17:00:58,979 Added logger: org.hisp.dhis.dxf2.synch using fil

e: C:\DHIS2_HOME\logs\dhis-data-sync.log (Log4JLogConfigInitializer.java [localh

ost-startStop-1])

  • INFO 2016-09-30 17:00:58,980 Added logger: org.hisp.dhis.dxf2.metadata using

file: C:\DHIS2_HOME\logs\dhis-metadata-sync.log (Log4JLogConfigInitializer.java

[localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,981 Added root logger using file: C:\DHIS2_HOME\logs

\dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:59,828 RP discovery / realm validation disabled; (Real

mVerifier.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,410 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,515 Scheduled task with key: 0 0 0 * * ? and cron: 0

0 0 * * ? (SpringScheduler.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,515 Scheduled task with key: fileResourceCleanupTask

and cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,516 Scheduled task with key: dataStatisticsTask and

cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,551 Executing startup routine [1 of 14, runlevel 1]:

InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:42,087 Executing startup routine [2 of 14, runlevel 2]:

PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]

)

  • INFO 2016-09-30 17:01:42,338 Executing startup routine [3 of 14, runlevel 3]:

DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [local

host-startStop-1])

  • INFO 2016-09-30 17:01:43,528 ‘system-process’ update org.hisp.dhis.dataelemen

t.DataElementCategory, name: default, uid: GLevLNI9wkl (AuditLogUtil.java [local

host-startStop-1])

  • INFO 2016-09-30 17:01:44,209 Executing startup routine [4 of 14, runlevel 4]:

IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:53,456 Executing startup routine [5 of 14, runlevel 4]:

ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-start

Stop-1])

  • INFO 2016-09-30 17:01:54,659 Executing startup routine [6 of 14, runlevel 5]:

TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:54,718 Executing startup routine [7 of 14, runlevel 6]:

TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:03,913 Tables updated (TableAlteror.java [localhost-sta

rtStop-1])

  • INFO 2016-09-30 17:05:03,914 Executing startup routine [8 of 14, runlevel 7]:

TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startS

top-1])

  • INFO 2016-09-30 17:05:29,265 Executing startup routine [9 of 14, runlevel 7]:

ModelUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:29,307 Executing startup routine [10 of 14, runlevel 9]

: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startS

top-1])

  • INFO 2016-09-30 17:05:29,315 Executing startup routine [11 of 14, runlevel 10

]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-start

Stop-1])

  • INFO 2016-09-30 17:05:29,665 Upgraded custom case entry form identifiers (Dat

aEntryFormUpgrader.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:29,667 Executing startup routine [12 of 14, runlevel 11

]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1

])

  • INFO 2016-09-30 17:05:30,120 Executing startup routine [13 of 14, runlevel 12

]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startSt

op-1])

  • WARN 2016-09-30 17:05:30,125 Encryption not configured: Missing the required

JCE policy files for strong encryption. (ConfigurationPopulator.java [localhost-

startStop-1])

  • INFO 2016-09-30 17:05:30,366 Executing startup routine [14 of 14, runlevel 13

]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-

1])

  • INFO 2016-09-30 17:05:30,757 All startup routines done (DefaultStartupRoutine

Executor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:37,960 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:38,166 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:41,053 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:41,523 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

Sep 30, 2016 5:05:41 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deployment of web application archive C:\xampp\tomcat\webapps\dhis.war has

finished in 465,305 ms

Sep 30, 2016 5:05:41 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\docs

Sep 30, 2016 5:05:42 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\docs has f

inished in 230 ms

Sep 30, 2016 5:05:42 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\examples

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\examples h

as finished in 6,134 ms

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\host-manager

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\host-manag

er has finished in 91 ms

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\manager

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\manager ha

s finished in 69 ms

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\ROOT

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\ROOT has f

inished in 59 ms

Sep 30, 2016 5:05:48 PM org.apache.coyote.AbstractProtocol start

INFO: Starting ProtocolHandler [“http-bio-8080”]

Sep 30, 2016 5:05:48 PM org.apache.coyote.AbstractProtocol start

INFO: Starting ProtocolHandler [“ajp-bio-8009”]

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.Catalina start

INFO: Server startup in 472338 ms

  1. psql DB import

psql:data.sql:1031227: ERROR: constraint “fk_program_dataentryformid” for relat

ion “program” already exists

psql:data.sql:1031235: ERROR: constraint "fk_program_organisationunits_organisa

tionunitid" for relation “program_organisationunits” already exists

psql:data.sql:1031243: ERROR: constraint "fk_program_organisationunits_programi

d" for relation “program_organisationunits” already exists

psql:data.sql:1031251: ERROR: constraint “fk_program_programstageid” for relati

on “programstagesection” already exists

psql:data.sql:1031259: ERROR: constraint “fk_program_relatedprogram” for relati

on “program” already exists

psql:data.sql:1031267: ERROR: constraint “fk_program_relationshipid” for relati

on “program” already exists

psql:data.sql:1031275: ERROR: constraint “fk_program_trackedentityid” for relat

ion “program” already exists

psql:data.sql:1031283: ERROR: constraint “fk_program_userid” for relation "prog

ram" already exists

psql:data.sql:1031291: ERROR: constraint “fk_program_userroles” for relation "p

rogram_userroles" already exists

psql:data.sql:1031299: ERROR: constraint “fk_program_workflowid” for relation "

program" already exists

psql:data.sql:1031307: ERROR: constraint “fk_programdataelement_dataelement” fo

r relation “programdataelement” already exists

psql:data.sql:1031315: ERROR: constraint “fk_programdataelement_program” for re

lation “programdataelement” already exists

psql:data.sql:1031323: ERROR: constraint “fk_programindicator_legendset” for re

lation “programindicator” already exists

psql:data.sql:1031331: ERROR: constraint “fk_programindicator_program” for rela

tion “programindicator” already exists

psql:data.sql:1031339: ERROR: constraint “fk_programindicator_userid” for relat

ion “programindicator” already exists

psql:data.sql:1031347: ERROR: constraint "fk_programinstance_organisationunitid

" for relation “programinstance” already exists

psql:data.sql:1031355: ERROR: constraint “fk_programinstance_programid” for rel

ation “programinstance” already exists

psql:data.sql:1031363: ERROR: constraint "fk_programinstance_trackedentityinsta

nceid" for relation “programinstance” already exists

psql:data.sql:1031371: ERROR: constraint “fk_programrule_program” for relation

“programrule” already exists

psql:data.sql:1031379: ERROR: constraint “fk_programrule_programstage” for rela

tion “programrule” already exists

psql:data.sql:1031387: ERROR: constraint “fk_programruleaction_dataelement” for

relation “programruleaction” already exists

psql:data.sql:1031395: ERROR: constraint "fk_programruleaction_programindicator

" for relation “programruleaction” already exists

psql:data.sql:1031403: ERROR: constraint “fk_programruleaction_programrule” for

relation “programruleaction” already exists

psql:data.sql:1031411: ERROR: constraint “fk_programruleaction_programstage” fo

r relation “programruleaction” already exists

psql:data.sql:1031419: ERROR: constraint "fk_programruleaction_programstagesect

ion" for relation “programruleaction” already exists

psql:data.sql:1031427: ERROR: constraint "fk_programruleaction_trackedentityatt

ribute" for relation “programruleaction” already exists

psql:data.sql:1031435: ERROR: constraint “fk_programrulevariable_dataelement” f

or relation “programrulevariable” already exists

psql:data.sql:1031443: ERROR: constraint “fk_programrulevariable_program” for r

elation “programrulevariable” already exists

psql:data.sql:1031451: ERROR: constraint “fk_programrulevariable_programstage”

for relation “programrulevariable” already exists

psql:data.sql:1031459: ERROR: constraint "fk_programrulevariable_trackedentitya

ttribute" for relation “programrulevariable” already exists

psql:data.sql:1031467: ERROR: constraint “fk_programstage_dataentryform” for re

lation “programstage” already exists

psql:data.sql:1031475: ERROR: constraint “fk_programstage_periodtypeid” for rel

ation “programstage” already exists

psql:data.sql:1031483: ERROR: constraint “fk_programstage_program” for relation

“programstage” already exists

psql:data.sql:1031491: ERROR: constraint "fk_programstagedataelement_dataelemen

tid" for relation “programstagedataelement” already exists

psql:data.sql:1031499: ERROR: constraint "fk_programstagedataelement_programsta

geid" for relation “programstagedataelement” already exists

psql:data.sql:1031507: ERROR: constraint "fk_programstageinstance_attributeopti

oncomboid" for relation “programstageinstance” already exists

psql:data.sql:1031515: ERROR: constraint "fk_programstageinstance_organisationu

nitid" for relation “programstageinstance” already exists

psql:data.sql:1031523: ERROR: constraint "fk_programstageinstance_programinstan

ceid" for relation “programstageinstance” already exists

psql:data.sql:1031531: ERROR: constraint "fk_programstageinstance_programstagei

d" for relation “programstageinstance” already exists

psql:data.sql:1031539: ERROR: constraint "fk_programstagesection_programindicat

ors_indicatorid" for relation “programstagesection_programindicators” already ex

ists

psql:data.sql:1031547: ERROR: constraint "fk_programstagesection_programindicat

ors_sectionid" for relation “programstagesection_programindicators” already exis

ts

psql:data.sql:1031555: ERROR: constraint "fk_programvalidation_leftprogramexpre

ssionid" for relation “programvalidation” already exists

psql:data.sql:1031563: ERROR: constraint “fk_programvalidation_programid” for r

elation “programvalidation” already exists

psql:data.sql:1031571: ERROR: constraint "fk_programvalidation_rightprogramexpr

essionid" for relation “programvalidation” already exists

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

psql:data.sql:1031675: ERROR: constraint “fk_relationship_relationshiptypeid” f

or relation “relationship” already exists

psql:data.sql:1031683: ERROR: constraint "fk_relationship_trackedentityinstance

ida" for relation “relationship” already exists

psql:data.sql:1031691: ERROR: constraint "fk_relationship_trackedentityinstance

idb" for relation “relationship” already exists

psql:data.sql:1031699: ERROR: constraint “fk_reminder_usergroup” for relation "

trackedentityinstancereminder" already exists

psql:data.sql:1031707: ERROR: constraint “fk_report_relativeperiodsid” for rela

tion “report” already exists

psql:data.sql:1031715: ERROR: constraint “fk_report_reporttableid” for relation

“report” already exists

psql:data.sql:1031723: ERROR: constraint “fk_report_userid” for relation "repor

t" already exists

psql:data.sql:1031731: ERROR: constraint "fk_reporttable_categorydimensions_cat

egorydimensionid" for relation “reporttable_categorydimensions” already exists

psql:data.sql:1031739: ERROR: constraint "fk_reporttable_categorydimensions_rep

orttableid" for relation “reporttable_categorydimensions” already exists

psql:data.sql:1031747: ERROR: constraint "fk_reporttable_categoryoptiongroups_c

ategoryoptiongroupid" for relation “reporttable_categoryoptiongroups” already ex

ists

psql:data.sql:1031755: ERROR: constraint "fk_reporttable_categoryoptiongroups_r

eporttableid" for relation “reporttable_categoryoptiongroups” already exists

psql:data.sql:1031763: ERROR: constraint “fk_reporttable_columns_reporttableid”

for relation “reporttable_columns” already exists

psql:data.sql:1031771: ERROR: constraint "fk_reporttable_datadimensionitems_dat

adimensionitemid" for relation “reporttable_datadimensionitems” already exists

psql:data.sql:1031779: ERROR: constraint "fk_reporttable_datadimensionitems_rep

orttableid" for relation “reporttable_datadimensionitems” already exists

psql:data.sql:1031787: ERROR: constraint "fk_reporttable_dataelementgroups_data

elementgroupid" for relation “reporttable_dataelementgroups” already exists

psql:data.sql:1031795: ERROR: constraint "fk_reporttable_dataelementgroups_repo

rttableid" for relation “reporttable_dataelementgroups” already exists

psql:data.sql:1031803: ERROR: constraint “fk_reporttable_filters_reporttableid”

for relation “reporttable_filters” already exists

psql:data.sql:1031811: ERROR: constraint "fk_reporttable_itemorgunitgroups_orgu

nitgroupid" for relation “reporttable_itemorgunitgroups” already exists

psql:data.sql:1031819: ERROR: constraint "fk_reporttable_itemorgunitunitgroups_

reporttableid" for relation “reporttable_itemorgunitgroups” already exists

psql:data.sql:1031827: ERROR: constraint “fk_reporttable_legendsetid” for relat

ion “reporttable” already exists

psql:data.sql:1031835: ERROR: constraint "fk_reporttable_organisationunits_orga

nisationunitid" for relation “reporttable_organisationunits” already exists

psql:data.sql:1031843: ERROR: constraint "fk_reporttable_organisationunits_repo

rttableid" for relation “reporttable_organisationunits” already exists

psql:data.sql:1031851: ERROR: constraint "fk_reporttable_orgunitgroups_orgunitg

roupid" for relation “reporttable_orgunitgroups” already exists

psql:data.sql:1031859: ERROR: constraint "fk_reporttable_orgunitlevels_reportta

bleid" for relation “reporttable_orgunitlevels” already exists

psql:data.sql:1031867: ERROR: constraint "fk_reporttable_orgunitunitgroups_repo

rttableid" for relation “reporttable_orgunitgroups” already exists

psql:data.sql:1031875: ERROR: constraint “fk_reporttable_periods_periodid” for

relation “reporttable_periods” already exists

psql:data.sql:1031883: ERROR: constraint “fk_reporttable_periods_reporttableid”

for relation “reporttable_periods” already exists

ALTER TABLE

psql:data.sql:1031899: ERROR: constraint “fk_reporttable_relativeperiodsid” for

relation “reporttable” already exists

psql:data.sql:1031907: ERROR: constraint “fk_reporttable_rows_reporttableid” fo

r relation “reporttable_rows” already exists

psql:data.sql:1031915: ERROR: constraint “fk_reporttable_userid” for relation "

reporttable" already exists

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

psql:data.sql:1031963: ERROR: constraint “fk_section_dataelementid” for relatio

n “sectiondataelements” already exists

psql:data.sql:1031971: ERROR: constraint “fk_section_dataelementoperandid” for

relation “sectiongreyedfields” already exists

psql:data.sql:1031979: ERROR: constraint “fk_section_datasetid” for relation "s

ection" already exists

psql:data.sql:1031987: ERROR: constraint “fk_section_indicatorid” for relation

“sectionindicators” already exists

psql:data.sql:1031995: ERROR: constraint “fk_sectiondataelements_sectionid” for

relation “sectiondataelements” already exists

psql:data.sql:1032003: ERROR: constraint “fk_sectiongreyedfields_sectionid” for

relation “sectiongreyedfields” already exists

psql:data.sql:1032011: ERROR: constraint “fk_sectionindicators_sectionid” for r

elation “sectionindicators” already exists

psql:data.sql:1032019: ERROR: constraint “fk_smscommand_program” for relation "

smscommands" already exists

psql:data.sql:1032027: ERROR: constraint “fk_smscommand_usergroup” for relation

“smscommands” already exists

ALTER TABLE

psql:data.sql:1032043: ERROR: constraint “fk_sqlview_userid” for relation "sqlv

iew" already exists

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

psql:data.sql:1032099: ERROR: constraint "fk_teprogramindicatordimension_legend

setid" for relation “trackedentityprogramindicatordimension” already exists

psql:data.sql:1032107: ERROR: constraint "fk_teprogramindicatordimension_progra

mindicatorid" for relation “trackedentityprogramindicatordimension” already exis

ts

psql:data.sql:1032115: ERROR: constraint "fk_trackedentityattribute_attributegr

oupid" for relation “trackedentityattribute” already exists

psql:data.sql:1032123: ERROR: constraint “fk_trackedentityattribute_legendset”

for relation “trackedentityattribute” already exists

psql:data.sql:1032131: ERROR: constraint "fk_trackedentityattribute_optionsetid

" for relation “trackedentityattribute” already exists

psql:data.sql:1032139: ERROR: constraint "fk_trackedentityattribute_trackedenti

tyattributeid" for relation “smscodes” already exists

psql:data.sql:1032147: ERROR: constraint "fk_trackedentityattribute_trackedenti

tyid" for relation “trackedentityattribute” already exists

psql:data.sql:1032155: ERROR: constraint “fk_trackedentityattribute_userid” for

relation “trackedentityattribute” already exists

ALTER TABLE

psql:data.sql:1032171: ERROR: constraint "fk_trackedentityinstance_organisation

unitid" for relation “trackedentityinstance” already exists

psql:data.sql:1032179: ERROR: constraint "fk_trackedentityinstance_representati

veid" for relation “trackedentityinstance” already exists

psql:data.sql:1032187: ERROR: constraint "fk_trackedentityinstance_trackedentit

yid" for relation “trackedentityinstance” already exists

psql:data.sql:1032195: ERROR: constraint “fk_user_userid” for relation “users”

already exists

psql:data.sql:1032203: ERROR: constraint “fk_user_userinfoid” for relation "use

rs" already exists

psql:data.sql:1032211: ERROR: constraint “fk_userapps_userinfoid” for relation

“userapps” already exists

psql:data.sql:1032219: ERROR: constraint "fk_userdatavieworgunits_organisationu

nitid" for relation “userdatavieworgunits” already exists

psql:data.sql:1032227: ERROR: constraint “fk_userdatavieworgunits_userinfoid” f

or relation “userdatavieworgunits” already exists

psql:data.sql:1032235: ERROR: constraint “fk_usergroup_userid” for relation "us

ergroup" already exists

psql:data.sql:1032243: ERROR: constraint “fk_usergroupaccess_usergroup” for rel

ation “usergroupaccess” already exists

psql:data.sql:1032251: ERROR: constraint "fk_usergroupmanaging_managedbygroupid

" for relation “usergroupmanaged” already exists

psql:data.sql:1032259: ERROR: constraint “fk_usergroupmanaging_managedgroupid”

for relation “usergroupmanaged” already exists

psql:data.sql:1032267: ERROR: constraint “fk_usergroupmembers_usergroupid” for

relation “usergroupmembers” already exists

psql:data.sql:1032275: ERROR: constraint “fk_usergroupmembers_userid” for relat

ion “usergroupmembers” already exists

psql:data.sql:1032283: ERROR: constraint “fk_userinfo_organisationunitid” for r

elation “usermembership” already exists

psql:data.sql:1032291: ERROR: constraint “fk_userkeyjsonvalue_user” for relatio

n “userkeyjsonvalue” already exists

psql:data.sql:1032299: ERROR: constraint “fk_usermembership_userinfoid” for rel

ation “usermembership” already exists

psql:data.sql:1032307: ERROR: constraint “fk_usermessage_user” for relation "us

ermessage" already exists

psql:data.sql:1032315: ERROR: constraint “fk_userrole_userid” for relation "use

rrole" already exists

psql:data.sql:1032323: ERROR: constraint “fk_userroleauthorities_userroleid” fo

r relation “userroleauthorities” already exists

psql:data.sql:1032331: ERROR: constraint “fk_userroledataset_datasetid” for rel

ation “userroledataset” already exists

psql:data.sql:1032339: ERROR: constraint “fk_userroledataset_userroleid” for re

lation “userroledataset” already exists

psql:data.sql:1032347: ERROR: constraint “fk_userrolemembers_userid” for relati

on “userrolemembers” already exists

psql:data.sql:1032355: ERROR: constraint “fk_userrolemembers_userroleid” for re

lation “userrolemembers” already exists

psql:data.sql:1032363: ERROR: constraint “fk_users_catconstraints_userid” for r

elation “users_catdimensionconstraints” already exists

psql:data.sql:1032371: ERROR: constraint “fk_users_cogsconstraints_userid” for

relation “users_cogsdimensionconstraints” already exists

psql:data.sql:1032379: ERROR: constraint “fk_usersetting_userinfoid” for relati

on “usersetting” already exists

psql:data.sql:1032387: ERROR: constraint "fk_userteisearchorgunits_organisation

unitid" for relation “userteisearchorgunits” already exists

psql:data.sql:1032395: ERROR: constraint “fk_userteisearchorgunits_userinfoid”

for relation “userteisearchorgunits” already exists

psql:data.sql:1032403: ERROR: constraint “fk_validationrule_leftexpressionid” f

or relation “validationrule” already exists

psql:data.sql:1032411: ERROR: constraint “fk_validationrule_periodtypeid” for r

elation “validationrule” already exists

psql:data.sql:1032419: ERROR: constraint “fk_validationrule_rightexpressionid”

for relation “validationrule” already exists

psql:data.sql:1032427: ERROR: constraint "fk_validationrule_skiptestexpressioni

d" for relation “validationrule” already exists

psql:data.sql:1032435: ERROR: constraint “fk_validationrulegroup_userid” for re

lation “validationrulegroup” already exists

psql:data.sql:1032443: ERROR: constraint "fk_validationrulegroup_validationrule

id" for relation “validationrulegroupmembers” already exists

psql:data.sql:1032451: ERROR: constraint "fk_validationrulegroupmembers_validat

ionrulegroupid" for relation “validationrulegroupmembers” already exists

psql:data.sql:1032459: ERROR: constraint "fk_validationrulegroupusergroupstoale

rt_usergroupid" for relation “validationrulegroupusergroupstoalert” already exis

ts

psql:data.sql:1032467: ERROR: constraint "fk_validationrulegroupusergroupstoale

rt_validationgroupid" for relation “validationrulegroupusergroupstoalert” alread

y exists

ALTER TABLE

REVOKE

REVOKE

GRANT

GRANT

GRANT

C:\Users\vundalon\Documents\software\data>

log tomcat.txt (16.9 KB)

log tomcat.txt (16.9 KB)

error sql db import.txt (17.1 KB)

···

2016-09-30 17:55 GMT+02:00 Knut Staring knutst@gmail.com:

What error?

On 30 Sep 2016 5:05 p.m., “ekialongo” vundalon@gmail.com wrote:

Hi Everyone,

I’m a newbie in DHIS2 and want to use its on window. I’m looking for the way to install the server by using Tomcat embeded in XAMP and restore a sql data base backup file (not a dump) in postgresql. Everything I tried send me error message.

Thanks.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Can’t load I A 32-bit .dll on a AMD 64-bit platform

Be sure that you have a 64 bit Java, since your OS is also 64 bit.

Regards,

Jason

···

On Thu, Oct 13, 2016 at 10:20 AM, vunda limbe vundalon@gmail.com wrote:

Hi Knut, Lamin and everybody,

sorry for late responding due to personal matter.

Here are the error message for Tomcat and psql db import:

  1. Tomcat :

java.lang.UnsatisfiedLinkError: C:\xampp\tomcat\bin\tcnative-1.dll: Can’t load I

A 32-bit .dll on a AMD 64-bit platform

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1941)

at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1857)

at java.lang.Runtime.loadLibrary0(Runtime.java:870)

at java.lang.System.loadLibrary(System.java:1122)

at org.apache.tomcat.jni.Library.(Library.java:40)

at org.apache.tomcat.jni.Library.initialize(Library.java:172)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.catalina.core.AprLifecycleListener.init(AprLifecycleListen

er.java:194)

at org.apache.catalina.core.AprLifecycleListener.isAprAvailable(AprLifec

ycleListener.java:99)

at org.apache.catalina.connector.Connector.setProtocol(Connector.java:59

at org.apache.catalina.connector.Connector.(Connector.java:66)

at org.apache.catalina.startup.ConnectorCreateRule.begin(ConnectorCreate

Rule.java:62)

at org.apache.tomcat.util.digester.Digester.startElement(Digester.java:1

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startEle

ment(AbstractSAXParser.java:509)

at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.

emptyElement(AbstractXMLDocumentParser.java:182)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp

l.scanStartElement(XMLDocumentFragmentScannerImpl.java:1339)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp

l$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2784)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(X

MLDocumentScannerImpl.java:602)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp

l.scanDocument(XMLDocumentFragmentScannerImpl.java:505)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X

ML11Configuration.java:841)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X

ML11Configuration.java:770)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.

java:141)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Ab

stractSAXParser.java:1213)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.p

arse(SAXParserImpl.java:643)

at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)

at org.apache.catalina.startup.Catalina.load(Catalina.java:615)

at org.apache.catalina.startup.Catalina.load(Catalina.java:663)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:280)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:454)

Sep 30, 2016 4:57:50 PM org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performanc

e in production environments was not found on the java.library.path: C:\Program

Files\Java\jdk1.8.0_102\bin;C:\windows\Sun\Java\bin;C:\windows\system32;C:\windo

ws;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\

;C:\Program Files\Intel\iCLS Client;C:\windows\system32;C:\windows;C:\windows\S

ystem32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\

Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R)

Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Managemen

t Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Compon

ents\IPT;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program

Files\Intel\WiFi\bin;C:\Program Files\Common Files\Intel\WirelessCommon;C:\Pro

gram Files (x86)\Common Files\Lenovo;C:\ProgramData\Lenovo\ReadyApps;C:\Program

Files (x86)\Skype\Phone;C:\Program Files (x86)\Gow\bin;C:\Program Files\Java\jd

k1.8.0_102\bin;C:\Program Files\PostgreSQL\9.4\bin;C:\Program Files (x86)\Calibr

e2;.

Sep 30, 2016 4:57:55 PM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler [“http-bio-8080”]

Sep 30, 2016 4:57:55 PM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler [“ajp-bio-8009”]

Sep 30, 2016 4:57:55 PM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 7609 ms

Sep 30, 2016 4:57:56 PM org.apache.catalina.core.StandardService startInternal

INFO: Starting service Catalina

Sep 30, 2016 4:57:56 PM org.apache.catalina.core.StandardEngine startInternal

INFO: Starting Servlet Engine: Apache Tomcat/7.0.56

Sep 30, 2016 4:57:56 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive C:\xampp\tomcat\webapps\dhis.war

  • INFO 2016-09-30 16:59:47,284 System property dhis2.home not set (DefaultLocat

ionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,293 Environment variable DHIS2_HOME points to C:\DHI

S2_HOME (DefaultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,343 File C:\DHIS2_HOME\dhis.conf does not exist (Def

aultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,355 File C:\DHIS2_HOME\dhis-google-auth.json does no

t exist (DefaultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,357 Could not find dhis-google-auth.json (DefaultDhi

sConfigurationProvider.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,358 File C:\DHIS2_HOME\dhis-google-auth.json does no

t exist (DefaultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,359 Could not find dhis-google-auth.json (DefaultDhi

sConfigurationProvider.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:52,871 Hibernate configuration loaded, using dialect: o

rg.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.ja

va [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,814 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,816 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,817 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,819 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,862 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,863 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,931 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,952 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,955 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,989 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,990 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,992 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,993 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,994 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • INFO 2016-09-30 17:00:50,730 Detected apps: [] (DefaultAppManager.java [local

host-startStop-1])

  • INFO 2016-09-30 17:00:53,032 Found the following message senders: [org.hisp.d

his.message.EmailMessageSender@337c3622, org.hisp.dhis.sms.config.SmsMessageSend

er@67c3f067] (DefaultMessageService.java [localhost-startStop-1])

  • INFO 2016-09-30 17:00:55,165 File store configured with provider ‘filesystem’

and container ‘files’. (JCloudsFileResourceContentStore.java [localhost-startS

top-1])

  • INFO 2016-09-30 17:00:57,532 Following listners are registered: [org.hisp.dhi

s.sms.listener.DataValueSMSListener@199b8ff9, org.hisp.dhis.sms.listener.J2MEDat

aValueSMSListener@4e8d6285, org.hisp.dhis.sms.listener.UnregisteredSMSListener@3

b54861f, org.hisp.dhis.sms.listener.DhisMessageAlertListener@2dc20d58, org.hisp.

dhis.sms.listener.TrackedEntityRegistrationSMSListener@6863bb5e, org.hisp.dhis.s

ms.listener.SingleEventListener@4ddf759d] (SmsConsumerThread.java [localhost-sta

rtStop-1])

  • INFO 2016-09-30 17:00:57,813 SMS consumer started (DefaultSmsConsumerService.

java [localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,977 Added logger: org.hisp.dhis.resourcetable using

file: C:\DHIS2_HOME\logs\dhis-analytics-table.log (Log4JLogConfigInitializer.jav

a [localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,978 Added logger: org.hisp.dhis.analytics.table usin

g file: C:\DHIS2_HOME\logs\dhis-analytics-table.log (Log4JLogConfigInitializer.j

ava [localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,979 Added logger: org.hisp.dhis.dxf2 using file: C:\

DHIS2_HOME\logs\dhis-data-exchange.log (Log4JLogConfigInitializer.java [localhos

t-startStop-1])

  • INFO 2016-09-30 17:00:58,979 Added logger: org.hisp.dhis.dxf2.synch using fil

e: C:\DHIS2_HOME\logs\dhis-data-sync.log (Log4JLogConfigInitializer.java [localh

ost-startStop-1])

  • INFO 2016-09-30 17:00:58,980 Added logger: org.hisp.dhis.dxf2.metadata using

file: C:\DHIS2_HOME\logs\dhis-metadata-sync.log (Log4JLogConfigInitializer.java

[localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,981 Added root logger using file: C:\DHIS2_HOME\logs

\dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:59,828 RP discovery / realm validation disabled; (Real

mVerifier.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,410 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,515 Scheduled task with key: 0 0 0 * * ? and cron: 0

0 0 * * ? (SpringScheduler.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,515 Scheduled task with key: fileResourceCleanupTask

and cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,516 Scheduled task with key: dataStatisticsTask and

cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,551 Executing startup routine [1 of 14, runlevel 1]:

InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:42,087 Executing startup routine [2 of 14, runlevel 2]:

PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]

)

  • INFO 2016-09-30 17:01:42,338 Executing startup routine [3 of 14, runlevel 3]:

DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [local

host-startStop-1])

  • INFO 2016-09-30 17:01:43,528 ‘system-process’ update org.hisp.dhis.dataelemen

t.DataElementCategory, name: default, uid: GLevLNI9wkl (AuditLogUtil.java [local

host-startStop-1])

  • INFO 2016-09-30 17:01:44,209 Executing startup routine [4 of 14, runlevel 4]:

IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:53,456 Executing startup routine [5 of 14, runlevel 4]:

ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-start

Stop-1])

  • INFO 2016-09-30 17:01:54,659 Executing startup routine [6 of 14, runlevel 5]:

TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:54,718 Executing startup routine [7 of 14, runlevel 6]:

TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:03,913 Tables updated (TableAlteror.java [localhost-sta

rtStop-1])

  • INFO 2016-09-30 17:05:03,914 Executing startup routine [8 of 14, runlevel 7]:

TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startS

top-1])

  • INFO 2016-09-30 17:05:29,265 Executing startup routine [9 of 14, runlevel 7]:

ModelUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:29,307 Executing startup routine [10 of 14, runlevel 9]

: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startS

top-1])

  • INFO 2016-09-30 17:05:29,315 Executing startup routine [11 of 14, runlevel 10

]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-start

Stop-1])

  • INFO 2016-09-30 17:05:29,665 Upgraded custom case entry form identifiers (Dat

aEntryFormUpgrader.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:29,667 Executing startup routine [12 of 14, runlevel 11

]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1

])

  • INFO 2016-09-30 17:05:30,120 Executing startup routine [13 of 14, runlevel 12

]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startSt

op-1])

  • WARN 2016-09-30 17:05:30,125 Encryption not configured: Missing the required

JCE policy files for strong encryption. (ConfigurationPopulator.java [localhost-

startStop-1])

  • INFO 2016-09-30 17:05:30,366 Executing startup routine [14 of 14, runlevel 13

]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-

1])

  • INFO 2016-09-30 17:05:30,757 All startup routines done (DefaultStartupRoutine

Executor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:37,960 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:38,166 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:41,053 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:41,523 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

Sep 30, 2016 5:05:41 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deployment of web application archive C:\xampp\tomcat\webapps\dhis.war has

finished in 465,305 ms

Sep 30, 2016 5:05:41 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\docs

Sep 30, 2016 5:05:42 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\docs has f

inished in 230 ms

Sep 30, 2016 5:05:42 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\examples

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\examples h

as finished in 6,134 ms

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\host-manager

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\host-manag

er has finished in 91 ms

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\manager

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\manager ha

s finished in 69 ms

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\ROOT

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\ROOT has f

inished in 59 ms

Sep 30, 2016 5:05:48 PM org.apache.coyote.AbstractProtocol start

INFO: Starting ProtocolHandler [“http-bio-8080”]

Sep 30, 2016 5:05:48 PM org.apache.coyote.AbstractProtocol start

INFO: Starting ProtocolHandler [“ajp-bio-8009”]

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.Catalina start

INFO: Server startup in 472338 ms

  1. psql DB import

psql:data.sql:1031227: ERROR: constraint “fk_program_dataentryformid” for relat

ion “program” already exists

psql:data.sql:1031235: ERROR: constraint "fk_program_organisationunits_organisa

tionunitid" for relation “program_organisationunits” already exists

psql:data.sql:1031243: ERROR: constraint "fk_program_organisationunits_programi

d" for relation “program_organisationunits” already exists

psql:data.sql:1031251: ERROR: constraint “fk_program_programstageid” for relati

on “programstagesection” already exists

psql:data.sql:1031259: ERROR: constraint “fk_program_relatedprogram” for relati

on “program” already exists

psql:data.sql:1031267: ERROR: constraint “fk_program_relationshipid” for relati

on “program” already exists

psql:data.sql:1031275: ERROR: constraint “fk_program_trackedentityid” for relat

ion “program” already exists

psql:data.sql:1031283: ERROR: constraint “fk_program_userid” for relation "prog

ram" already exists

psql:data.sql:1031291: ERROR: constraint “fk_program_userroles” for relation "p

rogram_userroles" already exists

psql:data.sql:1031299: ERROR: constraint “fk_program_workflowid” for relation "

program" already exists

psql:data.sql:1031307: ERROR: constraint “fk_programdataelement_dataelement” fo

r relation “programdataelement” already exists

psql:data.sql:1031315: ERROR: constraint “fk_programdataelement_program” for re

lation “programdataelement” already exists

psql:data.sql:1031323: ERROR: constraint “fk_programindicator_legendset” for re

lation “programindicator” already exists

psql:data.sql:1031331: ERROR: constraint “fk_programindicator_program” for rela

tion “programindicator” already exists

psql:data.sql:1031339: ERROR: constraint “fk_programindicator_userid” for relat

ion “programindicator” already exists

psql:data.sql:1031347: ERROR: constraint "fk_programinstance_organisationunitid

" for relation “programinstance” already exists

psql:data.sql:1031355: ERROR: constraint “fk_programinstance_programid” for rel

ation “programinstance” already exists

psql:data.sql:1031363: ERROR: constraint "fk_programinstance_trackedentityinsta

nceid" for relation “programinstance” already exists

psql:data.sql:1031371: ERROR: constraint “fk_programrule_program” for relation

“programrule” already exists

psql:data.sql:1031379: ERROR: constraint “fk_programrule_programstage” for rela

tion “programrule” already exists

psql:data.sql:1031387: ERROR: constraint “fk_programruleaction_dataelement” for

relation “programruleaction” already exists

psql:data.sql:1031395: ERROR: constraint "fk_programruleaction_programindicator

" for relation “programruleaction” already exists

psql:data.sql:1031403: ERROR: constraint “fk_programruleaction_programrule” for

relation “programruleaction” already exists

psql:data.sql:1031411: ERROR: constraint “fk_programruleaction_programstage” fo

r relation “programruleaction” already exists

psql:data.sql:1031419: ERROR: constraint "fk_programruleaction_programstagesect

ion" for relation “programruleaction” already exists

psql:data.sql:1031427: ERROR: constraint "fk_programruleaction_trackedentityatt

ribute" for relation “programruleaction” already exists

psql:data.sql:1031435: ERROR: constraint “fk_programrulevariable_dataelement” f

or relation “programrulevariable” already exists

psql:data.sql:1031443: ERROR: constraint “fk_programrulevariable_program” for r

elation “programrulevariable” already exists

psql:data.sql:1031451: ERROR: constraint “fk_programrulevariable_programstage”

for relation “programrulevariable” already exists

psql:data.sql:1031459: ERROR: constraint "fk_programrulevariable_trackedentitya

ttribute" for relation “programrulevariable” already exists

psql:data.sql:1031467: ERROR: constraint “fk_programstage_dataentryform” for re

lation “programstage” already exists

psql:data.sql:1031475: ERROR: constraint “fk_programstage_periodtypeid” for rel

ation “programstage” already exists

psql:data.sql:1031483: ERROR: constraint “fk_programstage_program” for relation

“programstage” already exists

psql:data.sql:1031491: ERROR: constraint "fk_programstagedataelement_dataelemen

tid" for relation “programstagedataelement” already exists

psql:data.sql:1031499: ERROR: constraint "fk_programstagedataelement_programsta

geid" for relation “programstagedataelement” already exists

psql:data.sql:1031507: ERROR: constraint "fk_programstageinstance_attributeopti

oncomboid" for relation “programstageinstance” already exists

psql:data.sql:1031515: ERROR: constraint "fk_programstageinstance_organisationu

nitid" for relation “programstageinstance” already exists

psql:data.sql:1031523: ERROR: constraint "fk_programstageinstance_programinstan

ceid" for relation “programstageinstance” already exists

psql:data.sql:1031531: ERROR: constraint "fk_programstageinstance_programstagei

d" for relation “programstageinstance” already exists

psql:data.sql:1031539: ERROR: constraint "fk_programstagesection_programindicat

ors_indicatorid" for relation “programstagesection_programindicators” already ex

ists

psql:data.sql:1031547: ERROR: constraint "fk_programstagesection_programindicat

ors_sectionid" for relation “programstagesection_programindicators” already exis

ts

psql:data.sql:1031555: ERROR: constraint "fk_programvalidation_leftprogramexpre

ssionid" for relation “programvalidation” already exists

psql:data.sql:1031563: ERROR: constraint “fk_programvalidation_programid” for r

elation “programvalidation” already exists

psql:data.sql:1031571: ERROR: constraint "fk_programvalidation_rightprogramexpr

essionid" for relation “programvalidation” already exists

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

psql:data.sql:1031675: ERROR: constraint “fk_relationship_relationshiptypeid” f

or relation “relationship” already exists

psql:data.sql:1031683: ERROR: constraint "fk_relationship_trackedentityinstance

ida" for relation “relationship” already exists

psql:data.sql:1031691: ERROR: constraint "fk_relationship_trackedentityinstance

idb" for relation “relationship” already exists

psql:data.sql:1031699: ERROR: constraint “fk_reminder_usergroup” for relation "

trackedentityinstancereminder" already exists

psql:data.sql:1031707: ERROR: constraint “fk_report_relativeperiodsid” for rela

tion “report” already exists

psql:data.sql:1031715: ERROR: constraint “fk_report_reporttableid” for relation

“report” already exists

psql:data.sql:1031723: ERROR: constraint “fk_report_userid” for relation "repor

t" already exists

psql:data.sql:1031731: ERROR: constraint "fk_reporttable_categorydimensions_cat

egorydimensionid" for relation “reporttable_categorydimensions” already exists

psql:data.sql:1031739: ERROR: constraint "fk_reporttable_categorydimensions_rep

orttableid" for relation “reporttable_categorydimensions” already exists

psql:data.sql:1031747: ERROR: constraint "fk_reporttable_categoryoptiongroups_c

ategoryoptiongroupid" for relation “reporttable_categoryoptiongroups” already ex

ists

psql:data.sql:1031755: ERROR: constraint "fk_reporttable_categoryoptiongroups_r

eporttableid" for relation “reporttable_categoryoptiongroups” already exists

psql:data.sql:1031763: ERROR: constraint “fk_reporttable_columns_reporttableid”

for relation “reporttable_columns” already exists

psql:data.sql:1031771: ERROR: constraint "fk_reporttable_datadimensionitems_dat

adimensionitemid" for relation “reporttable_datadimensionitems” already exists

psql:data.sql:1031779: ERROR: constraint "fk_reporttable_datadimensionitems_rep

orttableid" for relation “reporttable_datadimensionitems” already exists

psql:data.sql:1031787: ERROR: constraint "fk_reporttable_dataelementgroups_data

elementgroupid" for relation “reporttable_dataelementgroups” already exists

psql:data.sql:1031795: ERROR: constraint "fk_reporttable_dataelementgroups_repo

rttableid" for relation “reporttable_dataelementgroups” already exists

psql:data.sql:1031803: ERROR: constraint “fk_reporttable_filters_reporttableid”

for relation “reporttable_filters” already exists

psql:data.sql:1031811: ERROR: constraint "fk_reporttable_itemorgunitgroups_orgu

nitgroupid" for relation “reporttable_itemorgunitgroups” already exists

psql:data.sql:1031819: ERROR: constraint "fk_reporttable_itemorgunitunitgroups_

reporttableid" for relation “reporttable_itemorgunitgroups” already exists

psql:data.sql:1031827: ERROR: constraint “fk_reporttable_legendsetid” for relat

ion “reporttable” already exists

psql:data.sql:1031835: ERROR: constraint "fk_reporttable_organisationunits_orga

nisationunitid" for relation “reporttable_organisationunits” already exists

psql:data.sql:1031843: ERROR: constraint "fk_reporttable_organisationunits_repo

rttableid" for relation “reporttable_organisationunits” already exists

psql:data.sql:1031851: ERROR: constraint "fk_reporttable_orgunitgroups_orgunitg

roupid" for relation “reporttable_orgunitgroups” already exists

psql:data.sql:1031859: ERROR: constraint "fk_reporttable_orgunitlevels_reportta

bleid" for relation “reporttable_orgunitlevels” already exists

psql:data.sql:1031867: ERROR: constraint "fk_reporttable_orgunitunitgroups_repo

rttableid" for relation “reporttable_orgunitgroups” already exists

psql:data.sql:1031875: ERROR: constraint “fk_reporttable_periods_periodid” for

relation “reporttable_periods” already exists

psql:data.sql:1031883: ERROR: constraint “fk_reporttable_periods_reporttableid”

for relation “reporttable_periods” already exists

ALTER TABLE

psql:data.sql:1031899: ERROR: constraint “fk_reporttable_relativeperiodsid” for

relation “reporttable” already exists

psql:data.sql:1031907: ERROR: constraint “fk_reporttable_rows_reporttableid” fo

r relation “reporttable_rows” already exists

psql:data.sql:1031915: ERROR: constraint “fk_reporttable_userid” for relation "

reporttable" already exists

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

psql:data.sql:1031963: ERROR: constraint “fk_section_dataelementid” for relatio

n “sectiondataelements” already exists

psql:data.sql:1031971: ERROR: constraint “fk_section_dataelementoperandid” for

relation “sectiongreyedfields” already exists

psql:data.sql:1031979: ERROR: constraint “fk_section_datasetid” for relation "s

ection" already exists

psql:data.sql:1031987: ERROR: constraint “fk_section_indicatorid” for relation

“sectionindicators” already exists

psql:data.sql:1031995: ERROR: constraint “fk_sectiondataelements_sectionid” for

relation “sectiondataelements” already exists

psql:data.sql:1032003: ERROR: constraint “fk_sectiongreyedfields_sectionid” for

relation “sectiongreyedfields” already exists

psql:data.sql:1032011: ERROR: constraint “fk_sectionindicators_sectionid” for r

elation “sectionindicators” already exists

psql:data.sql:1032019: ERROR: constraint “fk_smscommand_program” for relation "

smscommands" already exists

psql:data.sql:1032027: ERROR: constraint “fk_smscommand_usergroup” for relation

“smscommands” already exists

ALTER TABLE

psql:data.sql:1032043: ERROR: constraint “fk_sqlview_userid” for relation "sqlv

iew" already exists

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

psql:data.sql:1032099: ERROR: constraint "fk_teprogramindicatordimension_legend

setid" for relation “trackedentityprogramindicatordimension” already exists

psql:data.sql:1032107: ERROR: constraint "fk_teprogramindicatordimension_progra

mindicatorid" for relation “trackedentityprogramindicatordimension” already exis

ts

psql:data.sql:1032115: ERROR: constraint "fk_trackedentityattribute_attributegr

oupid" for relation “trackedentityattribute” already exists

psql:data.sql:1032123: ERROR: constraint “fk_trackedentityattribute_legendset”

for relation “trackedentityattribute” already exists

psql:data.sql:1032131: ERROR: constraint "fk_trackedentityattribute_optionsetid

" for relation “trackedentityattribute” already exists

psql:data.sql:1032139: ERROR: constraint "fk_trackedentityattribute_trackedenti

tyattributeid" for relation “smscodes” already exists

psql:data.sql:1032147: ERROR: constraint "fk_trackedentityattribute_trackedenti

tyid" for relation “trackedentityattribute” already exists

psql:data.sql:1032155: ERROR: constraint “fk_trackedentityattribute_userid” for

relation “trackedentityattribute” already exists

ALTER TABLE

psql:data.sql:1032171: ERROR: constraint "fk_trackedentityinstance_organisation

unitid" for relation “trackedentityinstance” already exists

psql:data.sql:1032179: ERROR: constraint "fk_trackedentityinstance_representati

veid" for relation “trackedentityinstance” already exists

psql:data.sql:1032187: ERROR: constraint "fk_trackedentityinstance_trackedentit

yid" for relation “trackedentityinstance” already exists

psql:data.sql:1032195: ERROR: constraint “fk_user_userid” for relation “users”

already exists

psql:data.sql:1032203: ERROR: constraint “fk_user_userinfoid” for relation "use

rs" already exists

psql:data.sql:1032211: ERROR: constraint “fk_userapps_userinfoid” for relation

“userapps” already exists

psql:data.sql:1032219: ERROR: constraint "fk_userdatavieworgunits_organisationu

nitid" for relation “userdatavieworgunits” already exists

psql:data.sql:1032227: ERROR: constraint “fk_userdatavieworgunits_userinfoid” f

or relation “userdatavieworgunits” already exists

psql:data.sql:1032235: ERROR: constraint “fk_usergroup_userid” for relation "us

ergroup" already exists

psql:data.sql:1032243: ERROR: constraint “fk_usergroupaccess_usergroup” for rel

ation “usergroupaccess” already exists

psql:data.sql:1032251: ERROR: constraint "fk_usergroupmanaging_managedbygroupid

" for relation “usergroupmanaged” already exists

psql:data.sql:1032259: ERROR: constraint “fk_usergroupmanaging_managedgroupid”

for relation “usergroupmanaged” already exists

psql:data.sql:1032267: ERROR: constraint “fk_usergroupmembers_usergroupid” for

relation “usergroupmembers” already exists

psql:data.sql:1032275: ERROR: constraint “fk_usergroupmembers_userid” for relat

ion “usergroupmembers” already exists

psql:data.sql:1032283: ERROR: constraint “fk_userinfo_organisationunitid” for r

elation “usermembership” already exists

psql:data.sql:1032291: ERROR: constraint “fk_userkeyjsonvalue_user” for relatio

n “userkeyjsonvalue” already exists

psql:data.sql:1032299: ERROR: constraint “fk_usermembership_userinfoid” for rel

ation “usermembership” already exists

psql:data.sql:1032307: ERROR: constraint “fk_usermessage_user” for relation "us

ermessage" already exists

psql:data.sql:1032315: ERROR: constraint “fk_userrole_userid” for relation "use

rrole" already exists

psql:data.sql:1032323: ERROR: constraint “fk_userroleauthorities_userroleid” fo

r relation “userroleauthorities” already exists

psql:data.sql:1032331: ERROR: constraint “fk_userroledataset_datasetid” for rel

ation “userroledataset” already exists

psql:data.sql:1032339: ERROR: constraint “fk_userroledataset_userroleid” for re

lation “userroledataset” already exists

psql:data.sql:1032347: ERROR: constraint “fk_userrolemembers_userid” for relati

on “userrolemembers” already exists

psql:data.sql:1032355: ERROR: constraint “fk_userrolemembers_userroleid” for re

lation “userrolemembers” already exists

psql:data.sql:1032363: ERROR: constraint “fk_users_catconstraints_userid” for r

elation “users_catdimensionconstraints” already exists

psql:data.sql:1032371: ERROR: constraint “fk_users_cogsconstraints_userid” for

relation “users_cogsdimensionconstraints” already exists

psql:data.sql:1032379: ERROR: constraint “fk_usersetting_userinfoid” for relati

on “usersetting” already exists

psql:data.sql:1032387: ERROR: constraint "fk_userteisearchorgunits_organisation

unitid" for relation “userteisearchorgunits” already exists

psql:data.sql:1032395: ERROR: constraint “fk_userteisearchorgunits_userinfoid”

for relation “userteisearchorgunits” already exists

psql:data.sql:1032403: ERROR: constraint “fk_validationrule_leftexpressionid” f

or relation “validationrule” already exists

psql:data.sql:1032411: ERROR: constraint “fk_validationrule_periodtypeid” for r

elation “validationrule” already exists

psql:data.sql:1032419: ERROR: constraint “fk_validationrule_rightexpressionid”

for relation “validationrule” already exists

psql:data.sql:1032427: ERROR: constraint "fk_validationrule_skiptestexpressioni

d" for relation “validationrule” already exists

psql:data.sql:1032435: ERROR: constraint “fk_validationrulegroup_userid” for re

lation “validationrulegroup” already exists

psql:data.sql:1032443: ERROR: constraint "fk_validationrulegroup_validationrule

id" for relation “validationrulegroupmembers” already exists

psql:data.sql:1032451: ERROR: constraint "fk_validationrulegroupmembers_validat

ionrulegroupid" for relation “validationrulegroupmembers” already exists

psql:data.sql:1032459: ERROR: constraint "fk_validationrulegroupusergroupstoale

rt_usergroupid" for relation “validationrulegroupusergroupstoalert” already exis

ts

psql:data.sql:1032467: ERROR: constraint "fk_validationrulegroupusergroupstoale

rt_validationgroupid" for relation “validationrulegroupusergroupstoalert” alread

y exists

ALTER TABLE

REVOKE

REVOKE

GRANT

GRANT

GRANT

C:\Users\vundalon\Documents\software\data>


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2016-09-30 17:55 GMT+02:00 Knut Staring knutst@gmail.com:

What error?

On 30 Sep 2016 5:05 p.m., “ekialongo” vundalon@gmail.com wrote:

Hi Everyone,

I’m a newbie in DHIS2 and want to use its on window. I’m looking for the way to install the server by using Tomcat embeded in XAMP and restore a sql data base backup file (not a dump) in postgresql. Everything I tried send me error message.

Thanks.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Go and check at http://localhost:8080/dhis. From the log file tomcat and your dhis application are running. Admittedly running in a 32bit jre (which you should uninstall and reinstall a 64bit one) but running all the same.

···

On 13 October 2016 at 09:20, vunda limbe vundalon@gmail.com wrote:

Hi Knut, Lamin and everybody,

sorry for late responding due to personal matter.

Here are the error message for Tomcat and psql db import:

  1. Tomcat :

java.lang.UnsatisfiedLinkError: C:\xampp\tomcat\bin\tcnative-1.dll: Can’t load I

A 32-bit .dll on a AMD 64-bit platform

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1941)

at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1857)

at java.lang.Runtime.loadLibrary0(Runtime.java:870)

at java.lang.System.loadLibrary(System.java:1122)

at org.apache.tomcat.jni.Library.(Library.java:40)

at org.apache.tomcat.jni.Library.initialize(Library.java:172)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.catalina.core.AprLifecycleListener.init(AprLifecycleListen

er.java:194)

at org.apache.catalina.core.AprLifecycleListener.isAprAvailable(AprLifec

ycleListener.java:99)

at org.apache.catalina.connector.Connector.setProtocol(Connector.java:59

at org.apache.catalina.connector.Connector.(Connector.java:66)

at org.apache.catalina.startup.ConnectorCreateRule.begin(ConnectorCreate

Rule.java:62)

at org.apache.tomcat.util.digester.Digester.startElement(Digester.java:1

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startEle

ment(AbstractSAXParser.java:509)

at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.

emptyElement(AbstractXMLDocumentParser.java:182)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp

l.scanStartElement(XMLDocumentFragmentScannerImpl.java:1339)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp

l$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2784)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(X

MLDocumentScannerImpl.java:602)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp

l.scanDocument(XMLDocumentFragmentScannerImpl.java:505)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X

ML11Configuration.java:841)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X

ML11Configuration.java:770)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.

java:141)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Ab

stractSAXParser.java:1213)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.p

arse(SAXParserImpl.java:643)

at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)

at org.apache.catalina.startup.Catalina.load(Catalina.java:615)

at org.apache.catalina.startup.Catalina.load(Catalina.java:663)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:280)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:454)

Sep 30, 2016 4:57:50 PM org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performanc

e in production environments was not found on the java.library.path: C:\Program

Files\Java\jdk1.8.0_102\bin;C:\windows\Sun\Java\bin;C:\windows\system32;C:\windo

ws;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\

;C:\Program Files\Intel\iCLS Client;C:\windows\system32;C:\windows;C:\windows\S

ystem32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\

Intel\Intel® Management Engine Components\DAL;C:\Program Files\Intel\Intel®

Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel® Managemen

t Engine Components\IPT;C:\Program Files\Intel\Intel® Management Engine Compon

ents\IPT;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program

Files\Intel\WiFi\bin;C:\Program Files\Common Files\Intel\WirelessCommon;C:\Pro

gram Files (x86)\Common Files\Lenovo;C:\ProgramData\Lenovo\ReadyApps;C:\Program

Files (x86)\Skype\Phone;C:\Program Files (x86)\Gow\bin;C:\Program Files\Java\jd

k1.8.0_102\bin;C:\Program Files\PostgreSQL\9.4\bin;C:\Program Files (x86)\Calibr

e2;.

Sep 30, 2016 4:57:55 PM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler [“http-bio-8080”]

Sep 30, 2016 4:57:55 PM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler [“ajp-bio-8009”]

Sep 30, 2016 4:57:55 PM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 7609 ms

Sep 30, 2016 4:57:56 PM org.apache.catalina.core.StandardService startInternal

INFO: Starting service Catalina

Sep 30, 2016 4:57:56 PM org.apache.catalina.core.StandardEngine startInternal

INFO: Starting Servlet Engine: Apache Tomcat/7.0.56

Sep 30, 2016 4:57:56 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive C:\xampp\tomcat\webapps\dhis.war

  • INFO 2016-09-30 16:59:47,284 System property dhis2.home not set (DefaultLocat

ionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,293 Environment variable DHIS2_HOME points to C:\DHI

S2_HOME (DefaultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,343 File C:\DHIS2_HOME\dhis.conf does not exist (Def

aultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,355 File C:\DHIS2_HOME\dhis-google-auth.json does no

t exist (DefaultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,357 Could not find dhis-google-auth.json (DefaultDhi

sConfigurationProvider.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,358 File C:\DHIS2_HOME\dhis-google-auth.json does no

t exist (DefaultLocationManager.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:47,359 Could not find dhis-google-auth.json (DefaultDhi

sConfigurationProvider.java [localhost-startStop-1])

  • INFO 2016-09-30 16:59:52,871 Hibernate configuration loaded, using dialect: o

rg.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.ja

va [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,814 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,816 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,817 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,819 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,862 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,863 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,931 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,952 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,955 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,989 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,990 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,992 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,993 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:00,994 HHH90000003: Use of DOM4J entity-mode is conside

red deprecated (ModelBinder.java [localhost-startStop-1])

  • INFO 2016-09-30 17:00:50,730 Detected apps: [] (DefaultAppManager.java [local

host-startStop-1])

  • INFO 2016-09-30 17:00:53,032 Found the following message senders: [org.hisp.d

his.message.EmailMessageSender@337c3622, org.hisp.dhis.sms.config.SmsMessageSend

er@67c3f067] (DefaultMessageService.java [localhost-startStop-1])

  • INFO 2016-09-30 17:00:55,165 File store configured with provider ‘filesystem’

and container ‘files’. (JCloudsFileResourceContentStore.java [localhost-startS

top-1])

  • INFO 2016-09-30 17:00:57,532 Following listners are registered: [org.hisp.dhi

s.sms.listener.DataValueSMSListener@199b8ff9, org.hisp.dhis.sms.listener.J2MEDat

aValueSMSListener@4e8d6285, org.hisp.dhis.sms.listener.UnregisteredSMSListener@3

b54861f, org.hisp.dhis.sms.listener.DhisMessageAlertListener@2dc20d58, org.hisp.

dhis.sms.listener.TrackedEntityRegistrationSMSListener@6863bb5e, org.hisp.dhis.s

ms.listener.SingleEventListener@4ddf759d] (SmsConsumerThread.java [localhost-sta

rtStop-1])

  • INFO 2016-09-30 17:00:57,813 SMS consumer started (DefaultSmsConsumerService.

java [localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,977 Added logger: org.hisp.dhis.resourcetable using

file: C:\DHIS2_HOME\logs\dhis-analytics-table.log (Log4JLogConfigInitializer.jav

a [localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,978 Added logger: org.hisp.dhis.analytics.table usin

g file: C:\DHIS2_HOME\logs\dhis-analytics-table.log (Log4JLogConfigInitializer.j

ava [localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,979 Added logger: org.hisp.dhis.dxf2 using file: C:\

DHIS2_HOME\logs\dhis-data-exchange.log (Log4JLogConfigInitializer.java [localhos

t-startStop-1])

  • INFO 2016-09-30 17:00:58,979 Added logger: org.hisp.dhis.dxf2.synch using fil

e: C:\DHIS2_HOME\logs\dhis-data-sync.log (Log4JLogConfigInitializer.java [localh

ost-startStop-1])

  • INFO 2016-09-30 17:00:58,980 Added logger: org.hisp.dhis.dxf2.metadata using

file: C:\DHIS2_HOME\logs\dhis-metadata-sync.log (Log4JLogConfigInitializer.java

[localhost-startStop-1])

  • INFO 2016-09-30 17:00:58,981 Added root logger using file: C:\DHIS2_HOME\logs

\dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1])

  • WARN 2016-09-30 17:00:59,828 RP discovery / realm validation disabled; (Real

mVerifier.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,410 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,515 Scheduled task with key: 0 0 0 * * ? and cron: 0

0 0 * * ? (SpringScheduler.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,515 Scheduled task with key: fileResourceCleanupTask

and cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,516 Scheduled task with key: dataStatisticsTask and

cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:02,551 Executing startup routine [1 of 14, runlevel 1]:

InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:42,087 Executing startup routine [2 of 14, runlevel 2]:

PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]

)

  • INFO 2016-09-30 17:01:42,338 Executing startup routine [3 of 14, runlevel 3]:

DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [local

host-startStop-1])

  • INFO 2016-09-30 17:01:43,528 ‘system-process’ update org.hisp.dhis.dataelemen

t.DataElementCategory, name: default, uid: GLevLNI9wkl (AuditLogUtil.java [local

host-startStop-1])

  • INFO 2016-09-30 17:01:44,209 Executing startup routine [4 of 14, runlevel 4]:

IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:53,456 Executing startup routine [5 of 14, runlevel 4]:

ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-start

Stop-1])

  • INFO 2016-09-30 17:01:54,659 Executing startup routine [6 of 14, runlevel 5]:

TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:01:54,718 Executing startup routine [7 of 14, runlevel 6]:

TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:03,913 Tables updated (TableAlteror.java [localhost-sta

rtStop-1])

  • INFO 2016-09-30 17:05:03,914 Executing startup routine [8 of 14, runlevel 7]:

TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startS

top-1])

  • INFO 2016-09-30 17:05:29,265 Executing startup routine [9 of 14, runlevel 7]:

ModelUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:29,307 Executing startup routine [10 of 14, runlevel 9]

: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startS

top-1])

  • INFO 2016-09-30 17:05:29,315 Executing startup routine [11 of 14, runlevel 10

]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-start

Stop-1])

  • INFO 2016-09-30 17:05:29,665 Upgraded custom case entry form identifiers (Dat

aEntryFormUpgrader.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:29,667 Executing startup routine [12 of 14, runlevel 11

]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1

])

  • INFO 2016-09-30 17:05:30,120 Executing startup routine [13 of 14, runlevel 12

]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startSt

op-1])

  • WARN 2016-09-30 17:05:30,125 Encryption not configured: Missing the required

JCE policy files for strong encryption. (ConfigurationPopulator.java [localhost-

startStop-1])

  • INFO 2016-09-30 17:05:30,366 Executing startup routine [14 of 14, runlevel 13

]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-

1])

  • INFO 2016-09-30 17:05:30,757 All startup routines done (DefaultStartupRoutine

Executor.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:37,960 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:38,166 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:41,053 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

  • INFO 2016-09-30 17:05:41,523 SMS configuration not found (DefaultSmsConfigura

tionManager.java [localhost-startStop-1])

Sep 30, 2016 5:05:41 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deployment of web application archive C:\xampp\tomcat\webapps\dhis.war has

finished in 465,305 ms

Sep 30, 2016 5:05:41 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\docs

Sep 30, 2016 5:05:42 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\docs has f

inished in 230 ms

Sep 30, 2016 5:05:42 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\examples

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\examples h

as finished in 6,134 ms

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\host-manager

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\host-manag

er has finished in 91 ms

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\manager

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\manager ha

s finished in 69 ms

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deploying web application directory C:\xampp\tomcat\webapps\ROOT

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.HostConfig deployDirectory

INFO: Deployment of web application directory C:\xampp\tomcat\webapps\ROOT has f

inished in 59 ms

Sep 30, 2016 5:05:48 PM org.apache.coyote.AbstractProtocol start

INFO: Starting ProtocolHandler [“http-bio-8080”]

Sep 30, 2016 5:05:48 PM org.apache.coyote.AbstractProtocol start

INFO: Starting ProtocolHandler [“ajp-bio-8009”]

Sep 30, 2016 5:05:48 PM org.apache.catalina.startup.Catalina start

INFO: Server startup in 472338 ms

  1. psql DB import

psql:data.sql:1031227: ERROR: constraint “fk_program_dataentryformid” for relat

ion “program” already exists

psql:data.sql:1031235: ERROR: constraint "fk_program_organisationunits_organisa

tionunitid" for relation “program_organisationunits” already exists

psql:data.sql:1031243: ERROR: constraint "fk_program_organisationunits_programi

d" for relation “program_organisationunits” already exists

psql:data.sql:1031251: ERROR: constraint “fk_program_programstageid” for relati

on “programstagesection” already exists

psql:data.sql:1031259: ERROR: constraint “fk_program_relatedprogram” for relati

on “program” already exists

psql:data.sql:1031267: ERROR: constraint “fk_program_relationshipid” for relati

on “program” already exists

psql:data.sql:1031275: ERROR: constraint “fk_program_trackedentityid” for relat

ion “program” already exists

psql:data.sql:1031283: ERROR: constraint “fk_program_userid” for relation "prog

ram" already exists

psql:data.sql:1031291: ERROR: constraint “fk_program_userroles” for relation "p

rogram_userroles" already exists

psql:data.sql:1031299: ERROR: constraint “fk_program_workflowid” for relation "

program" already exists

psql:data.sql:1031307: ERROR: constraint “fk_programdataelement_dataelement” fo

r relation “programdataelement” already exists

psql:data.sql:1031315: ERROR: constraint “fk_programdataelement_program” for re

lation “programdataelement” already exists

psql:data.sql:1031323: ERROR: constraint “fk_programindicator_legendset” for re

lation “programindicator” already exists

psql:data.sql:1031331: ERROR: constraint “fk_programindicator_program” for rela

tion “programindicator” already exists

psql:data.sql:1031339: ERROR: constraint “fk_programindicator_userid” for relat

ion “programindicator” already exists

psql:data.sql:1031347: ERROR: constraint "fk_programinstance_organisationunitid

" for relation “programinstance” already exists

psql:data.sql:1031355: ERROR: constraint “fk_programinstance_programid” for rel

ation “programinstance” already exists

psql:data.sql:1031363: ERROR: constraint "fk_programinstance_trackedentityinsta

nceid" for relation “programinstance” already exists

psql:data.sql:1031371: ERROR: constraint “fk_programrule_program” for relation

“programrule” already exists

psql:data.sql:1031379: ERROR: constraint “fk_programrule_programstage” for rela

tion “programrule” already exists

psql:data.sql:1031387: ERROR: constraint “fk_programruleaction_dataelement” for

relation “programruleaction” already exists

psql:data.sql:1031395: ERROR: constraint "fk_programruleaction_programindicator

" for relation “programruleaction” already exists

psql:data.sql:1031403: ERROR: constraint “fk_programruleaction_programrule” for

relation “programruleaction” already exists

psql:data.sql:1031411: ERROR: constraint “fk_programruleaction_programstage” fo

r relation “programruleaction” already exists

psql:data.sql:1031419: ERROR: constraint "fk_programruleaction_programstagesect

ion" for relation “programruleaction” already exists

psql:data.sql:1031427: ERROR: constraint "fk_programruleaction_trackedentityatt

ribute" for relation “programruleaction” already exists

psql:data.sql:1031435: ERROR: constraint “fk_programrulevariable_dataelement” f

or relation “programrulevariable” already exists

psql:data.sql:1031443: ERROR: constraint “fk_programrulevariable_program” for r

elation “programrulevariable” already exists

psql:data.sql:1031451: ERROR: constraint “fk_programrulevariable_programstage”

for relation “programrulevariable” already exists

psql:data.sql:1031459: ERROR: constraint "fk_programrulevariable_trackedentitya

ttribute" for relation “programrulevariable” already exists

psql:data.sql:1031467: ERROR: constraint “fk_programstage_dataentryform” for re

lation “programstage” already exists

psql:data.sql:1031475: ERROR: constraint “fk_programstage_periodtypeid” for rel

ation “programstage” already exists

psql:data.sql:1031483: ERROR: constraint “fk_programstage_program” for relation

“programstage” already exists

psql:data.sql:1031491: ERROR: constraint "fk_programstagedataelement_dataelemen

tid" for relation “programstagedataelement” already exists

psql:data.sql:1031499: ERROR: constraint "fk_programstagedataelement_programsta

geid" for relation “programstagedataelement” already exists

psql:data.sql:1031507: ERROR: constraint "fk_programstageinstance_attributeopti

oncomboid" for relation “programstageinstance” already exists

psql:data.sql:1031515: ERROR: constraint "fk_programstageinstance_organisationu

nitid" for relation “programstageinstance” already exists

psql:data.sql:1031523: ERROR: constraint "fk_programstageinstance_programinstan

ceid" for relation “programstageinstance” already exists

psql:data.sql:1031531: ERROR: constraint "fk_programstageinstance_programstagei

d" for relation “programstageinstance” already exists

psql:data.sql:1031539: ERROR: constraint "fk_programstagesection_programindicat

ors_indicatorid" for relation “programstagesection_programindicators” already ex

ists

psql:data.sql:1031547: ERROR: constraint "fk_programstagesection_programindicat

ors_sectionid" for relation “programstagesection_programindicators” already exis

ts

psql:data.sql:1031555: ERROR: constraint "fk_programvalidation_leftprogramexpre

ssionid" for relation “programvalidation” already exists

psql:data.sql:1031563: ERROR: constraint “fk_programvalidation_programid” for r

elation “programvalidation” already exists

psql:data.sql:1031571: ERROR: constraint "fk_programvalidation_rightprogramexpr

essionid" for relation “programvalidation” already exists

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

psql:data.sql:1031675: ERROR: constraint “fk_relationship_relationshiptypeid” f

or relation “relationship” already exists

psql:data.sql:1031683: ERROR: constraint "fk_relationship_trackedentityinstance

ida" for relation “relationship” already exists

psql:data.sql:1031691: ERROR: constraint "fk_relationship_trackedentityinstance

idb" for relation “relationship” already exists

psql:data.sql:1031699: ERROR: constraint “fk_reminder_usergroup” for relation "

trackedentityinstancereminder" already exists

psql:data.sql:1031707: ERROR: constraint “fk_report_relativeperiodsid” for rela

tion “report” already exists

psql:data.sql:1031715: ERROR: constraint “fk_report_reporttableid” for relation

“report” already exists

psql:data.sql:1031723: ERROR: constraint “fk_report_userid” for relation "repor

t" already exists

psql:data.sql:1031731: ERROR: constraint "fk_reporttable_categorydimensions_cat

egorydimensionid" for relation “reporttable_categorydimensions” already exists

psql:data.sql:1031739: ERROR: constraint "fk_reporttable_categorydimensions_rep

orttableid" for relation “reporttable_categorydimensions” already exists

psql:data.sql:1031747: ERROR: constraint "fk_reporttable_categoryoptiongroups_c

ategoryoptiongroupid" for relation “reporttable_categoryoptiongroups” already ex

ists

psql:data.sql:1031755: ERROR: constraint "fk_reporttable_categoryoptiongroups_r

eporttableid" for relation “reporttable_categoryoptiongroups” already exists

psql:data.sql:1031763: ERROR: constraint “fk_reporttable_columns_reporttableid”

for relation “reporttable_columns” already exists

psql:data.sql:1031771: ERROR: constraint "fk_reporttable_datadimensionitems_dat

adimensionitemid" for relation “reporttable_datadimensionitems” already exists

psql:data.sql:1031779: ERROR: constraint "fk_reporttable_datadimensionitems_rep

orttableid" for relation “reporttable_datadimensionitems” already exists

psql:data.sql:1031787: ERROR: constraint "fk_reporttable_dataelementgroups_data

elementgroupid" for relation “reporttable_dataelementgroups” already exists

psql:data.sql:1031795: ERROR: constraint "fk_reporttable_dataelementgroups_repo

rttableid" for relation “reporttable_dataelementgroups” already exists

psql:data.sql:1031803: ERROR: constraint “fk_reporttable_filters_reporttableid”

for relation “reporttable_filters” already exists

psql:data.sql:1031811: ERROR: constraint "fk_reporttable_itemorgunitgroups_orgu

nitgroupid" for relation “reporttable_itemorgunitgroups” already exists

psql:data.sql:1031819: ERROR: constraint "fk_reporttable_itemorgunitunitgroups_

reporttableid" for relation “reporttable_itemorgunitgroups” already exists

psql:data.sql:1031827: ERROR: constraint “fk_reporttable_legendsetid” for relat

ion “reporttable” already exists

psql:data.sql:1031835: ERROR: constraint "fk_reporttable_organisationunits_orga

nisationunitid" for relation “reporttable_organisationunits” already exists

psql:data.sql:1031843: ERROR: constraint "fk_reporttable_organisationunits_repo

rttableid" for relation “reporttable_organisationunits” already exists

psql:data.sql:1031851: ERROR: constraint "fk_reporttable_orgunitgroups_orgunitg

roupid" for relation “reporttable_orgunitgroups” already exists

psql:data.sql:1031859: ERROR: constraint "fk_reporttable_orgunitlevels_reportta

bleid" for relation “reporttable_orgunitlevels” already exists

psql:data.sql:1031867: ERROR: constraint "fk_reporttable_orgunitunitgroups_repo

rttableid" for relation “reporttable_orgunitgroups” already exists

psql:data.sql:1031875: ERROR: constraint “fk_reporttable_periods_periodid” for

relation “reporttable_periods” already exists

psql:data.sql:1031883: ERROR: constraint “fk_reporttable_periods_reporttableid”

for relation “reporttable_periods” already exists

ALTER TABLE

psql:data.sql:1031899: ERROR: constraint “fk_reporttable_relativeperiodsid” for

relation “reporttable” already exists

psql:data.sql:1031907: ERROR: constraint “fk_reporttable_rows_reporttableid” fo

r relation “reporttable_rows” already exists

psql:data.sql:1031915: ERROR: constraint “fk_reporttable_userid” for relation "

reporttable" already exists

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

psql:data.sql:1031963: ERROR: constraint “fk_section_dataelementid” for relatio

n “sectiondataelements” already exists

psql:data.sql:1031971: ERROR: constraint “fk_section_dataelementoperandid” for

relation “sectiongreyedfields” already exists

psql:data.sql:1031979: ERROR: constraint “fk_section_datasetid” for relation "s

ection" already exists

psql:data.sql:1031987: ERROR: constraint “fk_section_indicatorid” for relation

“sectionindicators” already exists

psql:data.sql:1031995: ERROR: constraint “fk_sectiondataelements_sectionid” for

relation “sectiondataelements” already exists

psql:data.sql:1032003: ERROR: constraint “fk_sectiongreyedfields_sectionid” for

relation “sectiongreyedfields” already exists

psql:data.sql:1032011: ERROR: constraint “fk_sectionindicators_sectionid” for r

elation “sectionindicators” already exists

psql:data.sql:1032019: ERROR: constraint “fk_smscommand_program” for relation "

smscommands" already exists

psql:data.sql:1032027: ERROR: constraint “fk_smscommand_usergroup” for relation

“smscommands” already exists

ALTER TABLE

psql:data.sql:1032043: ERROR: constraint “fk_sqlview_userid” for relation "sqlv

iew" already exists

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE

psql:data.sql:1032099: ERROR: constraint "fk_teprogramindicatordimension_legend

setid" for relation “trackedentityprogramindicatordimension” already exists

psql:data.sql:1032107: ERROR: constraint "fk_teprogramindicatordimension_progra

mindicatorid" for relation “trackedentityprogramindicatordimension” already exis

ts

psql:data.sql:1032115: ERROR: constraint "fk_trackedentityattribute_attributegr

oupid" for relation “trackedentityattribute” already exists

psql:data.sql:1032123: ERROR: constraint “fk_trackedentityattribute_legendset”

for relation “trackedentityattribute” already exists

psql:data.sql:1032131: ERROR: constraint "fk_trackedentityattribute_optionsetid

" for relation “trackedentityattribute” already exists

psql:data.sql:1032139: ERROR: constraint "fk_trackedentityattribute_trackedenti

tyattributeid" for relation “smscodes” already exists

psql:data.sql:1032147: ERROR: constraint "fk_trackedentityattribute_trackedenti

tyid" for relation “trackedentityattribute” already exists

psql:data.sql:1032155: ERROR: constraint “fk_trackedentityattribute_userid” for

relation “trackedentityattribute” already exists

ALTER TABLE

psql:data.sql:1032171: ERROR: constraint "fk_trackedentityinstance_organisation

unitid" for relation “trackedentityinstance” already exists

psql:data.sql:1032179: ERROR: constraint "fk_trackedentityinstance_representati

veid" for relation “trackedentityinstance” already exists

psql:data.sql:1032187: ERROR: constraint "fk_trackedentityinstance_trackedentit

yid" for relation “trackedentityinstance” already exists

psql:data.sql:1032195: ERROR: constraint “fk_user_userid” for relation “users”

already exists

psql:data.sql:1032203: ERROR: constraint “fk_user_userinfoid” for relation "use

rs" already exists

psql:data.sql:1032211: ERROR: constraint “fk_userapps_userinfoid” for relation

“userapps” already exists

psql:data.sql:1032219: ERROR: constraint "fk_userdatavieworgunits_organisationu

nitid" for relation “userdatavieworgunits” already exists

psql:data.sql:1032227: ERROR: constraint “fk_userdatavieworgunits_userinfoid” f

or relation “userdatavieworgunits” already exists

psql:data.sql:1032235: ERROR: constraint “fk_usergroup_userid” for relation "us

ergroup" already exists

psql:data.sql:1032243: ERROR: constraint “fk_usergroupaccess_usergroup” for rel

ation “usergroupaccess” already exists

psql:data.sql:1032251: ERROR: constraint "fk_usergroupmanaging_managedbygroupid

" for relation “usergroupmanaged” already exists

psql:data.sql:1032259: ERROR: constraint “fk_usergroupmanaging_managedgroupid”

for relation “usergroupmanaged” already exists

psql:data.sql:1032267: ERROR: constraint “fk_usergroupmembers_usergroupid” for

relation “usergroupmembers” already exists

psql:data.sql:1032275: ERROR: constraint “fk_usergroupmembers_userid” for relat

ion “usergroupmembers” already exists

psql:data.sql:1032283: ERROR: constraint “fk_userinfo_organisationunitid” for r

elation “usermembership” already exists

psql:data.sql:1032291: ERROR: constraint “fk_userkeyjsonvalue_user” for relatio

n “userkeyjsonvalue” already exists

psql:data.sql:1032299: ERROR: constraint “fk_usermembership_userinfoid” for rel

ation “usermembership” already exists

psql:data.sql:1032307: ERROR: constraint “fk_usermessage_user” for relation "us

ermessage" already exists

psql:data.sql:1032315: ERROR: constraint “fk_userrole_userid” for relation "use

rrole" already exists

psql:data.sql:1032323: ERROR: constraint “fk_userroleauthorities_userroleid” fo

r relation “userroleauthorities” already exists

psql:data.sql:1032331: ERROR: constraint “fk_userroledataset_datasetid” for rel

ation “userroledataset” already exists

psql:data.sql:1032339: ERROR: constraint “fk_userroledataset_userroleid” for re

lation “userroledataset” already exists

psql:data.sql:1032347: ERROR: constraint “fk_userrolemembers_userid” for relati

on “userrolemembers” already exists

psql:data.sql:1032355: ERROR: constraint “fk_userrolemembers_userroleid” for re

lation “userrolemembers” already exists

psql:data.sql:1032363: ERROR: constraint “fk_users_catconstraints_userid” for r

elation “users_catdimensionconstraints” already exists

psql:data.sql:1032371: ERROR: constraint “fk_users_cogsconstraints_userid” for

relation “users_cogsdimensionconstraints” already exists

psql:data.sql:1032379: ERROR: constraint “fk_usersetting_userinfoid” for relati

on “usersetting” already exists

psql:data.sql:1032387: ERROR: constraint "fk_userteisearchorgunits_organisation

unitid" for relation “userteisearchorgunits” already exists

psql:data.sql:1032395: ERROR: constraint “fk_userteisearchorgunits_userinfoid”

for relation “userteisearchorgunits” already exists

psql:data.sql:1032403: ERROR: constraint “fk_validationrule_leftexpressionid” f

or relation “validationrule” already exists

psql:data.sql:1032411: ERROR: constraint “fk_validationrule_periodtypeid” for r

elation “validationrule” already exists

psql:data.sql:1032419: ERROR: constraint “fk_validationrule_rightexpressionid”

for relation “validationrule” already exists

psql:data.sql:1032427: ERROR: constraint "fk_validationrule_skiptestexpressioni

d" for relation “validationrule” already exists

psql:data.sql:1032435: ERROR: constraint “fk_validationrulegroup_userid” for re

lation “validationrulegroup” already exists

psql:data.sql:1032443: ERROR: constraint "fk_validationrulegroup_validationrule

id" for relation “validationrulegroupmembers” already exists

psql:data.sql:1032451: ERROR: constraint "fk_validationrulegroupmembers_validat

ionrulegroupid" for relation “validationrulegroupmembers” already exists

psql:data.sql:1032459: ERROR: constraint "fk_validationrulegroupusergroupstoale

rt_usergroupid" for relation “validationrulegroupusergroupstoalert” already exis

ts

psql:data.sql:1032467: ERROR: constraint "fk_validationrulegroupusergroupstoale

rt_validationgroupid" for relation “validationrulegroupusergroupstoalert” alread

y exists

ALTER TABLE

REVOKE

REVOKE

GRANT

GRANT

GRANT

C:\Users\vundalon\Documents\software\data>


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2016-09-30 17:55 GMT+02:00 Knut Staring knutst@gmail.com:

What error?

On 30 Sep 2016 5:05 p.m., “ekialongo” vundalon@gmail.com wrote:

Hi Everyone,

I’m a newbie in DHIS2 and want to use its on window. I’m looking for the way to install the server by using Tomcat embeded in XAMP and restore a sql data base backup file (not a dump) in postgresql. Everything I tried send me error message.

Thanks.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp