org.jboss.dashboard.dataset.DataSetException: Data set load time has been exceeded = 10.0s

Issue

• When opening the dashboard, it give the following error.

14:30:25,475 ERROR [org.jboss.dashboard.dataset.sql.SQLDataSet] (http-/10.10.10.10:8080-6) Error in load() SQLDataset. SQL = select processinstanceid,processname,status,start_date,end_date,user_identity userid,processversion,duration from processinstancelog: org.jboss.dashboard.dataset.DataSetException: Data set load time has been exceeded = 10.0s
        at org.jboss.dashboard.dataset.profiler.DataSetLoadConstraints.validate(DataSetLoadConstraints.java:61) [dashboard-provider-api-6.0.2-redhat-6.jar:6.0.2-redhat-6]
        at org.jboss.dashboard.profiler.CodeBlockTrace.checkRuntimeConstraints(CodeBlockTrace.java:302) [dashboard-commons-6.0.2-redhat-6.jar:6.0.2-redhat-6]
        at org.jboss.dashboard.dataset.sql.SQLDataSet.load(SQLDataSet.java:133) [dashboard-provider-sql-6.0.2-redhat-6.jar:6.0.2-redhat-6]
        at org.jboss.dashboard.provider.sql.SQLDataLoader.load(SQLDataLoader.java:105) [dashboard-provider-sql-6.0.2-redhat-6.jar:6.0.2-redhat-6]
        at org.jboss.dashboard.dataset.DataSetManagerImpl.loadDataSet(DataSetManagerImpl.java:111) [dashboard-provider-core-6.0.2-redhat-6.jar:6.0.2-redhat-6]
...

How to overcome this problem?

• The data provider query get time out after 10 seconds as well as if the data set size (maxDataSetSizeInBytes) is greater than 100 MB it fails to load the data. How to modify those parameters?