Details
-
Bug
-
Resolution: Done
-
Major
-
None
-
jBPM 6.3.0.Final
-
NEW
-
NEW
-
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