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 <[email protected]> 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 <[email protected]>: > >> What error? >> >> On 30 Sep 2016 5:05 p.m., "ekialongo" <[email protected]> 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 : [email protected] >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
