Report Engine connectors return wrong status bits

Report Engine connectors return wrong status bits

Summary

Report Engine Connectors return incorrect status bits in various constellations. This behavior has been fixed. Now the correct status bit is returned.

Description

Report Engine connectors return incorrect status bits in various constellations:

  • The SQL Connector returns incorrect status bits for AML and CEL when exporting via an external storage function and for archives.
  • The Data Storage Connector returns incorrect status bits for AML and CEL when using external storage.
  • The Service Engine Connector returns incorrect status bits for AML and CEL when called without translation.

The reason for returning wrong status bits might be:

  • A combination of SQL Server (and other databases) not supporting unsigned data types and the RES31 bit being set.
    Or:
  • Only N_UPDATE and/or PR_NR is set
    Or:
  • It is a system event

This behavior has been fixed. Now the correct status bit is returned.

To apply the fix:

  1. Install the latest build for version 11 or higher on the Report Engine Server and the Reporting Studio computer. This might be the same device.
  2. Start Reporting Studio and connect to any database on the Report Engine Server.
  3. Click on "Update SQL Server Extensions" in the SQL Server ribbon.

This will enable the fix in any database on the Report Engine server.



Item ID: 260099
Version: 11.00 Build: 117823
    • Related Articles

    • Report Engine: Ability to use status bits

      Summary Several report templates allow use of status bits. Description Status flags can now be filtered in Report Launcher. For this reason, we added the report setting Status flag processing. This filter can be used to filter the data and color the ...
    • FAQ: How can I monitor and react on the communication status of my devices with zenon?

      Data quality is very important to the integrity of a HMI or SCADA system. As such, zenon has numerous ways to monitor the communication status of different devices within your automation environment. Here are some options that you can use in your ...
    • Allocations sometimes assign the wrong status bits.

      Summary The assignment of functional related status bits is sometimes incorrect. DescriptionThe assignment of functional related status bits is sometimes incorrect. Solution Allocation do not assign the following status bits anymore: S_SELECT, S_AUS, ...
    • FAQ: Is it possible to run zenon Report Engine as a service?

      Most of the components of the zenon Report Engine are running as a service.  These are:  SQL-Server (MSSQL$ZA2019) Reporting Services (ReportServer$ZA2019) SQL-Server Agent$ZA2019 for scheduled tasks License Service (zrsLicSrv). Only the Service ...
    • Checklist: The Logic Service to Service Engine connection does not work

      Time estimate:   30 minutes Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative. Screenshot and followed ...