MSP Target error due to corrupt Global.mpt file

book

Article ID: 4085

calendar_today

Updated On:

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:

  1. Log in to Clarity
  2. 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."

Cause

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

Environment

Release:  All Supported Releases
Component:  MSP

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:

For other possible reasons for the "An error occurred while opening CA PPM in Microsoft Project. Please try again." error, see:

KB Clean Uninstall of the MSP Interface

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