Icon View Incident Report

Serious Serious
Reported By: David Cornelius
Reported On: 8/13/2008
For: Version 2.01 Build 4
# 2752 Using Compression with SAVE UPDATES and Published Tables Can Cause Uncompress Error

Using EDB 2.01 b4 on server database, which gets copied to clients, and using Compression level 6 for all published updates (defined at the table level), the client runs a script which saves updates for several tables using compression 6 (defined in the SAVE UPDATES statement). The updates are copied up to the server. Then, I run a script on the server which loads the updates successsfully, and tries to save its own updates using the same compression level, but it stops on the first table with the message:

Error 1304: An error occurred with the statement at line X and column Y (Error saving updates for the database D (Unknown error occurred with the table T (EDB Error 1201 An error occurred while uncompressing data (Unknown compression method))))

If I turn off compression (set it to level 0) both at the table level and when saving updates (both client and server), it works fine.

Comments Comments and Workarounds
The workaround is to not use compression.

Resolution Resolution
Fixed Problem on 8/16/2008 in version 2.01 build 5

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial