- Notifications
You must be signed in to change notification settings - Fork958
Description
Describe the bug
When open a project it takes long time to complete. The GUI displays, but the folders doesn't collapse and we are not able to do anything in the GUI for 10 - 15 seconds. After that period of time the folders collapse and we are able to move around. The project has a total of 337 jobs in different folders.
This is probably due to a SQL Query runs before finishing loading the web page. See below for example of the query.
My Rundeck detail
- Rundeck version: 5.16
- install type: war
- OS Name/version: Windows Server 2019
- DB Type/version: MS SQL Express 2019
To Reproduce
- Log on to Rundeck web
- Open project
Expected behavior
List all jobs and folders in the start page without delay when opening a project.
Desktop (please complete the following information):
- OS: Windows
- Browser: Edge, Chrome
- Version: Latest versions (used several versions)
Additional context
Using SQL Profiler we can see that Rundeck runs a sql query which takes 12 - 20 seconds to finish. This is an example of the query Rundeck generate and a screenshot from SQL Profiler of the same query.

** SQL Query
exec sp_executesql N'select this_.id as id1_12_0_, this_.version as version2_12_0_, this_.log_output_threshold as log_outp3_12_0_, this_.do_nodedispatch as do_noded4_12_0_, this_.next_execution as next_exe5_12_0_, this_.date_created as date_cre6_12_0_, this_.node_keepgoing as node_kee7_12_0_, this_.node_exclude_os_arch as node_exc8_12_0_, this_.uuid as uuid9_12_0_, this_.node_include as node_in10_12_0_, this_.success_on_empty_node_filter as success11_12_0_, this_.node_exclude_os_version as node_ex12_12_0_, this_.timeout as timeout13_12_0_, this_.node_exclude_precedence as node_ex14_12_0_, this_.node_exclude_name as node_ex15_12_0_, this_.notify_avg_duration_threshold as notify_16_12_0_, this_.day_of_week as day_of_17_12_0_, this_.node_include_os_version as node_in18_12_0_, this_.node_exclude_os_name as node_ex19_12_0_, this_.retry as retry20_12_0_, this_.filter as filter21_12_0_, this_.group_path as group_p22_12_0_, this_.scheduled as schedul23_12_0_, this_.orchestrator_id as orchest24_12_0_, this_.node_threadcount_dynamic as node_th25_12_0_, this_.node_include_name as node_in26_12_0_, this_.multiple_executions as multipl27_12_0_, this_.time_zone as time_zo28_12_0_, this_.rduser as rduser29_12_0_, this_.node_include_os_name as node_in30_12_0_, this_.filter_exclude as filter_31_12_0_, this_.node_exclude as node_ex32_12_0_, this_.node_rank_order_ascending as node_ra33_12_0_, this_.nodes_selected_by_default as nodes_s34_12_0_, this_.node_include_os_arch as node_in35_12_0_,this_.loglevel as logleve36_12_0_, this_.node_exclude_os_family as node_ex37_12_0_, this_.execution_enabled as executi38_12_0_, this_.max_multiple_executions as max_mul39_12_0_, this_.node_include_os_family as node_in40_12_0_, this_.last_updated as last_up41_12_0_, this_.retry_delay as retry_d42_12_0_, this_.workflow_id as workflo43_12_0_, this_.exec_count as exec_co44_12_0_, this_.month as month45_12_0_, this_.hour as hour46_12_0_, this_.log_output_threshold_action as log_out47_12_0_, this_.arg_string as arg_str48_12_0_, this_.user_role_list as user_ro49_12_0_, this_.total_time as total_t50_12_0_, this_.node_rank_attribute as node_ra51_12_0_, this_.server_nodeuuid as server_52_12_0_, this_.default_tab as default53_12_0_, this_.node_exclude_tags as node_ex54_12_0_, this_.seconds as seconds55_12_0_, this_.ref_exec_count as ref_exe56_12_0_, this_.exclude_filter_uncheck as exclude57_12_0_, this_.node_threadcount as node_th58_12_0_, this_.node_include_tags as node_in59_12_0_, this_.job_name as job_nam60_12_0_, this_.schedule_enabled as schedul61_12_0_, this_.year as year62_12_0_, this_.day_of_month as day_of_63_12_0_, this_.node_filter_editable as node_fi64_12_0_, this_.log_output_threshold_status as log_out65_12_0_, this_.description as descrip66_12_0_, this_.minute as minute67_12_0_, this_.project as project68_12_0_, this_.plugin_config as plugin_69_12_0_ from scheduled_execution this_ where (this_.uuid=@p0 or this_.uuid=@p1 or this_.uuid=@p2 or this_.uuid=@p3 or this_.uuid=@P4 or this_.uuid=@p5 or this_.uuid=@p6 or this_.uuid=@P7 or this_.uuid=@p8 or this_.uuid=@p9 or this_.uuid=@p10 or this_.uuid=@p11 or this_.uuid=@p12 or this_.uuid=@P13 or this_.uuid=@p14 or this_.uuid=@P15 or this_.uuid=@p16 or this_.uuid=@p17 or this_.uuid=@p18 or this_.uuid=@p19 or this_.uuid=@p20 or this_.uuid=@p21 or this_.uuid=@p22 or this_.uuid=@p23 or this_.uuid=@p24 or this_.uuid=@p25 or this_.uuid=@P26 or this_.uuid=@p27 or this_.uuid=@p28 or this_.uuid=@p29 or this_.uuid=@p30 or this_.uuid=@p31 or this_.uuid=@P32 or this_.uuid=@p33 or this_.uuid=@p34 or this_.uuid=@p35 or this_.uuid=@p36 or this_.uuid=@P37 or this_.uuid=@p38 or this_.uuid=@p39 or this_.uuid=@p40 or this_.uuid=@p41 or this_.uuid=@p42 or this_.uuid=@P43 or this_.uuid=@p44 or this_.uuid=@p45 or this_.uuid=@p46 or this_.uuid=@P47 or this_.uuid=@p48 or this_.uuid=@p49 or this_.uuid=@P50 or this_.uuid=@P51 or this_.uuid=@P52 or this_.uuid=@P53 or this_.uuid=@P54 or this_.uuid=@P55 or this_.uuid=@P56 or this_.uuid=@P57 or this_.uuid=@P58 or this_.uuid=@P59 or this_.uuid=@P60 or this_.uuid=@P61 or this_.uuid=@P62 or this_.uuid=@P63 or this_.uuid=@P64 or this_.uuid=@P65 or this_.uuid=@P66 or this_.uuid=@P67 or this_.uuid=@P68 or this_.uuid=@P69 or this_.uuid=@P70 or this_.uuid=@P71 or this_.uuid=@P72 or this_.uuid=@P73 or this_.uuid=@P74 or this_.uuid=@P75 or this_.uuid=@P76 or this_.uuid=@P77 or this_.uuid=@P78 or this_.uuid=@P79 or this_.uuid=@P80 or this_.uuid=@P81 or this_.uuid=@P82 or this_.uuid=@P83 or this_.uuid=@P84 or this_.uuid=@P85 or this_.uuid=@P86 or this_.uuid=@P87 or this_.uuid=@P88 or this_.uuid=@P89 or this_.uuid=@P90 or this_.uuid=@P91 or this_.uuid=@P92 or this_.uuid=@P93 or this_.uuid=@P94 or this_.uuid=@P95 or this_.uuid=@P96 or this_.uuid=@P97 or this_.uuid=@P98 or this_.uuid=@P99 or this_.uuid=@P100 or this_.uuid=@P101 or this_.uuid=@P102 or this_.uuid=@P103 or this_.uuid=@P104 or this_.uuid=@P105 or this_.uuid=@P106 or this_.uuid=@P107 or this_.uuid=@P108 or this_.uuid=@P109 or this_.uuid=@P110 or this_.uuid=@P111 or this_.uuid=@P112 or this_.uuid=@P113 or this_.uuid=@P114 or this_.uuid=@P115 or this_.uuid=@P116 or this_.uuid=@P117 or this_.uuid=@P118 or this_.uuid=@P119 or this_.uuid=@P120 or this_.uuid=@P121 or this_.uuid=@P122 or this_.uuid=@P123 or this_.uuid=@P124 or this_.uuid=@P125 or this_.uuid=@P126 or this_.uuid=@P127 or this_.uuid=@P128 or this_.uuid=@P129 or this_.uuid=@P130 or this_.uuid=@P131 or this_.uuid=@P132 or this_.uuid=@P133 or this_.uuid=@P134 or this_.uuid=@P135 or this_.uuid=@P136 or this_.uuid=@P137 or this_.uuid=@P138 or this_.uuid=@P139 or this_.uuid=@P140 or this_.uuid=@P141 or this_.uuid=@P142 or this_.uuid=@P143 or this_.uuid=@P144 or this_.uuid=@P145 or this_.uuid=@P146 or this_.uuid=@P147 or this_.uuid=@P148 or this_.uuid=@P149 or this_.uuid=@P150 or this_.uuid=@P151 or this_.uuid=@P152 or this_.uuid=@P153 or this_.uuid=@P154 or this_.uuid=@P155 or this_.uuid=@P156 or this_.uuid=@P157 or this_.uuid=@P158 or this_.uuid=@P159 or this_.uuid=@P160 or this_.uuid=@P161 or this_.uuid=@P162 or this_.uuid=@P163 or this_.uuid=@P164 or this_.uuid=@P165 or this_.uuid=@P166 or this_.uuid=@P167 or this_.uuid=@P168 or this_.uuid=@P169 or this_.uuid=@P170 or this_.uuid=@P171 or this_.uuid=@P172 or this_.uuid=@P173 or this_.uuid=@P174 or this_.uuid=@P175 or this_.uuid=@P176 or this_.uuid=@P177 or this_.uuid=@P178 or this_.uuid=@P179 or this_.uuid=@P180 or this_.uuid=@P181 or this_.uuid=@P182 or this_.uuid=@P183 or this_.uuid=@P184 or this_.uuid=@P185 or this_.uuid=@P186 or this_.uuid=@P187 or this_.uuid=@P188 or this_.uuid=@P189 or this_.uuid=@P190 or this_.uuid=@P191 or this_.uuid=@P192 or this_.uuid=@P193 or this_.uuid=@P194 or this_.uuid=@P195 or this_.uuid=@P196 or this_.uuid=@P197 or this_.uuid=@P198 or this_.uuid=@P199 or this_.uuid=@P200 or this_.uuid=@P201 or this_.uuid=@P202 or this_.uuid=@P203 or this_.uuid=@P204 or this_.uuid=@P205 or this_.uuid=@P206 or this_.uuid=@P207 or this_.uuid=@P208 or this_.uuid=@P209 or this_.uuid=@P210 or this_.uuid=@P211 or this_.uuid=@P212 or this_.uuid=@P213 or this_.uuid=@P214 or this_.uuid=@P215 or this_.uuid=@P216 or this_.uuid=@P217 or this_.uuid=@P218 or this_.uuid=@P219 or this_.uuid=@P220 or this_.uuid=@P221 or this_.uuid=@P222 or this_.uuid=@P223 or this_.uuid=@P224 or this_.uuid=@P225 or this_.uuid=@P226 or this_.uuid=@P227 or this_.uuid=@P228 or this_.uuid=@P229 or this_.uuid=@P230 or this_.uuid=@P231 or this_.uuid=@P232 or this_.uuid=@P233 or this_.uuid=@P234 or this_.uuid=@P235 or this_.uuid=@P236 or this_.uuid=@P237 or this_.uuid=@P238 or this_.uuid=@P239 or this_.uuid=@P240 or this_.uuid=@P241 or this_.uuid=@P242 or this_.uuid=@P243 or this_.uuid=@P244 or this_.uuid=@P245 or this_.uuid=@P246 or this_.uuid=@P247 or this_.uuid=@P248 or this_.uuid=@P249 or this_.uuid=@P250 or this_.uuid=@P251 or this_.uuid=@P252 or this_.uuid=@P253 or this_.uuid=@P254 or this_.uuid=@P255 or this_.uuid=@P256 or this_.uuid=@P257 or this_.uuid=@P258 or this_.uuid=@P259 or this_.uuid=@P260 or this_.uuid=@P261 or this_.uuid=@P262 or this_.uuid=@P263 or this_.uuid=@P264 or this_.uuid=@P265 or this_.uuid=@P266 or this_.uuid=@P267 or this_.uuid=@P268 or this_.uuid=@P269 or this_.uuid=@P270 or this_.uuid=@P271 or this_.uuid=@P272 or this_.uuid=@P273 or this_.uuid=@P274 or this_.uuid=@P275 or this_.uuid=@P276 or this_.uuid=@P277 or this_.uuid=@P278 or this_.uuid=@P279 or this_.uuid=@P280 or this_.uuid=@P281 or this_.uuid=@P282 or this_.uuid=@P283 or this_.uuid=@P284 or this_.uuid=@P285 or this_.uuid=@P286 or this_.uuid=@P287 or this_.uuid=@P288 or this_.uuid=@P289 or this_.uuid=@P290 or this_.uuid=@P291 or this_.uuid=@P292 or this_.uuid=@P293 or this_.uuid=@P294 or this_.uuid=@P295 or this_.uuid=@P296 or this_.uuid=@P297 or this_.uuid=@P298 or this_.uuid=@P299 or this_.uuid=@P300 or this_.uuid=@P301 or this_.uuid=@P302 or this_.uuid=@P303 or this_.uuid=@P304 or this_.uuid=@P305 or this_.uuid=@P306 or this_.uuid=@P307 or this_.uuid=@P308 or this_.uuid=@P309 or this_.uuid=@P310 or this_.uuid=@P311 or this_.uuid=@P312 or this_.uuid=@P313 or this_.uuid=@P314 or this_.uuid=@P315 or this_.uuid=@P316 or this_.uuid=@P317 or this_.uuid=@P318 or this_.uuid=@P319 or this_.uuid=@P320 or this_.uuid=@P321 or this_.uuid=@P322 or this_.uuid=@P323 or this_.uuid=@P324 or this_.uuid=@P325 or this_.uuid=@P326 or this_.uuid=@P327 or this_.uuid=@P328 or this_.uuid=@P329 or this_.uuid=@P330 or this_.uuid=@P331 or this_.uuid=@P332 or this_.uuid=@P333 or this_.uuid=@P334 or this_.uuid=@P335 or this_.uuid=@P336) and this_.project=@P337 order by this_.job_name asc',N'@p0 nvarchar(4000),@p1 nvarchar(4000),@p2 nvarchar(4000),@p3 nvarchar(4000),@P4 nvarchar(4000),@p5 nvarchar(4000),@p6 nvarchar(4000),@P7 nvarchar(4000),@p8 nvarchar(4000),@p9 nvarchar(4000),@p10 nvarchar(4000),@p11 nvarchar(4000),@p12 nvarchar(4000),@P13 nvarchar(4000),@p14 nvarchar(4000),@P15 nvarchar(4000),@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(4000),@p19 nvarchar(4000),@p20 nvarchar(4000),@p21 nvarchar(4000),@p22 nvarchar(4000),@p23 nvarchar(4000),@p24 nvarchar(4000),@p25 nvarchar(4000),@P26 nvarchar(4000),@p27 nvarchar(4000),@p28 nvarchar(4000),@p29 nvarchar(4000),@p30 nvarchar(4000),@p31 nvarchar(4000),@P32 nvarchar(4000),@p33 nvarchar(4000),@p34 nvarchar(4000),@p35 nvarchar(4000),@p36 nvarchar(4000),@P37 nvarchar(4000),@p38 nvarchar(4000),@p39 nvarchar(4000),@p40 nvarchar(4000),@p41 nvarchar(4000),@p42 nvarchar(4000),@P43 nvarchar(4000),@p44 nvarchar(4000),@p45 nvarchar(4000),@p46 nvarchar(4000),@P47 nvarchar(4000),@p48 nvarchar(4000),@p49 nvarchar(4000),@P50 nvarchar(4000),@P51 nvarchar(4000),@P52 nvarchar(4000),@P53 nvarchar(4000),@P54 nvarchar(4000),@P55 nvarchar(4000),@P56 nvarchar(4000),@P57 nvarchar(4000),@P58 nvarchar(4000),@P59 nvarchar(4000),@P60 nvarchar(4000),@P61 nvarchar(4000),@P62 nvarchar(4000),@P63 nvarchar(4000),@P64 nvarchar(4000),@P65 nvarchar(4000),@P66 nvarchar(4000),@P67 nvarchar(4000),@P68 nvarchar(4000),@P69 nvarchar(4000),@P70 nvarchar(4000),@P71 nvarchar(4000),@P72 nvarchar(4000),@P73 nvarchar(4000),@P74 nvarchar(4000),@P75 nvarchar(4000),@P76 nvarchar(4000),@P77 nvarchar(4000),@P78 nvarchar(4000),@P79 nvarchar(4000),@P80 nvarchar(4000),@P81 nvarchar(4000),@P82 nvarchar(4000),@P83 nvarchar(4000),@P84 nvarchar(4000),@P85 nvarchar(4000),@P86 nvarchar(4000),@P87 nvarchar(4000),@P88 nvarchar(4000),@P89 nvarchar(4000),@P90 nvarchar(4000),@P91 nvarchar(4000),@P92 nvarchar(4000),@P93 nvarchar(4000),@P94 nvarchar(4000),@P95 nvarchar(4000),@P96 nvarchar(4000),@P97 nvarchar(4000),@P98 nvarchar(4000),@P99 nvarchar(4000),@P100 nvarchar(4000),@P101 nvarchar(4000),@P102 nvarchar(4000),@P103 nvarchar(4000),@P104 nvarchar(4000),@P105 nvarchar(4000),@P106 nvarchar(4000),@P107 nvarchar(4000),@P108 nvarchar(4000),@P109 nvarchar(4000),@P110 nvarchar(4000),@P111 nvarchar(4000),@P112 nvarchar(4000),@P113 nvarchar(4000),@P114 nvarchar(4000),@P115 nvarchar(4000),@P116 nvarchar(4000),@P117 nvarchar(4000),@P118 nvarchar(4000),@P119 nvarchar(4000),@P120 nvarchar(4000),@P121 nvarchar(4000),@P122 nvarchar(4000),@P123 nvarchar(4000),@P124 nvarchar(4000),@P125 nvarchar(4000),@P126 nvarchar(4000),@P127 nvarchar(4000),@P128 nvarchar(4000),@P129 nvarchar(4000),@P130 nvarchar(4000),@P131 nvarchar(4000),@P132 nvarchar(4000),@P133 nvarchar(4000),@P134 nvarchar(4000),@P135 nvarchar(4000),@P136 nvarchar(4000),@P137 nvarchar(4000),@P138 nvarchar(4000),@P139 nvarchar(4000),@P140 nvarchar(4000),@P141 nvarchar(4000),@P142 nvarchar(4000),@P143 nvarchar(4000),@P144 nvarchar(4000),@P145 nvarchar(4000),@P146 nvarchar(4000),@P147 nvarchar(4000),@P148 nvarchar(4000),@P149 nvarchar(4000),@P150 nvarchar(4000),@P151 nvarchar(4000),@P152 nvarchar(4000),@P153 nvarchar(4000),@P154 nvarchar(4000),@P155 nvarchar(4000),@P156 nvarchar(4000),@P157 nvarchar(4000),@P158 nvarchar(4000),@P159 nvarchar(4000),@P160 nvarchar(4000),@P161 nvarchar(4000),@P162 nvarchar(4000),@P163 nvarchar(4000),@P164 nvarchar(4000),@P165 nvarchar(4000),@P166 nvarchar(4000),@P167 nvarchar(4000),@P168 nvarchar(4000),@P169 nvarchar(4000),@P170 nvarchar(4000),@P171 nvarchar(4000),@P172 nvarchar(4000),@P173 nvarchar(4000),@P174 nvarchar(4000),@P175 nvarchar(4000),@P176 nvarchar(4000),@P177 nvarchar(4000),@P178 nvarchar(4000),@P179 nvarchar(4000),@P180 nvarchar(4000),@P181 nvarchar(4000),@P182 nvarchar(4000),@P183 nvarchar(4000),@P184 nvarchar(4000),@P185 nvarchar(4000),@P186 nvarchar(4000),@P187 nvarchar(4000),@P188 nvarchar(4000),@P189 nvarchar(4000),@P190 nvarchar(4000),@P191 nvarchar(4000),@P192 nvarchar(4000),@P193 nvarchar(4000),@P194 nvarchar(4000),@P195 nvarchar(4000),@P196 nvarchar(4000),@P197 nvarchar(4000),@P198 nvarchar(4000),@P199 nvarchar(4000),@P200 nvarchar(4000),@P201 nvarchar(4000),@P202 nvarchar(4000),@P203 nvarchar(4000),@P204 nvarchar(4000),@P205 nvarchar(4000),@P206 nvarchar(4000),@P207 nvarchar(4000),@P208 nvarchar(4000),@P209 nvarchar(4000),@P210 nvarchar(4000),@P211 nvarchar(4000),@P212 nvarchar(4000),@P213 nvarchar(4000),@P214 nvarchar(4000),@P215 nvarchar(4000),@P216 nvarchar(4000),@P217 nvarchar(4000),@P218 nvarchar(4000),@P219 nvarchar(4000),@P220 nvarchar(4000),@P221 nvarchar(4000),@P222 nvarchar(4000),@P223 nvarchar(4000),@P224 nvarchar(4000),@P225 nvarchar(4000),@P226 nvarchar(4000),@P227 nvarchar(4000),@P228 nvarchar(4000),@P229 nvarchar(4000),@P230 nvarchar(4000),@P231 nvarchar(4000),@P232 nvarchar(4000),@P233 nvarchar(4000),@P234 nvarchar(4000),@P235 nvarchar(4000),@P236 nvarchar(4000),@P237 nvarchar(4000),@P238 nvarchar(4000),@P239 nvarchar(4000),@P240 nvarchar(4000),@P241 nvarchar(4000),@P242 nvarchar(4000),@P243 nvarchar(4000),@P244 nvarchar(4000),@P245 nvarchar(4000),@P246 nvarchar(4000),@P247 nvarchar(4000),@P248 nvarchar(4000),@P249 nvarchar(4000),@P250 nvarchar(4000),@P251 nvarchar(4000),@P252 nvarchar(4000),@P253 nvarchar(4000),@P254 nvarchar(4000),@P255 nvarchar(4000),@P256 nvarchar(4000),@P257 nvarchar(4000),@P258 nvarchar(4000),@P259 nvarchar(4000),@P260 nvarchar(4000),@P261 nvarchar(4000),@P262 nvarchar(4000),@P263 nvarchar(4000),@P264 nvarchar(4000),@P265 nvarchar(4000),@P266 nvarchar(4000),@P267 nvarchar(4000),@P268 nvarchar(4000),@P269 nvarchar(4000),@P270 nvarchar(4000),@P271 nvarchar(4000),@P272 nvarchar(4000),@P273 nvarchar(4000),@P274 nvarchar(4000),@P275 nvarchar(4000),@P276 nvarchar(4000),@P277 nvarchar(4000),@P278 nvarchar(4000),@P279 nvarchar(4000),@P280 nvarchar(4000),@P281 nvarchar(4000),@P282 nvarchar(4000),@P283 nvarchar(4000),@P284 nvarchar(4000),@P285 nvarchar(4000),@P286 nvarchar(4000),@P287 nvarchar(4000),@P288 nvarchar(4000),@P289 nvarchar(4000),@P290 nvarchar(4000),@P291 nvarchar(4000),@P292 nvarchar(4000),@P293 nvarchar(4000),@P294 nvarchar(4000),@P295 nvarchar(4000),@P296 nvarchar(4000),@P297 nvarchar(4000),@P298 nvarchar(4000),@P299 nvarchar(4000),@P300 nvarchar(4000),@P301 nvarchar(4000),@P302 nvarchar(4000),@P303 nvarchar(4000),@P304 nvarchar(4000),@P305 nvarchar(4000),@P306 nvarchar(4000),@P307 nvarchar(4000),@P308 nvarchar(4000),@P309 nvarchar(4000),@P310 nvarchar(4000),@P311 nvarchar(4000),@P312 nvarchar(4000),@P313 nvarchar(4000),@P314 nvarchar(4000),@P315 nvarchar(4000),@P316 nvarchar(4000),@P317 nvarchar(4000),@P318 nvarchar(4000),@P319 nvarchar(4000),@P320 nvarchar(4000),@P321 nvarchar(4000),@P322 nvarchar(4000),@P323 nvarchar(4000),@P324 nvarchar(4000),@P325 nvarchar(4000),@P326 nvarchar(4000),@P327 nvarchar(4000),@P328 nvarchar(4000),@P329 nvarchar(4000),@P330 nvarchar(4000),@P331 nvarchar(4000),@P332 nvarchar(4000),@P333 nvarchar(4000),@P334 nvarchar(4000),@P335 nvarchar(4000),@P336 nvarchar(4000),@P337 nvarchar(4000)',N'02b1d097-0039-444c-af51-2bfa6473cc20',N'66cc134e-d860-464c-a484-8588a013d9db',N'd9d34879-baf4-4831-be3d-89314b2d6edf',N'01cc5cb9-334e-498a-a824-2eb489230efb',N'317f79d1-dd69-4b6a-8fae-b5e2432d88d0',N'eced65e1-bc50-4d8f-b290-7c8d9c9a3d0f',N'75257252-4885-495f-8191-ff00c0aa00cf',N'19680aab-2748-4d98-a314-e237782a51ff',N'5b040005-d196-4200-bfb7-107c77bb8929',N'20297933-9d6b-4542-94f7-7686219fb8e5',N'cbe18ff3-d539-451f-9619-03f0d73b8948',N'69465bec-ebb3-45f0-abf2-42548ba9016a',N'16566ec9-045c-4941-94a5-5e8738a09c23',N'4f1f59b1-5c1a-4292-9144-1ba725c11548',N'88191bbc-f129-4e64-8c62-b1cb665a031f',N'8af1b259-99a7-43a4-892f-480fe0202493',N'9cbc4dcb-2697-47b8-b4f5-7bc3ef17d791',N'33fc4417-018e-4b07-b670-b561403c96cb',N'a0a5c0d6-1a78-47b8-a969-9b6f41120624',N'6082ab14-333d-410c-93e0-246d69fcbfea',N'7e3ec77b-ce6b-42a4-877f-8931b2bb3807',N'14e65be6-a7e1-478c-a46a-554fff0b5b06',N'6b74760d-fa3c-40e4-8bbe-d4bba6267fa7',N'50e33988-6ae1-4d4c-8237-c21b528e09fb',N'8b66e8d5-311c-4f32-872b-bea03d37cefb',N'0db52768-fb5b-47ab-a09a-0fa06a1a52ad',N'c2c07caa-bd28-4877-b0f7-5949e0832cf7',N'5684ec2d-6b47-43a9-a00b-517c1fb73558',N'9a6da1fc-cbfb-4f32-866c-65a4c5bcd9b8',N'b6fdbfbb-ccf6-45b4-be49-de4238b7a774',N'5003915f-8d9b-4918-ac07-358c36657602',N'd9179c19-0a78-4572-8333-c887004214cf',N'28a6c5a3-8968-436a-bddb-d1f025bbef6c',N'f9950852-fdab-43cd-a204-0e0b6115fc63',N'fb121ab1-63d0-42ba-a1e5-8f56e32d8388',N'8d5aa675-690b-447e-9177-c2ef5e80090f',N'91e312aa-9af1-4745-8a38-c55ca6835ffd',N'216b99b2-3111-4afe-9990-c519e8cbcc21',N'ab65fba3-d220-4af8-a6c5-0320474ff46d',N'539c58ec-ea95-4396-b8c5-df977ce402f2',N'0fd4eb19-9d34-4b57-b330-1a52a3bf7302',N'50dc6a84-a5ca-4f2f-a9c2-0bda8e20a1c2',N'4b5a21d9-6350-41af-9783-c718f5dfa495',N'd7f44b4e-bdd2-4fa7-8379-6176edd16332',N'17065fe6-154d-48bd-8149-166a6feaf136',N'4c4cc017-7106-4025-ae9d-3465613cb733',N'3a7477d2-710c-4d98-b5de-ed9a3426eb95',N'48b7972c-efc6-45f0-80ee-5072fbb25aab',N'7dd0b25c-5739-4cec-b203-8252880f5fa1',N'be7a6093-468d-4a09-b65b-1db6c6de2ea1',N'32fb3e34-4ca5-4677-8627-a5bf205fe420',N'1f640da1-8843-45f1-a985-84f854fc6738',N'6fad74da-5708-4373-a972-89c6c6ab61ea',N'3b11cb7f-09b8-47b9-b321-57580b968203',N'7428dd20-6d23-4558-9d1a-0c2f8cdd38de',N'f7acb0b4-6654-4c11-bed2-d44feaa5109f',N'4e37cd69-2108-4812-b88a-45c0fe7ce17c',N'1b5fbb22-b3e2-45e2-b904-48107f2f57d8',N'd0c921fb-7442-4212-9028-91b5b44570c4',N'e52a31ba-f06f-40a7-8c10-d0aeb73dbf5f',N'6cfe5fb9-a6c2-40c6-b3d8-e2aa6c87cd0b',N'1e392109-080e-4bef-9797-8a660fbf1c85',N'9c9ad9ed-0b4d-4b9a-a164-491cc53dab1f',N'e1b1519d-7d86-4a00-83ba-ed5747742672',N'7acec0c2-6efe-4a8f-8651-a7809b2498e0',N'5cd62879-6369-4668-b39c-66283e53d5c0',N'aaaf31d6-2cf8-49b9-a613-3f150753d7d9',N'ee05cfbf-3d49-42df-9b54-dd2874cf6169',N'eda88495-b0db-431c-92b8-383b937543af',N'5b579af3-e75a-464d-b855-5e2637b41f3d',N'42577897-0b5f-4b62-9ce3-6aca920ef8f8',N'b9006f77-ba32-42ba-a1ab-f0aac07fe493',N'28fe9ff9-add4-4605-9378-33afeb06329a',N'f0cec514-4215-47a9-bc3f-b1940aa9a62c',N'1514f381-f69f-468d-8149-c34324315b57',N'66155072-b68d-48dd-a4c9-d67f0638a84d',N'35d62a9e-6ca8-45ce-acdc-345bc3939706',N'a8ccf234-cd92-4dd0-839c-1146ae4a12ea',N'31672ca1-a12e-40f2-ba61-695962433d71',N'fdf48c50-fcec-43d5-8e9e-f018b95755c8',N'eb06c59a-ac41-4c13-ba16-79bf6ec285c5',N'e366cd1d-8777-42f7-8785-8bfc8a9c1aa3',N'623cd387-7b53-448f-84de-a86a6fdb3259',N'6f070ce7-b3da-4f54-a0b4-6ca15332b04e',N'17ded229-b01f-4032-bd5e-da7a0400027c',N'8cf4d472-c44a-4113-8d5b-ff9afad08590',N'b220dcea-4cbf-4596-a5a0-ba9e939b8454',N'6a7b4735-20bd-4ee4-8566-ef9f6a83b75f',N'b33445ab-4417-4c00-ab40-80d35028ed79',N'06f10f16-8d48-4c65-9198-6f1c61dd1419',N'c0468afb-9e01-48ba-a377-7658e02af3a0',N'ad1168d7-4b71-4651-8639-7d57f6c58e24',N'98164fe7-bc20-4dbe-b253-935fc0f86c06',N'13174e4f-e20c-4d10-b0cf-15328e39adef',N'e4850eb2-c080-48da-bd3d-b25952d2cb6c',N'14b9036b-c8ad-4bcf-ac9d-39929126bc52',N'1b216dc9-1987-4ed6-9511-cda8b88151a7',N'8378e261-87b4-40f2-b76a-c26a405b0969',N'ccda7db7-4c32-459f-b7cf-4de18c70b8dd',N'a0b217aa-2ce0-460b-909b-c5aab73769fc',N'e8a70e83-e1b0-4523-ba89-ad0eee3a7560',N'dc73eed2-4585-4000-9849-c031aa351a98',N'4f07e4c2-a2bc-4823-a632-d95fb5461460',N'755b6fc6-0c90-4f07-a413-c75fb441e0c8',N'22f23aa7-ede5-4516-b7b8-9ccd9b12f5d4',N'44901e3c-6d12-45b9-9cc1-f1644b3c9e5c',N'c3ba1faf-1d69-4331-bc89-c80093b6fe8d',N'46cfa302-ed85-43da-8b33-8490dec76390',N'b81c1e26-5ed3-4841-ba2b-61f7e44ba52a',N'6dc4e431-8bff-44a6-aba3-3c325ce71a41',N'af72a1df-19b4-47ff-be5d-46c94ffb28ae',N'4cc7afd5-d698-4dce-bb48-538d7bb91dd0',N'2884c0b9-0e2d-4a48-a09a-ea77019829aa',N'f243c3da-4c11-48b1-b4b7-cf2647de90fe',N'f95bf2a1-c822-4843-b6b5-24fd319dee14',N'28ff1b0c-7769-4e0f-b2c5-dbc40358fe8e',N'c7d15a2a-fd49-485f-ae33-a9e285424a8d',N'f03010a9-446c-4453-8577-cd71182560c1',N'8e664c1d-e66f-4fdb-a10a-fae5790ed9f0',N'8b2d6517-c9da-4cee-8db6-6b1017e0ceaf',N'1a5b8c82-d7fd-4b68-8bc6-2a2bbef61e75',N'fb52e59f-20de-47d6-b401-5fe730b9c14a',N'487e2b21-3e47-496c-b179-a93f0197fc19',N'6098fe55-eabc-4662-8fb2-be8be47188a2',N'88ee4a9e-bc1c-4458-ae21-83f431afb5b1',N'41a0d8d0-853a-4093-9f2e-92083898f9d9',N'f8e92603-8a99-48bf-ad96-4a6148a5fb4c',N'12a8965b-9f0f-4f60-b66e-83c58ae87bee',N'65a70b0b-c9ba-4672-acc5-f809083c2bb8',N'aefe838c-20e0-402d-a5d8-632420adf289',N'dde03b8c-12bc-44fa-954a-c3a33fdae6bd',N'2fc75617-db0b-48df-befd-99b0cbee3d60',N'90726894-a5de-4d40-8d19-356d8928d2f7',N'aa6610b8-4cc9-4593-9e5c-72a8d896678f',N'fe1904e6-7790-401c-99bb-4b9f40e518d0',N'1de47e9a-6b41-4345-8072-ef64bc3e57df',N'0878b794-75e5-495d-bd4f-5c71c06bc0d5',N'1c7f70b7-23ef-4ed2-a5f9-f2f10ab9e1f5',N'b47344fe-8dcd-434d-980a-7efa3e35deea',N'e9400cec-eeef-469b-a0fb-941a24da2e90',N'49b878e0-3c58-44aa-8e9d-2c1d2230dbc7',N'c3b353af-50fe-4961-8465-c11d15b39c2c',N'9bcc41a8-2fae-4513-9457-eaa4787058cc',N'21d2ed2d-b12f-4268-b97e-0cb8c2c86015',N'a32e7b45-088c-4ebe-aa5e-459d88cf91c7',N'b4e3759a-2790-447c-b51a-0afe0f329c8c',N'9bf848d0-f9b7-4028-91c9-f1f905cf3690',N'03f7e5b7-f0aa-417c-84d9-6adab40bd94b',N'472604a1-7b5e-4518-acaf-7e7cecac56cd',N'9779ecea-311e-4f03-9064-0a81155ea44b',N'e0755f2b-ccbb-45df-aa63-59e17eb04fb9',N'bf5dcb99-e938-4fec-af60-ed33a30db6f9',N'7f06a4b1-12ec-4545-aee0-93017c97c419',N'36082aa7-fd7c-41a5-b864-f1ea956705f5',N'2149ddcd-a52e-4fe9-bb69-827f70598492',N'c22e09f1-7ca6-443c-843b-3dd7afe678ad',N'2000fc28-5978-488a-9657-8b9c222df3e8',N'a8ae0efc-49bb-4efc-86fb-1149e55baa47',N'adf54225-6a9b-49fa-a553-92382d978b58',N'79a8ce6e-06b8-44fb-b793-1ac33391aeee',N'77d21f6f-3fbe-4e95-b37b-37d91fe38c71',N'1a490565-01b3-441f-b2af-37baf6914423',N'fd1fe16a-ba82-48fc-a653-348464b32daa',N'c418736a-85d0-4f50-acba-62efe24888b8',N'f7c44503-947e-4f35-845c-66650277fa75',N'8f196d50-ea36-4d15-9a31-e84b50ce6fe9',N'40723deb-a531-4b21-92eb-eb1ce5aee8e3',N'43f141b3-00f2-4d35-a460-9369eb9f5c67',N'65d1969d-950b-44ce-aa23-8d59915d934a',N'22e19f14-1a54-4a49-9499-225b7fb08d13',N'453b7484-d6d4-4929-8885-2b7d5f6ceac4',N'76619c6b-bc1b-4fe6-afe1-dc6c07deba5c',N'5c71535a-082f-4536-b82d-34e053d09b58',N'3fdf8226-0e76-4b62-ba64-b328f32d160a',N'ac36e562-e1c0-4ce6-8dff-fb5e748acfee',N'fcb8e05d-d27f-45fd-b2ca-a56eccee992b',N'9b547db9-22c0-4157-85c3-4e4d3ef94722',N'15ddcc2c-9a08-454a-a8ae-554e2b165147',N'9ba5ed38-4a62-40db-ae52-96c78253f03f',N'c84fa4e5-4d19-493a-bd56-d029eeb60a50',N'ca8c90c3-54ed-4757-a5ee-8ad2fe8f7b90',N'dd1de4ab-8be6-4388-a6f6-656607b01405',N'86da7185-32eb-4fb4-88a4-45ed4e54e298',N'37a587d5-1704-4820-b87f-fa3ca8c70bc2',N'f0678da2-40aa-479d-9f5d-3a9f35de8119',N'140fb6c7-8b9a-41a3-9dc9-304b0b0ec07b',N'db55fe7d-a67b-4071-9339-40cd914f1a75',N'be68fcc3-edb7-41ab-a603-93395edb9de1',N'd107f864-be2f-4701-bdd9-7abf40dcc67a',N'f95da1f4-3fef-46fd-8912-d32558f76143',N'45d41e38-ddf5-4569-946b-131a4effe331',N'a08ef513-5571-4589-a3f1-24b7d659a778',N'341f35d6-07ce-44e5-afe0-3dd62f765708',N'6e0bac03-860f-47a2-bf82-5e4769bb814a',N'6bb85b91-4225-4d46-8e4f-246eb27214eb',N'6aeeef2c-f4a6-418d-b069-a9b1376ae0e7',N'8c270f32-1d93-404b-8550-e70d95cf4265',N'8ff76973-9ea9-4ae4-b96e-ec7d9f381289',N'64d96a5d-430b-450f-8f03-fe5dddd39966',N'032e6d9c-00c9-47af-8af4-b76172eb72ec',N'7c2b467a-1816-490c-9f4c-12f8d3faff12',N'be352c77-ca46-4b47-8063-ee5eedc03304',N'9b77f6f5-f1de-46fc-881e-40aca96bbce1',N'8be88425-2677-4478-b5f5-e6fe136f614f',N'c705e4ef-39b1-42e4-a685-18aa0f108808',N'2510fc22-5c92-4cc3-b4a4-df6fb53d2495',N'062e9562-66af-4092-bb5f-32f16f23cccc',N'6d886fc4-12df-4268-8882-6bd936e1a7ca',N'4b50ace9-bcc4-4272-be07-161316172528',N'ca8f1f2c-70b8-4657-9b0d-9c7e88678a44',N'bf7384b4-4635-4b7d-8713-3d407791b703',N'518244ae-4a93-4713-97e9-9f33626ad2be',N'f0fb9c1f-63c5-4cef-b756-e2f003546e72',N'bc458bb5-c809-44a1-a39a-09b575e412fb',N'dc961db0-4d52-4037-b63a-989b2dbaf838',N'04a04d00-77b9-4bde-ab5a-537ea660386c',N'005869cf-19ad-469a-9061-520a0e379827',N'8dcf5217-d827-451a-b86b-418ba46d6b78',N'9876eca7-d09b-428b-a1c0-ae6273f063ff',N'48ec1602-7400-4607-816a-c4e964934df5',N'd335478b-7996-49f5-a456-92bda09d38a9',N'b021c215-3362-4bd8-b31c-4899fc46336c',N'855d1ad3-e621-4d78-9e19-a6be928af975',N'f9d8b293-9080-4bfc-987d-c2c90faebaa2',N'faeaca50-ab09-4fbb-9fb6-1249a3e4343d',N'2f250511-74a2-4a5b-bdbe-fe0991517a4c',N'63458d40-9409-4882-be74-752576d8a9e5',N'999da922-05a4-4e2a-9216-688296f24a2d',N'6052ffe6-cd8a-4c26-b4db-56ee66d1356a',N'8c4e5a98-c456-440d-80d0-6311a02a237e',N'5b2db57a-53e5-486a-9a5c-d982a52ceed9',N'774b4e0e-648c-4d33-ac4e-4212963e2369',N'97014573-fa40-48ee-af19-a4b77f753c68',N'830bd798-6f1b-4d0c-8422-97bff95bdf45',N'f631ab59-e4c9-4c97-9879-e761fc232d05',N'83042fce-a5bc-4751-b748-e124ecd22e41',N'4b91121f-0ac7-49ac-b068-0d721d8b5a4c',N'9f8b0c1d-bebc-4adc-b860-e6067ea479e3',N'017a64e7-b762-4df7-9833-8a9a96128fbe',N'093a987a-fa03-4745-be59-67194e3ef1fa',N'd81f96aa-7902-40bd-970c-4b4b1168574c',N'4e453a4a-3841-4884-bbca-8d15f21fa3d5',N'48ef4fe5-12dc-47cc-a8b7-d68978f90b29',N'f1a3636c-f1a3-460e-bf0e-a36821f0b10b',N'f60e7fd5-1257-4de1-a927-fd5b91f4fb46',N'db444cdb-40d4-49b6-868e-1a824507efea',N'9d8d6b41-c048-479c-9162-c75cd92fddd2',N'c5f2e35a-6455-4d92-98fa-f09bb6697dcc',N'65faea88-c695-4925-a3c5-723009e9e131',N'964b6a45-0eef-4810-8c1f-aee4240141ee',N'ffc0bb47-1b96-42b1-9cc6-81e6414a4b11',N'4a6a4235-1373-4d09-a9f8-0423a0d43f53',N'5785bac5-3c77-462b-aa64-84cd83697624',N'55e3b16c-69b7-4de1-9e07-dec2df0145eb',N'1e565064-1868-4838-bb91-d7302019b329',N'4121ad82-b4ab-4471-885f-0a4d9cb69d64',N'3851b0ef-cf97-43a0-a120-d10efe4678f3',N'3e15caac-e383-46ed-b394-7a7ce3924386',N'd2cfc8ee-118f-4074-8cee-ed19f094964e',N'b14f0e11-b537-48a4-8a62-cc56260fde99',N'c1c6561b-2e5b-4f4c-b2cf-a87cc83b48e3',N'79bbd557-aeeb-4111-8a56-da7baad7c425',N'b3d35d2a-d240-4456-b2fa-5923c741179a',N'79a8030f-51a1-43a9-aeb9-f3d1d76408f3',N'd3575aec-8591-4a5e-b0e3-8e02ceaf3c12',N'8efd00c4-ccbf-49a9-b6be-cafd50aa6e4f',N'1fc5d846-cbe2-4e4b-b792-f98cb8ea9a21',N'1063917c-bc4d-4779-b9f3-c01b6bcc5c56',N'dc880684-11a5-45f8-8e5c-ea12adcb7218',N'd88f6441-414d-4642-b4cf-f6d4c16b66ba',N'3a9db42b-d471-4e49-b751-799a33ad2121',N'ba2fed6f-baf0-4ad8-b7bb-aef5c5639d5d',N'df917291-4a01-475c-801d-533dcf2f74ca',N'58fc61bc-6310-4773-b05c-68fc5d28d676',N'3edcd427-def6-47fd-9d0b-c091a2973a7f',N'435de242-62cf-4892-8428-f8f2c1b3d479',N'ce58a18e-0545-40b0-9866-ccf0619f1c9d',N'3a1fdae4-4016-4fc8-9429-e3101aad8c1b',N'a512755a-cd9c-43f5-b3c8-04bb6e849e2f',N'bf85db86-66b8-482f-8766-df7d9123cd0d',N'59a0d7bd-5990-4f1f-88cd-801468a96ecb',N'fd4d100c-bd0b-4a4b-b2b5-043fee4b7ddd',N'2a6877db-e4d6-434a-ab1a-a8191399be31',N'9560fcd3-7fdc-47ce-9de9-d656bf8e87ee',N'5ef606c3-2e08-482a-b22b-ee7e41f0bd62',N'4b65b84f-8145-4337-b0f7-dbf6cc87a61b',N'4417b680-1ea8-4835-b381-4365a8a524a9',N'3db12b48-1012-4b21-8af5-f8466b79f519',N'b3e3db91-6580-44d4-a42c-4e51e861b21f',N'02dfdece-93a9-407e-a7c5-e230ce0c4ded',N'dcff6bcb-ce85-4cfc-9ecf-a96888a01776',N'c6a6342b-84c6-415e-92d3-baa3ab8c489c',N'179c4c7e-89f4-4d51-81a3-108687b03769',N'634dd809-a890-47e8-8ee4-9e8d1e86eec7',N'4aa82c33-c80a-4149-8ebf-0315f506b697',N'e6e7c741-9e3d-49e2-ad9c-c7cd8f11116f',N'e7addd57-77bf-4491-8a46-b83f2ec5f64c',N'4aac0b66-80be-4d4a-bf0c-3affeab5ffbf',N'6c5599e7-522c-46ee-b9c6-820d9bc35d93',N'4987f535-a52c-4781-8edc-78c740dacc54',N'ac3acd37-b1d2-4fb9-b55f-2c340df95ae4',N'e24e5f4a-d5ab-4206-8217-8a53ceb5366d',N'a408e4f2-cf4d-47ab-8f46-dd431db23b34',N'c6fafabf-c503-49cb-aee2-b0f349326fa5',N'17798322-fc28-44d3-b92c-9bd7a8a8ea64',N'adadbea9-d09b-495e-a45d-0a63519505ef',N'b1efc38b-0e05-4372-89c1-45128fd35301',N'1f1d2e4e-99d4-412d-b633-d15dccb56bc0',N'b9697c60-0bf7-42d3-986c-1553a3a1f4a0',N'45c9babd-99ae-467a-91c9-463493dfa4d6',N'4213080c-62cb-4395-b8e6-e2e1d8f65f27',N'1e31300f-3ae4-45eb-b3e8-e915d6929da2',N'a58dabb5-d033-4aec-b23b-c23d4e2210e8',N'd33f5cb1-2d52-4a72-85ee-b7d53def950b',N'4d08c529-c343-44b5-9c9e-859096e163aa',N'6fc8a00b-f111-4229-ab80-bde6bccb471a',N'2dafb5c5-872b-4ca1-8e05-bc6fe2252b70',N'd26eb812-4e4d-45a5-986b-2d1348389863',N'dfaeb50d-8105-4276-ba1c-b668c66e909c',N'e05ba708-274e-41ba-a04a-22f76e62d9cf',N'3936b044-e569-4184-bc44-5455327ebb2c',N'a1ce7aa7-8a22-4211-8437-972670bb9e04',N'5931da80-5f61-4dd6-9233-b78ad3c437d9',N'0b786579-7802-4ba0-85a6-91f699de32bc',N'e1c2e40b-84f6-4d96-b28a-70dd817e71c8',N'2d7e02f9-0a71-4c55-90cd-b7f7c307cf72',N'44bdd255-1ad6-4983-8f68-6d2299de2055',N'a0190d8f-34f8-40ff-8945-a84beb324bf3',N'8e835c1c-02a4-49f2-b955-b07033f4c320',N'bce54c5c-f52b-4f52-96be-461a41d03d1a',N'1c699dbd-453a-452b-b055-9e720ebadfd4',N'b41df70b-0f5b-4f93-8511-274792df3501',N'8b0cdd3b-6ce9-443e-88cc-d9a2a881294b',N'e1ffcf1c-8053-4eae-aa97-7b6ab9641b19',N'4b0e15ab-4cb0-42fe-a5ee-ecc473ac21c4',N'b416c201-41f1-4c86-8a93-764b1ac1db59',N'ccc416f9-e9e9-4257-8734-e506b1c200bd',N'MyProject'