This podcast is a talkthrough of the process of building a cube. I forgot to mention firewalls which can also block access to SQL/Analysis Services - so see the TechNet artilces for details. For other blog postings on this topic go to http://blogs.msdn.com/brismith/archive/tags/Analysis+Services/default.aspx.
I have the next method for creating tasks into a existing project:
public void CreateTask(string ProjectID, string TaskName
, string start, string duration)
Guid projectGuid = new Guid(ProjectID);
Guid sessionGuid = Guid.NewGuid();
const string SESSION_DESC = "description";
project.CheckOutProject(projectGuid, sessionGuid, SESSION_DESC);
dsProject = new
w2003wss1.ProjectDataSet(); w2003wss1.ProjectDataSet.TaskRow taskRow =
Guid taskGuid = Guid.NewGuid();
taskRow.PROJ_UID = projectGuid;
taskRow.TASK_UID = taskGuid;
taskRow.TASK_NAME = TaskName;
taskRow.TASK_START_DATE = DateTime.Parse(start);
taskRow.TASK_DUR = Convert.ToInt32(duration);
taskRow.TASK_DUR_FMT = (int)PSLibrary.Task.DurationFormat.EstHour;
Guid jobGuid = Guid.NewGuid();
bool validateOnly = false;
project.QueueAddToProject(jobGuid, sessionGuid, dsProject,
jobGuid = Guid.NewGuid();
project.QueueCheckInProject(jobGuid, projectGuid, false, sessionGuid,
catch (Exception e)
When QueueAddToProject() method is executed, an exception appears:
LastError=GeneralOnlyInsertsAllowed Instructions: Pass this into
PSClientError constructor to access all error information
jobUid, Guid sessionUid, ProjectDataSet dataset, Boolean validateOnly)
What happen? How can I solve this problem?
is it possible to modify from a Project Wrokspace the type of the default fields Probability and Impact from "Number" to "Choice"?
I haven't tested, but I would imagine it would break things relating to the sync of the issue/risk information to the reporting database. By all means test in a non-production environment and see what happens.
Also it would be helpful to other readers to only post against relevant blog postings. I reserve the option to remove non-relevant comment postings.
or your other problem I suspect the dataset also contains non-new records that it cannot insert.
thanks for your answer. I have tried to modify the type of this fields in a non-production environment, but the type appears to be "locked", but you do it dor all other fields.
¿What do you mean with "to only post against relevant blog postings"?
I mean that you have posted a PSI coding issue about adding a task, and a WSS workspace issue as a comment on an OLAP cube building blog post. There are posts on use of PSI that would be more appropriate, and may even help answer your question if you looked for them - or post to a newsgroup.
the post of peris is not mine. I am cperis, but not peris.
Sorry cperis. A case of mistaken identity.
it doesn't matter, the names are nearly the same.
Another question: Is it possible to allow a resource to give values to the Task Custom Fields when he creates a new Task in PWA or only the Project Manager can do it? That would be not very functional...