Advertisement
Guest User

dhis2.10

a guest
Jan 15th, 2013
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 12.34 KB | None | 0 0
  1. * ERROR 2013-01-15 23:15:08,850 Can't create table 'zimbabwerbf.#sql-410_51b' (errno: 150) (SchemaUpdate.java [pool-2-thread-1])
  2. * ERROR 2013-01-15 23:15:08,959 HHH000388: Unsuccessful: alter table program_patientIdentifierTypes add index fk_program_patientIdentifierTypes_patientidentifiertypeid (patientidentifiertypeid), add constraint fk_program_patientIdentifierTypes_patientidentifiertypeid foreign key (patientidentifiertypeid) references patientidentifiertype (patientidentifiertypeid) (SchemaUpdate.java [pool-2-thread-1])
  3. * ERROR 2013-01-15 23:15:08,960 Can't create table 'zimbabwerbf.#sql-410_51b' (errno: 150) (SchemaUpdate.java [pool-2-thread-1])
  4. * ERROR 2013-01-15 23:15:09,074 HHH000388: Unsuccessful: alter table programstageinstance_outboundsms add index FKD7263DB9BACED27D (programstageinstanceid), add constraint FKD7263DB9BACED27D foreign key (programstageinstanceid) references programstageinstance (programstageinstanceid) (SchemaUpdate.java [pool-2-thread-1])
  5. * ERROR 2013-01-15 23:15:09,075 Can't create table 'zimbabwerbf.#sql-410_51b' (errno: 150) (SchemaUpdate.java [pool-2-thread-1])
  6. * ERROR 2013-01-15 23:15:09,173 HHH000388: Unsuccessful: alter table programstageinstance_outboundsms add index FKD7263DB9E486B09E (outboundsmsid), add constraint FKD7263DB9E486B09E foreign key (outboundsmsid) references outbound_sms (id) (SchemaUpdate.java [pool-2-thread-1])
  7. * ERROR 2013-01-15 23:15:09,174 Can't create table 'zimbabwerbf.#sql-410_51b' (errno: 150) (SchemaUpdate.java [pool-2-thread-1])
  8. * ERROR 2013-01-15 23:15:09,283 HHH000388: Unsuccessful: alter table programstagesection add index FKFA727AAB8704EE73 (programStageid), add constraint FKFA727AAB8704EE73 foreign key (programStageid) references programstage (programstageid) (SchemaUpdate.java [pool-2-thread-1])
  9. * ERROR 2013-01-15 23:15:09,284 Can't create table 'zimbabwerbf.#sql-410_51b' (errno: 150) (SchemaUpdate.java [pool-2-thread-1])
  10. * INFO  2013-01-15 23:15:15,321 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@133ef4c] (DefaultMessageService.java [pool-2-thread-1])
  11. * INFO  2013-01-15 23:15:21,707 Scheduled task with key: dataMartLast6MonthsTask and cron: 0 0 0 ? * 2-7 (SpringScheduler.java [pool-2-thread-1])
  12. * INFO  2013-01-15 23:15:21,708 Scheduled task with key: dataMartFrom6To12MonthsTask and cron: 0 0 0 ? * 1 (SpringScheduler.java [pool-2-thread-1])
  13. * INFO  2013-01-15 23:15:24,195 Camel context started (DHIS2LifecycleStrategy.java [pool-2-thread-1])
  14. * INFO  2013-01-15 23:15:24,805 Executing startup routine [1 of 9, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  15. * INFO  2013-01-15 23:15:27,717 Tables updated (TableAlteror.java [pool-2-thread-1])
  16. * INFO  2013-01-15 23:15:27,719 Executing startup routine [2 of 9, runlevel 1]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  17. * INFO  2013-01-15 23:15:27,835 Executing startup routine [3 of 9, runlevel 2]: IdentityPopulator (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  18. * INFO  2013-01-15 23:15:27,880 Problem updating organisationunit:  (IdentityPopulator.java [pool-2-thread-1])
  19. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',`zimbabwerbf`.`organisationunit`.`comment`=null,`zimbabwerbf`.`organisationuni' at line 1
  20.     at sun.reflect.GeneratedConstructorAccessor63.newInstance(Unknown Source)
  21.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  22.     at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
  23.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  24.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  25.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  26.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
  27.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
  28.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
  29.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
  30.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
  31.     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
  32.     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2444)
  33.     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)
  34.     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2347)
  35.     at com.mysql.jdbc.UpdatableResultSet.updateRow(UpdatableResultSet.java:2411)
  36.     at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:98)
  37.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  38.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  39.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  40.     at java.lang.reflect.Method.invoke(Method.java:601)
  41.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  42.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  43.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  44.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  45.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  46.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  47.     at $Proxy31.execute(Unknown Source)
  48.     at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:101)
  49.     at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:77)
  50.     at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:66)
  51.     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4779)
  52.     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5273)
  53.     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  54.     at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
  55.     at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
  56.     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
  57.     at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:958)
  58.     at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1599)
  59.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
  60.     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  61.     at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  62.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
  63.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
  64.     at java.lang.Thread.run(Thread.java:722)
  65. * INFO  2013-01-15 23:15:27,889 Problem updating dataelement:  (IdentityPopulator.java [pool-2-thread-1])
  66. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',`zimbabwerbf`.`dataelement`.`valuetype`='int',`zimbabwerbf`.`dataelement`.`num' at line 1
  67.     at sun.reflect.GeneratedConstructorAccessor63.newInstance(Unknown Source)
  68.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  69.     at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
  70.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  71.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  72.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
  73.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
  74.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
  75.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
  76.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
  77.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
  78.     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
  79.     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2444)
  80.     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)
  81.     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2347)
  82.     at com.mysql.jdbc.UpdatableResultSet.updateRow(UpdatableResultSet.java:2411)
  83.     at org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:98)
  84.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  85.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  86.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  87.     at java.lang.reflect.Method.invoke(Method.java:601)
  88.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  89.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  90.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  91.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  92.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  93.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  94.     at $Proxy31.execute(Unknown Source)
  95.     at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:101)
  96.     at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:77)
  97.     at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:66)
  98.     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4779)
  99.     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5273)
  100.     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  101.     at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
  102.     at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
  103.     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
  104.     at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:958)
  105.     at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1599)
  106.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
  107.     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  108.     at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  109.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
  110.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
  111.     at java.lang.Thread.run(Thread.java:722)
  112. * INFO  2013-01-15 23:15:27,912 Executing startup routine [4 of 9, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  113. * INFO  2013-01-15 23:15:27,916 Executing startup routine [5 of 9, runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  114. * INFO  2013-01-15 23:15:27,975 Executing startup routine [6 of 9, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  115. * INFO  2013-01-15 23:15:28,009 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [pool-2-thread-1])
  116. * INFO  2013-01-15 23:15:28,594 Executing startup routine [7 of 9, runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  117. * INFO  2013-01-15 23:15:29,136 Executing startup routine [8 of 9, runlevel 5]: OrganisationUnitGroupSetPopulator (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  118. * INFO  2013-01-15 23:15:29,152 Executing startup routine [9 of 9, runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  119. * INFO  2013-01-15 23:15:29,174 Upgraded custom case entry form identifiers: 15 (DataEntryFormUpgrader.java [pool-2-thread-1])
  120. * INFO  2013-01-15 23:15:29,176 All startup routines done (DefaultStartupRoutineExecutor.java [pool-2-thread-1])
  121. Jan 15, 2013 11:15:31 PM org.apache.catalina.util.SessionIdGenerator createSecureRandom
  122. INFO: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [1,866] milliseconds.
  123. Jan 15, 2013 11:15:35 PM org.apache.catalina.startup.HostConfig deployDirectory
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement