When opening projects in MSP, receive a Compile Error after upgrading the PPM MSP Interface

Document ID : KB000004150
Last Modified Date : 31/08/2018
Show Technical Document Details
Issue:

After upgrading my CA PPM Microsoft Project (MSP) Interface, receive a Compile error when opening projects is MSP. You may see several different Compile errors noted below: 

  1. Compile error: Ambiguous name detected: ReadValue Open
  2. Compile error: Ambiguous name detected: CA_VBA_IS_CUSTOMIZED
  3. Compile error: Method or data member not found
  4. Compile error:  Variable not defined.

Steps to Reproduce:

  1. Navigate to a project in Project & Portfolio Management (PPM)
  2. Click the "Open in Scheduler" drop down on the Project Properties or Tasks tab
  3. Select Microsoft Project [Read-Write] or Microsoft Project [Read-Only]

Expected Result:  Project opens successfully in MSP

Actual Result: One of the following error appears in MSP: Compile error: Ambiguous name detected: ReadValue Open, Compile error: Ambiguous name detected: CA_VBA_IS_CUSTOMIZED, Compile error: Method or data member not found, Compile error:  Variable not defined and the project does not open. Screen shot below of one of the errors you may see:

Compile1.jpg

Environment:
Applies to all supported PAS environments for specified releases.
Cause:

This typically is caused by the Visual Basic modules not being upgraded successfully

Resolution:

1. In MSP:

• Go to View > Macros > Visual Basic

• Expand ProjectGlobal then Expand Modules

• Delete or "unhook" the modules that start with either CA_ and Niku_

• Expand Microsoft Project Objects, Double-click on Thisproject

• Select everything in the right panel and delete it

• Save and exit Visual Basic

2. Go to View > Macros > Macro Security and change Macro Settings to 'Enable all macros' (This can cause issues during the install)

3. Go to your Control Panel->Programs and Features and uninstall the CA Clarity Addin (Leave CA PPM Schedule Connect and CA PPM Microsoft Project Interface installed)

4. Navigate to the following folder directory: CA\PPM\CA PPM MSPInterface\addin and double click setup.exe to run through the install process for the Addin

Additional Information:
Reference KB000071385 - CA PPM and MSP integration - List of Knowledge Documents
Reference KB000015956 - CA PPM and MSP integration known defects - Support Technical Document Index