AE DB Load

Administrators use the utility AE DB Load ucybdbld ( see Utility DB Load) to load data to the AE database for various purposes. You can load initial data , contents that have been transported with the transport case, or contents for calculating the expected runtimes of executable objects. You can also load Rapid Automation solutions with this utility.

Start the Utility

Follow one of the options below:

Windows

• *G.EXE (ucybdbldg.exe)

  Regular utility start, G stands for the graphical user interface

• *.EXE

  Program to which start parameters can be assigned for batch calls, see Start Parameters - Utilities

• *.BAT

  Batch file for the utility

UNIX

• *.sh

  Regular utility start

• Without file ending

  Program to which start parameters can be assigned for batch call.

Load Data to the Database

AE DB Load automatically identifies the loading type and allows you to

• Load data for new and upgrade installations

The utility creates the database scheme and loads INITIAL and DEFAULT data. Select the <DB directory>\DB\GENERAL\<vers>\UC_UPD.TXT file of the version you require. When you load initial data to the AE database, a dialog displays in which you can configure ILM. For more information see Maintaining Data Records with ILM.

When you install or update the database, a dialog displays in which you can select the authentication method. Enter the pass phrase in the text fields of the options Server and Server and Agent. It is used to generate the company key. For more information, see Agent Authentication.

• Load data that has previously been unloaded by using AE DB Unload

Contents of transport cases or specific tables are stored in the file UC_DATA.TXT. You can load them to the same or to a different AE database. The target system must use the same service pack version as the source system or a later one for this purpose. For more information, see Transporting Data.

• Calculate an expected runtime (ERT)For this, the value of the parameter ERT_CALCULATION in the variable UC_CLIENT_SETTINGS must be configured to BATCH. Select the DB directory>\DB\GENERAL\<vers>\UC_UPD_ESTIMATE_ERT. TXT file which automatically calculates the runtime, and load it to your database. The last line of this file calls the ERT-calculation function. By default, it includes the whole AE system but you can also define a specific client. For more information, see ERT_CALCULATION and UC_CLIENT_SETTINGS - Various Client Settings.

Example

ESTIMATE_ERT 1000

Possible Messages and Errors

• If an SQL error occurs while you update the database or load initial data, a dialog displays which offers the following options:
  • Retry re-processes the SQL commands starting from the position where the error occurred. Processing continues if the problem does not occur again.
  • Cancel ends the loading process and the utility.
  • Ignore skips the command that caused the error.

  Important: Ignore and Cancel can result in an inconsistent database. A corresponding message displays that you must confirm if processing should continue.

• Message U0038128 displays and informs you that the utility version and the database version do not match. This happens when you try to load transport-case data while revisioning is active in the AE system.

  Important: Do not cancel the utility AE DB Load. It will start the loading process as soon as it has finished processing the data that is required for revisioning (see AE DB Revision Report). This procedure ensures that no data that is relevant for the revisioning process is lost even if you load data several times. Depending on the size of objects that should be loaded, this process may take some time.

See also:

• Start Parameters - Utilities
• ILM - Information Lifecycle Management