PSI - Add Task with AddPositionType.Middle

[tlenz]

Hi,

I'm new to this forum. Ok, in this moment I think everybody is new to this place .

I got a problem with adding tasks to an existing project using PSI. I use the
AddPositionType.Middle and set the "AddAfterTaskUID" to a correct value.
All works fine, if adding only a few task, but, if I try to add more tasks, say about 40, I get the queue error "TaskUnableToInsert".

if tried lots of things, like:

QueueAddToProject in small blocks (after 1,2,5,10,900 tasks added to the update dataset)

QueueAddToProject, then wait for jobdone state.
and other debugging thinks, but none of them works ...

Here is some code:

PHP Code:

 public ProjectDataSet.TaskRow AddNewTask(
            string taskName,
            Guid addAfterTaskUid,
            int taskOutlineLevel,
            int taskDuration,
            Task.DurationFormat taskDurationFMT)
        {
            // - increase and watch change count;
            IncreaseChangeCount();

            ProjectDataSet.TaskRow newTask = ChangesDataSet.Task.NewTaskRow();
            newTask.PROJ_UID = this.ProjUid;
            newTask.TASK_UID = Guid.NewGuid();
            newTask.TASK_NAME = taskName;
            newTask.TASK_DUR = taskDuration;
            newTask.TASK_DUR_FMT = (int)taskDurationFMT;//(int)Task.DurationFormat.Day;
            newTask.TASK_OUTLINE_LEVEL = taskOutlineLevel;
            newTask.TASK_IS_SUMMARY = (taskDuration == 0);

            // - if no addAfterTask, attach task at last position
            if (addAfterTaskUid == Guid.Empty)
            {
                newTask.AddPosition = (short)Task.AddPositionType.Last;
            }
            else
            {
                //newTask.AddPosition = (short)Task.AddPositionType.Last;
                newTask.AddPosition = (short)Task.AddPositionType.Middle;
                newTask.AddAfterTaskUID = addAfterTaskUid;
            }
            ShowMessage((string.Format("Task \"{0}\" added", taskName)));
            ChangesDataSet.Task.AddTaskRow(newTask);

            return newTask;
        } 


PHP Code:

public void PsiUpdateProject()
        {
            try
            {
                Guid sessionUid = PsiGetSessionUid();
                Guid jobUid = Guid.NewGuid();
                //ServiceFactory.ProjectSvc.QueueUpdateProject(jobUid, session, this.ChangesDataSet, false);
                ProjectDataSet changesAdded
                    = this.ChangesDataSet.GetChanges(DataRowState.Added) as ProjectDataSet;
                if (changesAdded != null)
                {
                     ServiceFactory.ProjectSvc.QueueAddToProject(
                        jobUid,
                        sessionUid,
                        changesAdded,
                        false);
                     ShowMessage(string.Format("project \"{0}\" updated add", this.ProjUid));
                     this.PsiWaitForQueue(this.ServiceFactory.QueueSystemSvc, jobUid);
                }
                changesAdded = null;
                ProjectDataSet changesModified
                    = this.ChangesDataSet.GetChanges(DataRowState.Modified) as ProjectDataSet;
                if (changesModified != null)
                {                
                    ServiceFactory.ProjectSvc.QueueUpdateProject(
                        jobUid,
                        sessionUid,
                        changesModified,
                        false);

                    ShowMessage(string.Format("project \"{0}\" updated mod", this.ProjUid));
                }
                changesModified = null;
                ProjectDataSet changesDeleted
                    = this.ChangesDataSet.GetChanges(DataRowState.Deleted) as ProjectDataSet;
                if (changesDeleted != null)
                {
                    ServiceFactory.ProjectSvc.QueueUpdateProject(
                        jobUid,
                        sessionUid,
                        changesDeleted,
                        false);
                    ShowMessage(string.Format("project \"{0}\" updated del", this.ProjUid));
                }
                changesDeleted = null;
                this.ChangesDataSet.AcceptChanges();
                this.ChangeCount = 0;

                //System.Threading.Thread.Sleep(TimeSpan.FromSeconds(4));
                //this.ChangesDataSet.Task.Clear();
            }
            catch (Exception ex)
            {
                ShowMessage("QueueAddToProject failed on project." + ex.Message);
            }
        } 


Does anybody have some problems or some answers?

[ssanderlin]

Welcome to the Forum!

Can you provide the full detail from the Queue error?

[tlenz]

Yes, for sure. Here it is.

I add tasks in blocks of ten with calling "queueAddToProject", then wait for job complete state from the queue system, then I read the project dataset again. After 3 to 4 updates I get this error:

PHP Code:

System.ApplicationException was caught
  Message="Queue request failed \"Failed\" Job ID: 5b7c0d70-60b5-4b9a-895d-bc8253610846.
<?xml version="1.0\" encoding=\"utf-16\"?>
    <errinfo>
        <general>
            <class name=\"Project\">
                <error id=\"7025\" name=\"TaskUnableToInsert\" uid=\"598f8f96-19b6-4cf1-80c6-73ed5137e11e\" />
            </class>
            <class name=\"Queue\">
                <error id=\"26000\" name=\"GeneralQueueJobFailed\" uid=\"7bf06bc4-f28c-49ae-9c8b-9448d47f54bd\" JobUID=\"5b7c0d70-60b5-4b9a-895d-bc8253610846\" ComputerName=\"S01RKM02\" GroupType=\"ProjectUpdate\" MessageType=\"\" MessageId=\"\" Stage=\"\" />
            </class>
        </general>
    </errinfo>

[ssanderlin]

Originally Posted by tlenz

Yes, for sure. Here it is.

I add tasks in blocks of ten with calling "queueAddToProject", then wait for job complete state from the queue system, then I read the project dataset again. After 3 to 4 updates I get this error:

PHP Code:

System.ApplicationException was caught
  Message="Queue request failed \"Failed\" Job ID: 5b7c0d70-60b5-4b9a-895d-bc8253610846.
<?xml version="1.0\" encoding=\"utf-16\"?>
    <errinfo>
        <general>
            <class name=\"Project\">
                <error id=\"7025\" name=\"TaskUnableToInsert\" uid=\"598f8f96-19b6-4cf1-80c6-73ed5137e11e\" />
            </class>
            <class name=\"Queue\">
                <error id=\"26000\" name=\"GeneralQueueJobFailed\" uid=\"7bf06bc4-f28c-49ae-9c8b-9448d47f54bd\" JobUID=\"5b7c0d70-60b5-4b9a-895d-bc8253610846\" ComputerName=\"S01RKM02\" GroupType=\"ProjectUpdate\" MessageType=\"\" MessageId=\"\" Stage=\"\" />
            </class>
        </general>
    </errinfo>

Interesting.... Less helpful than I had hoped, though.

What version of Project Server 2007 are you working with?

[tlenz]

I solved it!

Install the post service pack 1 hotfix (kb941426) and all goes well ...

thanks to Heiner Eichmann.

[ssanderlin]

Originally Posted by tlenz

I solved it!

Install the post service pack 1 hotfix (kb941426) and all goes well ...

thanks to Heiner Eichmann.

Great -- good to know this is resolved by the rollup.

Thanks for letting us know!