MSP Target Error Openfromdatabase when opening attempting to open a project in MSP

Document ID : KB000004225
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When opening Microsoft Project (MSP), receive one of two Target errors where the Error line reads either: "Error: Project cannot open the file." or "Error: Openfromdatabase"

Example of the Project cannot open the file error below:

targeterror.PNG

Environment:
This issue applies to all supported PAS environments for specified releases.
Cause:

1. This is typically due to the wrong MSP Interface bit level being installed. The MSP Interface bit level must match that of Microsoft Project. Example, if MSP's bit level is 64 bit, then the 64 bit level MSP interface should be installed. 

2. Another cause of this issue is if the Global.MPT has a different name other then ProjectGlobal 

Resolution:

1. If the issue is due to the wrong bit level of the interface being installed, perform a clean uninstall of the MSP Interface, then reinstall the MSP Interface with the correct version (that matches PPM) and bit level (that matches MSP) from PPM in Home->Account Settings->Software Downloads:

  • If your Microsoft Project Bit level is 32 bit download Microsoft Project Interface (x86)
  • If your Microsoft Project Bit level is 64 bit, download Microsoft Project Interface (x64)

Downloads.JPG

2. If the above isn't the cause of the issue, check to ensure the name is set as ProjectGlobal in Views->Macros->Visual Basic:

  • In MSP go to the Views tab, click Macros and select Visual Basic
  • In the left hand window, verify that the Global.MPT header is displayed as ProjectGlobal (Global.MPT)
  • If not, right click on the Global.MPT header and select the Properties option (it will include the current name of the header) from the list
  • Change the Project Name to ProjectGlobal and click OK
  • Go to Control Panel->Programs and Features and uninstall the CA Clarity Addin (Leave CA PPM Schedule Connect and CA PPM Microsoft Project Interface installed)
  • 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:

- For Target errors including the "Out of Range" or "Openfromdatabase" errors due to due to a corrupt Global.MPT see: TEC1338125

- For steps on how to do a clean uninstall of the CA PPM Microsoft Project Interface see: TEC1228411