Custom field values not showing

[tjdickie]

Hi all

I am working in Project Server 2003. We are adding new custom fields
at the task level called Allocated and Task Role. Task Role is Unix
Enterprise Task Text6 which is filed id # 188744484 in MSP_TEXT_FIELDS
table. I am inserting the value for this field using SQL then updating
MSP_PROJECTS and setting my Ext edit flg for TEXT and Project to 1 for
all the project. This works fine and I see the values in the new field
in Project. What is happening is I have Enterprise Project Text4 as a
required field and it has a value in it. After I have run my SQL
staements and I open project plans on some of my Projects I no longer
see the value of the enterprise Project field in Project any longer. I
can query the database and I see the filed 188744732 and the value for
this in the database but Project does not have the data and it is not
recognised as having a value. This is a sporatic issue some projects
are fine.

Any insight into why this issue is happening or how to fix it is
appreciated.

Thanks

Tom

 

[tjdickie]

Hi all

I am working in Project Server 2003. We are adding new custom fields
at the task level called Allocated and Task Role.  Task Role is Unix
Enterprise Task Text6 which is filed id # 188744484 in MSP_TEXT_FIELDS
table. I am inserting the value for this field using SQL then updating
MSP_PROJECTS and setting my Ext edit flg for TEXT and Project to 1 for
all the project. This works fine and I see the values in the new field
in Project. What is happening is I have Enterprise Project Text4 as a
required field and it has a value in it. After I have run my SQL
staements and I open project plans on some of my Projects I no longer
see the value of the enterprise Project field in Project any longer. I
can query the database and I see the filed 188744732 and the value for
this in the database but Project does not have the data and it is not
recognised as having a value. This is a sporatic issue some projects
are fine.

Any insight into why this issue is happening or how to fix it is
appreciated.

Thanks

Tom

Ok I am going to answer my own question. I was updating all task in
MSP_TASK table and there were blank lines in here with a UID= - 64684
and when these were put into MSP_TEXT_FIELDS it caused issues. I
removed anything with a UID<0 from the table and all my data is there
and intact.

 

[Jack Dahlgren MVP]

Tom,

I strongly advise against modifying the project server database using SQL
statements, especially if you are not sure what data you are deleting. This
is not supported by Microsoft (they prefer you use the PSI or whatever it
used to be called) and you can screw things up beyond repair.

Reading the database is unlikely to have bad effects, but modification is
dangerous.

-Jack Dahlgren

Hi all

I am working in Project Server 2003. We are adding new custom fields
at the task level called Allocated and Task Role. Task Role is Unix
Enterprise Task Text6 which is filed id # 188744484 in MSP_TEXT_FIELDS
table. I am inserting the value for this field using SQL then updating
MSP_PROJECTS and setting my Ext edit flg for TEXT and Project to 1 for
all the project. This works fine and I see the values in the new field
in Project. What is happening is I have Enterprise Project Text4 as a
required field and it has a value in it. After I have run my SQL
staements and I open project plans on some of my Projects I no longer
see the value of the enterprise Project field in Project any longer. I
can query the database and I see the filed 188744732 and the value for
this in the database but Project does not have the data and it is not
recognised as having a value. This is a sporatic issue some projects
are fine.

Any insight into why this issue is happening or how to fix it is
appreciated.

Thanks

Tom

Ok I am going to answer my own question. I was updating all task in
MSP_TASK table and there were blank lines in here with a UID= - 64684
and when these were put into MSP_TEXT_FIELDS it caused issues. I
removed anything with a UID<0 from the table and all my data is there
and intact.