Hello.
In my environment, I'm using the Tomcat bundle installation of Bonitasoft Community edition v 6.3.2. Database is MySQL. Lately, when users submit a process, the case is submitted into the database but is not shown in the Pending task or that user's to do list. I can see under the cases menu in the Bonita portal that the case is there. I do not understand why the cases are not showing up in the task menu. Are the database queries that run forcing the cases to appear in the task menu? Is it possible, that these queries did not execute which is causing the cases to not display?
That can be due to :
- Your user is not an actor member of your process / task .
- Your process have an error
- You don't have any 'Human task'
In your 'cases menu' you can see your process statut ( pending flow node / error flow node ). If your case have some pending flow node, just search your pending flow node.
Regards
Hi. Thanks for the response. I'm the Admin and do not see the cases in the pending task menu. There are definitely human task. How do I check the case in the pending flow node? Also, by checking the logs, I've noticed that the following errors occur even though I have 1.9 GB of 19 GB left. Would this affect the pending/active cases? Could this be the reason the pending cases are not showing up in the pending tasks menu?
WARN: SQL Error: 1114, SQLState: HY000
2020-02-04 01:16:21 org.hibernate.engine.jdbc.spi.SqlExceptionHelper
ERROR: The table 'arch_data_mapping' is full
2020-02-04 01:16:21 org.hibernate.engine.jdbc.spi.SqlExceptionHelper
WARN: SQL Error: 1114, SQLState: HY000
2020-02-04 01:16:21 org.hibernate.engine.jdbc.spi.SqlExceptionHelper
ERROR: The table 'arch_data_instance' is full
This message is clear, I think you need to clean your database:
- backup all your tables that's starting by 'arch' in the bonita database or make a script that backup and clear all your olders archive.
I have never see this before, so maybe, bonita have an archive limit.
Regards
When you say clear older archive, do you mean truncate? If so, are they any negative impacts?
The only impact is that you will not be able to see them in Bonita, but if you have make a backup, you will be able to add them again.
One more thing, is there documentation about the tables that are used within the system? I would like to understand if there's relationships between the tables, what type of data is written to the tables, etc. I just want to make sure by clearing older archive data, there will not be any orphans.
Out of curiousity, how big are your archive tables?
arch_mapping is about 1 million worth of data.
arch_mapping is about 1 million worth of data.
I don't know exactly, i have never found the table mapping.i just know, by experience that all tables starting by 'arch' is for archive.