Truncating Task Tables

[Former Member]

Can anyone please help to find a solution on the below problem:

For the Tables : Tasks, TaskCondition(ProcessTaskLog) and Tasklogs, the data volume is high and we are thinking of truncating the tables. But we can can see that the Tables are used in OOS and are not sure whether clearing these tables create any issues. Since we could see that TaskLogs are storing some logs, we can archive/truncate the table. But not sure on other Tables since we are seeing some process tasks stored in these tables.

Please help in providing details about these Tables and also kindly let us know whether truncating these tables cause any issues.

[Former Member]

Hi , I am facing same kind of issue with Process Logs. Please let me know if you have any solution for this below issue.

INFO | jvm 1 | main | 2017/11/29 02:13:15.843 | ERROR [TaskExecutor-master-66-ProcessTask [8807801521078]] [FlexibleSearch] Flexible search error occured... INFO | jvm 1 | main | 2017/11/29 02:13:15.843 | WARN [TaskExecutor-master-66-ProcessTask [8807801521078]] [ProcessengineTaskExecutionStrategy] could not remove finished task ProcessTaskModel (8807801521078@0) due to could not remove partOf attribute items in [alldocuments, conditions] for 8807801521078 due to could not translate value expression 'session.catalogversions'

Thanks, Malli

[former_member537989]

You should review why there are so many tasks in the table - what is the reason that they are staying there (processes are waiting for an event?), then when tasks being completed in a normal way, the taskconditions and tasklogs will be removed by framework due to partOf relationships.