IBM Support

IBM Maximo Application Suite - Watson IoT Platform tool 8.7.6 and 8.8.2 fails to deploy due to sqlmodel issues

Troubleshooting


Problem

The following is observed in the state an fpl sqlmodel pods logs:
  
Traceback (most recent call last):
  File "/opt/ibm/sqlmodel/sqlSync.py", line 458, in <module>
    processDatabaseModel(conn, schema, models[model], args.modelManagement, args.delimiter, args.splitOnCommand)
  File "/opt/ibm/sqlmodel/sqlSync.py", line 302, in processDatabaseModel
    processSqlFile(conn, schema, model["filename"], delimiter, splitOnCommand)
  File "/opt/ibm/sqlmodel/sqlSync.py", line 293, in processSqlFile
    raise e
  File "/opt/ibm/sqlmodel/sqlSync.py", line 283, in processSqlFile
    conn.execute(sqlCommand)
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1291, in execute
    return self._exec_driver_sql(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1595, in _exec_driver_sql
    ret = self._execute_context(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1862, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2047, in _handle_dbapi_exception
    util.raise_(exc_info[1], with_traceback=exc_info[2])
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.9/site-packages/ibm_db_sa/ibm_db.py", line 116, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.9/site-packages/ibm_db_dbi.py", line 1410, in execute
    self._execute_helper(parameters)
  File "/usr/local/lib/python3.9/site-packages/ibm_db_dbi.py", line 1322, in _execute_helper
    raise self.messages[len(self.messages) - 1]
ibm_db_dbi.Warning: ibm_db_dbi::Warning: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0605W  The index was not created because an index "IOTP_PROD.DEV_STATE_ORG_IX" with a matching definition already exists.  SQLSTATE=01550 SQLCODE=605
Traceback (most recent call last):
  File "/usr/local/lib/python3.9/site-packages/ibm_db_dbi.py", line 1312, in _execute_helper
    return_value = ibm_db.execute(self.stmt_handler, parameters)
Exception: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0605W  The index was not created because an index "IOTP_PROD.DEV_STATE_ORG_IX" with a matching definition already exists.  SQLSTATE=01550 SQLCODE=605 

Resolving The Problem

Issue is tracked and fixed under DT248023.
To fix the issue you can apply an eFix by updating:
1. The IoT State CR:
spec:
  settings:
    imageTags:
      sqlmodelstate: 1.0.107
2.  The FPL CR:
spec:
  settings:
    imageTags:
      sqlmodelfpl: 1.1.32

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m3p000000hAeZAAU","label":"Maximo Application Suite-\u003EMAS Applications-\u003EIoT Platform"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.11.0"}]

Document Information

Modified date:
08 December 2023

UID

ibm17091937

Page Feedback