Upgrading Legacy Detailing Data

Data model modifications performed in releases prior to release 13, service pack 5 must have their detailing data upgraded during database migration. There have been no modifications to the detailing model after R13 SP5, so any later data does not need to be upgraded.

If all of the detailings in the database were last saved in R13 SP5 or later, there is no need to run this tool. It is strongly recommended that this tool is not used when there is no detailing data saved prior to R13 SP5 to be migrated.
To get the last saved version information for all of the detailings in a given project, run:

CATIPDDetailingUpdate –blobInfo –projectID XXX

When the Manufacturing Hub database is upgraded from one release to a higher release, all of the data exposed in the database is upgraded. However, the V5 detailings that are not exposed in the database cannot be updated by the database upgrade tool.

Consequently, the CATIPDDetailingUpdate.exe tool needs to be used to upgrade such V5 detailing data. This tool is available in the intel_a\code\bin directory of the V5 installation.

When using DELMIA Process Engineer Copy across DB of Manufacturing Hub project functionality or the Copy project command, V5 detailing is still available in the new project. To be able to use these capabilities for projects with detailing saved prior to Release 11, the CATIPDDetailingUpdate.exe tool must be run for the project to be copied. Please use this tool on the machine with Manufacturing Hub client installed.

This tool must be run on a machine that has a proper working installation of DELMIA Process Engineer Client and a proper working installation of V5 DELMIA (of the same level as Process Engineer). Also, ensure that a proper V5 license is available with which all data in the detailing can be loaded and saved.

  1. Execute CATIPDDetailingUpdate.exe on level Rx by following these steps:

    1. Set the following environment variables to bypass the Manufacturing Hub login prompt dialog box while running the tool. The values of the environment variables must be the login and password used while loading a project into V5 (Note: This login should have sufficient privileges to load and save data in the database)
      DELMIA_DETAILING_UPDATE_LOGIN
      DELMIA_DETAILING_UPDATE_PASSWORD

    2. Run the command CATIPDDetailingUpdate –outputDir
      This displays the directory in which the log file generated by the tool is created (this is the Windows temporary directory). The log file will be named DetailingUpdateResults_<FileTimeStamp>.txt.

    3. Run the command CATIPDDetailingUpdate –projectsInfo
      This generates information on the various projects in the database, namely project name, project ID, etc. in the log file.

    4. Run the command CATIPDDetailingUpdate –projectID XXX (where XXX= the project ID obtained from the log file in this step)
      This command updates all the detailing data on all the processes in the project with the ID XXX .

    5. Unset the environment variables set above.

  2. Install the PE Rx+n client and server. (Please refer to the DELMIA Process Engineer installation documentation for details.) During installation, the data is automatically updated.

  3. Install V5 Rx+n. Please refer to the DELMIA V5 installation documentation for details.
  • Note that the tool needs to be run once per migration (i.e., there is no need to run the tool in Rx+n level after the migration from Rx level has been completed.)
  • PCS Impact: Since the tool loads and saves these detailings one after another, the tool may eventually run out of memory before it finishes updating all the detailings in the database (especially when the database contains a large number of detailings). When memory runs out, rerun the tool until all the detailings are processed. For example, a database contains n detailings, all of which need to be updated. After processing m detailings of these n detailings, if the tool runs out of memory, when the tool is rerun, it skips the first m detailings (because they have already been processed), and starts processing detailing m+1.
  • Help about the Tool: Use the -help option of the tool for information about possible options the tool provides, and samples of the options' use.