2015-05-11 00:00:00,740 [Appian Work Item - 2945 - ProcessExec00 : ExpressionGroupRequest] ERROR org.hibernate.util.JDBCExceptionReporter - javax.resource.ResourceException: IJ000456: Unchecked throwable in ManagedConnection.getConnection() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@7e35c3e7[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@42b3b6f5 connection handles=0 lastUse=1431302400740 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@623b8aed pool internal context=SemaphoreArrayListManagedConnectionPool@2e8f51c9[pool=MySqlDS] xaResource=XAResourceWrapperImpl@4c36d8b0[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@42b3b6f5 pad=false overrideRmValue=null productName=MySQL productVersion=5.6.24-log jndiName=jdbc/csopai] txSync=null] 2015-05-11 00:00:06,568 [Appian Work Item - 2945 - ProcessExec00 : ExpressionGroupRequest] ERROR com.appiancorp.process.engine.ExpressionGroup - An error occurred while evaluating expression: alertDates:rule!myfunc() (Expression evaluation error in rule 'myfunc' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Cannot open connection) com.appiancorp.process.expression.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'myfunc' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Cannot open connection (APNX-1-4198-000) at com.appiancorp.process.expression.ExpressionRuntimeException.(ExpressionRuntimeException.java:69) at com.appiancorp.core.expr.exceptions.AppianScriptException.(AppianScriptException.java:24) at com.appiancorp.core.expr.exceptions.ParseException.(ParseException.java:20) at com.appiancorp.core.expr.exceptions.FunctionException.(FunctionException.java:13) at com.appiancorp.core.expr.AppianScriptContextTop.evalExternalFunction(AppianScriptContextTop.java:446) at com.appiancorp.core.expr.AppianScriptContextChild.evalExternalFunction(AppianScriptContextChild.java:212) at com.appiancorp.core.expr.tree.FunctionCall$ExternalEvaluable.eval0(FunctionCall.java:535) at com.appiancorp.core.expr.Evaluable.eval(Evaluable.java:165) at com.appiancorp.core.expr.tree.FunctionCall.evalImmediate(FunctionCall.java:326) at com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:299) at com.appiancorp.core.expr.tree.FunctionCall.eval(FunctionCall.java:360) at com.appiancorp.core.expr.Tree.eval0(Tree.java:192) at com.appiancorp.core.expr.Tree.eval(Tree.java:188) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:322) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:251) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:239) at com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:85) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:43) at com.appiancorp.core.expr.Tree.eval(Tree.java:188) at com.appiancorp.core.expr.Parse.evalInner(Parse.java:273) at com.appiancorp.core.expr.Parse.eval(Parse.java:232) at com.appiancorp.core.expr.Parse.eval(Parse.java:217) at com.appiancorp.core.expr.AppianScriptEngine.eval(AppianScriptEngine.java:66) at com.appiancorp.process.engine.ExpressionGroup.eval(ExpressionGroup.java:247) at com.appiancorp.process.engine.ExpressionGroup.eval(ExpressionGroup.java:296) at com.appiancorp.process.engine.ExpressionGroupRequest.execute0(ExpressionGroupRequest.java:67) at com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:80) at com.appiancorp.mdb.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:26) at sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:104) at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:56) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ejb3.component.messagedriven.MessageDrivenComponentDescription$5$1.processInvocation(MessageDrivenComponentDescription.java:203) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185) at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73) at com.appiancorp.ra.workpoller.UnattendedRequestListener$$$view2.onMessage(Unknown Source) at sun.reflect.GeneratedMethodAccessor1382.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:140) at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73) at com.sun.proxy.$Proxy511.onMessage(Unknown Source) at com.appiancorp.ra.workpoller.WorkItem.run(WorkItem.java:54) at org.jboss.jca.core.workmanager.WorkWrapper.run(WorkWrapper.java:218) at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808) at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:849) at java.lang.Thread.run(Thread.java:745) at org.jboss.threads.JBossThread.run(JBossThread.java:122) Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at com.appiancorp.rdbms.hb.HbSqlExceptionConverter.convert(HbSqlExceptionConverter.java:95) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473) at sun.reflect.GeneratedMethodAccessor436.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:345) at com.sun.proxy.$Proxy95.beginTransaction(Unknown Source) at com.appiancorp.type.external.teneoimpl.TeneoDataStore.beginTransaction(TeneoDataStore.java:248) at com.appiancorp.rules.query.QueryRuleInvoker.invoke(QueryRuleInvoker.java:232) at com.appiancorp.rules.query.QueryRuleInvoker.invoke(QueryRuleInvoker.java:226) at com.appiancorp.rules.query.QueryRuleInvoker.doInvoke(QueryRuleInvoker.java:202) at com.appiancorp.rules.query.QueryRuleInvoker.invoke(QueryRuleInvoker.java:142) at com.appiancorp.expression.plugin.QueryRuleExpression.queryRuleExec(QueryRuleExpression.java:44) at sun.reflect.GeneratedMethodAccessor828.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.appiancorp.process.expression.CustomFunction$1.call(CustomFunction.java:756) at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:25) at com.appiancorp.process.expression.CustomFunction.evaluate(CustomFunction.java:751) at com.appiancorp.process.expression.CustomFunction.evalDynamic(CustomFunction.java:202) at com.appiancorp.process.expression.CustomFunction.eval0(CustomFunction.java:193) at com.appiancorp.core.expr.Evaluable.eval(Evaluable.java:213) at com.appiancorp.process.expression.ExpressionEvaluator.evaluate(ExpressionEvaluator.java:294) at com.appiancorp.core.expr.AppianScriptContextTop.evalExternalFunction(AppianScriptContextTop.java:437) ... 81 more Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000456: Unchecked throwable in ManagedConnection.getConnection() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@7e35c3e7[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@42b3b6f5 connection handles=0 lastUse=1431302400740 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@623b8aed pool internal context=SemaphoreArrayListManagedConnectionPool@2e8f51c9[pool=MySqlDS] xaResource=XAResourceWrapperImpl@4c36d8b0[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@42b3b6f5 pad=false overrideRmValue=null productName=MySQL productVersion=5.6.24-log jndiName=jdbc/csopai] txSync=null] at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:151) at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92) at com.appiancorp.rdbms.hb.LoggingDatasourceConnectionProvider.getConnection(LoggingDatasourceConnectionProvider.java:28) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) ... 107 more Caused by: javax.resource.ResourceException: IJ000456: Unchecked throwable in ManagedConnection.getConnection() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@7e35c3e7[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@42b3b6f5 connection handles=0 lastUse=1431302400740 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject@623b8aed pool internal context=SemaphoreArrayListManagedConnectionPool@2e8f51c9[pool=MySqlDS] xaResource=XAResourceWrapperImpl@4c36d8b0[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@42b3b6f5 pad=false overrideRmValue=null productName=MySQL productVersion=5.6.24-log jndiName=jdbc/csopai] txSync=null] at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:511) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143) ... 110 more Caused by: javax.resource.ResourceException: No matching credentials in Subject! at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getConnectionProperties(BaseWrapperManagedConnectionFactory.java:965) at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkIdentity(BaseWrapperManagedConnection.java:845) at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.getConnection(BaseWrapperManagedConnection.java:466) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:497) ... 111 more