Stored Procedure Looping

This issue has been solved. See solution.
Aryanos's picture
Aryanos
May 20th, 2009

I wasn't able to find any information regarding an issue that I am having. I created a stored procedure integrator which received information for projects (e.g., project name, project number, description, address, contact name, contact email) and in a DropDownListComponent set it up so the items are displayed dynamically and it displays the project number field.

When the workflow starts, it is working properly as it calls the stored procedure once to populate the drop down. However, once an item is selected and they go to the next form, there is a delay of about 5-10 seconds before it goes to the next form. Tracing the process in the Debugger it appears it is looping through the component multiple times before going to the next form.

I've spoke with the DBA and he said the stored procedure is correct. Are there any settings that I can check to see why this is happening?

Filed under: ,
0 votes
sturnbow's picture
sturnbow
27 weeks 12 hours ago

Here's a nice way to show us

Here's a nice way to show us the problem so we can help you debug it...

  • Setup a free account on www.screencast.com
  • Download Jing... free video capture tool (includes audio)... captures are limited to 5 minutes.
  • Record your process... show design time settings and runtime simulator.
  • Upload to screencast via Jing (VERY EASY)
  • Put the link in your post

This is much easier than trying to go back and forth via text :-)

0 votes
Aryanos's picture
Aryanos
26 weeks 6 days ago

Looping Video

Hi Sturnbow,

I created a video regarding the issue I am having. As you can see, the stored procedure is being called more than once to return the info stated in my initial post. Once I click the next button, it does a few more calls before going to the next form. Sorry, I didn't have a mic handy to record audio.

0 votes
sturnbow's picture
sturnbow
26 weeks 6 days ago

For some reason the video is

For some reason the video is only displaying about a quarter of the screen.  When you did the Jing recording... did you pick the entire screen?  You have to move the crosshair so that the entire screen gets recorded.  Any sections that are grayed out will not get included in the recording.

0 votes
sturnbow's picture
sturnbow
26 weeks 6 days ago

PM me your contact info and

PM me your contact info and we can setup a Gotomeeting session if that's easier for you :-)

0 votes
Aryanos's picture
Aryanos
26 weeks 4 days ago

Resolved My Issue

Solution

I was able to resolve it by putting the integrator components outside the form instead of putting it in the drop-down control. I guess this was just my noob mistake.

0 votes
SOLUTION