02-01-2021 04:10 PM
We are running Finesse 11.6(1). When we are configuring the cfadmin for Finesse to connect to AWDB, it throws out an error cannot connect to primary or secondary DB. we are using a local sql account with sysadmin role for connection. Cannot figure out what could be the issue. Below is what we see in Finesse logs. Has anyone else run into this issue?
Error connecting AWDB Connection Pool java.sql.SQLException: activeCpds is null
Solved! Go to Solution.
02-16-2021 07:35 PM
Yes we tried all of those scenarios and every one of them worked. In the end it turned out to being an issue with forced encryption turned on our sql and apparently finesse doesn’t support forced encryption. We had an enhancement defect raised for the same.
02-03-2021 12:39 PM
Hi,
I would suggest opening a TAC case so that they can dive deeper into the error.
Thanx,
Denise
02-04-2021 02:19 AM
Harresh,
Its very likely to be something simple.
Can you Telnet to the SQL server on port 1433?
You can try "utils network connectivity" from the finesse server or a "telnet <host> <port>" from your PC.
Why don't you try to confirm you can connect to AW Database from another machine without issue.
e.g. from your PC or or the B side AW Database connect to the A side AW database using the same account.
The account does NOT need to be sysadmin - a read only account will suffice and makes more sense.
You can download the SQL Client and try to connect to the SQL server from your PC.
First thing I would check is do you have windows FW enabled on the AW Database machine.
In summary
1) Can you connect to SQL Server via TCP 1433?
2) Can SQL Studio from your PC or other AW server connect to the AW database using the SQL user account?
Gerry
Gerard
02-16-2021 07:35 PM
Yes we tried all of those scenarios and every one of them worked. In the end it turned out to being an issue with forced encryption turned on our sql and apparently finesse doesn’t support forced encryption. We had an enhancement defect raised for the same.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide