Which job/event/program will generate entry in table SWWWIDEADL & SWWWIDH

[Former Member]

Dear Gurus,

I have a problem where my task was overdue, however entry was not created in both tables SWWWIDEADL & SWWWIDH.

It works for other similar tasks and sometime not working.

I don't know how to investigate because have no idea which job/event/program actually writes entry into those tables.

What I know is just the entry suddenly there and my task status is already changed to overdue.

I believe in order for SAP to convert my task from not-overdue to overdue must be done by some repeated job in system.

Anyone can give some hints?

[Former Member · Accepted solution]

My understanding is that SWWWIDEADL gets a new entry in the moment when the work item gets created. The deadlines are defined in the workflow template for each step. Let's stay it has been defined that deadline is 1 day after the work item creation. Work item gets created (in SWWWIHEAD) at 1.1.2015, and at the same time SWWWIDEADL gets a new entry with the same work item ID with deadline 2.1.2015. So, there is no background job.

Then the background job SWWDHEX checks if the deadline have been missed, so at 2.1.2015 something will happen depending on your workflow template.

Regards,

Karri

PS. Of course I might be wrong. I have never really investigated how this thing works. Normally there is not much need to investigate things at table level, because everything can be found in the workflow log.

[Former Member · Accepted solution]

Hi Karri,

Thanks, you were right that once the task with deadline indicator active it will generate table entry.

I wonder why some of same tasks (with deadline indicator) not getting written to table, however at least I know where to start trace the problem.

[former_member185167]

Hello,

Why does it matter what gets written to which table when? What problem are you facing?

regards

Rick

[Former Member]

Hi Rick,

Because I faced an inconsistent behavior on the same task regarding to deadline monitor.

Since I need to trace/debug what the root cause is so I need to know where to start my trace/debug.

[former_member185167]

What was the inconsistent behaviour?

[Former Member]

For the different instance with same task (with deadline activated), some generates entry in those table and some are not.

Maybe challenging because it may not be reproducible easily, I have 2 cases already but now currently working fine.

I need to monitor more and see if it's happening again.

[pokrakam]

What is the deadline time on the failed instances? I think if the deadline is in the past it doesn't bother - e.g. expression that evaluates to yesterday. Would need to experiment to be 100% sure.

[Former Member]

Hi Lim,

Check for the log of the Job 'SWWDHEX'.

Also you can debug the program 'RSWWDHEX' to get some clues about your issue.

Thanks,

Vijay.

[Former Member]

Hi Vijay,

I did run RSWWDHEX several times and still won't generate entry in those table.

I assume that program is to READ entry instead of INSERTING entry.

CMIIW

[Former Member]

Hi Lim,

I am not sure. The next option is put /h and activate the workflow and debug.

Also check note 706478 - this is related to prevent tables from increasing data and Your tables are one of them.

Thanks,

Vijay.