Microsoft KB Archive Search

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.

  1. Home
  2. A resource is not integrated successfully when you try to integrate from Microsoft Dynamics SL into Project Server 2007

A resource is not integrated successfully when you try to integrate from Microsoft Dynamics SL into Project Server 2007

Symptoms

Consider the following scenario in Project Controller in Microsoft Dynamics SL:
  • You create a new resource in the Employee and Resource Maintenance (PA.EMP.00) screen.
  • You integrate this resource into Microsoft Office Project Server 2007 by clicking to select the Integrated Resource check box.
  • You click Save.
In this scenario, you notice that the resource is not integrated into Project Server 2007 as expected.

Additionally, you receive the following error message in MSDSLEventlog:

DSL_2_Project: Commit Exception - Type:System.ArgumentNullException Message:Value cannot be null.

Parameter name: key

↑ Back to the top

Cause

This problem occurs if the cpnyid field is blank on the records for the resource that is being integrated in the PJEMPLOY and PJQUEUEMSP database tables.

↑ Back to the top

Resolution

To resolve this issue, populate the missing cpnyid value for the resource record in the PJEMPLOY table. To do this, use the following Microsoft SQL Server statement:

update pjemploy set CpnyID = 'CCCC' where Employee = 'XXXXX'
update PJQUEUEMSP set CpnyID='CCCC' where SLKeyValue='XXXXX' and CpnyID=''

--Replace XXXXX with the employee ID that you are trying to integrate and replace CCCC with the correct company ID for the employee.
After you update the record, try to integrate the resource again.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kbsolomon, kb

↑ Back to the top

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