Upgrading the network model

The upgrading procedure repeatedly involves starting and stopping Optima services. For information on checking, starting, and stopping Optima services: → Managing Optima services.

Some steps of the procedure may slightly vary depending on your installation scenario. Make sure you follow the instructions that match your scenario (→ Installation scenarios).

Requirements for being able to upgrade the network model

Important:  During the update, Optima must be stopped and restarted. It is good practice to notify in advance all persons who might be affected by the upgrade process.

  1. On a machine that has Visum installed, copy the current model and the simulation model to an empty folder.
  2. Copy the script saveAll.vbs to the same folder.
  3. Rename the current model to: CurrentModel.ver
  4. Open the current model in Visum.

  5. Drag the script saveAll.vbs to Visum.

    The script exports the model into a set of text-based files located in the same folder as the file CurrentModel.ver. Ignore the warnings about missing attributes.

    The resulting files are:

    • CurrentModel.dmd
    • CurrentModel.xml
    • CurrentModel.net
  6. Close Visum without saving.
  7. Rename the simulation model to SimulationModel.ver.
  8. Open the simulation model in Visum.

  9. Drag the script saveAll.vbs to Visum.

    The script exports the model into a set of text-based files located in the same folder as the file SimulationModel.ver. Ignore the warnings about missing attributes.

    The resulting files are:

    • SimulationModel.dmd
    • SimulationModel.xml
    • SimulationModel.net

Step 1: Creating an empty database

  1. On the .NET server, copy the files generated previously plus the file tprb.sql to the folder /model_update/ within the TDE installation folder.
  2. Connect to the database server by selecting it from the list on the left panel.
  3. Open the folder: $TDE/database_definition
  4. Right-click the script: create-empty-db.bat

  5. On the shortcut menu, click Edit.

    Caution:   Do not run the script now!

  6. Change NEW_DB_NAME to a name that does not yet exist in the database list.
  7. Make sure that the connection parameters point to the server that hosts the Optima database.
  8. Double-click the script to execute it.
  9. Open pgAdmin 4.
  10. Verify that the new database has been created.

Step 2: Importing the model

  1. Open pgAdmin 4.
  2. Truncate all model tables by using: \TDE\scripts\DB_TRUNCATOR.sql
  3. In the installation path of TDE, open the folder: \TDE\exec\

  4. Verify the configuration file CommandLineTDE.csv (→ Methodology and Configuration).

    The following table gives you some hints to configure TDE:

    Key Description Notes
    DS_OPUT Connection string to the Optima real-time database The parameter Database must match the name of the database created
    DS_MAIN Path to the current model Do not add any file extension
    DS_NETW

    DS_TATTDS_LKST

    		Path to the simulation model Do not add any file extension
    DS_DEMD



    DS_DEMS

    		−2 to disable the .dmd files

    −2 to disable the .dmd files

    		 Use −1 if you use the .dmd files
    DS_FUNC −2 to disable the .xml files Use −1 if you use the .xml files
  5. Execute TDE_GUI.exe. (To do so, select Execute in the review window.)

Step 3: Importing the TPRB table (and if provided the RLIN_TSYS_TRE_EQUA table)

  1. Copy the file
    \TDE\model_update\tprb.sql
    into the folder
    \TDE\database_definition\custom_scripts\
  2. Open the folder: C:\optima\optima_zip\PTV-Optima-XXXXX\optima-db\custom_scripts

  3. Right-click the file: load-custom-script.bat

  4. On the shortcut menu, click Edit.

    Caution:  Do not run the script now!

  5. Change NEW_DB_NAME to a name that does not yet exist in the database list.
  6. Make sure that the connection parameters point to the server that hosts the Optima database.
  7. Execute the script: load-custom-script.bat

Step 4: Verifying the validity of the database

On the .NET server:

  1. Open the TDE log file:

    C:\optima\TDE\LogFile_TDE_GUI.log

    Important:  It is MANDATORY to check for the absence of ERROR messages in the log file.

  2. Open pgAdmin 4.

  3. Click Ctrl+E to open the Query Manager.

  4. Execute the following queries to verify basic database integrity (click F5 to execute a query):

    • SELECT COUNT(*) from link must return the number of assignment links of the model (greater than zero).
    • SELECT COUNT(*) from strt must match the number of links in the Navteq network (greater than zero).
    • SELECT COUNT(*) from lkst must be greater than zero.

If all the checks listed have been successful, you get a valid DB.

This step involves starting and stopping services. For information on how to stop and start Optima services: → Managing Optima services.

  1. On the server that hosts the .NET components:

    1. Stop the service: PTV Optima AS.
    2. Stop the service PTV Optima TRE.
    3. Stop the service Hyperpath.
    4. Stop the service PTV TrafficDataWarehouse.

  2. Rename the old database:

    1. Open pgAdmin 4.
    2. Right-click the database optima.
    3. Click Properties.
    4. Change the name to optima_backup.
    5. Click Save.

  3. Rename the new database:

    1. In pgAdmin 4, right-click the database you previously created.
    2. Click Properties.
    3. Change the name to optima.
    4. Click Save.
  4. Start the service PTV Optima AS.
  5. Start the service PTV Optima TRE.
  6. Start the service Hyperpath.
  7. Start the service PTV TrafficDataWarehouse.