Project and Portfolio Management Practitioners Forum
cancel

Workflow Transaction Table problem

Highlighted
Onur Eroglu
Frequent Contributor.

Workflow Transaction Table problem

Hi,

We have a storage problem beacuse of holding historical data on the following tables:

KWFL_STEP_TRANSACTIONS
KWFL_STEP_TRANSACTION_HISTORY
KWFL_TRANSITION_TRANSACTIONS

The thread with id = 1421945 suggests that:
'You can use clm.KWFL_workflow_engine.event to delete these rows, but then you have to resize your table space in Oracle to account for clearing the rows out.
'

Could you please clarify how we run this event.


Thanks,

Onur Eroglu
1 REPLY
Celil
Acclaimed Contributor.

Re: Workflow Transaction Table problem

Hi Onur, How are you :)

I couldn't understand "clm.KWFL_workflow_engine.event" mean but maybe you know, after deletion huge of data from database you should reduce the tablespace size with oracle command.

I will search "clm.KWFL_workflow_engine.event" for you. If I find something, I will let you know.

Cheers
Celil

IT Governance Professional
& PPM Solution Architect