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.
Solved! Go to 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))
Please make sure that you are indeed not using Bigint fields. The following community article may be useful to help you resolve the issue:
Hope that helps. Please let me know how that goes.
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?