_getNumericAttribute Error on Oracle RDB ODBC Driver

[Kieran]

I receive an error stating:
"Internal Error in _getNumericAttribute: number too big"
when using the Oracle RDB ODBC 3.03 driver to connect to a database via Input tool. The error doesn't always appear, only about 50% of the times I've tried to use that driver through Alteryx.

Alteryx 10.6.8.17850

Any suggestions would be appreciated.

[ChristianR · Accepted solution]

Hi @Kieran

From your error message it looks like you may have hit one of the limitations of using the ODBC Driver

https://help.alteryx.com/10.6/index.htm#DataSources/Oracle.htm

ODBC (Client Versions: 10.02.00.03 (Vista), 10.02.00.01(32 and 64 bit), 11.01.00.06(32 and 64 bit))

• All versions - INT64 is transported as a Fixed Numeric; SQL_C_BIGINT is not supported.

Please make sure that you are indeed not using Bigint fields.  The following community article may be useful to help you resolve the issue:

https://community.alteryx.com/t5/Data-Sources/Having-issues-with-decimals-In-Database/m-p/5772/highl...

Hope that helps.  Please let me know how that goes.

[sbutoliy]

I am getting the same error when I run the InDatabase Alteryx workflows. The data is sourced in Redhshift. The workflows usually throws error in the FOrmula tool or the Union tool. Any ideas why would that happen?