MSP Target error due to corrupt Global.mpt file

Products

Clarity PPM On Premise

Issue/Introduction

Microsoft Office® Project (MSP) throws a target "Out of Range", "Subscript out of range" or "OpenFromDatabase" error.

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:

Log in to Clarity
Navigate to a project and 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 the user's 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."

Environment

Release: All Supported Releases
Component: MSP

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:

Close MSP
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