alfresco - items lose tasks

[Nana]

Hello,

i have a software that runs with alfresco 4.0.d and jbpm as workflow engine.

i noticed that items stored in alfresco lose their tasks again and again (getTasks() returns null).
The item has a workflow id that has no tasks.

which sql queries can i use to find out which workflow or task instance have lost their tasks ?

And how can i solve it ? with sql queries ?

Thanks for your help

[EddieMay]

Hi @Nana,

There's threads here and here about retrieving tasks that might be useful. 

HTH,

[Nana]

thank you but i need sql queries that query the database.