Reading Sub projects from MS Project Server

Rajeshrv · September 21, 2018, 10:34am

Am trying to read a project from Microsoft Project Server 2016, which has a sub project.

Loading the project as mentioned in
https://docs.aspose.com/display/tasksnet/Creating%2C+Reading+and+Saving+Projects#Creating,ReadingandSavingProjects-ImportingProjectDataFromMicrosoftProjectDatabase

While reading the sub project task, Tsk.IsSubproject is coming as false and also has zero children.
Can you please confirm whether reading Projects with Subprojects from MS Project server is supported.

To reproduce the issue, please create two projects in the Server and make one as SubProject of other and try to read the project details from server.

Thank you,
RajeshKumar R.V.

MuzammilKhan · September 21, 2018, 2:49pm

@Rajeshrv

While reading the sub project task, Tsk.IsSubproject shall be false for the tasks of sub-project but for the task where the sub-project is inserted it shall be true.
For more clarification, please run this code sample for your project:

Project prj = new Project(settings);

// Create a ChildTasksCollector instance
ChildTasksCollector collector = new ChildTasksCollector();

// Collect all the tasks from RootTask using TaskUtils
TaskUtils.Apply(prj.RootTask, collector, 0);

// Parse through all the collected tasks
foreach (Task tsk in collector.Tasks)
{
    Console.WriteLine("Task Id: {0}", tsk.Get(Tsk.Id));
    Console.WriteLine("Task Uid: {0}", tsk.Get(Tsk.Uid));
    Console.WriteLine("Task Name: {0}", tsk.Get(Tsk.Name));
    Console.WriteLine("Is Subproject: {0}", tsk.Get(Tsk.IsSubproject));
    Console.WriteLine("Task Start: {0}", tsk.Get(Tsk.Start));
    Console.WriteLine("Task Finish: {0}", tsk.Get(Tsk.Finish));
}

Rajeshrv · September 23, 2018, 7:24am

Thanks for your reply.

The above solution is working if I try to read MPP project using MPP file, but if I try to read the project from Project Server 2016 I was able to read the subproject as Task, but that tasks fetches zero children. More over the flag IsSubProject on that task reads as false. This behavior is not specific to a project file from Project Server, if I try to read any project with type 6 (MasterProject) am having similar behavior.

MuzammilKhan · September 23, 2018, 6:07pm

@Rajeshrv

Thank you for your feedback.
We have logged this issue with ID “TASKSNET-2732” for further investigation. You will automatically be informed here once we have more information to share.

Rajeshrv · November 21, 2018, 5:48am

Team, can you please confirm on TASKNET-2732, so that we could plan our features for next release accordingly.

Thank you.

MuzammilKhan · November 21, 2018, 9:28am

@Rajeshrv

Thank you for writing back to us.
We are working on this issue and it shall be a part of Aspose.Task for .NET 19.1 which shall be available in Jan 19.

aspose.notifier · December 13, 2018, 6:52am

The issues you have found earlier (filed as TASKSNET-2732) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan

Rajeshrv · December 13, 2018, 12:48pm

Hi Team,
I was just trying to using this version 18.12 and when i try to read project using below code :

SqlConnectionStringBuilder sqlConnectionString = new SqlConnectionStringBuilder
{
DataSource = oSelDataCon.DbDataSource,
Encrypt = true,
TrustServerCertificate = true,
InitialCatalog = oSelDataCon.DbInitialCatalog,
NetworkLibrary = “DBMSSOCN”,
UserID = oSelDataCon.DbUsername,
Password = oSelDataCon.DbPassword
};
MspDbSettings oMsPDbSet = new MspDbSettings(sqlConnectionString.ConnectionString, new Guid(sCurrentMppProjId))
{
Schema = oSelDataCon.DbSchema
};
return new Project(oMsPDbSet);//Throws error here.

Throwing this error “Unable to cast object of type ‘System.Guid’ to type ‘System.String’.”
But if I switch back to 18.6 version things are fine.

MuzammilKhan · December 13, 2018, 8:12pm

@Rajeshrv

Thank you for writing back to us.
We have logged this issue with ID “TASKSNET-2898” for further investigation. You will automatically be informed here once we have more information to share.

Rajeshrv · January 8, 2019, 1:38pm

@MuzammilKhan
Can you confirm when I can get this fix, we need to plan for our release accordingly.

Thank you.

MuzammilKhan · January 8, 2019, 4:38pm

@Rajeshrv

Thank you for writing back to us.

This issue has been resolved and will be a part of our next API release i.e. Aspose.Tasks for .NET 19.1.

Rajeshrv · January 9, 2019, 11:46am

@MuzammilKhan
Thanks for the update, please do confirm when could we expect the same.
Also do let me know if I could try any pre-release version of this some how.

MuzammilKhan · January 9, 2019, 3:28pm

@Rajeshrv

Thank you for writing back to us. Aspose.Tasks for .NET 19.1 shall probably be available at the end of next week.

aspose.notifier · January 11, 2019, 5:00pm

The issues you have found earlier (filed as TASKSNET-2898) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan

Rajeshrv · February 14, 2019, 10:11am

Team,
Currently am checking the subjected behavior with 19.1/19.2 dll, and am seeing two different problems

Code :
SqlConnectionStringBuilder sqlConnectionString = new SqlConnectionStringBuilder
{
DataSource = oSelDataCon.DbDataSource,
Encrypt = true,
TrustServerCertificate = true,
InitialCatalog = oSelDataCon.DbInitialCatalog,
NetworkLibrary = “DBMSSOCN”,
UserID = oSelDataCon.DbUsername,
Password = oSelDataCon.DbPassword
};
MspDbSettings oMsPDbSet = new MspDbSettings(sqlConnectionString.ConnectionString, new Guid(sCurrentMppProjId))
{
Schema = oSelDataCon.DbSchema
};
return new Project(oMsPDbSet);//Throws error here.

Throwing this error “System.ArgumentException: ‘An item with the same key has already been added.’"
.Resources.GetByUid(iRscUid).Assignments ==> gives no assignment details its just empty.

Could you please check these issues.

MuzammilKhan · February 14, 2019, 7:21pm

@Rajeshrv

Thank you for your feedback.

We have logged this issue with ID “TASKSNET-3024” for further investigation. You will automatically be informed here once we have more information to share.

MuzammilKhan · February 18, 2019, 8:19pm

@Rajeshrv

We have investigated the issue and the exception is thrown and caught in Aspose.Tasks internal code, and you can examine such exceptions with “Break when thrown” (or similar) option enabled in IDE.

If the exception was not-handled, then you wouldn’t be able to examine “.Resources.GetByUid(iRscUid).Assignments” property.

Could you please confirm that the exception is “handled” and test application is not crashing? Secondly, can you please share stack trace/ log with us?

Rajeshrv · February 19, 2019, 5:16am

@MuzammilKhan
Stack trace shows this message " at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)"

AsposeTask_AssignmentErrorTrace.JPG (137.4 KB)

And this message is coming up for any project read from Project Server.

Thank you.

MuzammilKhan · February 20, 2019, 11:32am

@Rajeshrv

Thank you for your feedback.

We have recorded the details and will consider it during the issue resolution. You will be update here once we have more information to share.

MuzammilKhan · February 20, 2019, 7:52pm

@Rajeshrv

It is requested to kindly confirm if “Call Stack” window in IDE has the similar content as shown in this image HandledException.png (73.6 KB) (the right bottom window) and if it the content is different then kindly share Call Stack with us.