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:
- 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.
- Start Reporting Studio and connect to any
database on the Report Engine Server.
- 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 ...