Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You receive an error message when you click Save in the Project Connector Setup (PA.MSP.00) screen in Microsoft Dynamics SL


Symptoms

Consider the following scenario in Microsoft Office Project Connector in Microsoft Dynamics SL:
  • You complete all the required fields in the Project Connector Setup (PA.MSP.00) screen.
  • You click Save.
In this scenario, you receive one of the following error message:

Error message 1

System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=CustomFieldInvalidUID

Instructions: Pass this into PSClientError constructor to access all error information at

Microsoft.Office.Project.Server.WebService.CustomFields.CreateCustomFields(CustomFieldDataSet cfds, Boolean validateOnly, Boolean autoCheckIn)


Error message 2

System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=GeneralSecurityAccessDenied Instructions: Pass this into PSClientError constructor to access all error information at Microsoft.Office.Project.Server.WebService.CustomFields.CreateCustomFields(CustomFieldDataSet cfds, Boolean validateOnly, Boolean autoCheckIn

↑ Back to the top


Cause

Cause 1

One or more of the Microsoft Dynamics SL Enterprise custom fields is deleted in Project Web Access. When this occurs, a record is created in the MSP_CUSTOM_FIELDS_SHADOW table in the ProjectServer_Published database. This record prevents Microsoft Dynamics SL from re-creating the deleted field correctly.

To resolve this issue, see Resolution 1.

Cause 2

The Windows user account that is currently logged in to Windows is not set up as an administrator in Microsoft Office Project Server 2007.

To resolve this issue, see Resolution 2.

↑ Back to the top


Resolution

Resolution 1

To resolve this issue, delete the record that appears in the MSP_CUSTOM_FIELDS_SHADOW table in the ProjectServer_Published database. To do this, use the following SQL statements.

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

delete from msp_custom_fields_shadow where md_prop_uid='DAA683DD-A065-4CF9-BBE6-7F446C9EAB5F'

delete from msp_custom_fields_shadow where md_prop_uid='D399B550-001B-4A2E-9BFD-01F16ED51ED1'

delete from msp_custom_fields_shadow where md_prop_uid='678DE020-C4F1-44AC-A914-68567FEA81E0'

delete from msp_custom_fields_shadow where md_prop_uid='BFEBE24B-E365-4C0D-82A7-BE0B2017C1C7'

delete from msp_custom_fields_shadow where md_prop_uid='0A3FA9EE-33C9-4CCC-9D16-F8C7EA5CE5E6'

delete from msp_custom_fields_shadow where md_prop_uid='A8A52F96-04D8-45B0-898F-B8F8B42F0ECF'

delete from msp_custom_fields_shadow where md_prop_uid='779A4F85-70B6-43BC-A9A3-9C348602832B'

delete from msp_custom_fields_shadow where md_prop_uid='CD5D1522-A41B-4F2E-848A-0556A98329A7'

delete from msp_custom_fields_shadow where md_prop_uid='17E93C33-3191-4206-902B-75ED58838EB8'

delete from msp_custom_fields_shadow where md_prop_uid='8FBAF009-9D1F-41FC-A84B-9E906D1C1748'

delete from msp_custom_fields_shadow where md_prop_uid='B5B3E2AA-8F47-470E-8860-9D2573B4F423'

delete from msp_custom_fields_shadow where md_prop_uid='153A9DFE-1B22-441F-A5E5-7E99E124CEA0'

delete from msp_custom_fields_shadow where md_prop_uid='5ED7B535-899C-4819-B668-B1C4EE27909D'

delete from msp_custom_fields_shadow where md_prop_uid='8224FC4D-9DE5-4E62-A9D2-7BBAE190645E'

delete from msp_custom_fields_shadow where md_prop_uid='9C36C8BA-75FD-4E4D-A24E-22D46B0F4A1E'

delete from msp_custom_fields_shadow where md_prop_uid='6E122B6E-B280-47A1-8CC9-18E86D9520FD'

delete from msp_custom_fields_shadow where md_prop_uid='66D59477-48A5-45D5-BB93-D5C8975F8E78'

delete from msp_custom_fields_shadow where md_prop_uid='E6242613-F6C5-4B69-B292-87A572546AD1'

delete from msp_custom_fields_shadow where md_prop_uid='EE6E6D2B-2D98-48DF-971C-F27A5C1C8D01'

delete from msp_custom_fields_shadow where md_prop_uid='0AA690CF-FC98-42F8-BEA1-80E8E522266A'

delete from msp_custom_fields_shadow where md_prop_uid='B6CA94E5-DF9B-4AA0-A468-F7F3F4AB7B92'

delete from msp_custom_fields_shadow where md_prop_uid='4AF396D9-A04D-4326-9E62-6113877A4A66'

Resolution 2

To resolve this issue, set up the Windows user account as an administrator in Microsoft Office Project Server 2007. To do this:
  1. Locate the Project Web Access (PWA) site.
  2. Click Server Settings.
  3. Click Manage Users.
  4. Search for the appropriate Windows user account, or select the account from the list.
  5. Double-click the user account to edit the security settings.
  6. Under the Security Groups heading, add Administrators Group for this user.
  7. Click Save and Continue.

↑ Back to the top


Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2430071
Revision : 1
Created on : 1/7/2017
Published on : 8/5/2011
Exists online : False
Views : 116