2015-04-09 08:14:33.522 | 2015-04-09 16:14:33.521 1576 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0190N ALTER TABLE "DB2INST2.STACK" specified attributes for column "STATUS_REASON" that are not compatible with the existing column. SQLSTATE=42837 SQLCODE=-190 '\nALTER TABLE stack ALTER COLUMN status_reason SET DATA TYPE CLOB' ()
2015-04-09 08:14:33.522 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2015-04-09 08:14:33.522 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2015-04-09 08:14:33.522 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters context)
2015-04-09 08:14:33.523 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/ibm_db_sa-0.3.2-py2.7.egg/ibm_db_sa/ibm_db.py", line 106, in do_execute
2015-04-09 08:14:33.523 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2015-04-09 08:14:33.523 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1332, in execute
2015-04-09 08:14:33.523 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters self._execute_helper(parameters)
2015-04-09 08:14:33.523 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1244, in _execute_helper
2015-04-09 08:14:33.523 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters raise self.messages[len(self.messages) - 1]
2015-04-09 08:14:33.523 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters ProgrammingError: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0190N ALTER TABLE "DB2INST2.STACK" specified attributes for column "STATUS_REASON" that are not compatible with the existing column. SQLSTATE=42837 SQLCODE=-190
2015-04-09 08:14:33.523 | 2015-04-09 16:14:33.521 1576 TRACE oslo_db.sqlalchemy.exc_filters
2015-04-09 08:14:33.524 | 2015-04-09 16:14:33.523 1576 WARNING migrate.changeset.databases.ibmdb2 [-] Unable to change the column type. Error: (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0190N ALTER TABLE "DB2INST2.STACK" specified attributes for column "STATUS_REASON" that are not compatible with the existing column. SQLSTATE=42837 SQLCODE=-190 '\nALTER TABLE stack ALTER COLUMN status_reason SET DATA TYPE CLOB' ()
2015-04-09 08:14:35.939 | 2015-04-09 16:14:35.938 1576 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0190N ALTER TABLE "DB2INST2.RESOURCE" specified attributes for column "STATUS_REASON" that are not compatible with the existing column. SQLSTATE=42837 SQLCODE=-190 '\nALTER TABLE resource ALTER COLUMN status_reason SET DATA TYPE CLOB' ()
2015-04-09 08:14:35.939 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2015-04-09 08:14:35.939 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2015-04-09 08:14:35.939 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters context)
2015-04-09 08:14:35.939 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/ibm_db_sa-0.3.2-py2.7.egg/ibm_db_sa/ibm_db.py", line 106, in do_execute
2015-04-09 08:14:35.939 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2015-04-09 08:14:35.939 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1332, in execute
2015-04-09 08:14:35.940 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters self._execute_helper(parameters)
2015-04-09 08:14:35.940 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1244, in _execute_helper
2015-04-09 08:14:35.940 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters raise self.messages[len(self.messages) - 1]
2015-04-09 08:14:35.940 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters ProgrammingError: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0190N ALTER TABLE "DB2INST2.RESOURCE" specified attributes for column "STATUS_REASON" that are not compatible with the existing column. SQLSTATE=42837 SQLCODE=-190
2015-04-09 08:14:35.940 | 2015-04-09 16:14:35.938 1576 TRACE oslo_db.sqlalchemy.exc_filters
2015-04-09 08:14:35.940 | 2015-04-09 16:14:35.940 1576 WARNING migrate.changeset.databases.ibmdb2 [-] Unable to change the column type. Error: (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0190N ALTER TABLE "DB2INST2.RESOURCE" specified attributes for column "STATUS_REASON" that are not compatible with the existing column. SQLSTATE=42837 SQLCODE=-190 '\nALTER TABLE resource ALTER COLUMN status_reason SET DATA TYPE CLOB' ()
2015-04-09 08:14:38.069 | 2015-04-09 16:14:38.068 1576 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0190N ALTER TABLE "DB2INST2.SOFTWARE_DEPLOYMENT" specified attributes for column "STATUS_REASON" that are not compatible with the existing column. SQLSTATE=42837 SQLCODE=-190 '\nALTER TABLE software_deployment ALTER COLUMN status_reason SET DATA TYPE CLOB' ()
2015-04-09 08:14:38.069 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2015-04-09 08:14:38.070 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2015-04-09 08:14:38.070 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters context)
2015-04-09 08:14:38.070 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/ibm_db_sa-0.3.2-py2.7.egg/ibm_db_sa/ibm_db.py", line 106, in do_execute
2015-04-09 08:14:38.070 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2015-04-09 08:14:38.070 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1332, in execute
2015-04-09 08:14:38.070 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters self._execute_helper(parameters)
2015-04-09 08:14:38.070 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1244, in _execute_helper
2015-04-09 08:14:38.070 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters raise self.messages[len(self.messages) - 1]
2015-04-09 08:14:38.071 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters ProgrammingError: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0190N ALTER TABLE "DB2INST2.SOFTWARE_DEPLOYMENT" specified attributes for column "STATUS_REASON" that are not compatible with the existing column. SQLSTATE=42837 SQLCODE=-190
2015-04-09 08:14:38.071 | 2015-04-09 16:14:38.068 1576 TRACE oslo_db.sqlalchemy.exc_filters
2015-04-09 08:14:38.072 | 2015-04-09 16:14:38.071 1576 WARNING migrate.changeset.databases.ibmdb2 [-] Unable to change the column type. Error: (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0190N ALTER TABLE "DB2INST2.SOFTWARE_DEPLOYMENT" specified attributes for column "STATUS_REASON" that are not compatible with the existing column. SQLSTATE=42837 SQLCODE=-190 '\nALTER TABLE software_deployment ALTER COLUMN status_reason SET DATA TYPE CLOB' ()
In db2, data type change not alter from non-lob to lob.
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000888.html?cp=SSEPGG_9.7.0%2F2-10-6-26
This line of codes break the migration for db2. /github. com/openstack/ heat/blob/ master/ heat/db/ sqlalchemy/ migrate_ repo/versions/ 061_status_ reason_ longtext. py#L23
https:/