Solved

How to fix a BI reporting issue in SPD 2010 Workflow with Wait for field change?

Posted on 2011-10-01
1
273 Views
Last Modified: 2012-06-27
In a SharePoint Designer workflow designed, there is a connection and back end sql stored procedure call for a report after Wait for field change activity. The report completely fails if it is called after this Pause activity. Another similar workflow designed by someone else works perfectly fine in the same environment. What could be the reason?
In my requirement the report is supposed to be fired if an assignee of a task changes an InfoPath form field status, so it has to be generated after the field has changed and hence the back end call is to be made after the pause. But after hitting the pause the report fails. How to fix this issue?
The report is ultimately used along with Performance Point server.
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
rajivkapoorONidealsdotcodotin earned 0 total points
ID: 36992330
Keep the status of the task change in a variable and compare its value for a change in side a while loop and then call connection for BI
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question