Invalid column name 'ASSN_ENTSUMPROJID'

[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???

 

[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.

 

[Max]

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

Max

Hi Max,

Verify if ASSN_ENTSUMPROJID exists in table MSP_ASSN_ENTERPRISE.

If not, someone modified the Project Server structure.

Claudio Hidetoshi - Brazil.

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???

 

[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!

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

Max

Hi Max,

Verify if ASSN_ENTSUMPROJID exists in table MSP_ASSN_ENTERPRISE.

If not, someone modified the Project Server structure.

Claudio Hidetoshi - Brazil.

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???