SharePoint User Group UK

Ok, I think I understand what you're trying to do. I've had a little play in the designer and think your workflow must look something like this?

If it does, then I'm not sure why it wouldn't work, However it's not something I've tried in anger, so I'm not sure whether the workflow will handle task creation within the while loop very well.

I'd step through the code and check the status of the tasks when you're marking the supervisor task as unapproved, and check on the deletion and recreation of the task.

http://www.myfatblog.co.uk/images/workflowtop.jpg

http://www.myfatblog.co.uk/images/workflowbottom.jpg

---

www.myfatblog.co.uk
MCTS: WSS 3.0
MCTS: MOSS 2007

Paul, the workflow is like the one you draw.

The problem is inside the activity "CreateTaskUser", in that activity the listitemid is -1, i didn't understand what you want me to check..

What i should check on the deletion and recreation of the task?

In the createtaskuser i am putting the code i posted before.

Thanks for your help paul

 

Hmm, that method should certainly return an item id integer if the task has been created. the problem is SharePoint doesn't always create the objects when you expect it to, it prepares everything, and then waits for the workflow to hit a point where it would serialize to the database.

I would be tempted to try placing an OnTaskCreated after the createTask item, and move your code into the methodInvoking for the onCreated. This will force the workflow to wait for the task to be created before trying to do anything with it.

Paul.

---

www.myfatblog.co.uk
MCTS: WSS 3.0
MCTS: MOSS 2007

Paul i did what you say, i though that what you said was the problem, but the listitemid is still -1 after the onTaskCreated!

I test it whith cag instead a while and i had the same problem!

Hmm, I'm pretty stumped then I have to say.. If you're coming to the userGroup meeting tonight, bring a printout of the SP designer view and your code and we'll take a look if you like.. I'll keep an eye out for a frustrated looking developer with a pile of paper under his arm.. 8-)

---

www.myfatblog.co.uk
MCTS: WSS 3.0
MCTS: MOSS 2007

Paul i don't live in UK, in fact i am far for UK, so i am not going to the meeting tonight.

If you want i  can send you a simple test with a simple workflow, so you can see the problem.

Thanks

 

No probs, I'll send you my personal e-mail address and you can send me the zipped up VS project.

---

www.myfatblog.co.uk
MCTS: WSS 3.0
MCTS: MOSS 2007

We are also facing the same problem, is it resolved for you, if so please let me know the solution..

Thanks in advance.

What problem are you facing? This thread slipped a little off topic. Post a new message stating what issues you're having and one of us will try and help I'm sure.

Paul.

---

www.myfatblog.co.uk
MCTS: WSS 3.0
MCTS: MOSS 2007

When I get listItemId it return -1 because I use CreateTask Activity in loop activity but I can use below method for get next ID of task in CreateTask method

 

taskId = GetNextAvailableIdFromList(workflowProperties.Site, workflowProperties.TaskListId);

 

public static int GetNextAvailableIdFromList(SPSite site, Guid listId)
        {
            int NextAvailableId = -1;
            if (site.WebApplication.ContentDatabases.Count > 0)
            {
                string DBConnString = site.WebApplication.ContentDatabases[0].DatabaseConnectionString;
                SqlConnection con = new SqlConnection(DBConnString);
                try
                {
                    con.Open();
                    SqlCommand com = con.CreateCommand();
                    com.CommandText = String.Format("select tp_NextAvailableId from AllLists where tp_ID = '{0}'", listId.ToString());

                    NextAvailableId = (int)com.ExecuteScalar();
                }
                finally
                {
                    con.Close();
                }
            }
            return NextAvailableId;
        }

Bind the ListItemId to a field or property to avoid the -1 problem.