Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-4724

Some dashbuilder DataSet columns used by console have wrong data types

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • None
    • jBPM 6.3.0.Final
    • Console
    • NEW
    • NEW
    • Hide

      In Process instance perspective start new filter creation. Use column "processInstanceId" with operator "equals_to" and enter some String value like "asdf". Click Ok and observe the deluge of modals.

      Show
      In Process instance perspective start new filter creation. Use column "processInstanceId" with operator "equals_to" and enter some String value like "asdf". Click Ok and observe the deluge of modals.

    Description

      There are some mistakes in data types declared for some data set columns (e.g. [1] processInstanceId is declared as label, but is in fact number). This leads to a lot of error modals (at least 6) being opened when user makes a mistake during filter creation and enters input of wrong type:
      ---------
      Modals show:
      "DataSet with UUID [ jbpmProcessInstances ] error: org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: jbpmProcessInstances"

      Server log shows:
      Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting "asdf"; SQL statement:
      ...
      Caused by: java.lang.NumberFormatException: For input string: "asdf"
      ----------------
      Please review the underlying data types of columns and use appropriate numeric / label / date methods when defining data sets. Dashbuilder already has logic implemented for dealing with inputs data not having correct type. Most importantly, use "numeric" type when applicable to prevent deluge of error modals when user enters generic String where number is expected during filter creation.
      -----------------
      [1] https://github.com/droolsjbpm/jbpm-console-ng/blob/0621e6ad915cccf5a741d0b34247b21d849befc3/jbpm-console-ng-showcase/src/main/java/org/jbpm/console/ng/server/impl/DashbuilderBootstrap.java#L72

      Attachments

        Activity

          People

            nmirasch@redhat.com Neus Miras Chueca
            jhrcek Jan Hrcek (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: