Report Engine: Generating Report with Data from Linked Server with Date/Time Format (Month, Day, Year, 12h) causes errors
Description
Report generation
failed for a broader date range because the linked server's datetime used a
Month/Day/Year 12-hour format, which caused timestamp parsing errors.
The issue has been
addressed and the behaviour is now as expected.
To benefit from this fix:
- Update your zenon Software
Platform to the latest build of zenon 12 or higher.
Item ID: 316118
Version: 12.00 Build: 601779
Related Articles
FAQ: What is the time zone and time format used in zenon Software Platform products and what needs to be considered?
When you ask someone what the time is, they'll usually be able to tell you. But when you ask them what date and time sunrise was yesterday in a different country on a different continent, in a different hemisphere it gets less easy. Terms like GMT ...
Checklist: Data Missing in Service Engine
Time estimate: 60 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. Checklist usage: #. [Quick hints] ...
FAQ: How, where, why and when does zenon Service Engine save data?
zenon Disk Space Handling: The zenon Service Engine, by default, stores process data on the hard disk. This is true for a standalone zenon project, as well as the zenon Service Engine server(s) in the zenon network topology. This data consists of ...
Checklist: Printer does not print in the format as expected
Time estimate: 15 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. No .frm file is used to specify ...
FAQ: How can I backup the Service Engine data, the data created during Service Engine?
The path of the Service Engine folder can be amended in the project properties and it is set into zenon6.ini (VBF30=) when the start project is set in Engineering Studio or in zenon Startup Tool. In the Service Engine folder, there is the subfolder ...