Full Text Index Task Failure

We recently upgraded IIQ Version from 8.2p4 to 8.4p2. After the upgrade Full Text Index Task was running fine until recently.

We are seeing below error while running Full Text Index Task.

“2025-02-12T18:15:00,178 ERROR Thread-10 sailpoint.api.FullTextifier.Builder:438 - Exception building index
org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: sailpoint.object.Bundle.classifications, could not initialize proxy - no Session
at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:606) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:218) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.collection.internal.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:162) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.collection.internal.PersistentBag.isEmpty(PersistentBag.java:376) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at sailpoint.tools.Util.isEmpty(Util.java:986) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.fulltext.AbstractIndexer.addClassificationsToIndex(AbstractIndexer.java:569) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.fulltext.BundleIndexer.index(BundleIndexer.java:220) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.fulltext.AbstractIndexer.addDocuments(AbstractIndexer.java:335) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.fulltext.BundleManagedAttributeIndexer.addDocuments(BundleManagedAttributeIndexer.java:129) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.fulltext.Builder.refreshIndex(Builder.java:216) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.fulltext.Builder.refreshAll(Builder.java:170) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.api.FullTextifier.refreshAll(FullTextifier.java:199) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.task.FullTextIndexer.execute(FullTextIndexer.java:114) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.api.TaskManager.runSync(TaskManager.java:981) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.request.TaskExecuteExecutor.execute(TaskExecuteExecutor.java:161) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
at sailpoint.request.RequestHandler.run(RequestHandler.java:163) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]”

Anyone had similar kind of issue after upgrade?

I could not find a relevant article for this error. Please provide some inputs regarding this.

@sathvikareddy

This can happen after upgrade, delete all the old index files and run the task again it will create the files again

Note- Better take a back up before

What are all the files that need to be deleted?

We deleted the contents from “BundleManagedAttributeIndex” file already.

Is there a list of index files which needs to be cleaned out?

We faced this issue during upgrade and deleting the complete along with folder helped us to fix the issue, is not fixed for you?

We deleted only the BundleManagedAttributeIndex. Can you please elaborate on more, when you say you deleted everything?

What else need to be deleted?

@iamksatish are there any specific index tables that we should be clearing out?

No Actually , deleting this completely should fix the issue

Can you try configuring this in a different location from global settings and see if that works

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.