Resolution:
Description:
===========
 Attempting to retrieve any BIGINT value from the database fails with the error, “Error converting data type bigint to int”. If we try to insert any BIGINT value into the database, the value is incorrect.

Environment:
============
All supported versions of TIBCO iProcess Engine (SQL).
All Supported Operating Systems.

Symptoms:
==========
The EAIDB steps fails with the following error while selecting a BIGINT column and mapping it to a NUMERIC output field:

2012/09/24 09:41:47.059669(BG:4:2496:2:SPTEST1:2047815:SPCALL:pro:proeai.c:81845:3601): 1869-Procedure:SPTEST1 EAI Step:SPCALL Case:2047815 EAI plug-in EAIRun_Call() failed, error: SQL_SYS_ERR - MS-SQL error code :8114 - [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type bigint to int.
2012/09/24 09:41:47.081640(BG:4:2496:0:SPTEST1:2047815:SPCALL:pro:cplmain.c:81512:2388): 1631-WARNING: <CPLInstruction - Error> <-2> <RELEASE> <RELEASE^SMSPHwfeE969^112:0.0^2^^2047815^2047815^pro^SMSPHwfeE969^C1^^5^09/24/2012^08:56^34206183^SMSPHwfeE969^SW_TRANSACTION^1^>
2012/09/24 09:41:47.088976(BG:4:2496:2:SPTEST1:2047815:SPCALL:pro:swbgmbd.c:82103:1113): 1864-Transaction failure : Reason code = -2

Cause:
=======
BIGINT datatype is not supported.

Resolution:
==========

Either of the following workarounds may be implemented based on the requirements.

OPTION 1 - Use a text field to map the BIGINT values. The text length should be configured to 20.

OPTION 2 - Define a numeric field with length 18 and decimal places greater than 0 (say 2). This workaround may not be able to accommodate the maximum bigint value.

In TIBCO iProcess Engine (SQL), use of BIGINT data type with the EAI DB plugin fails.