topic IBM DB2 + Activiti Explorer = weird error in Alfresco Archive

IBM DB2 + Activiti Explorer = weird error

lossril — Thu, 07 Jan 2016 07:59:56 GMT

When I start Activiti Explorer 5.19 webapp which is configured to connect to IBM DB2 database and go to Manage>Database in webapp, it throws an error:Exceptioncom.vaadin.event.ListenerMethod$MethodException: Invocation of method buttonClick in org.activiti.explorer.ui.mainlayout.MainMenuBar$ShowM

Re: IBM DB2 + Activiti Explorer = weird error

lossril — Mon, 11 Jan 2016 07:40:10 GMT

Btw, we found the error:
<java>
public List<String> getTablesPresentInDatabase() {
    List<String> tableNames = new ArrayList<String>();
    Connection connection = null;
    try {
      connection = getDbSqlSession().getSqlSession().getConnection();
      DatabaseMetaData databaseMetaData = connection.getMetaData();
      ResultSet tables = null;
      try {
        log.debug("retrieving activiti tables from jdbc metadata");
        String databaseTablePrefix = getDbSqlSession().getDbSqlSessionFactory().getDatabaseTablePrefix();
        String tableNameFilter = databaseTablePrefix+"ACT_%";
        if ("postgres".equals(getDbSqlSession().getDbSqlSessionFactory().getDatabaseType())) {
          tableNameFilter = databaseTablePrefix+"act_%";
        }
        if ("oracle".equals(getDbSqlSession().getDbSqlSessionFactory().getDatabaseType())) {
          tableNameFilter = databaseTablePrefix+"ACT" + databaseMetaData.getSearchStringEscape() + "_%";
        }
        tables = databaseMetaData.getTables(null, null, tableNameFilter, getDbSqlSession().JDBC_METADATA_TABLE_TYPES);
        while (tables.next()) {
          String tableName = tables.getString("TABLE_NAME");
          tableName = tableName.toUpperCase();
          tableNames.add(tableName);
          log.debug(" retrieved activiti table name {}", tableName);
        }
      } finally {
        tables.close();
      }
    } catch (Exception e) {
      throw new ActivitiException("couldn't get activiti table names using metadata: "+e.getMessage(), e);
    }
    return tableNames;
}
</java>

In this method you did some character escaping for postgres and oracle databases, but not for db2. "_%" means "one symbol" so it goes into different data schema and finds the ACTIONS table. That's clearly a bug, please fix it in next release.

Re: IBM DB2 + Activiti Explorer = weird error

jbarrez — Wed, 20 Jan 2016 21:19:48 GMT

Thanks for reporting this. I wonder why we've never seen this on our QA environment.
We'll look into it and see if we can amend that code, thanks for pointing us already in the right direction!

Re: IBM DB2 + Activiti Explorer = weird error

lossril — Fri, 22 Jan 2016 07:17:17 GMT

Probably because you didn't have a table named 'ACTsomething' in your QA environment and/or database user which is used to access Activiti tables didn't have rights to read them. To reproduct the case, create the table - in our case it was even in the other schema and grant the user rights to read it. Unfortunately, we cannot restrict system user from reading some tables due to environment specifics.