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)