IEA Software, Inc.

IEA Software Knowledge Base - ID:55903

IEA Knowledge base

Emerald Billing (KB ID: 55903)

Sep 13 2005

Using Emerald 4.5.11 or earlier when exporting realtime card transactions or importing a batch of transactions the following error is displayed: credit card Import query failed. [Microsoft][ODBC SQL Server Driver][SQL
Server]String or binary data would be truncated. How can this problem be fixed?

Sep 13 2005

The most likely cause is someone entering a credit card number having more than 16 digits (And passing the card validation algorithm). The problem can be resolved by expanding the size of the AccountNumber field in the ExternalTrans table by running the following query against your Emerald4 database: (Admin/Database/SQL Query)

ALTER TABLE ExternalTrans ALTER COLUMN AccountNumber VARCHAR(20)

Next retry the export or import batch.