Versions Compared

Old Version 2

changes.mady.by.user Evgeniya Kononova

Saved on

compared with

New Version Current

changes.mady.by.user Bahdan Tsiulkou

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

External The external event protocol viewer is created with using the help of the idb.exe utility.

Note
titleAttention!
If you use the Time and Attendance module is in use ( the module system that is a part of the Access Manager module of the ACFA PSIM subsystem) , use the RemoteProtocolConnector utility to extract the event protocol viewer into a separate an individual database—see Axxon PSIM Web WEB Report System PSIM. User Guide (the most recent version of this document is available in AxxonSoft documentation repository).
Info
titleNote

To operate the Report SystemFor the report system to operate, which is a part of the base Axxon PSIM, use the method of extracting the event protocol viewer into a separate database is used. The method an individual database that is described in this section , i.e. using the idb.exe utility. Configuration of the connection to such protocol DB is required in the Report SystemIn the report subsystem, which is a part of the base Axxon PSIM (see Connecting to the Events Log (PROTOCOL table))., you must configure the connection to such a database protocol.

First, you must It is necessary to create the protocol database beforehand with the help of using the MS SQL Server program. Do For this, do the following:

  1. Open Microsoft SQL Server Management Studio Express;
  2. Select Databases.
    Image RemovedImage Added
  3. Right-click and select New Database…
  4. Specify In the New Database… window that opens, enter the name of the protocol database name in the the Database name line in the New Database dialog window.
    Image RemovedImage Added
  5. To create a the new protocol database, click the OK button. 
  6. Shut down Close Microsoft SQL Server Management Studio Express by clicking the Close X button in the upper right corner of the dialog window.

As a result, the protocol database is created.

To enable connect the external event protocolviewer, do the following:

  1. Run Open the idb.exe utility (see Starting and shutting down the idb.exe utility).Select the Protocol database from the Select source database
  2. In the Select data source: drop-down list, select the database for the Protocol administering.
    3. Image Removed
  3. Image Added
  4. To enable the mode if using the Protocol database, set the Use checkbox.
    Image RemovedImage Added
    As a result, the Configure  Image Added button becomes active.
  5. To connect configure the connection to the the Protocol database, click the Configure the Image Added button. As a result, the Data link propertiesLink Properties dialog window appearsis displayed on the screen.
  6. Go to the In the window that opens, go to the Provider tab.
  7. Select the Microsoft OLE DB Provider for SQL Server item from the the OLE DB Provider(s) list.
    Image RemovedImage Added
  8. Click the Next button.  You will be You are automatically redirected to the the Connection tab.
  9. Do the following in the Connection tab:
    1. Select a server name from the From the 1. Select or enter a server name: drop-down list, select the server name. 
      Image RemovedImage Added
    2. In the Specify the user name in the User name field and , specify the password in user name.
    3. In the Password field, enter the password.
    4. Set the Allow saving password checkbox.
    5. Go to the All tab.
      Image RemovedImage Added
    6. In the Persist Security Info field, set the True value. This is necessary to correctly save the user password.
      Info
      titleNote

      Each time you change the server connection parameters, you must set the True value in the Persist Security Info field value to True.

    7. Select the protocol database in the From the 3. Select the database on the server drop-down list, select the protocol database.

      Info
      titleNote

      You must select a database at this step. If you leave the database field blank, then after you close the Data Link Properties window, the line "Database is not set in connection settings" appears in the database description window of the IDB idb.exe utility, and the OK button to save changes is becomes inactive.

    8. Click the Test Connection button.

    9. If you successfully connect to the connection to MS SQL Server is successfully establishedserver, then the Test connection succeeded message appearsis displayed.
      Image RemovedImage Added

    10. Click the OK button in the message window . The window closes automatically.

  10. Select the dbi file. Click the button next to the Select dbi-file information field.

    1. to close it.

  12. Click the Update database button to start the process of updating the database structure.
    Image AddedAs a result, the
    13. Open dialog window appears.
  13. Select the database structure file C:\Program Files\Axxon PSIM\protocol.dbi.
    Image Removed
    14. Click the Update database button to update the database in accordance with the psim.dbi file specified in the Select dbi-file field.
    Image Removed
    As a result, database update starts. Information about this process is
  14. process of updating the database structure starts with the corresponding messages that are displayed in the Protocol table. 
    15. Database
  15. The structure is updated
    16. ,
  16. when
    17. there is
  17. the
    18. Database
  18.  Data Updating is completed! message is displayed in
    19. the
  19. the Protocol table.
  20. To save Axxon PSIM connection parameters to the Protocol database, click the OK button. As a result, the dialog window closes automatically.

External event protocol is created and connectedCreating and connecting the external event viewer is complete.