Details

    • Complexity:
      Low

      Description

      The cause of this is having two Drugs open and editing at the same time:

      1) Open Drug A to edit in a tab
      2) Open Drug B to edit in another tab
      3) Return to Drug A tab and edit/save
      4) Error below is shown.

      The solution is to change the ConceptDrugFormController to NOT be a session form. This is in the openmrs-servlet.xml file.

      The workaround is to only open one drug at a time.

      Version: 1.8.2 Build 22077
      Implementation ID:
      User ID: ada
      Started Modules: serialization.xstream v0.2.5, pcslabinterface v0.5, dataentrystatistics v1.0, patientmatching v1.2.4, reporting v0.6.3.DEV, metadatasharing v0.10, amrscustomization v1.0.1, formentry v4.5.9.4, flowsheet v0.2.1-SNAPSHOT, amrsregistration v1.1, logic v0.5, datalogging v1.0-SNAPSHOT, htmlformentry v1.7.3, tribe v1.5, rowperpatientreports v0.0.1, xforms v4.0.4, groovy v2.1, obsgroupexport v1.2, reportingcompatibility v1.5.4.1, idcards v1.3.1, restmodule v1.4.5, kenyareports v0.0.1, htmlwidgets v1.5.6.2

      Summary:
      org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [update drug set name=?, combination=?, dose_strength=?, maximum_daily_dose=?, minimum_daily_dose=?, units=?, date

      Description:
      Stack trace:
      at [ignored] ...
      $Proxy81.saveDrug(Unknown Source)
      org.openmrs.module.amrscustomization.web.controller.CustomConceptDrugFormController.onSubmit(CustomConceptDrugFormController.java:95)
      at [ignored] ...
      javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:65)
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:76)
      org.openmrs.module.xforms.web.XformsFilter.doFilter(XformsFilter.java:60)
      org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:74)
      org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:58)
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:112)
      at [ignored] ...
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at [ignored] ...

      <snip>

        Attachments

          Activity

            People

            • Assignee:
              bwolfe Ben Wolfe
              Reporter:
              bwolfe Ben Wolfe
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: