English

Error: Cannot copy a feature class table into Informix 10 database; Underlying DBMS error. DBMS table not found. The specified table is not in the database

Error Message

If a feature class table is copied and pasted into an Informix/SDE database, the following error returns:

Underlying DBMS error.
DBMS table not found[[Informix][Informix ODBC Driver][Informix]The specified table (sde.table_name) is not in the database.][sde:sde.table_name][STATE_ID = 0]

The following issues may be related to this error:

1. A new, empty feature class table can be created, but data cannot be added to it.

2. Existing feature class tables cannot be previewed. The same error message is returned.

Cause

The Locale settings for both database and client do not match.

Prior to Informix 10.00.xC4, IDS had no issue if the DB_LOCALE environment variable was set to en_US.CP1252 on the client and set to EN_US.8859-1 or EN_US.819 on the database server.

For Informix 9.4 TC5, the problem is not the locale settings, but is related to an IDS bug fix in version 10.00.xC4. The defect is:

171156 ABLE TO CONNECT TO DATABASE CREATED WITH UTF8 LOCALE WITH CLIENT WHEN DB_LOCALE SET TO EN_US.8859-1

Solution or Workaround

Follow the instructions to set both the client locale and the database locale to 'en_US.819' (or other setting that has been used for the database) for the ODBC DSN environment setting.

Change Informix ODBC Driver settings:

In Windows:
Go to Start > Control Panel > Administrative Tools > Data Source (ODBC) > System DSN > click the Informix data source name that was created > Environment tab > Check 'Use Server Database Locale'.

If the Database Locale changes to en_US.819 for example, then 'en_US.819' can be copied/pasted to the Client Locale to replace the original one ('en_US.CP1252').