# Cases are not showing up in task menu **URL:** \ **Category:** Q&A\ **Created:** [4 February 2020 02:59 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999 "2020-02-04T02:59:33Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Michele.DuBose](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@Michele.DuBose](https://community.ofelia.com/u/Michele.DuBose)\ **Post date:** [4 February 2020 02:59 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/1 "2020-02-04T02:59:33Z")
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?   ---
**Author:** ![bastien.laurent\_1374](https://avatars.discourse-cdn.com/v4/letter/b/fbc32d/32.png) [@bastien.laurent\_1374](https://community.ofelia.com/u/bastien.laurent_1374)\ **Post date:** [4 February 2020 08:02 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/2 "2020-02-04T08:02:01Z")
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 ---
**Author:** ![Michele.DuBose](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@Michele.DuBose](https://community.ofelia.com/u/Michele.DuBose)\ **Post date:** [4 February 2020 08:07 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/3 "2020-02-04T08:07:03Z")
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** ---
**Author:** ![bastien.laurent\_1374](https://avatars.discourse-cdn.com/v4/letter/b/fbc32d/32.png) [@bastien.laurent\_1374](https://community.ofelia.com/u/bastien.laurent_1374)\ **Post date:** [5 February 2020 07:26 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/4 "2020-02-05T07:26:23Z")
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 ---
**Author:** ![Michele.DuBose](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@Michele.DuBose](https://community.ofelia.com/u/Michele.DuBose)\ **Post date:** [5 February 2020 08:19 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/5 "2020-02-05T08:19:32Z")
When you say clear older archive, do you mean truncate?  If so, are they any negative impacts? ---
**Author:** ![bastien.laurent\_1374](https://avatars.discourse-cdn.com/v4/letter/b/fbc32d/32.png) [@bastien.laurent\_1374](https://community.ofelia.com/u/bastien.laurent_1374)\ **Post date:** [5 February 2020 08:26 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/6 "2020-02-05T08:26:32Z")
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. ---
**Author:** ![Michele.DuBose](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@Michele.DuBose](https://community.ofelia.com/u/Michele.DuBose)\ **Post date:** [5 February 2020 13:26 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/7 "2020-02-05T13:26:13Z")
Thank you ---
**Author:** ![Michele.DuBose](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@Michele.DuBose](https://community.ofelia.com/u/Michele.DuBose)\ **Post date:** [5 February 2020 15:21 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/8 "2020-02-05T15:21:21Z")
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. ---
**Author:** ![rtumminelli\_1394599](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/rtumminelli_1394599/32/1412_2.png) [@rtumminelli\_1394599](https://community.ofelia.com/u/rtumminelli_1394599)\ **Post date:** [5 February 2020 21:46 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/9 "2020-02-05T21:46:03Z")
Out of curiousity, how big are your archive tables? ---
**Author:** ![Michele.DuBose](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@Michele.DuBose](https://community.ofelia.com/u/Michele.DuBose)\ **Post date:** [5 February 2020 21:47 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/10 "2020-02-05T21:47:34Z")
arch\_mapping is about 1 million worth of data. ---
**Author:** ![Michele.DuBose](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@Michele.DuBose](https://community.ofelia.com/u/Michele.DuBose)\ **Post date:** [5 February 2020 21:47 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/11 "2020-02-05T21:47:53Z")
arch\_mapping is about 1 million worth of data. ---
**Author:** ![bastien.laurent\_1374](https://avatars.discourse-cdn.com/v4/letter/b/fbc32d/32.png) [@bastien.laurent\_1374](https://community.ofelia.com/u/bastien.laurent_1374)\ **Post date:** [6 February 2020 07:21 UTC](https://community.ofelia.com/t/cases-are-not-showing-up-in-task-menu/9999/12 "2020-02-06T07:21:04Z")
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.