Update 8.1p4 to version 8.2 error in the database

IdentityIQ (IIQ) IIQ Discussion and Questions
1

You have version 8.1 p4 installed and you want to update to 8.2.

The command ./iiq.bat update is executed and the following error is received.

undefined
undefined1258×314 41.1 KB

2024-07-19T11:39:19,690 ERROR main sailpoint.server.upgrade.Upgrader:1272 - Cannot load JDBC driver class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’
sailpoint.tools.GeneralException: Cannot load JDBC driver class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’

We have placed the driver in the iiq folder but we still have the same error.

Any advice?

Regards.

2

have you verified if mssql-jdbc-8.4 jar file is present in WEB-INF/lib folder?

3

Hello Sunny,

we have

image

it needs to be mssql-jdbc-8.4?

Regards.

4

not necesessary, depends of the mssql db version that you have installed, you can check the compatibility on this table:

image
image870×792 18.8 KB

this is the page:

also, check the permission and owner of the file jar and the entire sailpoint folder and try to use the cmd instead of powershell, I had some problems with powershell in the past

5

Hi and Hello,

@wendycape what version of java you have?

Java Version Compatibility: Confirm that the JDBC driver version is compatible with the Java version being used. Some drivers might not work with newer or older versions of Java

Regards,
Adam