Long running activity 'Assignment of Values to Selection Groups' during ERP TB&CC Package

[david_batho4]

We are running a Time Based and CC Reduction for ERP.

The activity 'Assignment of Values to Selection Groups' runs for many many hours.

The long running job is running program CNV_TDMS_03_ASSIGN_VALUES.

The runtime analysis shows is to be looping millions of times (1,200,000 selects in 20mins) on table fetech to cnvmbtselgrpval.

And still running after 10 hours.

The select statement is...

SELECT "CLIENT" AS c ,"PACKID" AS c ,"GROUP_ID" AS c ,"VARIANT" AS c ,"SETID"

AS c ,"MEMBER_ID" AS c ,"VALNUM" AS c ,"MASTER" AS c ,"SIGN" AS c ,"SOPTION" AS

c ,"VALUE_LOW" AS c ,"VALUE_HIGH" AS c ,"EXTID" AS c

FROM "CNVMBTSELGRPVAL"

WHERE "CLIENT" = @P0 AND "PACKID" = @P1 AND "GROUP_ID" = @P2 AND "SETID"

= @P3 AND "MASTER" = @P4

/* R3:CNV_TDMS_03_ASSIGN_VALUES:5692 T:CNVMBTSELGRPVAL */

/*unc. rd.*/

@P0 nvarchar(3) '001'

@P1 nvarchar(5) '9000F'

@P2 nvarchar(20) 'G_WERKS_VKORG_EKORG'

@P3 nvarchar(5) '00018'

@P4 nvarchar(1) ''

Package ID, Group ID is always 9000F and 'G_WERKS_VKORG_EKORG', setID cycles from 00001 to 00031.

The system itself is not generally performing well, but this excessive number of feteches to this table would suggest the logic in the program is not correct or my lack of config has caused the program to behave this way. Please help.

Dave

[Sandeep_Kumar]

Its difficult to identify the root cause without looking into system.

I wuld advise to cretae an OSS ticket under component CA-TDM so that support colleagues can check the same.

[david_batho4]

Thanks Sandeep,

I've created a SAP message already. SAP have been investigating. I think they debugged and changed some code on the fly to get it through this task the first time. They are still investigating for a proper fix, looks like it could be a coding issue. Will advise outcome asap.

Kind regards,

Dave