JDBC Connection Unstable

#1

Dears,

We are using Dundas BI to connect to Sybase IQ database using JDBC connection (jconn4.jar) and we are able to connect successfully but suddenly it’s stopped to connect and throw an exception error.

And to be able to connect again using the JDBC and making the dashboard working we must restart Dundas BI Application pool from IIS.

If anyone can help because this is a production issue and affecting our business.

Below are the JDBC configurations.
JDBC URL:
jdbc:sybase:Tds:{{IPAddress}}:{{Port}}/{{DBName}}

Driver Class Name:
com.sybase.jdbc4.jdbc.SybDriver

Below is the error log from Dundas:
Dundas.BI.Data.DataConnectionException: The connection cannot be established. Using data connector ‘[] Data Connectors Root Folder/MFNNMISPI’. —> Dundas.BI.Data.DataProviders.JavaException: Failed To Create JVM Instance.
at Dundas.BI.Entities.DataConnectors.DataConnector.GetCredentialContext()
at Dundas.BI.Data.DataRetrieval.ProviderReader.Initialize(DataConnector dataConnector, QueryDefinition query)
at Dundas.BI.Data.DataRetrieval.ProviderReader…ctor(QueryProviderTask task, RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.OutputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.InputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.OutputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.InputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.OutputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.InputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.OutputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.InputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.OutputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.InputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.OutputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.InputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.OutputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.InputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.Transforms.OutputConnector.GenerateReader(RequestOptions options, WarehouseMonitor monitor)
at Dundas.BI.Data.DataRetrieval.QueryPlan.GetDataReader()
at Dundas.BI.Data.DataRetrieval.ReaderProcessor.Process()
— End of inner exception stack trace —
at Dundas.BI.Data.DataProviders.JniEnvironment.AttachCurrentThread(JniEnvironment* )
at Dundas.BI.Data.DataProviders.JniEnvironment.{ctor}(JniEnvironment* )
at Dundas.BI.Data.DataProviders.JdbcConnection…ctor(JdbcProvider jdbcProvider)
at Dundas.BI.Data.DataProviders.JdbcProvider.CreateConnection(ParameterValueCollection providerValues)
at Dundas.BI.Data.DataProviders.JdbcProvider.GetConnection(IProviderConnector dataConnector)
at Dundas.BI.Entities.DataConnectors.DataConnector.GetCredentialContext()

#2

Hi Ahmed,

It is recommended to use ODBC for connecting with Sybase Database. Based on the support article below, Sybase database is one of the data sources that have ODBC driver.

https://www.dundas.com/support/learning/documentation/connect-to-data/how-to/connecting-to-odbc

Having said that you can still use JDBC driver to connect, however, there is no guarantee any specific third-party JDBC driver will work perfectly with Dundas BI. You can follow instructions in the link below for JDBC connection:

https://www.dundas.com/support/support-center/support-articles/data-connectors/connecting-to-jdbc

Finally, make sure you are not having any network issues in your environment. You can try and install DBeaver to see if the connection is established properly or not.

I hope these solutions work for you.

Thanks
Razi