Initialize a Domain - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Hexagon PPM

Intergraph Smart Instrumentation Administration

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Administration & Configuration
Version_SPI_custom
13.1

The following topic guides you through the task of initializing (creating) a domain for use in Smart Instrumentation. There are various ways to initialize a domain:

  • Initialize an empty domain.

  • Initialize a new domain from a DDTI seed file. (Restore a domain backup.)

  • Initialize a new domain using a domain from another database as a source (Oracle or SQL).

  • A DDTI file contains data that is not database dependent. The data in a DDTI file can be imported to any database format (MSS or Oracle) irrespective of its source.

  • A DDTI backup file and a DDTI offline package file contain different data and therefore are not interchangeable, a package file cannot be used to initialize a domain or a domain backup file to export/import a package.

  • Before initializing a domain, familiarize yourself with domain initialization prerequisites.  For details, see Prerequisites for Domain Initialization.

  • In the INtools.ini file, located in the SmatPlant Instrumentation home folder, in the [Database] section, add the following statement: AutoCommit=TRUE

  1. Start the Administration module to open the Logon Information dialog box with DBA displayed in the User name box.  This is the default user name that enables you to log on to the Admin schema.

  2. In the Password box, type DBA, the default password you use to log on to the Admin schema.

  3. Click OK to open the System Administration window.

  4. Click File > Initialize.

  5. On the Initialize dialog box, in the Domain box, type the domain name, which must be unique in the current database, start with a letter, and contain only alphanumeric characters without spaces.  You can use an underscore (_) to indicate a space.

  • You can use a name of previously deleted domain.

  • You can modify the domain name after completing the initialization.  For details, see Make Domain Definitions.

  1. In the Domain schema name box, type the logon name of the domain schema, which must be unique in the current database, start with a letter, and contain only alphanumeric characters without spaces.  You can use an underscore (_) to indicate a space.  The software needs to use this name internally to connect to this domain.

  2. In the Domain schema password box, type the logon password of the Domain schema, which must be unique in the current database, start with a letter, and contain only alphanumeric characters without spaces.  You can use an underscore (_) to indicate a space.

    SHARED Tip The schema password must be different from the domain name.  We recommend that you write down the schema password and keep it in a safe place.  When initializing a domain, the software changes all the password characters to upper case.  This means that if the Domain schema name is MY_DOMAIN, you cannot use my_domain as the password string.

  3. In the View-Only Domain schema password box, accept the default password of the View-Only Domain schema or change it as appropriate, provided the setting is unique in the current database, starts with a letter, and contains only alphanumeric characters without spaces.  You can use an underscore (_) to indicate a space.

    SHARED Tip The default password and the characters that you type when changing the password appear masked.

  4. Proceed to the relevant section.

    Empty Database

    1. Under Target Domain type, to determine the type of the domain that you want to initialize, select one of the following options:

      • Owner operator — Allows you to initialize the domain as a domain with As-Built functionality.  The database is partitioned into several schemas: a single schema for As-Built and separate schemas for projects.

      • Engineering Project Company - Project Mode — As with the owner operator mode, this mode allows you to initialize the EPC domain as a domain with Project Center functionality.  The database is partitioned into several schemas: a single schema for Project Center and separate schemas for projects.

        The functionality of the EPC-Project mode domain is exactly like the Owner Operator domain, the only difference is instead of the domain being called As-Built it is called Project Center.

      • Engineering company — Allows you to initialize the domain as a domain contracted to design and build plants based on process information.  A domain of the Engineering company type usually involves one set of data which may be revised extensively during the life cycle of the plant.  In this case, the data for each project is maintained within a single database schema.  Once a plant is operational, the domain type can be changed to Owner operator if required, and the owner can perform the necessary maintenance and modernization.

        SHARED Tip During the initialization process, the software might display various error message that do not cause the initialization process to fail.  If you want to prevent the software from displaying these message, select the Do not display error messages check box.  After completing the initialization process, you can view the error messages recorded in the InitLog.txt file, which appears in the Smart Instrumentation home folder.

    Seed File/Database

    1. Under Target Domain type, to determine the type of the domain that you want to initialize, select one of the following options:

      • Owner operator — Allows you to initialize the domain as a domain with As-Built functionality.  The database is partitioned into several schemas: a single schema for As-Built and separate schemas for projects.

      • Engineering Project Company - Project Mode — As with the owner operator mode, this mode allows you to initialize the EPC domain as a domain with Project Center functionality.  The database is partitioned into several schemas: a single schema for Project Center and separate schemas for projects.

        The functionality of the EPC-Project mode domain is exactly like the Owner Operator domain, the only difference is instead of the domain being called As-Built it is called Project Center.

      • Engineering company — Allows you to initialize the domain as a domain contracted to design and build plants based on process information.  A domain of the Engineering company type usually involves one set of data which may be revised extensively during the life cycle of the plant.  In this case, the data for each project is maintained within a single database schema.  Once a plant is operational, the domain type can be changed to Owner operator if required, and the owner can perform the necessary maintenance and modernization.

        SHARED Tip During the initialization process, the software might display various error message that do not cause the initialization process to fail.  If you want to prevent the software from displaying these message, select the Do not display error messages check box.  After completing the initialization process, you can view the error messages recorded in the InitLog.txt file, which appears in the Smart Instrumentation home folder.

    2. Click Source.

    3. In the Source Data Connection dialog box, from the Database type drop-down select list, select the required source type. The software automatically detects and displays your database software and SI Source File.

    Depending on your choice, the dynamic dialog box displays the required fields for data input.

    SI Source File

    The Si Source File is the Smart Instrumentation domain backup that has been saved as a DDTI file

    1. Click Browse.

    2. In the Select Source Seed File Path dialog box, locate and select the required seed file (.ddti).

    3. Click Connect.

    4. From the Domain select list, select the required domain.

    5. If initializing a project for working with As-Built, from the Project select list, select the required project.

    6. Select any available, required optional feature:

    • Save last ID for merging renamed items.

    • Copy users & departments to target domain.

    1. Click OK.

    SQL Server or Oracle database

    Select this option if you are initializing a domain from an SQL Server or Oracle database.

    1. In the Server and Database name fields type the required information.

      The Admin schema name and Admin schema password are inserted automatically.

    2. Click Connect.

    3. From the Domain select list, select the required domain.

    4. If initializing a project for working with As-Built, from the Project select list, select the required project.

    5. Select any available, required optional feature:

    • Save last ID for merging renamed items.

    • Copy users & departments to target domain.

    1. Click OK.

  5. Click OK to start the initialization process.

After completing the initialization process, it is strongly recommended that you update the current database statistics for the initialized domain. Updating statistics improves the database performance.  For details, see Update Statistics.