SAP Knowledge Base Article - Preview

3247840 - DTU utilization outage caused by impex import in distributed mode

Symptom

DTU utilization outage issue happened, most of DTU consumed by the following query:

(@P0 bigint,@P1 nvarchar(4000),@P2 bigint,@P3 bigint,@P4 nvarchar(4000),@P5 bigint,@P6 bigint,@P7 nvarchar(4000),@P8 bigint,@P9 bigint,@P10 nvarchar(4000),@P11 bigint,@P12 bigint,@P13 nvarchar(4000),@P14 bigint,@P15 bigint,@P16 nvarchar(4000),@P17 bigint,@P18 bigint,@P19 nvarchar(4000),@P20 bigint,@P21 bigint,@P22 nvarchar(4000),@P23 bigint,@P24 bigint,@P25 nvarchar(4000),@P26 bigint,@P27 bigint,@P28 nvarchar(4000),@P29 bigint,@P30 bigint,@P31 nvarchar(4000),@P32 bigint,@P33 bigint,@P34 nvarchar(4000),@P35 bigint,@P36 bigint,@P37 nvarchar(4000),@P38 bigint,@P39 bigint,@P40 nvarchar(4000),@P41 bigint,@P42 bigint,@P43 nvarchar(4000),@P44 bigint,@P45 bigint,@P46 nvarchar(4000),@P47 bigint,@P48 bigint,@P49 nvarchar(4000),@P50 bigint,@P51 bigint,@P52 nvarchar(4000),@P53 bigint,@P54 bigint,@P55 nvarchar(4000),@P56 bigint,@P57 bigint,@P58 nvarchar(4000),@P59 bigint,@P60 bigint,@P61 nvarchar(4000),@P62 bigint,@P63 bigint,@P64 nvarchar(4000),@P65 bigint,@P66 bigint,@P67 nvarchar(4000),@P68 bigint,@P69 bigint,@P70 nvarchar(4000),@P71 bigint,@P72 bigint,@P73 nvarchar(4000),@P74 bigint,@P75 bigint,@P76 nvarchar(4000),@P77 bigint,@P78 bigint,@P79 nvarchar(4000),@P80 bigint,@P81 bigint,@P82 nvarchar(4000),@P83 bigint,@P84 bigint,@P85 nvarchar(4000),@P86 bigint,@P87 bigint,@P88 nvarchar(4000),@P89 bigint,@P90 bigint,@P91 nvarchar(4000),@P92 bigint,@P93 bigint,@P94 nvarchar(4000),@P95 bigint,@P96 bigint,@P97 nvarchar(4000),@P98 bigint,@P99 bigint,@P100 nvarchar(4000),@P101 bigint,@P102 bigint,@P103 nvarchar(4000),@P104 bigint,@P105 bigint,@P106 nvarchar(4000),@P107 bigint,@P108 bigint,@P109 nvarchar(4000),@P110 bigint,@P111 bigint,@P112 nvarchar(4000),@P113 bigint,@P114 bigint,@P115 nvarchar(4000),@P116 bigint,@P117 bigint,@P118 nvarchar(4000),@P119 bigint,@P120 bigint,@P121 nvarchar(4000),@P122 bigint,@P123 bigint,@P124 nvarchar(4000),@P125 bigint,@P126 bigint,@P127 nvarchar(4000),@P128 bigint,@P129 bigint,@P130 nvarchar(4000),@P131 bigint,@P132 bigint,@P133 nvarchar(4000),@P134 bigint,@P135 bigint,@P136 nvarchar(4000),@P137 bigint,@P138 bigint,@P139 nvarchar(4000),@P140 bigint,@P141 bigint,@P142 nvarchar(4000),@P143 bigint,@P144 bigint,@P145 nvarchar(4000),@P146 bigint,@P147 bigint,@P148 nvarchar(4000),@P149 bigint,@P150 bigint,@P151 nvarchar(4000),@P152 bigint,@P153 bigint,@P154 nvarchar(4000),@P155 bigint,@P156 bigint,@P157 nvarchar(4000),@P158 bigint,@P159 bigint,@P160 nvarchar(4000),@P161 bigint,@P162 bigint,@P163 nvarchar(4000),@P164 bigint,@P165 bigint,@P166 nvarchar(4000),@P167 bigint,@P168 bigint,@P169 nvarchar(4000),@P170 bigint,@P171 bigint,@P172 nvarchar(4000),@P173 bigint,@P174 bigint,@P175 nvarchar(4000),@P176 bigint,@P177 bigint,@P178 nvarchar(4000),@P179 bigint,@P180 bigint,@P181 nvarchar(4000),@P182 bigint,@P183 bigint,@P184 nvarchar(4000),@P185 bigint,@P186 bigint,@P187 nvarchar(4000),@P188 bigint,@P189 bigint,@P190 nvarchar(4000),@P191 bigint,@P192 bigint,@P193 nvarchar(4000),@P194 bigint,@P195 bigint,@P196 nvarchar(4000),@P197 bigint,@P198 bigint,@P199 nvarchar(4000),@P200 bigint,@P201 bigint,@P202 nvarchar(4000),@P203 bigint,@P204 bigint,@P205 nvarchar(4000),@P206 bigint,@P207 bigint,@P208 nvarchar(4000),@P209 bigint,@P210 bigint,@P211 nvarchar(4000),@P212 bigint,@P213 bigint,@P214 nvarchar(4000),@P215 bigint,@P216 bigint,@P217 nvarchar(4000),@P218 bigint,@P219 bigint,@P220 nvarchar(4000),@P221 bigint,@P222 bigint,@P223 nvarchar(4000),@P224 bigint,@P225 bigint,@P226 nvarchar(4000),@P227 bigint,@P228 bigint,@P229 nvarchar(4000),@P230 bigint,@P231 bigint,@P232 nvarchar(4000),@P233 bigint,@P234 bigint,@P235 nvarchar(4000),@P236 bigint,@P237 bigint,@P238 nvarchar(4000),@P239 bigint,@P240 bigint,@P241 nvarchar(4000),@P242 bigint,@P243 bigint,@P244 nvarchar(4000),@P245 bigint,@P246 bigint,@P247 nvarchar(4000),@P248 bigint,@P249 bigint,@P250 nvarchar(4000),@P251 bigint,@P252 bigint,@P253 nvarchar(4000),@P254 bigint,@P255 bigint,@P256 nvarchar(4000),@P257 bigint,@P258 bigint,@P259 nvarchar(4000),@P260 bigint,@P261 bigint,@P262 nvarchar(4000),@P263 bigint,@P264 bigint,@P265 nvarchar(4000),@P266 bigint,@P267 bigint,@P268 nvarchar(4000),@P269 bigint,@P270 bigint,@P271 nvarchar(4000),@P272 bigint,@P273 bigint,@P274 nvarchar(4000),@P275 bigint,@P276 bigint,@P277 nvarchar(4000),@P278 bigint,@P279 bigint,@P280 nvarchar(4000),@P281 bigint,@P282 bigint,@P283 nvarchar(4000),@P284 bigint,@P285 bigint,@P286 nvarchar(4000),@P287 bigint,@P288 bigint,@P289 nvarchar(4000),@P290 bigint,@P291 bigint,@P292 nvarchar(4000),@P293 bigint,@P294 bigint,@P295 nvarchar(4000),@P296 bigint,@P297 bigint,@P298 nvarchar(4000),@P299 bigint,@P300 bigint)

SELECT item_t0.PK FROM stocklevels item_t0 WHERE 
(( item_t0.p_unit = @P0 AND item_t0.p_productcode = @P1 AND item_t0.p_warehouse = @P2)  
OR ( item_t0.p_unit = @P3 AND item_t0.p_productcode = @P4 AND item_t0.p_warehouse = @P5) 
OR ( item_t0.p_unit = @P6 AND item_t0.p_productcode = @P7 AND item_t0.p_warehouse = @P8) 
OR ( item_t0.p_unit = @P9 AND item_t0.p_productcode = @P10 AND item_t0.p_warehouse = @P11) 
OR ( item_t0.p_unit = @P12 AND item_t0.p_productcode = @P13 AND item_t0.p_warehouse = @P14) 
OR ( item_t0.p_unit = @P15 AND item_t0.p_productcode = @P16 AND item_t0.p_warehouse = @P17) 
OR ( item_t0.p_unit = @P18 AND item_t0.p_productcode = @P19 AND item_t0.p_warehouse = @P20) 
OR ( item_t0.p_unit = @P21 AND item_t0.p_productcode = @P22 AND item_t0.p_warehouse = @P23) 
OR ( item_t0.p_unit = @P24 AND item_t0.p_productcode = @P25 AND item_t0.p_warehouse = @P26) 
OR ( item_t0.p_unit = @P27 AND item_t0.p_productcode = @P28 AND item_t0.p_warehouse = @P29) 
OR ( item_t0.p_unit = @P30 AND item_t0.p_productcode = @P31 AND item_t0.p_warehouse = @P32) 
OR ( item_t0.p_unit = @P33 AND item_t0.p_productcode = @P34 AND item_t0.p_warehouse = @P35) 
OR ( item_t0.p_unit = @P36 AND item_t0.p_productcode = @P37 AND item_t0.p_warehouse = @P38) 
OR ( item_t0.p_unit = @P39 AND item_t0.p_productcode = @P40 AND item_t0.p_warehouse = @P41) 
OR ( item_t0.p_unit = @P42 AND item_t0.p_productcode = @P43 AND item_t0.p_warehouse = @P44) 
OR ( item_t0.p_unit = @P45 AND item_t0.p_productcode = @P46 AND item_t0.p_warehouse = @P47) 
OR ( item_t0.p_unit = @P48 AND item_t0.p_productcode = @P49 AND item_t0.p_warehouse = @P50) 
OR ( item_t0.p_unit = @P51 AND item_t0.p_productcode = @P52 AND item_t0.p_warehouse = @P53) 
OR ( item_t0.p_unit = @P54 AND item_t0.p_productcode = @P55 AND item_t0.p_warehouse = @P56) 
OR ( item_t0.p_unit = @P57 AND item_t0.p_productcode = @P58 AND item_t0.p_warehouse = @P59) 
OR ( item_t0.p_unit = @P60 AND item_t0.p_productcode = @P61 AND item_t0.p_warehouse = @P62) 
OR ( item_t0.p_unit = @P63 AND item_t0.p_productcode = @P64 AND item_t0.p_warehouse = @P65) 
OR ( item_t0.p_unit = @P66 AND item_t0.p_productcode = @P67 AND item_t0.p_warehouse = @P68) 
OR ( item_t0.p_unit = @P69 AND item_t0.p_productcode = @P70 AND item_t0.p_warehouse = @P71) 
OR ( item_t0.p_unit = @P72 AND item_t0.p_productcode = @P73 AND item_t0.p_warehouse = @P74) 
OR ( item_t0.p_unit = @P75 AND item_t0.p_productcode = @P76 AND item_t0.p_warehouse = @P77) 
OR ( item_t0.p_unit = @P78 AND item_t0.p_productcode = @P79 AND item_t0.p_warehouse = @P80) 
OR ( item_t0.p_unit = @P81 AND item_t0.p_productcode = @P82 AND item_t0.p_warehouse = @P83) 
OR ( item_t0.p_unit = @P84 AND item_t0.p_productcode = @P85 AND item_t0.p_warehouse = @P86) 
OR ( item_t0.p_unit = @P87 AND item_t0.p_productcode = @P88 AND item_t0.p_warehouse = @P89) 
OR ( item_t0.p_unit = @P90 AND item_t0.p_productcode = @P91 AND item_t0.p_warehouse = @P92) 
OR ( item_t0.p_unit = @P93 AND item_t0.p_productcode = @P94 AND item_t0.p_warehouse = @P95) 
OR ( item_t0.p_unit = @P96 AND item_t0.p_productcode = @P97 AND item_t0.p_warehouse = @P98) 
OR ( item_t0.p_unit = @P99 AND item_t0.p_productcode = @P100 AND item_t0.p_warehouse = @P101) 
OR ( item_t0.p_unit = @P102 AND item_t0.p_productcode = @P103 AND item_t0.p_warehouse = @P104) 
OR ( item_t0.p_unit = @P105 AND item_t0.p_productcode = @P106 AND item_t0.p_warehouse = @P107) 
OR ( item_t0.p_unit = @P108 AND item_t0.p_productcode = @P109 AND item_t0.p_warehouse = @P110) 
OR ( item_t0.p_unit = @P111 AND item_t0.p_productcode = @P112 AND item_t0.p_warehouse = @P113) 
OR ( item_t0.p_unit = @P114 AND item_t0.p_productcode = @P115 AND item_t0.p_warehouse = @P116) 
OR ( item_t0.p_unit = @P117 AND item_t0.p_productcode = @P118 AND item_t0.p_warehouse = @P119) 
OR ( item_t0.p_unit = @P120 AND item_t0.p_productcode = @P121 AND item_t0.p_warehouse = @P122) 
OR ( item_t0.p_unit = @P123 AND item_t0.p_productcode = @P124 AND item_t0.p_warehouse = @P125) 
OR ( item_t0.p_unit = @P126 AND item_t0.p_productcode = @P127 AND item_t0.p_warehouse = @P128) 
OR ( item_t0.p_unit = @P129 AND item_t0.p_productcode = @P130 AND item_t0.p_warehouse = @P131) 
OR ( item_t0.p_unit = @P132 AND item_t0.p_productcode = @P133 AND item_t0.p_warehouse = @P134) 
OR ( item_t0.p_unit = @P135 AND item_t0.p_productcode = @P136 AND item_t0.p_warehouse = @P137) 
OR ( item_t0.p_unit = @P138 AND item_t0.p_productcode = @P139 AND item_t0.p_warehouse = @P140) 
OR ( item_t0.p_unit = @P141 AND item_t0.p_productcode = @P142 AND item_t0.p_warehouse = @P143) 
OR ( item_t0.p_unit = @P144 AND item_t0.p_productcode = @P145 AND item_t0.p_warehouse = @P146) 
OR ( item_t0.p_unit = @P147 AND item_t0.p_productcode = @P148 AND item_t0.p_warehouse = @P149) 
OR ( item_t0.p_unit = @P150 AND item_t0.p_productcode = @P151 AND item_t0.p_warehouse = @P152) 
OR ( item_t0.p_unit = @P153 AND item_t0.p_productcode = @P154 AND item_t0.p_warehouse = @P155) 
OR ( item_t0.p_unit = @P156 AND item_t0.p_productcode = @P157 AND item_t0.p_warehouse = @P158) 
OR ( item_t0.p_unit = @P159 AND item_t0.p_productcode = @P160 AND item_t0.p_warehouse = @P161) 
OR ( item_t0.p_unit = @P162 AND item_t0.p_productcode = @P163 AND item_t0.p_warehouse = @P164) 
OR ( item_t0.p_unit = @P165 AND item_t0.p_productcode = @P166 AND item_t0.p_warehouse = @P167) 
OR ( item_t0.p_unit = @P168 AND item_t0.p_productcode = @P169 AND item_t0.p_warehouse = @P170) 
OR ( item_t0.p_unit = @P171 AND item_t0.p_productcode = @P172 AND item_t0.p_warehouse = @P173) 
OR ( item_t0.p_unit = @P174 AND item_t0.p_productcode = @P175 AND item_t0.p_warehouse = @P176) 
OR ( item_t0.p_unit = @P177 AND item_t0.p_productcode = @P178 AND item_t0.p_warehouse = @P179) 
OR ( item_t0.p_unit = @P180 AND item_t0.p_productcode = @P181 AND item_t0.p_warehouse = @P182) 
OR ( item_t0.p_unit = @P183 AND item_t0.p_productcode = @P184 AND item_t0.p_warehouse = @P185) 
OR ( item_t0.p_unit = @P186 AND item_t0.p_productcode = @P187 AND item_t0.p_warehouse = @P188) 
OR ( item_t0.p_unit = @P189 AND item_t0.p_productcode = @P190 AND item_t0.p_warehouse = @P191) 
OR ( item_t0.p_unit = @P192 AND item_t0.p_productcode = @P193 AND item_t0.p_warehouse = @P194) 
OR ( item_t0.p_unit = @P195 AND item_t0.p_productcode = @P196 AND item_t0.p_warehouse = @P197) 
OR ( item_t0.p_unit = @P198 AND item_t0.p_productcode = @P199 AND item_t0.p_warehouse = @P200) 
OR ( item_t0.p_unit = @P201 AND item_t0.p_productcode = @P202 AND item_t0.p_warehouse = @P203) 
OR ( item_t0.p_unit = @P204 AND item_t0.p_productcode = @P205 AND item_t0.p_warehouse = @P206) 
OR ( item_t0.p_unit = @P207 AND item_t0.p_productcode = @P208 AND item_t0.p_warehouse = @P209) 
OR ( item_t0.p_unit = @P210 AND item_t0.p_productcode = @P211 AND item_t0.p_warehouse = @P212) 
OR ( item_t0.p_unit = @P213 AND item_t0.p_productcode = @P214 AND item_t0.p_warehouse = @P215) 
OR ( item_t0.p_unit = @P216 AND item_t0.p_productcode = @P217 AND item_t0.p_warehouse = @P218) 
OR ( item_t0.p_unit = @P219 AND item_t0.p_productcode = @P220 AND item_t0.p_warehouse = @P221) 
OR ( item_t0.p_unit = @P222 AND item_t0.p_productcode = @P223 AND item_t0.p_warehouse = @P224) 
OR ( item_t0.p_unit = @P225 AND item_t0.p_productcode = @P226 AND item_t0.p_warehouse = @P227) 
OR ( item_t0.p_unit = @P228 AND item_t0.p_productcode = @P229 AND item_t0.p_warehouse = @P230) 
OR ( item_t0.p_unit = @P231 AND item_t0.p_productcode = @P232 AND item_t0.p_warehouse = @P233) 
OR ( item_t0.p_unit = @P234 AND item_t0.p_productcode = @P235 AND item_t0.p_warehouse = @P236) 
OR ( item_t0.p_unit = @P237 AND item_t0.p_productcode = @P238 AND item_t0.p_warehouse = @P239) 
OR ( item_t0.p_unit = @P240 AND item_t0.p_productcode = @P241 AND item_t0.p_warehouse = @P242) 
OR ( item_t0.p_unit = @P243 AND item_t0.p_productcode = @P244 AND item_t0.p_warehouse = @P245) 
OR ( item_t0.p_unit = @P246 AND item_t0.p_productcode = @P247 AND item_t0.p_warehouse = @P248) 
OR ( item_t0.p_unit = @P249 AND item_t0.p_productcode = @P250 AND item_t0.p_warehouse = @P251) 
OR ( item_t0.p_unit = @P252 AND item_t0.p_productcode = @P253 AND item_t0.p_warehouse = @P254) 
OR ( item_t0.p_unit = @P255 AND item_t0.p_productcode = @P256 AND item_t0.p_warehouse = @P257) 
OR ( item_t0.p_unit = @P258 AND item_t0.p_productcode = @P259 AND item_t0.p_warehouse = @P260) 
OR ( item_t0.p_unit = @P261 AND item_t0.p_productcode = @P262 AND item_t0.p_warehouse = @P263) 
OR ( item_t0.p_unit = @P264 AND item_t0.p_productcode = @P265 AND item_t0.p_warehouse = @P266) 
OR ( item_t0.p_unit = @P267 AND item_t0.p_productcode = @P268 AND item_t0.p_warehouse = @P269) 
OR ( item_t0.p_unit = @P270 AND item_t0.p_productcode = @P271 AND item_t0.p_warehouse = @P272) 
OR ( item_t0.p_unit = @P273 AND item_t0.p_productcode = @P274 AND item_t0.p_warehouse = @P275) 
OR ( item_t0.p_unit = @P276 AND item_t0.p_productcode = @P277 AND item_t0.p_warehouse = @P278) 
OR ( item_t0.p_unit = @P279 AND item_t0.p_productcode = @P280 AND item_t0.p_warehouse = @P281) 
OR ( item_t0.p_unit = @P282 AND item_t0.p_productcode = @P283 AND item_t0.p_warehouse = @P284) 
OR ( item_t0.p_unit = @P285 AND item_t0.p_productcode = @P286 AND item_t0.p_warehouse = @P287) 
OR ( item_t0.p_unit = @P288 AND item_t0.p_productcode = @P289 AND item_t0.p_warehouse = @P290) 
OR ( item_t0.p_unit = @P291 AND item_t0.p_productcode = @P292 AND item_t0.p_warehouse = @P293) 
OR ( item_t0.p_unit = @P294 AND item_t0.p_productcode = @P295 AND item_t0.p_warehouse = @P296) 
OR ( item_t0.p_unit = @P297 AND item_t0.p_productcode = @P298 AND item_t0.p_warehouse = @P299)) 
AND (item_t0.TypePkString=@P300 )


Read more...

Environment

Commerce Cloud

Product

SAP Commerce Cloud 2011

Keywords

DTU 100% impex import distributed mode , KBA , CEC-COM-CPS-TSK , Cronjob - Impex - Task Engine , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.