Edit custom field to not use lookup table

S

Shane

Hi All -

Whilst refreshing the enterprise custom fields, I stupidly saved the Team
Name field to use the State lookup table - I know, I know... :-(

My question here is how do I undo that.

The field is now saved with that lookup table and cannot be changed.

I have access to the DB so if a change is needed in there, just let me know
how.

We are using MOPS 2007 and are patched all the way.

Cheers
Shane
 
G

Gary L. Chefetz

Shane:

Don't beat yourself up over this, as it's a Microsoft mistake to not have
created the blank Team lookup table. You can fix this directly in the
database, here are the instructions:

http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/AttachTeamNamesLookupTable.aspx

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
 
S

Shane

Gary -

One thing I noticed after making the db change was that the queue now throws
an error for the Team Name custom field.

Error summary/areas:
Reporting message processor failed
ReportingCustomFieldMetadataChangeMessageFailed
ReportingCustomFieldMetadataChangeMessageFailed
ReportingCustomFieldMetadataChangeMessageFailed
ReportingCustomFieldMetadataChangeMessageFailed
ReportingCustomFieldMetadataChangeMessageFailed
ReportingCustomFieldMetadataChangeMessageFailed
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Reporting message processor failed">
<error id="24002"
name="ReportingCustomFieldMetadataChangeMessageFailed"
uid="3762d2bd-f19a-41f2-a469-d2fa8508f612"
QueueMessageBody="CustomFieldTypeUID='0000740f-cf67-4b93-a405-f0c12c5bc942'.
ChangeType='Alter'" Error="Unable to transfer the custom field metadata
change. The custom field 'Team Name' was subjected to an unsupported change.
LookupTable, ModificationDate" />
<error id="24002"
name="ReportingCustomFieldMetadataChangeMessageFailed"
uid="5c78a607-9795-4237-8eb9-4956e476ee42"
QueueMessageBody="CustomFieldTypeUID='0000740f-cf67-4b93-a405-f0c12c5bc942'.
ChangeType='Alter'" Error="Unable to transfer the custom field metadata
change. The custom field 'Team Name' was subjected to an unsupported change.
LookupTable, ModificationDate" />
<error id="24002"
name="ReportingCustomFieldMetadataChangeMessageFailed"
uid="aba2a003-dc81-4aad-95a1-2e3144aab199"
QueueMessageBody="CustomFieldTypeUID='0000740f-cf67-4b93-a405-f0c12c5bc942'.
ChangeType='Alter'" Error="Unable to transfer the custom field metadata
change. The custom field 'Team Name' was subjected to an unsupported change.
LookupTable, ModificationDate" />
<error id="24002"
name="ReportingCustomFieldMetadataChangeMessageFailed"
uid="7d67ae55-3932-407d-ad97-21582ec21281"
QueueMessageBody="CustomFieldTypeUID='0000740f-cf67-4b93-a405-f0c12c5bc942'.
ChangeType='Alter'" Error="Unable to transfer the custom field metadata
change. The custom field 'Team Name' was subjected to an unsupported change.
LookupTable, ModificationDate" />
<error id="24002"
name="ReportingCustomFieldMetadataChangeMessageFailed"
uid="9eaa47e3-4041-46e4-9966-67106f07c4c6"
QueueMessageBody="CustomFieldTypeUID='0000740f-cf67-4b93-a405-f0c12c5bc942'.
ChangeType='Alter'" Error="Unable to transfer the custom field metadata
change. The custom field 'Team Name' was subjected to an unsupported change.
LookupTable, ModificationDate" />
<error id="24002"
name="ReportingCustomFieldMetadataChangeMessageFailed"
uid="5e4630d7-4158-4a08-a5fd-c67de27798e7"
QueueMessageBody="CustomFieldTypeUID='0000740f-cf67-4b93-a405-f0c12c5bc942'.
ChangeType='Alter'" Error="Unable to transfer the custom field metadata
change. The custom field 'Team Name' was subjected to an unsupported change.
LookupTable, ModificationDate" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="72ae0371-7e4f-4451-8310-57a1f88ccca1"
JobUID="126adb5f-c855-43e0-b489-39d71a856f6c" ComputerName="HOFGA1052"
GroupType="ReportingCustomFieldMetadataSync"
MessageType="ReportCustomFieldMetadataSyncMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>

I have tried refreshing both the lookup table and the field itself but the
queued error persists. Is this something that will cause issues further down
the line?

Thanks,
Shane
 
S

Shane

No I populated it with some "dummy" names

I have since executed a reporting database refresh and the Reporting Custom
Field Metadata Sync jobs all executed successfully.

Can I consider that an indication that it resolved itself?
 

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

How to Create an S-Curve from Custom Field? 0
Is it possible to edit colours already saved as part of a custom theme? 0
Custom field with lookup table 3
How to change the lookup table of a custom field? 2
Lookup table corruption. Only us? 7
Lookup Table how to feed data 0
Can't add multi-level custom enterprise lookup field 7
Enterprise custom field update 2

Top