Stored Procedure Looping
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?
Comments
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...
This is much easier than trying to go back and forth via text :-)
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.
I like my beats fast and my bass down low
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.
PM me your contact info and
PM me your contact info and we can setup a Gotomeeting session if that's easier for you :-)
Resolved My Issue
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.
I like my beats fast and my bass down low
Would you like to reply?
Login or Register to post your comment.