Uploaded image for project: 'Household'
  1. Household
  2. HSHOLD-3

Error while running sql: ALTER TABLE `household_obs` DROP KEY `household_obs_grouping_uuid` . Message: Cannot drop index 'household_obs_grouping_uuid': needed in a foreign key constraint

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: TBD
    • Resolution: Fixed
    • Labels:
      None
    • Complexity:
      Undetermined

      Description

      The following error is given when trying to start the Household Module.

      Error while trying to start module
      Error while running sql: ALTER TABLE `household_obs` DROP KEY `household_obs_grouping_uuid` . Message: Cannot drop index 'household_obs_grouping_uuid': needed in a foreign key constraint

        • org.openmrs.util.DatabaseUtil.executeSQL(DatabaseUtil.java:139)
        • org.openmrs.api.db.hibernate.HibernateAdministrationDAO.executeSQL(HibernateAdministrationDAO.java:340)
        • org.openmrs.api.impl.AdministrationServiceImpl.executeSQL(AdministrationServiceImpl.java:802)
          sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source)
          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          java.lang.reflect.Method.invoke(Method.java:616)
          org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
          org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
          org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
          org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
          org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
          sun.proxy.$Proxy318.executeSQL(Unknown Source)
          sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source)
          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          java.lang.reflect.Method.invoke(Method.java:616)
          org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
          org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
          org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
          org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
          org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        • org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
          org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
          org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
          org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
          sun.proxy.$Proxy319.executeSQL(Unknown Source)
          sun.reflect.GeneratedMethodAccessor709.invoke(Unknown Source)
          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          java.lang.reflect.Method.invoke(Method.java:616)
          org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
          org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
          org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
          org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
          org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
          org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
          sun.proxy.$Proxy319.executeSQL(Unknown Source)
        • org.openmrs.module.ModuleFactory.runDiff(ModuleFactory.java:696)
        • org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:540)
        • org.openmrs.api.context.Daemon$1.run(Daemon.java:58)

      This happens with Household Module 1.0.1, when installing the module for the first time, on OpenMRS Version: 1.9.3 Build f535e9.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              arbaughj James Arbaugh [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: