The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as Facility Hero) app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
Goals and Symptoms
When WebReach is used to retrieve historical data, it fails with an error indicating a problem with timestamp conversion.
A query sent in WebReach fails to return any data, but instead fails with the following error message:
Error with provideHTML. Error with GenerateHTML. WebReachHistoricalASP in GetQuery: -2147218290 Cannot execute default connection: An error occurred in Execute: An error occurred while setting timestamp to string: An error occurred converting unix time to system time: Invalid procedure call or argument
/ion5/Historical/GetLogs.asp, line 31
Facts and Changes
This article applies to the following product(s):
ION Enterprise 5.0
Causes and Fixes
This problem would occur if any timestamp in the recordset returned from the database contained a millisecond portion that became zero when rounded to three digits.
Apply Service Pack 1 for ION Enterprise 5.0.
There is no workaround, other than to change the date range so a problem timestamp is not included.
All content © 1992-2007 Schneider Electric
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!