How do I check in enterprise projects and enterprise resources? (Project Server 2007)

Resolution for Project Managers (Project Server 2007 only)

Project managers can check in their own checked out projects by completing the following steps:

1. Log into Project Web Access with project manager permissions.

2. Click the Project Center link in the Quick Launch menu.

3. On the Project Center page, click the Go To menu button and click the Check in my projects item.

4. In the data grid, select the option checkbox for the “stuck” checked out project and click the Check In button.

Resolution for Administrators (Project Server 2007 only)

Project Server administrators can check in projects and resources that are stuck in a checked out state by completing the following steps:

1. Logon to Project Web Access with administrator permissions.

2. Click the Server Settings link in the Quick Launch menu.

3. Click the Force Check-in Enterprise Objects link in the Database Administration section.

4. Click the pick list at the top of the page and select either Enterprise Projects or Enterprise Resources from the list.

5. In the data grid, select the option checkbox for the “stuck” item(s) and click the Check In button.

Resolution for SQL Server DBA’s (Project Server 2007 only)

Projects can occasionally become stuck in a checked out state, and the Project Server administrator cannot check in the projects using the Project Web Access interface. In this case, a SQL Server DBA must perform the following steps to check in the project:

1. Launch the SQL Server Management Studio application and connect to the server containing the Project Server 2007 databases.

2. Expand the Databases folder and then expand the Draft database folder for your production Project Server 2007 instance.

3. Expand the Tables folder for the Draft database.

4. Right-click on the dbo.MSP_PROJECTS table and select the Open Table item.

5. In the database table, select the name of the “stuck” project in the PROJ_NAME column.

6. Tab to the right until you locate the PROJ_CHECKOUTBY field.

7. In the PROJ_CHECKOUTBY field, select the Unique ID currently in the field and enter NULL in the field instead.

8. Press the Enter key or Tab key to complete the data change.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: