Compile Error after upgrading the MSP Interface

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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

• 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.

Steps to Reproduce:

1. Navigate to a project in Clarity
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.

Environment

Releases: All

Component: Clarity Microsoft Project

Cause

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

Resolution

1. In MSP Go to View > Macros > Visual Basic

2. Expand ProjectGlobal then Expand Modules

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

4.  Expand Microsoft Project Objects, Double-click on Thisproject

5. Select everything in the right panel and delete it

6. Save and exit Visual Basis

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

8. 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)

9. Navigate to the following folder directory: CA\PPM\CA PPM MSPInterface\addin

10. Double click setup.exe to run through the install process for the Addin

Additional Information

• If the above KB doesn't help, see also: MSP - 'Compile error: Variable not defined'
• See MSP Integration - Master KB of Known Issues
• See MSP Integration Known Defects - Master KB
• Tips on searching for known Clarity Issues using Self Service