MSP2003 - Implicit conversion of data type

J

J

We have upgraded a distributed test environment from
Project Server 2002 to 2003 and during client testing
received the following error during a publish:

[Microsoft][ODBC SQL Server Driver][SQL Server]
Disallowed implicit conversion from data type datetime to
data type int,
table 'ISD.dbo.MSP_FIELD_ATTRIBUTES_PROJ_WRITEVIEW',
column 'ATTRIB_ID'. Use the CONVERT function to run this
query.

After the workplan crashed, upon re-opening the save
event returned:

[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot
insert duplicate key row in object 'MSP_TASKS' with
unique index 'I_MSP_TASKS'.

Again, after closing and re-opening:

No calculations can be performed now.

There is a circular relationship in task 17 Summary task
4 of "Z001-010-03-cPMO Test Project.Published". The
successors of this task refer back to this task or its
predecessors
 
J

J

Sorry about the incomplete post below - {TAB}{SPACE} =
SEND

Continued:

, causing a circular reference.

To remove the link that is causing the circular
reference, select the two tasks that are causing the
circular link, and then click Unlink Tasks on the
Standard toolbar."

Since this is a test environment, we don't care about
retrieving the data from within the workplan, only to
know what steps to take in order to ensure these problems
do not occur in production. We have experienced many
issues with corrupt workplans in 2002 and do not want to
continue down the same frustrating path.

Any help/advise is greatly appreciated.

Jason
 
G

Gary L. Chefetz \(MVP\)

J:

Circular references in project plans is considered user-introduced
corruption. You need to resolve the circular relationship before going any
further with this plan. This is true for all versions of project. The fact
that it showed up during or just after your upgrade may be related to
increased sensitivity in the application or mere coincidence.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts

-
J said:
Sorry about the incomplete post below - {TAB}{SPACE} =
SEND

Continued:

, causing a circular reference.

To remove the link that is causing the circular
reference, select the two tasks that are causing the
circular link, and then click Unlink Tasks on the
Standard toolbar."

Since this is a test environment, we don't care about
retrieving the data from within the workplan, only to
know what steps to take in order to ensure these problems
do not occur in production. We have experienced many
issues with corrupt workplans in 2002 and do not want to
continue down the same frustrating path.

Any help/advise is greatly appreciated.

Jason
-----Original Message-----
We have upgraded a distributed test environment from
Project Server 2002 to 2003 and during client testing
received the following error during a publish:

[Microsoft][ODBC SQL Server Driver][SQL Server]
Disallowed implicit conversion from data type datetime to
data type int,
table 'ISD.dbo.MSP_FIELD_ATTRIBUTES_PROJ_WRITEVIEW',
column 'ATTRIB_ID'. Use the CONVERT function to run this
query.

After the workplan crashed, upon re-opening the save
event returned:

[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot
insert duplicate key row in object 'MSP_TASKS' with
unique index 'I_MSP_TASKS'.

Again, after closing and re-opening:

No calculations can be performed now.

There is a circular relationship in task 17 Summary task
4 of "Z001-010-03-cPMO Test Project.Published". The
successors of this task refer back to this task or its
predecessors
.
Click to expand...
Click to expand...
 
Top