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:
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
ionManager.java [localhost-startStop-1])
S2_HOME (DefaultLocationManager.java [localhost-startStop-1])
aultLocationManager.java [localhost-startStop-1])
t exist (DefaultLocationManager.java [localhost-startStop-1])
sConfigurationProvider.java [localhost-startStop-1])
t exist (DefaultLocationManager.java [localhost-startStop-1])
sConfigurationProvider.java [localhost-startStop-1])
rg.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.ja
va [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
red deprecated (ModelBinder.java [localhost-startStop-1])
host-startStop-1])
his.message.EmailMessageSender@337c3622, org.hisp.dhis.sms.config.SmsMessageSend
er@67c3f067] (DefaultMessageService.java [localhost-startStop-1])
and container ‘files’. (JCloudsFileResourceContentStore.java [localhost-startS
top-1])
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])
java [localhost-startStop-1])
file: C:\DHIS2_HOME\logs\dhis-analytics-table.log (Log4JLogConfigInitializer.jav
a [localhost-startStop-1])
g file: C:\DHIS2_HOME\logs\dhis-analytics-table.log (Log4JLogConfigInitializer.j
ava [localhost-startStop-1])
DHIS2_HOME\logs\dhis-data-exchange.log (Log4JLogConfigInitializer.java [localhos
t-startStop-1])
e: C:\DHIS2_HOME\logs\dhis-data-sync.log (Log4JLogConfigInitializer.java [localh
ost-startStop-1])
file: C:\DHIS2_HOME\logs\dhis-metadata-sync.log (Log4JLogConfigInitializer.java
[localhost-startStop-1])
\dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
mVerifier.java [localhost-startStop-1])
tionManager.java [localhost-startStop-1])
0 0 * * ? (SpringScheduler.java [localhost-startStop-1])
and cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])
cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])
InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]
)
DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [local
host-startStop-1])
t.DataElementCategory, name: default, uid: GLevLNI9wkl (AuditLogUtil.java [local
host-startStop-1])
IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-start
Stop-1])
TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
rtStop-1])
TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startS
top-1])
ModelUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startS
top-1])
]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-start
Stop-1])
aEntryFormUpgrader.java [localhost-startStop-1])
]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1
])
]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startSt
op-1])
JCE policy files for strong encryption. (ConfigurationPopulator.java [localhost-
startStop-1])
]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-
1])
Executor.java [localhost-startStop-1])
tionManager.java [localhost-startStop-1])
tionManager.java [localhost-startStop-1])
tionManager.java [localhost-startStop-1])
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
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:
- 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
- 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:
- 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
- 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