dcsimg

The ODBC driver crashes when exporting values exceeding two billion

Products

Webtrends Analytics 9.x
Webtrends Analytics 8.x

Issue

Exports of ODBC fields with values exceeding two billion result in failure.

Cause

The Webtrends ODBC driver, being a a 32-bit application, has a maximum integer size of 2^32 or 2147483648.

Resolution

The following methods are possible workarounds:
1. Retrieve the data using REST or Webtrends Web Services.
2. Export to a CSV as the numbers will be exported as text.