Crash when I try to Assign a resource... EPM 2007

L

Luis Mata

Hi

In this moment I Have a Problem with project professional, when I create a
New Project Connected to Project Server 2007...

I can put the task, duration, task link in the view Gantt Chart, and put the
resource from PS2007 in the view Resource Sheet. But when I try to assign the
resource to a task in the view Gantt Chart, in this moment MS Project
Professional is Stopping Worked and restart again... This problem not happend
when I work with PS Isolate...

Can you Help Me..

Thank's

Luis Mata
 
L

Luis Mata

I discover that the problem is when I create a Custom Field type Numberth
have this formula


IIf(([Total de Horas de Trabajo (Number1)]=0),(0),(((50*(Sin((([Time in
Hours Passed]/[Total_Work_Hours
(Number1)])*3,141592653589)-(3,141592653589/2))+1))*[Total_Work_Hours(Number1)])/100))

I Test this Formula only in Project Professional, and this work very well,
the problem in when I put this in the Enterprise Custom Field

Please Help Me
 
M

Marc Schoeni

Luis,

One of our MOPS2007 customers experienced similar issues when trying to save
or publish a project. We opened a support call with Microsoft PSS and they
found out that the saving error was related to formulas in stored in custom
fields; so obviously there's an issue with saving and retrieving the formula
in the database. If you remove all formulas from the project I'm positive
you will be able to assign resources without any problems.

Let us know...

--
Marc
MCP for EPM
www.diventis.ch
www.msepm.blogspot.com

Luis Mata said:
I discover that the problem is when I create a Custom Field type Numberth
have this formula


IIf(([Total de Horas de Trabajo (Number1)]=0),(0),(((50*(Sin((([Time in
Hours Passed]/[Total_Work_Hours
(Number1)])*3,141592653589)-(3,141592653589/2))+1))*[Total_Work_Hours(Number1)])/100))

I Test this Formula only in Project Professional, and this work very well,
the problem in when I put this in the Enterprise Custom Field

Please Help Me

Luis Mata said:
Hi

In this moment I Have a Problem with project professional, when I create
a
New Project Connected to Project Server 2007...

I can put the task, duration, task link in the view Gantt Chart, and put
the
resource from PS2007 in the view Resource Sheet. But when I try to assign
the
resource to a task in the view Gantt Chart, in this moment MS Project
Professional is Stopping Worked and restart again... This problem not
happend
when I work with PS Isolate...

Can you Help Me..

Thank's

Luis Mata
 
L

Luis Mata

Hi Marc

I understand your position, and I discover that indeed I delete the custom
Field with the Formulas and I can assign resources but the problem is that I
need this formula to calculate the variance from Work Estimate to Status Date
and the Actual Work Work, and I need this for all the Enterprise projects...

How can I resolve this and maintenance this Field with formulas in My
Customize Fields???

Please Help me...

LM

Marc Schoeni said:
Luis,

One of our MOPS2007 customers experienced similar issues when trying to save
or publish a project. We opened a support call with Microsoft PSS and they
found out that the saving error was related to formulas in stored in custom
fields; so obviously there's an issue with saving and retrieving the formula
in the database. If you remove all formulas from the project I'm positive
you will be able to assign resources without any problems.

Let us know...

--
Marc
MCP for EPM
www.diventis.ch
www.msepm.blogspot.com

Luis Mata said:
I discover that the problem is when I create a Custom Field type Numberth
have this formula


IIf(([Total de Horas de Trabajo (Number1)]=0),(0),(((50*(Sin((([Time in
Hours Passed]/[Total_Work_Hours
(Number1)])*3,141592653589)-(3,141592653589/2))+1))*[Total_Work_Hours(Number1)])/100))

I Test this Formula only in Project Professional, and this work very well,
the problem in when I put this in the Enterprise Custom Field

Please Help Me

Luis Mata said:
Hi

In this moment I Have a Problem with project professional, when I create
a
New Project Connected to Project Server 2007...

I can put the task, duration, task link in the view Gantt Chart, and put
the
resource from PS2007 in the view Resource Sheet. But when I try to assign
the
resource to a task in the view Gantt Chart, in this moment MS Project
Professional is Stopping Worked and restart again... This problem not
happend
when I work with PS Isolate...

Can you Help Me..

Thank's

Luis Mata
 
G

Gary L. Chefetz [MVP]

Luis:

I believe that the problem you're experiencing is directly related to the
formula itself. You may not reference a standard custom field (A custom
field that you define in project) when creating a formula for and Enterprise
Custom Field. The bug, if any, is that the system isn't catching this for
you.

--


Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project


Luis Mata said:
Hi Marc

I understand your position, and I discover that indeed I delete the custom
Field with the Formulas and I can assign resources but the problem is that
I
need this formula to calculate the variance from Work Estimate to Status
Date
and the Actual Work Work, and I need this for all the Enterprise
projects...

How can I resolve this and maintenance this Field with formulas in My
Customize Fields???

Please Help me...

LM

Marc Schoeni said:
Luis,

One of our MOPS2007 customers experienced similar issues when trying to
save
or publish a project. We opened a support call with Microsoft PSS and
they
found out that the saving error was related to formulas in stored in
custom
fields; so obviously there's an issue with saving and retrieving the
formula
in the database. If you remove all formulas from the project I'm positive
you will be able to assign resources without any problems.

Let us know...

--
Marc
MCP for EPM
www.diventis.ch
www.msepm.blogspot.com

Luis Mata said:
I discover that the problem is when I create a Custom Field type
Numberth
have this formula


IIf(([Total de Horas de Trabajo (Number1)]=0),(0),(((50*(Sin((([Time in
Hours Passed]/[Total_Work_Hours
(Number1)])*3,141592653589)-(3,141592653589/2))+1))*[Total_Work_Hours(Number1)])/100))

I Test this Formula only in Project Professional, and this work very
well,
the problem in when I put this in the Enterprise Custom Field

Please Help Me

:

Hi

In this moment I Have a Problem with project professional, when I
create
a
New Project Connected to Project Server 2007...

I can put the task, duration, task link in the view Gantt Chart, and
put
the
resource from PS2007 in the view Resource Sheet. But when I try to
assign
the
resource to a task in the view Gantt Chart, in this moment MS Project
Professional is Stopping Worked and restart again... This problem not
happend
when I work with PS Isolate...

Can you Help Me..

Thank's

Luis Mata
 
L

Luis Mata

Hi Team

I discover that the problem is when I calculate in the formula the value of
PI()=3,141592653589

The Decimal Point (,) or (.) is not recognize for PS, but when I use this
Field Local in Project Professional this work Right, I change de value for PI
and try with only the value 3 wihout decimal point and the formula in the
Enterprise Field work very well...

Another test that I try is create one Field call PI and in the formula =
3,141592653589, and when I Insert this enterprise field in Project
Professional I watch that the value is 0...

Can you Help me.

Regards

Luis Mata
Gary L. Chefetz said:
Luis:

I believe that the problem you're experiencing is directly related to the
formula itself. You may not reference a standard custom field (A custom
field that you define in project) when creating a formula for and Enterprise
Custom Field. The bug, if any, is that the system isn't catching this for
you.

--


Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project


Luis Mata said:
Hi Marc

I understand your position, and I discover that indeed I delete the custom
Field with the Formulas and I can assign resources but the problem is that
I
need this formula to calculate the variance from Work Estimate to Status
Date
and the Actual Work Work, and I need this for all the Enterprise
projects...

How can I resolve this and maintenance this Field with formulas in My
Customize Fields???

Please Help me...

LM

Marc Schoeni said:
Luis,

One of our MOPS2007 customers experienced similar issues when trying to
save
or publish a project. We opened a support call with Microsoft PSS and
they
found out that the saving error was related to formulas in stored in
custom
fields; so obviously there's an issue with saving and retrieving the
formula
in the database. If you remove all formulas from the project I'm positive
you will be able to assign resources without any problems.

Let us know...

--
Marc
MCP for EPM
www.diventis.ch
www.msepm.blogspot.com

I discover that the problem is when I create a Custom Field type
Numberth
have this formula


IIf(([Total de Horas de Trabajo (Number1)]=0),(0),(((50*(Sin((([Time in
Hours Passed]/[Total_Work_Hours
(Number1)])*3,141592653589)-(3,141592653589/2))+1))*[Total_Work_Hours(Number1)])/100))

I Test this Formula only in Project Professional, and this work very
well,
the problem in when I put this in the Enterprise Custom Field

Please Help Me

:

Hi

In this moment I Have a Problem with project professional, when I
create
a
New Project Connected to Project Server 2007...

I can put the task, duration, task link in the view Gantt Chart, and
put
the
resource from PS2007 in the view Resource Sheet. But when I try to
assign
the
resource to a task in the view Gantt Chart, in this moment MS Project
Professional is Stopping Worked and restart again... This problem not
happend
when I work with PS Isolate...

Can you Help Me..

Thank's

Luis Mata
 
C

Chris Slowinski

Hi,

I'm experiencing a problem similar to Luis' except I have no custom field
formulae. Using a fresh installation of Project, it will crash if I try to
assign a resource to a task in the Gantt view while connected to Project
Server 2007. It's a very vexing problem. I'm trying this on Vista x64
Ultimate if it makes any sort of difference.

Gary L. Chefetz said:
Luis:

I believe that the problem you're experiencing is directly related to the
formula itself. You may not reference a standard custom field (A custom
field that you define in project) when creating a formula for and Enterprise
Custom Field. The bug, if any, is that the system isn't catching this for
you.

--


Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project


Luis Mata said:
Hi Marc

I understand your position, and I discover that indeed I delete the custom
Field with the Formulas and I can assign resources but the problem is that
I
need this formula to calculate the variance from Work Estimate to Status
Date
and the Actual Work Work, and I need this for all the Enterprise
projects...

How can I resolve this and maintenance this Field with formulas in My
Customize Fields???

Please Help me...

LM

Marc Schoeni said:
Luis,

One of our MOPS2007 customers experienced similar issues when trying to
save
or publish a project. We opened a support call with Microsoft PSS and
they
found out that the saving error was related to formulas in stored in
custom
fields; so obviously there's an issue with saving and retrieving the
formula
in the database. If you remove all formulas from the project I'm positive
you will be able to assign resources without any problems.

Let us know...

--
Marc
MCP for EPM
www.diventis.ch
www.msepm.blogspot.com

I discover that the problem is when I create a Custom Field type
Numberth
have this formula


IIf(([Total de Horas de Trabajo (Number1)]=0),(0),(((50*(Sin((([Time in
Hours Passed]/[Total_Work_Hours
(Number1)])*3,141592653589)-(3,141592653589/2))+1))*[Total_Work_Hours(Number1)])/100))

I Test this Formula only in Project Professional, and this work very
well,
the problem in when I put this in the Enterprise Custom Field

Please Help Me

:

Hi

In this moment I Have a Problem with project professional, when I
create
a
New Project Connected to Project Server 2007...

I can put the task, duration, task link in the view Gantt Chart, and
put
the
resource from PS2007 in the view Resource Sheet. But when I try to
assign
the
resource to a task in the view Gantt Chart, in this moment MS Project
Professional is Stopping Worked and restart again... This problem not
happend
when I work with PS Isolate...

Can you Help Me..

Thank's

Luis Mata
 
G

Gary L. Chefetz [MVP]

Chris:

Me-too posts aren't the most effective way to solve your problems, because
it gives so little information about your system. Of course, experienced
users do not assign resources in the Gantt chart view by using the picklist
in the resource column. The appropriate tools for doing this are the Build
Team tool, the Task Entry View or the Assign Resources dialog. I can't
reproduce your crashing problem, so it's not a bug. Take the time to start
your own thread and explain your setup.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Chris Slowinski said:
Hi,

I'm experiencing a problem similar to Luis' except I have no custom field
formulae. Using a fresh installation of Project, it will crash if I try
to
assign a resource to a task in the Gantt view while connected to Project
Server 2007. It's a very vexing problem. I'm trying this on Vista x64
Ultimate if it makes any sort of difference.

Gary L. Chefetz said:
Luis:

I believe that the problem you're experiencing is directly related to the
formula itself. You may not reference a standard custom field (A custom
field that you define in project) when creating a formula for and
Enterprise
Custom Field. The bug, if any, is that the system isn't catching this for
you.

--


Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project


Luis Mata said:
Hi Marc

I understand your position, and I discover that indeed I delete the
custom
Field with the Formulas and I can assign resources but the problem is
that
I
need this formula to calculate the variance from Work Estimate to
Status
Date
and the Actual Work Work, and I need this for all the Enterprise
projects...

How can I resolve this and maintenance this Field with formulas in My
Customize Fields???

Please Help me...

LM

:

Luis,

One of our MOPS2007 customers experienced similar issues when trying
to
save
or publish a project. We opened a support call with Microsoft PSS and
they
found out that the saving error was related to formulas in stored in
custom
fields; so obviously there's an issue with saving and retrieving the
formula
in the database. If you remove all formulas from the project I'm
positive
you will be able to assign resources without any problems.

Let us know...

--
Marc
MCP for EPM
www.diventis.ch
www.msepm.blogspot.com

I discover that the problem is when I create a Custom Field type
Numberth
have this formula


IIf(([Total de Horas de Trabajo (Number1)]=0),(0),(((50*(Sin((([Time
in
Hours Passed]/[Total_Work_Hours
(Number1)])*3,141592653589)-(3,141592653589/2))+1))*[Total_Work_Hours(Number1)])/100))

I Test this Formula only in Project Professional, and this work very
well,
the problem in when I put this in the Enterprise Custom Field

Please Help Me

:

Hi

In this moment I Have a Problem with project professional, when I
create
a
New Project Connected to Project Server 2007...

I can put the task, duration, task link in the view Gantt Chart,
and
put
the
resource from PS2007 in the view Resource Sheet. But when I try to
assign
the
resource to a task in the view Gantt Chart, in this moment MS
Project
Professional is Stopping Worked and restart again... This problem
not
happend
when I work with PS Isolate...

Can you Help Me..

Thank's

Luis Mata
 
C

Chris Slowinski

You're probably right about the "me-too" post thing; I just don't like to add
more threads than are necessary =). That being said, in this case a new
thread was warranted.

Turns out I fixed my problem. I'm using Hewlett-Packard's security manager
software on my notebook and it has an option for Single Sign-On. If this is
enabled, I experience the problem I described; turning it off, everything is
clear sailing.
The appropriate tools for doing this are the Build
Team tool, the Task Entry View or the Assign Resources dialog.

True enough; I was just poking around to see if I could reproduce the
problem I was seeing.

I appreciate your response and suggestions!


Chris
 
Top