Skip to main content
February 14, 2023
Question

unable to configure sqlserver datasource | Test Failed

  • February 14, 2023
  • 4 replies
  • 0 views

Hi Everyone,

I am trying to connect to sqlserver as a new data source from admin console  and providing the connection url , username and password as provided by the client.

Additionally trying to create the connected system with the same credentials but both the time I am getting Test Failed. Please suggest if am missing something.

Thank You!

    4 replies

    February 15, 2023

    This is the error log which we are getting when we are trying to establish the connection from Data Source from Appian.

     2023-02-14 18:02:25,337 [ajp-nio-0.0.0.0-8009-exec-235] ERROR com.appiancorp.expr.server.scriptingfunctions.DataSourceFunctions - Failed datasource validation com.appiancorp.rdbms.datasource.DataSourceValidationException: java.sql.SQLException: Unable to obtain a connection within configured timeout at com.appiancorp.rdbms.datasource.TeneoDataSourceValidator.validateDataSource(TeneoDataSourceValidator.java:73) at com.appiancorp.rdbms.datasource.TeneoDataSourceValidator.validateAndCloseDataSource(TeneoDataSourceValidator.java:47) at com.appiancorp.rdbms.datasource.TeneoDataSourceValidator.testDataSourceConnection(TeneoDataSourceValidator.java:40) at com.appiancorp.expr.server.scriptingfunctions.DataSourceFunctions.testDataSource_appian_internal(DataSourceFunctions.java:99) at sun.reflect.GeneratedMethodAccessor5888.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.appiancorp.process.expression.CustomFunction$1.call(CustomFunction.java:846) at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:27) at com.appiancorp.process.expression.CustomFunction.evaluate(CustomFunction.java:840) at com.appiancorp.process.expression.CustomFunction.evalDynamic0(CustomFunction.java:248) at com.appiancorp.process.expression.CustomFunction.evalDynamic(CustomFunction.java:236) at com.appiancorp.process.expression.CustomFunction.eval0(CustomFunction.java:208) at com.appiancorp.core.expr.DefaultEvaluable.eval(DefaultEvaluable.java:214) at com.appiancorp.process.expression.ExpressionEvaluator.evaluate(ExpressionEvaluator.java:318) at com.appiancorp.core.expr.tree.performancelog.PerformanceLogPageFunction.eval0(PerformanceLogPageFunction.java:100) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:106) at com.appiancorp.core.expr.Tree.eval(Tree.java:445) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) com.appiancorp.security.changelog.AuditLogLocationService.callWithLocation(AuditLogLocationService.java:25) at com.appiancorp.sailapp.SailApplicationUtils.evaluate0(SailApplicationUtils.java:96) at com.appiancorp.sailapp.SailApplicationUtils.evaluateUiWithPlog(SailApplicationUtils.java:75) at com.appiancorp.sailapp.SailApplicationUtils.evaluateSailApplicationUI(SailApplicationUtils.java:57) at com.appiancorp.rest.standalone.SailApplicationRestService.reeval(SailApplicationRestService.java:118) at sun.reflect.GeneratedMethodAccessor2444.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1688) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:750) Caused by: java.sql.SQLException: Unable to obtain a connection within configured timeout at com.appiancorp.rdbms.datasource.ConnectionTimeoutBasicDataSource.getConnection(ConnectionTimeoutBasicDataSource.java:56) at com.appiancorp.rdbms.datasource.TeneoDataSourceValidator.validateDataSource(TeneoDataSourceValidator.java:61) ... 860 more Caused by: java.util.concurrent.TimeoutException at java.util.concurrent.FutureTask.get(FutureTask.java:205) at com.appiancorp.rdbms.datasource.ConnectionTimeoutBasicDataSource.getConnection(ConnectionTimeoutBasicDataSource.java:52) ... 861 more

    Thank You!

    stefanhelzle0001
    February 15, 2023

    Seems like a timeout issue. Are you sure that the Appian environment has access to that database server?

    February 15, 2023

    How can we check if the Appian environment has access to the database server? I think data source is the way

    to provide access to Appian environment for the specific Database server.(Please correct if I am wrong)

    When we try to connect directly through sql server using same credentials it connects. In cmd we are are able to ping

    the server. But when we try to create Data Source it fails. Is there any other configuration needed from Admin console?