No WorkItem After Lock Table OverFlow

[Ganimede-Dignan]

Hi,

after a system error due Lock Table OverFlow, already solved by BASIS team, we have a strange case, some workflow task don't send workitems into Inbox of users.

For task TS00008046 and TS96000001 we are not able to receive WorkItems, for each task the last workitem genereted is at date/time of Lock Table OverFlow error, as example for TS96000001:

It's an ECC 6.00 box, with :

SAP_ABA	700	0014	SAPKA70014
SAP_BASIS	700	0014	SAPKB70014
PI_BASIS	2006_1_700	0004	SAPKIPYM04
ST-PI	2008_1_700	0004	SAPKITLRD4
SAP_BW	700	0016	SAPKW70016
SAP_AP	700	0012	SAPKNA7012
SAP_APPL	600	0012	SAPKH60012
SAP_HR	600	0022	SAPKE60022
EA-IPPE	400	0011	SAPKGPID11
EA-APPL	600	0011	SAPKGPAD11
EA-DFPS	600	0011	SAPKGPDD11
EA-FINSERV	600	0011	SAPKGPFD11
EA-GLTRADE	600	0011	SAPKGPGD11
EA-HR	600	0022	SAPKGPHD22
EA-PS	600	0011	SAPKGPPD11
EA-RETAIL	600	0011	SAPKGPRD11
FINBASIS	600	0011	SAPK-60011INFINBASIS
ECC-DIMP	600	0011	SAPK-60011INECCDIMP
ERECRUIT	600	0011	SAPK-60011INERECRUIT
FI-CA	600	0011	SAPK-60011INFICA
FI-CAX	600	0011	SAPK-60011INFICAX
INSURANCE	600	0011	SAPK-60011ININSURANC
IS-CWM	600	0011	SAPK-60011INISCWM
IS-H	600	0012	SAPK-60012INISH
IS-M	600	0011	SAPK-60011INISM
IS-OIL	600	0011	SAPK-60011INISOIL
IS-PS-CA	600	0011	SAPK-60011INISPSCA
IS-UT	600	0011	SAPK-60011INISUT
LSOFE	600	0011	SAPK-60011INLSOFE
SEM-BW	600	0011	SAPKGS6011
ST-A/PI	01N_700ECC	0000	-

[I042439 · Accepted solution]

Hi

First we need to find out if any instance of the task  TS00008046 is generated or not and then check why isn't it going to any user.

Did you try checking in SWI2_FREQ by specifying the task  TS00008046 in task filter and the date range AFTER the issue was resolved? Are there any instances of this task generated in the system?

If yes, do we see the agent in the log for that task ? if not, what do we see there? any erorr? or no agents?

regards,

Modak

[Ganimede-Dignan · Accepted solution]

Hi,

thank you for collaboration... I'm not a WF expert I'm from BASIS team.

>First we need to find out if any instance of the task  TS00008046 is generated or not and then check why isn't it >going to any user.

How can I check it?

>Did you try checking in SWI2_FREQ by specifying the task  TS00008046 in task filter and the date range AFTER >the issue was resolved?

Sure, After Lock OverFlow no one message, last entry in SWI2_FREQ for task TS00008046 is the same as Lock issue.

>Are there any instances of this task generated in the system?

How can I check it?

>If yes, do we see the agent in the log for that task ? if not, what do we see there? any erorr? or no agents?

How can I check it?

Thank You so much.

Regards.

[I042439 · Accepted solution]

Hi

SWI2_FREQ is the place, where you already checked, for any generated instance.

if we are sure that IDOC Notification should have been generated and is not generated, please check if the config for the same is correct or not (not sure how it will change on lock overflow, but you can check).

Refer note 44416 for various idoc notification configs to check for (I know it is of lower release, however, you still can get the steps to check the config in your system).

Regards,

Modak

[Ganimede-Dignan · Accepted solution]

Hi,

now I've got an example... just created IDOC but no one message in inbox:

WF Trace from SWEL:

[pokrakam · Accepted solution]

OK, so it's not the linkage being deactivated. The log shows the check function failed. Check what FM is entered in SWETYPV, it is raising an exception for those IDOCs.

This is a standard mechanism to suppress workflows under conditions coded into the check FM, so on a purely technical basis the system looks to be functioning correctly.

[pokrakam]

Hi Ganimede,

Sounds like the incident may have deactivated your event linkage. This blog explains it nicely:

Regards,

Mike

[Former Member]

Hi,

Clarify on this : How you decided the task TS00008046 is not sending work items to the agents?

Have you checked the workflow log for any of the work items of this task? If yes, share the technical log screen shot.

Just for a Note(I think you have already observed): "ORDERS input error " this is the short description of the Task.

Task  TS96000001 does not exist in my system.

Regards,

MK.

[Ganimede-Dignan]

Hi,

>How you decided the task TS00008046 is not sending work items to the agents?

Because there isn't any workitem into Inbox, there are several IDOCS ORDER type created during the day time and no one person has got receive messages. Until Lock Table OverFlow we receive several messages due IDOC problem such (material error code, etc). If we check from WE02/BD87 we can see IDOCS with normal error but we haven't any message into Ibox. For other tasks it always the same.

>Have you checked the workflow log for any of the work items of this task?

mhmm... how can I check it? Form SWEL tcode?

Thank You.

Regards.

[Ganimede-Dignan]

An example of message for IDOC ORDER that we are not able to receive now:

"Material 8013232516333 is not defined for sales org.9101 , distr.chan.90 , language FR"