dhis2-devs team mailing list archive

Thread
Date

Fwd: Dhis2 versão de teste

To: dhis2-users@xxxxxxxxxxxxxxxxxxx, dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
From: Marcio Thome <mthome@xxxxxxxxxxxxx>
Date: Mon, 17 Mar 2014 12:01:15 -0300
In-reply-to: <CANsnOhZ43AbF3FrwB2_YTLvVBzc5iuBV6ywpZ_ovLWnOWW2kMg@mail.gmail.com>

Dear All

I am needing some help to install DHIS2 Ver. 2.14 build 13815 on APache
Tomcat 7.0, MySQL version 5.2.43, Java version 7.0-07. I am attaching three
logs:

1. First run of DHIS
2. About with the built number
3. Error from MySQL: can't create dhis2.datavalue.

I am needing to develop new reports ASAP and would like to use the
functionalities of 2.14.

Thank you all.

Best

Marcio


-- 
Márcio Thomé

Coordenador
Departamento de Avaliação e Estatísticas
BEMFAM - Bem Estar Familiar no Brasil

Avenida Carlos Chagas Filho, 791. Ilha do Fundão.
Rio de Janeiro. 21941-599
Tel.: 55-21-30057207 R. 2408
Skype: Marcio-Deav

Mar 17, 2014 10:45:21 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.7.0_07\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program Files/Java/jre7/lib/i386;C:\Program Files\CodeGear\RAD Studio\5.0\bin;C:\Users\Public\Documents\RAD Studio\5.0\Bpl;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\CodeGear\RAD Studio\5.0\lib\DevExpress\Delphi 2007 Library\;C:\Users\administrador\Documents\Repositorio_SES\bin;C:\Program Files\TortoiseSVN\bin;C:\Program Files\MySQL\MySQL Server 5.5\bin;C:\Program Files\Java\jdk1.7.0_07\bin;C:\Program Files\CodeGear\RAD Studio\5.0\bin;C:\Users\Public\Documents\RAD Studio\5.0\Bpl;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\CodeGear\RAD Studio\5.0\lib\DevExpress\Delphi 2007 Library\;C:\Users\administrador\Documents\Repositorio_SES\bin;C:\Program Files\TortoiseSVN\bin;C:\Program Files\MySQL\MySQL Server 5.5\bin;;D:\eclipse;;.
Mar 17, 2014 10:45:21 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.j2ee.server:dhis2' did not find a matching property.
Mar 17, 2014 10:45:21 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Mar 17, 2014 10:45:21 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Mar 17, 2014 10:45:21 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 489 ms
Mar 17, 2014 10:45:21 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Mar 17, 2014 10:45:21 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.40
Mar 17, 2014 10:45:30 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
Mar 17, 2014 10:45:30 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
* INFO  2014-03-17 10:45:33,677 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-03-17 10:45:33,680 Environment variable DHIS2_HOME not set (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-03-17 10:45:33,680 Home directory set to /opt/dhis2 (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-03-17 10:45:34,422 File D:\opt\dhis2\hibernate.properties does not exist (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-03-17 10:45:34,422 Could not read external configuration from file system (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
* INFO  2014-03-17 10:45:34,423 Hibernate configuration loaded, using dialect: org.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:16,636 HHH000388: Unsuccessful: alter table dataelementcategoryoption add index fk_dataelementcategory_conceptid (conceptid), add constraint fk_dataelementcategory_conceptid foreign key (conceptid) references concept (conceptid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:16,637 Can't create table 'dhis2.#sql-6dc_f78' (errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:25,594 HHH000388: Unsuccessful: alter table indicator add index fk_indicator_userid (userid), add constraint fk_indicator_userid foreign key (userid) references userinfo (userinfoid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:25,595 Can't create table 'dhis2.#sql-6dc_f78' (errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:25,662 HHH000388: Unsuccessful: alter table indicator add index fk_indicator_legendset (legendsetid), add constraint fk_indicator_legendset foreign key (legendsetid) references maplegendset (maplegendsetid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:25,663 Can't create table 'dhis2.#sql-6dc_f78' (errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:29,894 HHH000388: Unsuccessful: alter table interpretationcomment add index fk_interpretation_userid (userid), add constraint fk_interpretation_userid foreign key (userid) references userinfo (userinfoid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:29,895 Can't create table 'dhis2.#sql-6dc_f78' (errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:37,602 HHH000388: Unsuccessful: alter table orgunitgroup add index fk_indicator_userid (userid), add constraint fk_indicator_userid foreign key (userid) references userinfo (userinfoid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:37,603 Can't create table 'dhis2.#sql-6dc_f78' (errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:55,384 HHH000388: Unsuccessful: alter table report add index fk_report_relativeperiodsid (relativeperiodsid), add constraint fk_report_relativeperiodsid foreign key (relativeperiodsid) references relativeperiods (relativeperiodsid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:55,385 Can't create table 'dhis2.#sql-6dc_f78' (errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:55,766 HHH000388: Unsuccessful: alter table reporttable add index fk_report_relativeperiodsid (relativeperiodsid), add constraint fk_report_relativeperiodsid foreign key (relativeperiodsid) references relativeperiods (relativeperiodsid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:46:55,767 Can't create table 'dhis2.#sql-6dc_f78' (errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:47:04,378 HHH000388: Unsuccessful: alter table usergroupmembers add index fk_usergroup_userid (userid), add constraint fk_usergroup_userid foreign key (userid) references userinfo (userinfoid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-17 10:47:04,379 Can't create table 'dhis2.#sql-6dc_f78' (errno: 121) (SchemaUpdate.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:20,002 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@106a791, org.hisp.dhis.sms.SmsMessageSender@1e33cd0] (DefaultMessageService.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:28,887 Detected apps: [] (DefaultAppManager.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:37,106 Executing startup routine [1 of 11, runlevel 1]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:37,196 Executing startup routine [2 of 11, runlevel 1]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:37,229 Added default concept (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:38,012 Added default category (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:38,034 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:38,065 Executing startup routine [3 of 11, runlevel 2]: TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:42,116 Tables updated (TableAlteror.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:42,116 Executing startup routine [4 of 11, runlevel 3]: IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:51,710 Executing startup routine [5 of 11, runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:52,338 Created table/index messageconversation_lastmessage (TableCreator.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:52,448 Created table/index interpretation_lastupdated (TableCreator.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:52,449 Executing startup routine [6 of 11, runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,588 Inserted data into program_attributes table. (TableAlteror.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,593 Inserted data into program_identifiertypes table. (TableAlteror.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,598 Dropped program_patientattributes table. (TableAlteror.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,603 Dropped program_patientidentifiertypes table. (TableAlteror.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,604 Executing startup routine [7 of 11, runlevel 4]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,683 Executing startup routine [8 of 11, runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,684 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,685 Executing startup routine [9 of 11, runlevel 6]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,696 Executing startup routine [10 of 11, runlevel 7]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:53,723 Executing startup routine [11 of 11, runlevel 7]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:54,564 Populated default locales (I18nLocalePopulator.java [localhost-startStop-1])
* INFO  2014-03-17 10:47:54,564 All startup routines done (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
Mar 17, 2014 10:47:58 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'webapi-fred'
* WARN  2014-03-17 10:48:02,237 Did not find any ViewResolvers to delegate to; please configure them using the 'viewResolvers' property on the ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java [localhost-startStop-1])
Mar 17, 2014 10:48:02 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'webapi'
Mar 17, 2014 10:48:11 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'mobile'
Mar 17, 2014 10:48:12 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Mar 17, 2014 10:48:12 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Mar 17, 2014 10:48:12 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 170312 ms

Attachment: 2_ABOUT_DHIS2_BUILD_214_13815.jpg
Description: JPEG image

10:58:54 Restoring C:\Users\dmoliveira\Desktop\bckp 20140314 1516.sql

Running: mysql.exe --defaults-extra-file="c:\users\dmoliv~1\appdata\local\temp\tmp1dhwjj.cnf"  --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=dhis2 < "C:\\Users\\dmoliveira\\Desktop\\bckp 20140314 1516.sql"

ERROR 1005 (HY000) at line 1757080: Can't create table 'dhis2.datavalue' (errno: 150)


Operation failed with exitcode 1

11:00:57 Import of C:\Users\dmoliveira\Desktop\bckp 20140314 1516.sql has finished with 1 errors

Follow ups

Re: Fwd: Dhis2 versão de teste
From: Bob Jolliffe, 2014-03-18