Which table/column in reporting database?

[anovak]

I have a situation where someone assigned an enterprise resource to a
summary task in Project Server which we all know can cause corruption
in the database. I've been able to find a column in the reporting
database that tells me what date/time the assignment was made. Is
there a way to find out who created the assignment (and shouldn't
have)? Which table/view/column in which database?

Thanks!
Andy

 

[Brian Kennemer]

You would likely need to go back through logs to find out who had the
project checked out. I doubt that the RDB is going to have this info.

 

[HansH]

Does creating summary tasks cause corruption in the database? It's a bad
practice, yes, but corruption in the database?

The information you are looking for is not available in the reporting
database.
The easiest way to avoid assignments on summary tasks is by creating a
small VBA macro that cancels assignment creation when the task is a
summary task. The macro is not too difficult to create.

I hope this helps,
Hans

Projectopolis <http://msepm.hsquared.be>

 

[andy.novak]

Does creating summary tasks cause corruption in the database? It's a bad
practice, yes, but corruption in the database?

The information you are looking for is not available in the reporting
database.
The easiest way to avoid assignments on summary tasks is by creating a
small VBA macro that cancels assignment creation when the task is a
summary task. The macro is not too difficult to create.

I hope this helps,
Hans

Projectopolis <http://msepm.hsquared.be>

Yes, we had a situation in the past where there was only one project
out there with an assignment at the summary task level. It was
causing a significant and strange error message when folks were
attempting to view assignments via the Resource Center. Microsoft
Premier Support identified the issue, we removed it, and the error
went away. It is a proven fact, yes, that summary task assignments
cause corruption. Microsoft has stated it in the past before we had
this little episode.
Could you provide any tips on how to create that VBA macro and how one
would go about deploying it?
Thanks,
Andy