Technical FAQs

Ask a Question

WebReach Queries Fail with an Time Conversion Error

Goals and Symptoms

Summary

When  WebReach is used to retrieve historical data, it fails with an error indicating a problem with timestamp conversion.

Symptoms

A query sent in WebReach fails to return any data, but instead fails with the following error message:

Error Type:
PEGQuery (0x80040C8E)
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

Facts

This article applies to the following product(s):

ION Enterprise 5.0

Causes and Fixes

Cause

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.

Resolution

Apply Service Pack 1 for ION Enterprise 5.0.

Workaround

There is no workaround, other than to change the date range so a problem timestamp is not included.

  • Original article#10139

    Public

    All content © 1992-2007 Schneider Electric

Was this helpful?
What can we do to improve the information ?