dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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@xxxxxxxxx> wrote:

> Hi Knut, Lamin and everybody,
>
> sorry for late responding due to personal matter.
> Here are the error message for Tomcat and psql db import:
>
> 1. Tomcat :
>
>
> java.lang.UnsatisfiedLinkError: C:\xampp\tomcat\bin\tcnative-1.dll: Can't
> load I
> A 32-bit .dll on a AMD 64-bit platform
>         at java.lang.ClassLoader$NativeLibrary.load(Native Method)
>         at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1941)
>         at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1857)
>         at java.lang.Runtime.loadLibrary0(Runtime.java:870)
>         at java.lang.System.loadLibrary(System.java:1122)
>         at org.apache.tomcat.jni.Library.<init>(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
> 2)
>         at org.apache.catalina.connector.Connector.<init>(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
> 288)
>         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 (DefaultHibernateConfigurationP
> rovider.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
>
>
> 2. 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>
>
>
> 2016-09-30 17:55 GMT+02:00 Knut Staring <knutst@xxxxxxxxx>:
>
>> What error?
>>
>> On 30 Sep 2016 5:05 p.m., "ekialongo" <vundalon@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>