Upgrade 8.3 to 8.4 Database identityiqah

[anshu77 (Anshu K)]

Hello Experts,

I am working on upgrading the IIQ version from 8.3 to 8.4. Version 8.3 uses SSB/SSD. The upgrade process has always been smooth, but it seems that the SailPoint team has made several changes. I am finding it difficult to complete the upgrade.

Kindly assist me with the following query:

1. identityiqah – Do I need to create this database? I am running the upgrade script but getting an error stating that the database does not exist. Can I use the “create DB” script here to create the identityiqah database?

Kindly help me some steps also with SSB/SSD , in previous version I just copied the custom files

Thanks

Anshu

[enistri_devo (Emanuele Nistri)]

@anshu77

am working on upgrading the IIQ version from 8.3 to 8.4. Version 8.3 uses SSB/SSD. The upgrade process has always been smooth, but it seems that the SailPoint team has made several changes. I am finding it difficult to complete the upgrade.

Kindly assist me with the following query:

1. identityiqah – Do I need to create this database? I am running the upgrade script but getting an error stating that the database does not exist. Can I use the “create DB” script here to create the identityiqah database?

Kindly help me some steps also with SSB/SSD , in previous version I just copied the custom files

Hi @anshu77,

yes you must have this new db and you can find the creation script on database folder where this script will create the db, logins etc. Remeber you must modify your iiq.properties with the new connection. for ex:

##### 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=PWD

##### MySQL/Aurora (without SSL)  #####
dataSourceAccessHistory.url=jdbc:mysql://localhost/identityiqah?useServerPrepStmts=true&tinyInt1isBit=true&useSSL=false&characterEncoding=UTF-8&serverTimezone=UTC
dataSourceAccessHistory.driverClassName=com.mysql.cj.jdbc.Driver
sessionFactoryAccessHistory.hibernateProperties.hibernate.dialect=org.hibernate.dialect.MySQL57Dialect

[anshu77 (Anshu K)]

Thank you Emanuele for your prompt reply. Let me try this.

Thanks
Anshu

[anshu77 (Anshu K)]

I hope I need to use this script but I see the details are huge.

create_identityiq_tables-8.4.sqlserver

Do I need to remove idenittyiq database related information and run only for identityiqah. Kindly reply.

Thansk
Anshu

[Arpitha1 (Arpitha Halaguru Kunne Gowda)]

@anshu77

identityiqah

During the upgrade process, you will run the upgrade DDL (e.g., upgrade_identityiq_tables.mysql) before executing the iiq upgrade command. Therefore, simply updating the iiq.properties file with the connection details and providing the new password is sufficient.

[anshu77 (Anshu K)]

no that’s not correct. I dont have access to create this database under master > identityiqah , I need to run the create script first to create this DB as this is mandatory.