Invalid column name 'ASSN_ENTSUMPROJID'

M

Max

Everytime I publish a project, the application returns this error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'ASSN_ENTSUMPROJID'.

This is the third post concerning this issue, but no replies. If you google
the error, there is no information available out there either. Is there not
an MVP who can assist???
 
C

Claudio Hidetoshi

Hi Max,

Verify if ASSN_ENTSUMPROJID exists in table MSP_ASSN_ENTERPRISE.

If not, someone modified the Project Server structure.

Claudio Hidetoshi - Brazil.
 
M

Max

Thanks. I checked into this and unfortunately, the structure has NOT been
modified. Any other suggestions or assistance is appreciated.

Max

Claudio Hidetoshi said:
Hi Max,

Verify if ASSN_ENTSUMPROJID exists in table MSP_ASSN_ENTERPRISE.

If not, someone modified the Project Server structure.

Claudio Hidetoshi - Brazil.


Max said:
Everytime I publish a project, the application returns this error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'ASSN_ENTSUMPROJID'.

This is the third post concerning this issue, but no replies. If you google
the error, there is no information available out there either. Is there not
an MVP who can assist???
Click to expand...
Click to expand...
 
P

Paul Jones

I have the same error. I've found some google threads with the same error
description but no solution. This error first appeared after the Project
Server SP2a was applied. I hope someone reading this thread will have a
solution. My Project users are driving me bonkers complaining about this
error!

Max said:
Thanks. I checked into this and unfortunately, the structure has NOT been
modified. Any other suggestions or assistance is appreciated.

Max

Claudio Hidetoshi said:
Hi Max,

Verify if ASSN_ENTSUMPROJID exists in table MSP_ASSN_ENTERPRISE.

If not, someone modified the Project Server structure.

Claudio Hidetoshi - Brazil.


Max said:
Everytime I publish a project, the application returns this error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'ASSN_ENTSUMPROJID'.

This is the third post concerning this issue, but no replies. If you google
the error, there is no information available out there either. Is there not
an MVP who can assist???
Click to expand...
Click to expand...
Click to expand...
 
Top