Invalid Field Name 'ASSN_ENTSUMPROJID'

[Viren Saini]

I have Project Server 2003 with SP2a and Project Pro 2003 with SP3.

When i am saving a project to the Project Server, i am getting the following
message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'ASSN_ENTSUMPROJID'

This message is not coming for all project. Please help me understand the
reason behind this and if you have a solution to fix this issue, then kindly
share the same.

Thanks in advance...

Regards,

Viren Saini

 

[Stephen C. Sanderlin]

The ASSN_ENTSUMPROJID column should exist in the MSP_ASSN_ENTERPRISE
table... I would check to make sure it exists there, but since you say
the error doesn't show for all projects, I imagine it's where it should
be.

As a side question, why are you operating at different patch levels on
your client and server? This is not a recommended practice.

--
Stephen C. Sanderlin
Owner/Founder - EPMFAQ
http://www.epmfaq.com/
http://forums.epmfaq.com/

Principal Consultant - BT INS
http://bt.ins.com/

This electronic message, along with any information, advice, and
opinions it contains, are mine alone and are not representative of my
employer. All information is provided in "GOOD FAITH" and on an "AS IS"
basis only. I provide no presentations or warranties, express or
implied, including implied warranties of fitness for a particular
purpose, merchantability, title, and noninfringement. I strongly advise
you to extensively test any changes, workarounds, or techniques
described herein on a development system prior to implementation in a
production environment, and you are hereby notified that I bear no
responsibility whatsoever for any loss, harm, or otherwise negative
outcomes resulting from your actions, whether or not said actions were
a result of this electronic message, directly or indirectly.