Task 6: Creating Time Sheets on the Production Instance

For production environments with heavy usage of Time Management, such as more than 300 users logging or approving time in a peak hour, we recommend running the script at a time other than peak usage.

When the data in all the.xmlfiles is ready to use for time sheet creation on the production instance, do the following:

  1. Copy all of the .xml files for time sheets to the desired directory on the production instance. Be sure to use any .xml files to which you made corrections while testing on the TEST instance.

  2. Run the script on your production instance without using test mode, to create time sheets in PPM. Use the number of threads (-maxThreadcount argument) indicated by your performance testing on the TEST instance. See Running the Time Sheet Data Importer Script.

    While the script is running, monitor the following:

    • Usage of system resources (CPU, memory, disk space)

    • Table space available in the database

    • Redo archive log growth in the database

  3. When the script completes, review and correct all errors as in step 4 in Task 1 and step 5 in Task 1, and rerun the script until it moves all of the .xml files to the SUCCESS subdirectory and creates corresponding time sheets.

  4. Run the kTMPMSync.sh script with the -includeDates argument set to yes. For information about the kTMPMSync.sh script, see the Project Management Configuration Guide.