Pages

Sunday, 4 January 2009

EPM/SharePoint Security Integration

Out-of-the-box EPM integration with SharePoint provides the following;
  1. Project Owner (who ever creates the project or is assigned as the Owner) is able to add and modify SharePoint documents/lists including Risks and Issues

  2. Project Team Members who are assigned to tasks are able to add and modify SharePoint documents/lists including Risks and Issues

  3. Project Team Members who are NOT assigned should have view only rights.

If you are changing and testing access rights, you may need to ensure that you are publishing the project after any change. You may also need to perform SharePoint Synchronisation of access rights.



EPM Scheduled Jobs

When deploying EPM2007, the timings of the following scheduled jobs need to be considered;

  1. SQL DB Backups
  2. OLAP Cube Build
  3. Resource Capacity
  4. Message Queue Cleanups
  5. Email Alerts and Reminders
  6. AD Synch for ERP and Groups
  • Other SharePoint Timer Jobs and any other

Thursday, 1 January 2009

Unable to Install ActiveX Controls

Have you ever encountered an issue where by ActiveX controls do not install even if you have admin rights on the PC?


Try cleaning up/removing old controls and re-installing. Here are some general steps that will help;

CAUSE
This issue may occur if an issue exists with one or more Microsoft Project ActiveX Control objects that are already installed on your computer, and the issue prevents you from downloading and installing the ActiveX Control objects correctly.


RESOLUTION
To resolve this issue, follow these steps:
1.Remove the Microsoft Project ActiveX Control objects that are installed on your computer. To do this, follow these steps:
a. Start Internet Explorer if it is not already started.
b. On the Tools menu, click Internet Options.
c. Click the General tab, and then click Settings under Temporary Internet files.
d. In the Settings dialog box, click View Objects.
e. Remove objects starting with PJ*.* if the objects are present
To do so, right-click the object, and then click Remove.
f. Quit Internet Explorer.


2.Verify that the ActiveX Control objects are removed from your computer. To do this, follow these steps:
a. Click Start, click Run, type cmd in the Open box, and then click OK.
b. At the command prompt, change to the one of the following folders, depending on your situation:
•If you are running Microsoft Windows 2000: Drive:\Winnt\Downloaded Program Files
•If you are running Microsoft Windows XP, Microsoft Windows Millennium Edition (Me), or Microsoft Windows 98: Drive:\Windows\Downloaded Program\Files
c. Type dir pj*.*, and then press ENTER.
d. Use one of the following methods, depending on your situation:
•If no files are listed in the Command Prompt window, you do not have to follow the remaining steps in this article.
•If one or more files are listed in the Command Prompt window, delete the files. To do this, type del pj*.*, and then press ENTER.
e. Type exit, and then press ENTER to quit Command Prompt.
The loation of the ActiveX controls is shown in the fig below.














3.Log on to Project Server by using Microsoft Project Web Access.

If the issue persists, go to step 4.
4.Remove cookies. To do this, follow these steps:
a. Start Internet Explorer if it is not already started.
b. On the Tools menu, click Internet Options.
c. On the General tab, click Settings under Temporary Internet files.
d. Click Delete Cookies, and then close the Internet Options window.
e. Start Internet Explorer, access Microsoft Project Web Access, and then download the controls.