Solved

Query XML execution is extremly slow

  • 7 December 2017
  • 5 replies
  • 12 views
TomaszPoszytek
Userlevel 7
Badge +17

Hi!

 

I'm facing issues with the "Query XML" action. It is executing extremly slow. It needs minutes to complete even though the XML is rather small:

<Item>
      <MiejsceKontroliStatus type="System.String">USZKODZONY</MiejsceKontroliStatus>
      <MiejsceKontroliElementOk type="System.Boolean">False</MiejsceKontroliElementOk>
      <MiejsceKontroliZdjecie type="System.String">&amp;lt;a href=&amp;quot;https://image_URL&amp;quot; target=&amp;quot;_blank&amp;quot;&amp;gt;&amp;lt;img width=&amp;quot;400&amp;quot; src=&amp;quot;https://image_URL&amp;quot; /&amp;gt;&amp;lt;/a&amp;gt;</MiejsceKontroliZdjecie>
      <MiejsceOpis type="System.String">Some description</MiejsceOpis>
      <MiejsceKontroliOpis type="System.String">Some description</MiejsceKontroliOpis>
      <MiejsceStatus type="System.String">USZKODZONY</MiejsceStatus>
      <MiejsceZdjecie type="System.String">&amp;lt;a href=&amp;quot;https://image_URL&amp;quot; target=&amp;quot;_blank&amp;quot;&amp;gt;&amp;lt;img width=&amp;quot;400&amp;quot; src=&amp;quot;https://image_URLg&amp;quot; /&amp;gt;&amp;lt;/a&amp;gt;</MiejsceZdjecie>
      <RejonMiejsca type="System.String">Some string</RejonMiejsca>
      <IDMiejsca type="System.String">Some ID</IDMiejsca>
      <MiejsceKontroliReakcja type="System.Boolean">True</MiejsceKontroliReakcja>
      <CzestotliwoscMiejsca type="System.String">Tydzień</CzestotliwoscMiejsca>
      <MiejsceKontroliUsterka type="System.String">Some description</MiejsceKontroliUsterka>
</Item>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The xpath queries I'm using are not complex either, ex.: "//IDMiejsca".

I have to admit, I never faced such issue before. Execution of five actions takes around 30 minutes (!!!)

 

Any suggestions?

 

Regards,

Tomasz

icon

Best answer by TomaszPoszytek 11 December 2017, 17:09

View original
Regards, Tomasz Poszytek

5 replies

C
Badge +9

Hi Tomasz,

Can you message me a workflow history URL for an instance where this is happening? We can take a look to see where the latency is coming from.

Thanks,


Callum

TomaszPoszytek
Userlevel 7
Badge +17

So it seems it was just a temporary issue with the Nintex infrastructure. Problem solved.

Regards, Tomasz Poszytek
C
Badge +9

Reference to public notice if this affected others

http://status.nintex.com/pages/incident/566925105401bb333d000014/5a2a51ee7fb8b23daa595b57

G
Badge +8

Is there maybe another update on this? I am developing a workflow that contains some loops, query and update xml actions and an approval, it takes extremely long. 

I logged "start task process" to history list before I assign a task (in parallel) - 2 minutes later my task gets assigned.

Sometimes is takes 4 minutes to get out of a loop containing a very simple Update XML action, similar to Thomasz's.

My flow is taking almost 20-30 minutes for doing the following:

- Query XML to get repeating section contents

- Looping through the results to put them in in a variable (only 2 lines in my repeating section containing both only 2 nodes)

- Assigning a parallel task to 2 users

- Querying the tasks to retrieve the comments (only the two relevant task ID's)

- Update the XML of my repeating section in a loop

Thank you. 

C
Badge +9

Hi Glenda,

Not aware of any issues with the Query XML performance right now - would it be possible for you to PM me a workflow history URL to an instance, I can check our records and see if I can see where the time is being taken.

Thanks,

Callum

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings