Product/components used and version/fix level:

Currently using version 10.3. both designer and integration server

Detailed explanation of the problem:

When ever I try to enable a connection, getting status as pending enabled

Error messages / full error message screenshot / log file:

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/86fbff79fa53001c9c21c4942edfd49b98bb2948_2_1035x42.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/86fbff79fa53001c9c21c4942edfd49b98bb2948.png 2x" data-dominant-color="EAEAEA">

image1110×46 6.08 KB

Question related to a free trial, or to a production (customer) instance?

Hi Satwik

Can you provide your connection properties for the connection.

thank you
subhash

Connection Type webMethods Adapter for JDBC Connection
Package Name DBConnection
Transaction Type NO_TRANSACTION
DataSource Class com.microsoft.sqlserver.jdbc.SQLServerDataSource
Database Name LDMS
Port Number 1433

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/a459b55cc36ed0c144199fbd573b99202e76ff88_2_1035x246.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/a459b55cc36ed0c144199fbd573b99202e76ff88_2_1380x328.png 2x" data-dominant-color="FBFBFB">

image1460×348 12.5 KB

when you try to enable does the connection shows any error?

Hi,

remember to set minimum pool size to 0 to avoid stale connections.
Can you provide SQL Server version as well as MSSQL JDBC driver version, please?

Any Fixes applied to the JDBC adapter, ART etc.?

Regards,
Holger

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/90b2097967a2c82577d0d0e88df8a436f8b72ab6.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/90b2097967a2c82577d0d0e88df8a436f8b72ab6.png 2x" data-dominant-color="F9F9F9">

image757×348 55.1 KB

Hi @Holger_von_Thomsen please refer the image attached.

current path for jar is:
IntegrationServer\instances\default\packages\WmJDBCAdapter\code\jars\static

is it correct? as per this link the path needs to be changed?

Hi Satvik,

for most of the JDBC driver jars code/jars should be sufficient, code/jars/static is only required for jars, which have a native part under lib directory.

When the jars are placed under code/jars, it only requires a simple reload of the package if any of these are exchanged.
When they are placed under code/jars/static, it always requires a shutdown and restart of IS to load the updated jars.

Regards,
Holger

+100 this. This is somewhat a YMMV item but in the time that I’ve been doing this I’ve never encountered a scenario where having Minimum Pool Size anything other than 0 was useful/necessary.

Also be sure to set the expire and block timeouts to something reasonable. The default of 1 second is not a good value to use for either. Expire should be just slightly less than the session timeout defined by the target DB. Block typically doesn’t much matter but depending on the usage of the pool and how often if ever all connections in the pool are used simultaneously you’ll want to specify a value that balances threads waiting too long vs not waiting long enough for the “normal” case.

As an addition to what @Holger_von_Thomsen wrote, and since I had once fallen into this trap: An IS restart from the UI is not the same as shutting it down and starting up again.

The UI-level restart does not terminate the JVM entirely and some things therefore are not re-initialized. In addition to class loading stuff, this also affects things like the JVM memory settings etc.

Hi Satvik,

the link you have shared points to an older article referring to an earlier version of webMethods IS, where it was not yet possible to have multiple instances under one installation directory.

When the page shows “Pending enabled” you can try to reload the page.
Sometimes creating the first connection in the pool can take a little bit longer than the page expects for directly switching to “Enabled”.

Regards,
Holger