MSP Target error due to corrupt Global.mpt file

Products

• Clarity PPM On Premise

Issue/Introduction

Microsoft Office® Project (MSP) throws a target error with one of the following:

• Out of Range
• Subscript out of range
• OpenFromDatabase

The errors that are thrown may include the following:

Target: Microsoft.Vbe.Interop.VBProject Item(System.Object) 

Error: Subscript out of range 
Trace: at Microsoft.Vbe.Interop._VBProjects.Item(Object index) 
at CAClarityAddIn.ClarityUI.updateMacros() 
at CAClarityAddIn.ClarityUI.ClarityUI_Load(Object sender, RibbonUIEEventsArgs e)

Target: System.Object...
Error: The macro "OpenFromDatabase" cannot be found. 

Steps to Reproduce:

1. Log in to Clarity.
2. Navigate to a project.
3. From the Properties or Tasks tab, click on the "Open in Scheduler" drop down to open the project in Microsoft Project in Read or Read/Write mode.

Expected Result: Project opens successfully

Actual Result: Receive a Target error which may reference one of the below in the Error line of the message   

• "Out of Range"
• "Subscript out of range" 
• "Openfromdatabase"

Alternatively, the error may also occur when MSP is opened from your desktop and the Open icon on the CA PPM Integration button is selected. When this is the case, opening Microsoft Project from Clarity by clicking on the "Open in Scheduler" drop down will throw a different error such as "An error occurred while opening CA PPM in Microsoft Project. Please try again."

Cause

This is typically due to a corruption of the Global.MPT file

Resolution

Delete or rename the Global.MPT file on the user workstation and generate a new Global.MPT using the steps below:

1. Close MSP
2. Delete or rename the Global.MPT file under C:\Users\{username}\AppData\Roaming\Microsoft\MS Project\16\en-US

Notes:

• The file may be in a slightly different path depending on the version of MSP. The path above is for Project 2016. 
• If you run into issues finding the Global.MPT ensure hidden folders are made visible:
  • In the folder directory, select Folder and search Options
  • Click the View tab
  • Select the radio button for 'Show hidden files, folders, and drives'

    3. Open MSP and then close MSP

Important: DO NOT DELETE the global.mpt file that MSP creates in the following folder:

• C:\Program Files\Microsoft Office\OFFICE11\1033

Additional Information

See also:

• MSP Target Error Openfromdatabase due to wrong Bit Level
• For other possible reasons for the "An error occurred while opening CA PPM in Microsoft Project. Please try again." error, see KB MSP: 'An error occurred while opening CA PPM project'
• KB Clean Uninstall of the MSP Interface