|
|
|
|
Overview | Example
Example: View the ULS log file entries using Microsoft Excel
This example demonstrates the steps required to view the ULS log file entries using Microsoft Excel 2007. To look for a specific entry in a log file, you must use the Manage Queue jobs page in Project Web Access in conjunction with the ULS logs.
Step 1: Read Job information in PWA Jobs Grid
- On PWA, click on Server Settings -> Queue -> Manage Queue
- View the job grid for error information
Let’s say that we have noticed that a project publish failed at 9:10PM on Feb 10, 2010 in job grid.
- Click on Available Columns list, select JobGroupID . Click Add to move jobGroupID to the Selected Columns list ((JobGroupID column is required to study the ULS log file in later step)
- In the Job Grid toolbar, click Refresh Status and verify that the JobGroupID column has been added
- Gather following job information that you would like to view the error details in ULS log file:
Project Name, Job execution date time and JobGroupID
In our example, Project Name: Assets Database Design; Job's Start Date: 2/10/2010 9:10 PM; Job's End Date:2/10/2010 9:11PM; JobGrouPID:C0020bdf-q30b-4600-8692-ee9f2ebc4f1c
Step 2: Locate ULS log file and determine error details
- Log on to Project Server machine and navigate to the ULS log file folder
- Locate the log file related to job you are looking for; you can easily find the required log file based on job’s start/end dates and server settings define for log file creation. Log files will be created for every 30 minutes by default)
I found the most recent log file named EPM2007DEMO-20100210-2103.log; Our job was processed at queue from 9:10 PM to 9:11 PM. It means, our job details are going to be available in this file.
- Copy the log file to desktop or some other convenient location where MS Excel application is installed.(This step is optional); I copied the log file to desktop
- Launch Office Excel 2007 and click Open
- In the Open dialog box, browse the location of log file
- In the Files of Types list, select All Files (*.*) so that you are able to see the log file; From the file list, select the log file you want to view
- The following import options will be displayed for your input
- log file will be open in excel
- Format the column TimeStamp to show date and time
- Format the column Message:
Select the entire Message column -> Right click to access the Format Cells option ->
Select General category under number tab -> Select Wrap text under Alignment tab
- Adjust the columns width to view the entire content in each column
- You can search for all entries pertaining to the specific queue job by using the column filters. Apply the filter to columns
- In the Area column, select the "Project Server" value from the filter to display the entries related to Project Server only
- Select the JobGroupID value in Correlation column. (In this example, JobGroup ID is C0020bdf-q30b-4600-8692-ee9f2ebc4f1c)
- Read the contents of Message on every row; Sequence of execution steps will be available on every row on Message column
- Noticed the Reporting sync error in one of the cell under Message column saying that "Owner filed is missing in WSS list"
FYI: Owner filed is mandatory field in Issue list, it seems to be this field was deleted from workspace site. This causing the Reporting Sync error during publishing process.
| |
|
