So this is just a frustration that have to note and what are people's steps to deal with this scenario:
I'm loading data via the Data Integrator into an Classifications business object. In the first load, my data is successfully loaded. However, I notice some data mapping issues. So I Delete the records from a Query. Then I Clear Cache. And go for a second load, my data is successfully loaded. I go into the Classifications Hierarchy form and get the dreaded:
"Please contact your system administrator. The tree control reported this error while trying to draw itself: There was an error in the database or the query definition."
When this happens, I tell myself that I have deleted the records too quickly and not allowed the system to reset in time. The solution, is the dreaded wait time of the clean up agent to process records that are either 12 hours, 1 day, 3 days, or sometimes 1 week before all records with a trirecordstate is null to be removed from the DB by the clean up agent.
The only workaround it seems to be increase the clean up agent time.
However, is there a sequence of steps I need to follow before I delete records from a Hierarchy form so that I don't get the dreaded:
"Please contact your system administrator. The tree control reported this error while trying to draw itself: There was an error in the database or the query definition." each time?
It just seems odd that a system like TRIRIGA has this type of issue.
What's your thoughts? Should I submit a RFE to have a better solution to not have this error appearing each time I load data into Hierarchy forms? How did you get around this?
Thanks in advance!