I am using
openmrs-sdk-maven-plugin to package my distro and then using
openmrs-sdk:run to test my packaged distro.
While packaging the distro, I am mentioning a base
dbSql as well. This base
dbSql gets copied as
<targetDir>/dbdump/dump.sql. While this command works fine when I try to provide this SQL file as
openmrs-sdk:run, it fails with an error saying:
Failed to import database: Error executing: DELETE FROM
openmrs.global_property WHERE property = ‘search.indexVersion’ [ERROR] . Cause: org.apache.ibatis.jdbc.RuntimeSqlException: Line missing end-of-line terminator (; ) => DELETE FROM
openmrs.global_property WHERE property = ‘search.indexVersion’
While debugging the
openmrs-sdk I figured out as part of copying the dump we add a query to delete the
search.indexVersion property to every dump. Here is the line which does that. This query has the semicolon missing which is causing the dump to fail. Here is the link to the query.
I feel this is a bug, and I can raise a quick fix for this unless anyone else thinks otherwise.