Cases are not showing up in task menu

1
0
-1

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?

1 answer

1
0
-1

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

Comments

Submitted by Michele.DuBose on Tue, 02/04/2020 - 09:07

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

Submitted by bastien.laurent... on Wed, 02/05/2020 - 08:26

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

Submitted by Michele.DuBose on Wed, 02/05/2020 - 09:19

When you say clear older archive, do you mean truncate? If so, are they any negative impacts?

Submitted by bastien.laurent... on Wed, 02/05/2020 - 09:26

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.

Submitted by Michele.DuBose on Wed, 02/05/2020 - 14:26

Thank you

Submitted by Michele.DuBose on Wed, 02/05/2020 - 16:21

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.

Submitted by rtumminelli_1394599 on Wed, 02/05/2020 - 22:46

Out of curiousity, how big are your archive tables?

Submitted by Michele.DuBose on Wed, 02/05/2020 - 22:47

arch_mapping is about 1 million worth of data.

Submitted by Michele.DuBose on Wed, 02/05/2020 - 22:47

arch_mapping is about 1 million worth of data.

Submitted by bastien.laurent... on Thu, 02/06/2020 - 08:21

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.

Notifications