Hello Developer,
I am trying to upgrade from 8.3 to 8.4, but I am getting error as mention in the image,
where in iiq.properties doesnot contain the information of the properties,
as the error says, encrypt set to true and trustservercertificate to false.
but still I am getting error. while running the iiq upgrade commane in cmd.
can you please suggest me which step, I am missing over here.
thanks
Hi @Riyazuddin99
are you using self signed certificate or dont have trusted CA ?
if yes you can use the below in the iiq properties file
encrypt=true
trustServerCertificate=true
also make sure get the latest JDBC driver based on the database that you use
also run iiq upgrade -debug so you will get verbose logging.
hello @vinnysail ,
I am using any certificate.
how can I validate whether is it using any certificate
i did the run the command but getting error.
is it something as except result. for the command iiq upgrade -debug
if its not working you can enable debug logging in log4j2.properties file.
I set the logger level to debug but still the same error.
Hello @Riyazuddin99 Which method are you using to upgrade from 8.3 to 8.4? Could you please share more information? Are you using SSD for this?
as per the guide to upgrade to from 8.3 to 8.4,
not using any SSD part.
I guess the standard method to upgrade the server.
Hi @Riyazuddin99 ,
If this is a test environment, you can update the datasource.url as shown below by replacing the hostname in the URL and then try again.
datasource.url=jdbc:sqlserver://**hostName**;databaseName=identityiq_test;encrypt=true;trustServerCertificate=true;
I noticed that the database name is showing as identityiq_test. Did you @Riyazuddin99 change the database name? @Arun-Kumar Could this be causing the issue?
at my end the database name is created by using the server name as suffix.
identityiq_test is the database.
and before running the upgrade script, everything was working.
after running the upgrade_identityiq_table.mssql
getting the error
Yes, that’s likely the cause.
identityiq_test is not the default DB name (identityiq is default).
identityiq_test to match your actual DB name oridentityiq if you want default.iiq upgrade command again.my database name identityiq_test, implementation team has change it from the default one to the custom name.
Did you create access history database? Which is new additional database from 8.4 and mandatory to create even if you are not planning to use.
Did you update the access history database connection details
section
"##### Access History ####"
in iiq.properties?
##### Access History ####
##### Data Source Properties for Access History #####
dataSourceAccessHistory.maxWaitMillis=10000
dataSourceAccessHistory.maxTotal=50
dataSourceAccessHistory.minIdle=5
#dataSourceAccessHistory.minEvictableIdleTimeMillis=300000
#dataSourceAccessHistory.maxOpenPreparedStatements=-1
dataSourceAccessHistory.username=identityiqah
dataSourceAccessHistory.password=1:ACP:1zLz2jWFgxin6IMcEIX7YG/Osi8odwceLRDqEPZ3VyA=
##### MSSQL Server #####
## URL Format: dataSource.url=jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
dataSourceAccessHistory.url=jdbc:sqlserver://localhost:1433;databaseName=identityiqah;
dataSourceAccessHistory.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
sessionFactoryAccessHistory.hibernateProperties.hibernate.dialect=sailpoint.persistence.SQLServerUnicodeDialect
Post database upgrade, please check following tables for schema version: 8.4-87
post successful iiq upgrade system_version will be updated.
||spt_hist_database_version||
|system_version|schema_version|
|8.4-00 |8.4-87|
||spt_database_version||
|system_version|schema_version|
|8.4-104 | 8.4-87|
Hi @Riyazuddin99
If my guess is correct. you have not created access history DB.
Which jar file are you using?
Please refer below article for the correct jar file.
Step-by-Step: Best Practices for IdentityIQ 7.1p6 to 8.4p2 Upgradation
Hello @pattabhi ,
yes, I did create the access history database, as it say it is mandatory.
share the upgrade_identity script which is been used.
only modification was made on the database name. as to match with old database name
upgrade_identityiq_tables.sqlserver (59.2 KB)