outline code table corrupted?

[jay]

Desktop: MS Project Professional 2002 SP-1

Server: MS Project Server 2003 SP-1

We have a custom (resource) outline code table which we tried to link to a
custom (task) outline code table. This did not provide the desired results
so we unlinked the two tables. Now, when viewing/editing the custom resource
outline code table, all the entries are displayed in red, each entry also
having an alert indicator, and the table cannot be accessed by the view it
was setup for. Existing Enterprise Resource Pool entries which have the
outline code table information associated with it are displaying the correct
data, however when you try to change an existing enterprise resource pool
entry, the custom resource outline code table values do not appear.
Similarly, the custom resource outline code table values do not appear when
attempting to add a new resource. For each case, the following error appears:

“The Enterprise Outline Code is not defined. Enterprise Outline Code
Enterprise Resource Outline Code28 has not been defined in your enterprise
global or was defined in this session. Please check out the enterprise
global to define it, restart Microsoft Project to load the latest definition,
or talk to your system administrator if you don’t have global checkout
privileges.â€

Pertinent suggestions, advice and/or general guidance would be greatly
appreciated!!

Have a great day!!

 

[Gary L. Chefetz [MVP]]

Jay:

I strongly suggest that you delete this Enterprise field and all its values
and start over again by defining the outline code and code mask, then assign
the values to the resources:

Use the procedure outlined here:

http://www.projectserverexperts.com/Shared Documents/DeleteCustomField.htm

 

[jay]

Hi Gary,

Thank you for your response and suggestion. Given our current circumstance,
we don't have any other alternative but to delete the Enterprise field,
re-create the outline table and then manually reassign the values. (FYI - we
have over 1,000 resources in the Enterprise Resource Pool).

The questions that still remain are -

What is the source of this problem?
What will prevent the problem/corruption from recurring?

Unfortuately, the final recovery step of reassigning the values to the
resources cannot be a "copy & paste" type effort. PWA's Resource Center
currently displays the corrupted user defined field with numeric values (e.g.
661, 145, -1, etc.)...???RRN record pointer values???? SO, exporting grid to
Excel and then copy/paste the column value to Enterprise Resource Pool column
(same resource order) is NOT an option. YUK

Jay

 

[Gary L. Chefetz [MVP]]

Jay:

If you're sharing a look-up structure, I suspect the fact that you unlinked
the fields without first clearing the values is the cause. If you were
intending to change the code structure, and it involved a step change that
affects every user, then there's little value in trying to preserve the
original values.