Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.

Database Connection Error

Hi, can anyone help me to resolve the error because while connecting to the new connection string of SQL Server Management Studio,i.e, jdbc:sqlserver://uaeadmmsql01mdg.c3ywakkpm0b8.us-east-1.rds.amazonaws.com:1433;databaseName=my_database_name it is showing an error which is "Connection failed". However, I have provided the correct username and password. What should be done in this scenario?

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Did you check the tomcat-stdout log for any details?

  • This is what the log shows: 

    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

    Caused by: java.sql.SQLException: Unable to obtain a connection within configured timeout
    	at com.appiancorp.rdbms.datasource.ConnectionTimeoutBasicDataSource.getConnection(ConnectionTimeoutBasicDataSource.java:53)
    	at com.appiancorp.rdbms.datasource.TeneoDataSourceValidator.validateDataSource(TeneoDataSourceValidator.java:61)
    	... 953 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:49)
    	... 954 more
    Can it be due to the port number? Appian uses 1433 in this case , is that port blocked?

Reply
  • This is what the log shows: 

    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

    Caused by: java.sql.SQLException: Unable to obtain a connection within configured timeout
    	at com.appiancorp.rdbms.datasource.ConnectionTimeoutBasicDataSource.getConnection(ConnectionTimeoutBasicDataSource.java:53)
    	at com.appiancorp.rdbms.datasource.TeneoDataSourceValidator.validateDataSource(TeneoDataSourceValidator.java:61)
    	... 953 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:49)
    	... 954 more
    Can it be due to the port number? Appian uses 1433 in this case , is that port blocked?

Children
No Data