IIQ 8.3p4 to 8.4 upgrade error

Which IIQ version are you inquiring about?

8.4

Please share any other relevant files that may be required (for example, logs).

FAILURE: An unexpected error occurred: Error creating bean with name sessionFactory defined in class path resource [hibernateBeans.xml]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.cache.spi.CacheImplementor]

Share all details about your problem, including any error messages you may have received.

So I am currently getting the above error when trying to upgrade the IIQ CLI.
The error pops up right after the console logs the below:
LCM Enabled. Importing LCM Upgrade [8.4]
AI Disabled.
FAM Disabled.
CAM Disabled.
PAM Enabled. Importing PAM Upgrade [8.4]

the iiq.properties file has the correct details for the identitiq database and the identityiqah database. Encrypt is set to falsefor both connections.
I can’t really find this error anywhere else.
Has anyone experienced this error before?

EDIT:
Managed to get the IIQ cli upgrade working.
I deleted all files in the identityiq directory and extracted the war file again and copied over my config again and it ran fine.
I started up the tomcat server again and immediately got an error when I tried to login with the spadmin account.

The below is what I found in the logs:

2025-04-10 21:29:19 [BundleProfileRelationServiceSynchronizer] ERROR sailpoint.server.BundleProfileRelationSynchronizer - Unable to process events: Session/EntityManager is closed
sailpoint.tools.GeneralException: Session/EntityManager is closed
	at sailpoint.persistence.HibernatePersistenceManager.decache(HibernatePersistenceManager.java:2936) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
	at sailpoint.persistence.ClassPersistenceManager.decache(ClassPersistenceManager.java:382) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
	at sailpoint.server.InternalContext.decache(InternalContext.java:990) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
	at sailpoint.server.BundleProfileRelationSynchronizer.processEvents(BundleProfileRelationSynchronizer.java:216) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
	at sailpoint.server.BundleProfileRelationSynchronizer.run(BundleProfileRelationSynchronizer.java:74) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
	Suppressed: sailpoint.tools.GeneralException: Session/EntityManager is closed
		at sailpoint.persistence.HibernatePersistenceManager.saveInternal(HibernatePersistenceManager.java:1693) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.persistence.HibernatePersistenceManager.saveObject(HibernatePersistenceManager.java:1437) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.persistence.HibernatePersistenceManager.unlockObject(HibernatePersistenceManager.java:1349) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.persistence.ClassPersistenceManager.unlockObject(ClassPersistenceManager.java:260) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.server.InternalContext.unlockObject(InternalContext.java:684) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.api.ObjectUtil.unlockObject(ObjectUtil.java:2494) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.service.bundle.BundleProfileRelationLock.releaseLock(BundleProfileRelationLock.java:62) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.service.bundle.BundleProfileRelationLock.close(BundleProfileRelationLock.java:91) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.server.BundleProfileRelationSynchronizer.processEvents(BundleProfileRelationSynchronizer.java:124) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.server.BundleProfileRelationSynchronizer.run(BundleProfileRelationSynchronizer.java:74) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
	Caused by: sailpoint.tools.GeneralException: Session/EntityManager is closed
		at sailpoint.persistence.HibernatePersistenceManager.startTransaction(HibernatePersistenceManager.java:546) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.persistence.HibernatePersistenceManager.saveInternal(HibernatePersistenceManager.java:1533) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		... 9 more
	Caused by: java.lang.IllegalStateException: Session/EntityManager is closed
		at org.hibernate.internal.AbstractSharedSessionContract.checkOpen(AbstractSharedSessionContract.java:375) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
		at org.hibernate.engine.spi.SharedSessionContractImplementor.checkOpen(SharedSessionContractImplementor.java:148) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
		at org.hibernate.internal.AbstractSharedSessionContract.checkOpenOrWaitingForAutoClose(AbstractSharedSessionContract.java:381) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
		at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:479) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
		at sailpoint.persistence.HibernatePersistenceManager.getSession(HibernatePersistenceManager.java:486) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.persistence.HibernatePersistenceManager.getSession(HibernatePersistenceManager.java:385) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.persistence.HibernatePersistenceManager.startTransaction(HibernatePersistenceManager.java:533) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		at sailpoint.persistence.HibernatePersistenceManager.saveInternal(HibernatePersistenceManager.java:1533) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
		... 9 more
Caused by: java.lang.IllegalStateException: Session/EntityManager is closed
	at org.hibernate.internal.AbstractSharedSessionContract.checkOpen(AbstractSharedSessionContract.java:375) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
	at org.hibernate.engine.spi.SharedSessionContractImplementor.checkOpen(SharedSessionContractImplementor.java:148) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
	at org.hibernate.internal.AbstractSharedSessionContract.checkOpenOrWaitingForAutoClose(AbstractSharedSessionContract.java:381) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
	at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:479) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
	at sailpoint.persistence.HibernatePersistenceManager.getSession(HibernatePersistenceManager.java:486) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
	at sailpoint.persistence.HibernatePersistenceManager.getSession(HibernatePersistenceManager.java:385) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
	at sailpoint.persistence.HibernatePersistenceManager.decache(HibernatePersistenceManager.java:2932) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
	... 4 more

Edit 2::
Just had another look. spadmin is there and the password is correct.
I copied over the old cfg and dat files from 8.3 to 8.4.
Still the same error it just takes longer.
in the logs it looks like it is trying to authenticate via LDAP strangely enough even though it should be internal

check this thread that might be related

Bundle Profile Relation Service Synchronizer error - IdentityIQ (IIQ) / IIQ Discussion and Questions - SailPoint Developer Community

I doubt it mainly because the error on that post is:
226 - Unable to process events: null
java.lang.NullPointerException: null

Whereas my error is:
Unable to process events: Session/EntityManager is closed

It has something to do with the session.entityManager.

Can u enable the logging and try again ?

logger.bsync.name=sailpoint.server.BundleProfileRelationSynchronizer
logger.bsync.level=trace

So this is how the error looks when we try to login with the spadmin account.
The network monitoring shows all 200 responses.
It seems that there is an issue with the login functionality

if possible then pls post logs details from sailpoint.log or catalina.out

you can provide syslog event message for that error code. post caused by error section

If it is new IIQ instance import init.xml

2025-04-11 08:40:41 [http-nio-8080-exec-6] ERROR sailpoint.connector.ADLDAPConnector - 886961092 Authentication failed for: sp*****

It does look like it is trying pass through authentication.
There are no logs of IIQ querying the db.
It simply does an ldap filter on the AD source and tries to contact a bunch of dns.

We were missing the sapjco3 jar file.
That was the only problem

@Yaseenl Could you please elaborate on how you identified the issue? I’d appreciate it if you could share more details about the steps or methods you used to find the root cause.