I am assuming you must have looked at the 8.4 release notes. Access history was introduced in 8.4 so you need to decide if you are going to enable that feature. There are few task specific to this feature that are run during upgrade, that can take time as the new schema has to be prepared etc.
Also check and compare the support matrix for both version to see if you need to upgrade any of the pre-requisite (java, tomcat, OS etc)
I went to your other comments as well like bewlo:
Still facing issue in migration/upgradation? recently we have completed migration to 8.4 came across similar issues but resolved it successfully.
the sql driver which we have used is: mssql-jdbc-12.6.3.jre11.jar let me know if you need any help.
Invalid object name âidentityiqah.spt_hist_database_versionâ.
Msg 208, Level 16, State 1, Line 1625
Invalid object name âidentityiqah.spt_hist_database_versionâ
Please suggest if we have to run the script to create the new DB as well.
I assume the Access History database has been created.
Could you please provide the DB upgrade script you used? The creation script for the new Access History DB should be visible starting around line 399.
This issue indicates either an incomplete creation of the Access History DB or an incomplete execution of the overall upgrade script.
Please ensure the following lines of code executed successfully:
line number: 1621 to Line number 1642
This is necessary to maintain the schema version. DO NOT REMOVE
insert into identityiqah.spt_hist_database_version (system_version,name) values ('8.4-00','main');
update identityiqah.spt_hist_database_version set schema_version='8.4-87' where name='main';
use identityiq
update identityiq.spt_database_version set schema_version='8.4-87' where name='main'
Please check the output of the following queries to verify the successful execution of the DB script and the iiq upgrade command:
select * from identityiq.spt_database_version;
select * from identityiqah.spt_hist_database_version;
note:
The schema_version is updated after a successful schema upgrade, and the system_version is updated after a successful iiq upgrade.
The identityiqah database must be created as part of the installation, even if you do not intend to use the Access History feature.
in both the scenarioâs access history database script is present inside the same database script.
for example SQL Server db script:
new installation(create_identityiq_tables-8.4.sqlserver) â line number 56
in case of upgrade: upgrade_identityiq_tables.sqlserver â line number around 399
--
-- make sure the identityiqah database and identityiqah user exist.
--
CREATE DATABASE identityiqah
GO
CREATE LOGIN [identityiqah] WITH PASSWORD='identityiqah',
DEFAULT_DATABASE=identityiqah
GO
USE identityiqah
GO
Hi @pattabhi : Getting below error while running iiq console cmd:
WARN main springframework.context.support.ClassPathXmlApplicationContext:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name âversionCheckerâ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://;databaseName=identityiqah;
org.springframework.beans.factory.BeanCreationException: Error creating bean with name âversionCheckerâ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://;databaseName=identityiqah
Hi @pattabhi : We are getting below error while testing our Linux application:
ConnectionFailedException ] [ Possible suggestions ] a) Check UNIX host is up and running. b) Make sure there is a smooth connectivity between Identity Server and UNIX host. [ Error details ] Login failed. Error while connecting to the host no such algorithm: X25519 for provider BC
