Skip to Content
author's profile photo
Former Member

Master Data Load Problem - Need Help

Hi, When loading a master data object the load is taking a long long time! It looks like the process is taking the most time on an update statement to the SID table.

I Applied note "750207 Deadlock when loading master data", but that didn't seem to work. We are on 3.1 SP15 and the load is about 11k records.

Can anyone provide some suggestions?

This is what the process details show.

UPDATE

"/BIC/SZSOUTLET"

SET

"CHCKFL" = :A0

WHERE

"SID" IN ( :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 , :A8 , :A9 , :A10 , :A11 , :A12 , :A13 , :A14 ,

:A15 , :A16 , :A17 , :A18 , :A19 , :A20 , :A21 , :A22 , :A23 , :A24 , :A25 , :A26 , :A27 , :A28 , :A29

, :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 ,

:A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58

, :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 ,

:A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , :A87

, :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 ,

:A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 ,

:A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A125 , :A126 , :A127 ,

:A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 ,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Jul 20, 2004 at 06:38 PM

    This object is a numc(8) and it has a number range in the SNRO transaction. Since it's a NUMC(8) it shouldn't have a number range object. So I am wondering if because this object has a number range if this is what is causing the slow load time.

    The reason I believe it has the number range is because the object was originally set to 10 in length before we changed it to 8.

    Any thoughts or comments...?

    Add comment
    10|10000 characters needed characters exceeded