Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the 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
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
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!