Specifications

20 – Using PlantScape Data in Other Applications
420 R400
Configuring the Report Setup Options
Restricting Data Upload
Data read from the ODBC database into the PlantScape server database can be
restricted in two ways by stopping:
• Point PV values from being written to
• Point history values from being written to
If you do not want to allow operators to overwrite PV or history value data on the
PlantScape server database, make sure that the Enable PV Upload and Enable
History Data Upload options are not enabled.
Storing Failed Commands
If you wish, you can store commands that have produced database errors by
enabling the Enable Failed Commands Backup option. If this option is enabled, a
backup file is created or appended to whenever an error occurs as a result of a
failed SQL command. There is one backup file per report. The reports use the
naming convention rptnnn.bak where nnn is the report number.
Any command that results in an error from the SQL database server, as well as
those remaining commands which were not executed as a result of the error, will
be copied to this backup file, and a message is sent to the log file giving details of
the error.
The backup file, if it exists, is run before the Input Reference file each time the
report is requested. Execution of the backup file will halt if any SQL command
results in an error. Any commands successfully completed from the backup file
will be removed from that file. The backup file can be edited or deleted to stop
the same erroneous commands being processed.
If any errors are detected, the report status will be set to ERROR and an alarm
(priority determined by the “Alarm priority error” combobox) is raised.
Enabling Auto-Commit for SQL code
If you enable the Auto-Commit SQL Code option, PlantScape will automatically
commit each command in the Input Reference file as it is executed. This means
that any rollback commands issued will not be effective, and if a command fails,
all previous commands will already have been carried out.
If this option is not enabled, the commands will be committed after successful
completion of the report, or rolled back in the event of an error in the report. If
you would like to perform commit or rollback operations at any other time
during the report, these must be included in the Input Reference file.
plscpcg.book Page 420 Monday, May 28, 2001 10:11 AM