[RHPAM-1043] Process instances data cannot be loaded from Sybase 16.0 - JBoss Issue Tracker

Details

Type: Bug
Status: Verified (View Workflow)
Priority: Critical
Resolution: Done
Affects Version/s: 7.0.0.GA, 7.0.1.GA
Fix Version/s: 7.0.2.GA
Component/s: jBPM Runtime UI
Labels:
None
Environment:

Sybase 16.0

Affects Build:
CR1
Target Release:

7.0.2.GA
Fix Build:
CR2
Git Pull Request:
https://github.com/kiegroup/jbpm-wb/pull/1140, https://github.com/kiegroup/jbpm-wb/pull/1164
Sprint:
2018 Week 19-22, 2018 Week 23-24, 2018 Week 25-26, 2018 Week 27-29, 2018 Week 30-32

Description

When Sybase is used as a DB, the data can't be loaded into Process Instances perspective.
The error shown in the UI is the generic one which points to jBPM capabilities problem - UIError.png.

In the server log the following error can be seen (the full server log attached - profile-log.txt):

ERROR [org.dashbuilder.dataprovider.sql.JDBCUtils] (default task-57) SELECT COUNT(*) FROM (SELECT processInstanceId, processId, start_date, end_date, status, parentProcessInstanceId, outcome, duration, user_identity, processVersion, processName, correlationKey, externalId, processInstanceDescription, sla_due_date, slaCompliance, lastModificationDate, errorCount FROM (select log.processInstanceId, log.processId, log.start_date, log.end_date, log.status, log.parentProcessInstanceId, log.outcome, log.duration, log.user_identity, log.processVersion, log.processName, log.correlationKey, log.externalId, log.processInstanceDescription, log.sla_due_date, log.slaCompliance, COALESCE(info.lastModificationDate, log.end_date) as lastModificationDate, (select COUNT(errInfo.id) from ExecutionErrorInfo errInfo where errInfo.process_inst_id=log.processInstanceId and errInfo.error_ack=0) as errorCount from ProcessInstanceLog log left join ProcessInstanceInfo info on info.InstanceId=log.processInstanceId) "dbSQL" WHERE status = '1' AND externalId IN ('consoleErrorsContainerID')) "dbSQL"

[0m[31m12:49:28,573 ERROR [org.kie.server.remote.rest.jbpm.QueryDataResource] (default task-57) The request could not be understood by the server due to malformed syntax: Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed.  Use the CONVERT function to run this query.

: org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: jbpmProcessInstances

	at org.dashbuilder.dataset.DataSetManagerImpl.lookupDataSet(DataSetManagerImpl.java:156)

	at org.jbpm.kie.services.impl.query.QueryServiceImpl.query(QueryServiceImpl.java:275)

	at org.jbpm.kie.services.impl.query.QueryServiceImpl.query(QueryServiceImpl.java:217)

	at org.kie.server.services.jbpm.QueryDataServiceBase.queryFiltered(QueryDataServiceBase.java:187)

	at org.kie.server.services.jbpm.QueryDataServiceBase.queryFiltered(QueryDataServiceBase.java:146)

	at org.kie.server.remote.rest.jbpm.QueryDataResource.runQueryFiltered(QueryDataResource.java:342)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:498)

	at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

	at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:295)

	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:249)

	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:236)

	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:406)

	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:213)

	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)

	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)

	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

	at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)

	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

	at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:64)

	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)

	at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)

	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)

	at io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33)

	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

	at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:53)

	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)

	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)

	at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:59)

	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)

	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)

	at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)

	at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)

	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

	at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

	at org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68)

	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)

	at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)

	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)

	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)

	at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)

	at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)

	at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)

	at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)

	at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)

	at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)

	at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)

	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)

	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)

	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)

	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:330)

	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:812)

	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

	at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLException: Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed.  Use the CONVERT function to run this query.

	at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780)

	at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665)

	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:295)

	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272)

	at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2409)

	at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2395)

	at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:553)

	at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:397)

	at org.dashbuilder.dataprovider.sql.JDBCUtils.executeQuery(JDBCUtils.java:107)

	at org.dashbuilder.dataprovider.sql.model.Select.fetchCount(Select.java:173)

	at org.dashbuilder.dataprovider.sql.SQLDataSetProvider$LookupProcessor.run(SQLDataSetProvider.java:735)

	at org.dashbuilder.dataprovider.sql.SQLDataSetProvider._lookupDataSet(SQLDataSetProvider.java:439)

	at org.dashbuilder.dataprovider.sql.SQLDataSetProvider.lookupDataSet(SQLDataSetProvider.java:234)

	at org.dashbuilder.dataset.DataSetManagerImpl.lookupDataSet(DataSetManagerImpl.java:154)

	... 61 more

Gliffy Diagrams

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

profile-log.txt
859 kB
17/May/18 6:52 AM
serverLog_7_0_1_CR1.txt
852 kB
13/Jun/18 11:22 AM
serverLog_7_0_2_CR1.txt
749 kB
18/Jul/18 3:58 AM
UIError.png
68 kB
17/May/18 6:48 AM

Issue Links

relates to

JBPM-7299 Process Instances: Data can't be loaded from Sybase 16.0

Resolved

JBPM-7472 Manage Errors: Data can't be loaded from Sybase 16.0

Resolved

Process instances data cannot be loaded from Sybase 16.0

Details

Description

Gliffy Diagrams

Attachments

Attachments

Issue Links

Activity

People

Dates