Where does the Data Live?

B

Brad

Hi All,

I having problems with one custom field that I cannot remove for some
reason. No matter how many times I try and remove it normally, it just
reappears with all of its ValueList items when I log back in.

I'm running MSP 2003 over PWA 2003 in a Enterpise environment. I thought
that perhaps I could remove it directly from one of the SQL tables, but I
cannot find the values at all. I can see in MSP_Conversions that "Text2" is
actually called 188743734, but I cannot see where the value list lives. In
other words, the values you see when you pull down the drop down box.

I have searched all SQL files and even searched the Registry on my PC, but I
cannot find those values.

Any ideas out there? Without being able to remove this custom field, it
shows up in every task in every project.

Thanks in advance,
Brad
 
K

Kishore

Hi Brad,
The value list items are stored in MSP_ATTRIBUTE_STRINGS table. Items are
stored in column: [as_value]

Hope this helps.

Regards,
Kishore Dodda
 
B

Brad

Hi Kishore,

Thank you very much for your help. I went into MSP_ATTRIBUTE_STRINGS and
removed all references to the custom filed in question on a test project. No
place in teh table are the values listed in the custom field present for the
test project ID. But, unfortunately, when I go back into the test project I
see the same custom field there with all its attributes like nothing happened.

In fact, when I go into the Organizer, I see the same custom field listed on
both sides of the Organizer. Once on the right for the project and once on
the left for the Enterprise Global.

MSP_ATTRIBUTES_STRINGS doesn't hold and Enterprise Custom Fields. Do you
know where this data lives?

Thanks again!

Brad



Kishore said:
Hi Brad,
The value list items are stored in MSP_ATTRIBUTE_STRINGS table. Items are
stored in column: [as_value]

Hope this helps.

Regards,
Kishore Dodda

Brad said:
Hi All,

I having problems with one custom field that I cannot remove for some
reason. No matter how many times I try and remove it normally, it just
reappears with all of its ValueList items when I log back in.

I'm running MSP 2003 over PWA 2003 in a Enterpise environment. I thought
that perhaps I could remove it directly from one of the SQL tables, but I
cannot find the values at all. I can see in MSP_Conversions that "Text2" is
actually called 188743734, but I cannot see where the value list lives. In
other words, the values you see when you pull down the drop down box.

I have searched all SQL files and even searched the Registry on my PC, but I
cannot find those values.

Any ideas out there? Without being able to remove this custom field, it
shows up in every task in every project.

Thanks in advance,
Brad
Click to expand...
Click to expand...
 
E

Ed Morrison

You should always remove custom fields using the Organizer with the
Enterprise Global open. Go to Tools, Organizer, Fields tab. Select the
field and click delete. No database changes are necessary.
 
B

Brad

Hi Ed,

I wish what you wrote were true, but I have repeatedly used the Organizer
and as soon as I logout and back in, the fields come back.

Thanks,
Brad
 
G

Gary L. Chefetz [MVP]

Brad:

What Ed wrote is the gospel. Removing them from the tables directly simply
doesn't work. If you're saving your Global after making this change, and the
fields come back, it's an indication that your save isn't successful.
Perhaps your Enterprise Global is corrupt.
 
B

Brad

Hi Gary,

Its not that I don't believe you or Ed, its just that it doesn't work. I've
even made copies of projects and opened them offline to still see the
nuisance text fields. My thinking is that the Global file is corrupt. How do
I fix it?

Thanks for all your help.

Brad
 
G

Gary L. Chefetz [MVP]

Do you have a good backup?




Brad said:
Hi Gary,

Its not that I don't believe you or Ed, its just that it doesn't work.
I've
even made copies of projects and opened them offline to still see the
nuisance text fields. My thinking is that the Global file is corrupt. How
do
I fix it?

Thanks for all your help.

Brad
Click to expand...
 
B

Brad

Hi Gary,

The only back ups I have were made after the problem was found.

Thanks,
Brad
 
E

Ed Morrison

Brad,
Lets verify that you are using the Organizer correctly. First you must open
the Enterprise Global using an account with Administrator privileges. Then
open the Organizer and click on the fields tab. The Enterprise Custom field
should appear on the right hand side in the box labeled as 'Checked-Out
Enterprise Global'. Select the field in question and click delete.

Of course, we should always make a backup of the Enterprise Global before we
make any changes.

If this doesn't work correctly. Create an Enterprise Global in a different
instance of Project Server, back it up, and restore it to the problem
instance. Then make all of the changes necessary (making frequent
backups!).

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com
 
B

Brad

Hi Ed,

Thanks for the response. Yes, I have signed on as Asministrator, brought up
the Enterprise Global and removed the reference to TEXT2 from the Fields tab
in the Organizer.

When I return to the Gantt and look at a task assignment, I can see that
TEXT2 no longer exists. BUT, once I save and exit and then return, TEXT2 with
all its pre-defined values return as if nothing ever happened.

So you think I should sign onto another machine and create a fresh
Global.mpt and recreate the whole thing? And then do a replace in my live
envrironments?

Thanks again.

Brad
 
E

Ed Morrison

Brad,
Not a Global.mpt, but an Enterprise Global. They are two different objects.
The Global.mpt resides on a users computer, while the Enterprise Global
resides in the database and determines enterprise wide properties such as
Enterprise Custom Text fields.

Is this an Enterprise Custom Text field or just a Custom Text field? If it
is not an enterprise field, it does not reside in the Enterprise Global, but
in the project plan itself.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com
 
B

Brad

Hi Ed,

Sorry Ed, I mis-spoke, its the Enterprise Global. But the field is just a
regualr custom text field with values. But it shows up on both sides of the
Organzer when I open it up from the Enterprise Global. Its like the custom
text field copied itself into the Entrprise Global and will not allow it to
be removed.

Thanks,
Brad
 
B

Brad

Thanks Ed, I think your right. Its corrupt. What I was hoping to be able to
do was to find the data in the SQL files and remove the references manually.
Is this possible?

Regards,
Brad
 
B

Brad

Hi Gary,

This solution really made sense to me and I had high hopes that it was going
to work. But unfortunetly it didn't.

Do you know what that field PROJ_EXT_EDITED in MSP_Projects is used for?
There are other PROJ_EXT_EDITED fields in the file with different suffixes
like PROJ_EXT_EDITED_TEXT. Do you know what they do?

Thanks for your help Gary, I think we're on to something with the binary
stuff.

Regards,
Brad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where does the data live?? 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Problem with enterprise task custom field on ProjectSummaryTask in amaster project 0
Visio 2013: how do I auto-colour Shapes in alignment with pre-entered Shape Data? 0
Char Limit to Formulas?? 4
PS7 - Custom Resource Field in Project Center 1
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Fetch Custom Field Data from External Tasks 1

Top