Feedback
Did this article resolve your question/issue?

   

Article

Greenplum ODBC driver does not handle vacumm db warning

Information

 
TitleGreenplum ODBC driver does not handle vacumm db warning
URL NameGreenplum-ODBC-driver-does-not-handle-vacumm-db-warning
Article Number000178402
EnvironmentProduct: Connect/Connect64 XE for ODBC Greenplum Wire Protocol driver
Version: 07.01.0099, 7.1
OS: All supported platforms
Database: Greenplum
Application: ODBC Administrator, ODBC Test
Question/Problem Description
DataDirect Greenplum ODBC driver returns an incorrect error and terminates the connection when the Greenplum database returns a warning regarding vacuuming the database
Steps to ReproduceSteps to reproduce issue:
Connect to a Greenplum database that returns a vacuum database warning.

Observed Results
The below error is returned and the connection is terminated.

Expected Results:
The driver should connect successfully with SQL_SUCCESS_WITH_INFO and return the vacuum database warning message similar to "[DataDirect][ODBC Greenplum Wire Protocol driver][Greenplum]WARNING: database "xxx" must be vacuumed within 2147482338 transactions(Hint To avoid a database shutdown, execute a full-database VACUUM in "xxxx".; File varsup.c; Line 109; Routine GetNewTransactionId; )"
Clarifying Information
Error Message[DataDirect][ODBC Greenplum Wire Protocol driver]The Connect Series for ODBC Greenplum Wire Protocol driver is only licensed to connect to Greenplum databases. You are attempting to connect to the following type of server:
Defect NumberDefect 48490
Enhancement Number
Cause
Resolution
Fixed in hot fix 07.01.0101 (B0152, U0096) and 07.16.0256 (B0314, U0208).

Refer to "Connect and Connect64 for ODBC hot fix download and install instructions" for instructions on how to download and install the hot fix.
Workaround
Notes
Last Modified Date11/20/2020 7:20 AM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.