Unable to update data model using liquibase.xml. Module: HTML Form Entry

Implementing
,
1

Dear Concern, I’m facing a critical issue.

I’m facing a disgusting issue and bored with frustration . My organization using openmrs 1.8 . Now everyone decide to upgrade it 2.05 . I upgraded it and I saw many tables structure changed on DB. But after upgrading I tried to enable “HTML form entry” module. But it gives error “Error while trying to start module Unable to update data model using liquibase.xml. Module: HTML Form Entry” . How can I solve it? Without “Html Form Module” openmrs is useless for me.

Openmrs version: 2.05 Tomcat: 8 Java: 8 Mysql: mysql Ver 14.14 Distrib 5.7.20, for Linux (x86_64) using EditLine wrapper

2

Can you paste the tomcat logs at pastebin.com?

3

Hi, I solved this problem. But I’m facing another issue. I tried to update from 1.9.2 to 2.1.2

During Database upgrade, its shows:

??? Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `cohort_member` ADD `start_date` DATETIME NOT NULL: Data truncation: Incorrect datetime value: '0000-00-00 00:00:00' for column 'start_date' at row 1:???
Unable to update the database. See server error logs for the full stacktrace.
???There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::201609171146-3::vshankar:???
??? Caused By: Error executing SQL ALTER TABLE `cohort_member` ADD `start_date` DATETIME NOT NULL: Data truncation: Incorrect datetime value: '0000-00-00 00:00:00' for column 'start_date' at row 1:???
??? Caused By: Data truncation: Incorrect datetime value: '0000-00-00 00:00:00' for column 'start_date' at row 1???

My database 5.7.2 version. I also disable full group by using this tutorial:

Can you please give me quick answer. My administration decide to migrate 2.12 version. We have 80000 patients and 3300000 observation.

Screen shot: https://unsee.cc/ef5cb2f0/

https://unsee.cc/3457ed9e/

4

Try executing this sql statement:

UPDATE cohort_member SET start_date = NULL WHERE start_date < ‘0000-01-01 00:00:00’

Then continue with the upgrade.

1 Like
5

Hi, I created same table structure, but after run upgrade showing this error:

??? liquibase-update-to-latest.xml : Not precondition failed???
??? Caused By: Preconditions Failed???
???There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::201610042145-1::vshankar:???
Unable to update the database. See server error logs for the full stacktrace.
??? Reason: ???
???:???
6

Did you run the sql statement that i gave above?

If yes, can you paste the log at pastebin.com?

7

Again I tried to upgrade openmrs from 1.9.2 to 2.1.2 in “Test installation” mode. Please see the video, I’m getting this error.

Is there any way to solve this issue?

Also two error on log:

ERROR - TestInstallUtil.addTestData(105) |2018-01-29 15:04:24,535| mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 2006 (HY000) at line 4414 in file: ‘/tmp/tomcat8-tomcat8-tmp/testDataSet5274836228896457710dump’: MySQL server has gone away ERROR - TestInstallUtil.addTestData(116) |2018-01-29 15:04:24,536| The process terminated abnormally while adding test data. Please look under the Configuration section at: https://wiki.openmrs.org/display/docs/Release+Testing+Helper+Module

8

Are you choosing the Test Installation mode because you just want to get some demo data?

9

Solved. Its need mysql 5.7.2