Hi All,
I am facing the following error while trying to install bahmni 0.93 on centOS with blank database with JSS_config
TASK [implementation-config : Run openmrs liquibase migrations] *************************************************************
task path: /opt/bahmni-installer/bahmni-playbooks/roles/implementation-config/tasks/implementation-config.yml:73
fatal: [localhost]: FAILED! => {“changed”: true, “failed”: true, “msg”: “non-zero return code”, “rc”: 255, “stderr”: “+ . /etc/bahmni-installer/bahmni.conf\n++ IMPLEMENTATION_NAME=jss\n++ OPENMRS_DB_USERNAME=openmrs-user\n++ OPENMRS_DB_PASSWORD=P@ssw0rd\n++ OPENMRS_DB_SERVER=localhost\n++ OPENELIS_DB_USERNAME=clinlims\n++ OPENELIS_DB_PASSWORD=password\n++ OPENELIS_DB_SERVER=localhost\n++ OPENERP_DB_USERNAME=odoo\n++ OPENERP_DB_PASSWORD=password\n++ OPENERP_DB_SERVER=localhost\n++ MYSQL_ROOT_USER=root\n++ MYSQL_ROOT_PASSWORD=P@ssw0rd\n++ REPORTS_DB_SERVER=localhost\n++ REPORTS_DB_PASSWORD=P@ssw0rd\n++ REPORTS_DB_USERNAME=reports-user\n+ CHANGE_LOG_TABLE=’-Dliquibase.databaseChangeLogTableName=liquibasechangelog -Dliquibase.databaseChangeLogLockTableName=liquibasechangeloglock -DschemaName=openmrs’\n+ LIQUIBASE_JAR=/opt/openmrs/openmrs/WEB-INF/lib/liquibase-core-2.0.5.jar\n+ DRIVER=com.mysql.jdbc.Driver\n++ ls /opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar\n+ CLASSPATH=/opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar\n+ CHANGE_LOG_FILE=liquibase.xml\n+ ‘[’ -f /var/www/bahmni_config/openmrs/migrations/liquibase.xml ‘]’\n+ cd /var/www/bahmni_config/openmrs/migrations\n+ java -Dliquibase.databaseChangeLogTableName=liquibasechangelog -Dliquibase.databaseChangeLogLockTableName=liquibasechangeloglock -DschemaName=openmrs -jar /opt/openmrs/openmrs/WEB-INF/lib/liquibase-core-2.0.5.jar --driver=com.mysql.jdbc.Driver --classpath=/opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar --changeLogFile=liquibase.xml --url=jdbc:mysql://localhost:3306/openmrs --username=openmrs-user --password=P@ssw0rd update\nINFO 3/11/22 1:57 PM:liquibase: Successfully acquired change log lock\nINFO 3/11/22 1:57 PM:liquibase: Reading from liquibasechangelog
\nINFO 3/11/22 1:57 PM:liquibase: Reading from liquibasechangelog
\nSEVERE 3/11/22 1:57 PM:liquibase: Change Set liquibase.xml::JSS-1::tw failed. Error: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\nliquibase.exception.DatabaseException: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)\n\tat liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)\n\tat liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)\n\tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)\n\tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)\n\tat liquibase.Liquibase.update(Liquibase.java:114)\n\tat liquibase.integration.commandline.Main.doMigration(Main.java:825)\n\tat liquibase.integration.commandline.Main.main(Main.java:134)\nCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column ‘identifier_type’ cannot be null\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:423)\n\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:411)\n\tat com.mysql.jdbc.Util.getInstance(Util.java:386)\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)\n\tat liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)\n\t… 9 more\nINFO 3/11/22 1:57 PM:liquibase: Successfully released change log lock\nLiquibase Update Failed: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\nSEVERE 3/11/22 1:57 PM:liquibase: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\nliquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::JSS-1::tw:\n Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null:\n Caused By: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null:\n Caused By: Column ‘identifier_type’ cannot be null\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)\n\tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)\n\tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)\n\tat liquibase.Liquibase.update(Liquibase.java:114)\n\tat liquibase.integration.commandline.Main.doMigration(Main.java:825)\n\tat liquibase.integration.commandline.Main.main(Main.java:134)\nCaused by: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO idgen_identifier_source (uuid, name, description, identifier_type, creator, date_created)\n VALUES (uuid(), ‘GAN’, ‘ID sequence source for patients whose primary health center is Ganiyari’, @patient_identifier, 1, curdate()): Column ‘identifier_type’ cannot be null\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)\n\tat liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)\n\tat liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)\n\t… 5 more\nCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column ‘identifier_type’ cannot be null\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:423)\n\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:411)\n\tat com.mysql.jdbc.Util.getInstance(Util.java:386)\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)\n\tat liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)\n\t… 9 more\n\n\nFor more information, use the --logLevel flag)\n”, “stdout”: “”, “stdout_lines”: []}
to retry, use: --limit @/opt/bahmni-installer/bahmni-playbooks/all.retry
PLAY RECAP ******************************************************************************************************************
localhost : ok=151 changed=53 unreachable=0 failed=1
Traceback (most recent call last):
File “/usr/bin/bahmni”, line 9, in
load_entry_point(‘bahmni==0.1’, ‘console_scripts’, ‘bahmni’)()
File “/usr/lib64/python2.7/site-packages/click/core.py”, line 764, in call
return self.main(*args, **kwargs)
File “/usr/lib64/python2.7/site-packages/click/core.py”, line 717, in main
rv = self.invoke(ctx)
File “/usr/lib64/python2.7/site-packages/click/core.py”, line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/lib64/python2.7/site-packages/click/core.py”, line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/lib64/python2.7/site-packages/click/core.py”, line 555, in invoke
return callback(*args, **kwargs)
File “/usr/lib64/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/usr/lib/python2.7/site-packages/bahmni-0.1-py2.7.egg/bahmni.py”, line 91, in install
File “/usr/lib64/python2.7/subprocess.py”, line 542, in check_call
raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command ‘ansible-playbook -i /etc/bahmni-installer/local all.yml -vv --extra-vars ‘@/etc/bahmni-installer/rpm_versions.yml’ --extra-vars ‘@/etc/bahmni-backrest.conf’ --extra-vars ‘@/etc/bahmni-installer/setup.yml’’ returned non-zero exit status 2