Hi Team,
Getting error while trying to extract data using Denodo Query from Alteryx Desktop whereas the same DB connection works fine in DBeaver.
Can someone assist.
Attached is the flow and error.
Thank You,
Abdulrasheed.
Solved! Go to Solution.
1) try it without an order by (one of the messages tells you not to use order by in-db).
2) turn off amp.
3) if that doesn't work - can you capture additional odbc logs? these things can be hard to diagnose. Also - if you don't use datastream out- can you add a browse? does it work? if so - that would point to a datatype you are brining out.
also, if i use Input Data tool with Same Denodo SQL Query and limiting it to 100 records then it fine but whole set, its failing
Here are the logs captured from ODBC enabled.
denodoODBC_28052.log:
[0.056]DSN info: DSN='DenodoODBC_PROD_64Bit',server='dvprod',port='9996',dbase='te_global_data',user='TE271203',passwd='xxxxx'
[0.058] onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0'
[0.058] conn_settings='(null)', conn_encoding='(null)'
[0.058] translation_dll='',translation_option=''
mylog_28052.log:
[23228-0.002]ci=0000000000000000 globals.extra_systable_prefixes = ''
[23228-0.002]exe name=odbcad32 plaformId=2
[23228-0.002]CC_conninfo_init opt=2
[23228-0.002]copy_globals driver=PostgreSQL Unicode(x64) socket_buffersize=4096
[23228-0.002]aszKey='DSN', value='DenodoODBC_PROD_64Bit'
[23228-0.002]copyAttributes: DSN='DenodoODBC_PROD_64Bit',server='',dbase='',user='',passwd='',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1)
[23228-0.066]copy_globals driver=PostgreSQL Unicode(x64) socket_buffersize=4096
[23228-0.069]getDSNinfo: DSN=DenodoODBC_PROD_64Bit overwrite=0
[23228-0.069]getCommonDefaults:setting ODBCINST.INI position of 000002E99B1911C0
[23228-0.069]ci=000002E99B1911C0 globals.extra_systable_prefixes = ''
[23228-0.069]force_abbrev=0 bde=0 cvt_null_date=0
[23228-0.069]getCommonDefaults:setting ODBC.INI position of 000002E99B1911C0
[23228-0.069]ci=000002E99B1911C0 globals.extra_systable_prefixes = 'dd_;'
[23228-0.069]calling getDSNdefaults
[23228-0.069]checking libpq library
[23228-0.081]psqlodbc path based libpq loaded module=00007FF9CB5A0000
[23228-0.081]libpq hmodule=00007FF9CB5A0000
[23228-0.081]libpq_exist=1
[23228-3.379]GetProcAddres for GetMsdtclog
[23228-12.393]GetProcAddres for SetMsdtclog
[23228-17.913]DETACHING PROCESS
[23228-0.000]ci=0000000000000000 globals.extra_systable_prefixes = ''
[23228-0.000]exe name=odbcad32 plaformId=2
[23228-0.000]CC_conninfo_init opt=2
[23228-0.000]copy_globals driver=PostgreSQL Unicode(x64) socket_buffersize=4096
[23228-0.000]aszKey='DSN', value='DenodoODBC_PROD_64Bit'
[23228-0.000]copyAttributes: DSN='DenodoODBC_PROD_64Bit',server='',dbase='',user='',passwd='',port='',onlyread='',protocol='',conn_settings='(null)',disallow_premature=-1)
[23228-0.050]copy_globals driver=PostgreSQL Unicode(x64) socket_buffersize=4096
[23228-0.050]getDSNinfo: DSN=DenodoODBC_PROD_64Bit overwrite=0
[23228-0.051]getCommonDefaults:setting ODBCINST.INI position of 000002E99B1911C0
[23228-0.052]ci=000002E99B1911C0 globals.extra_systable_prefixes = ''
[23228-0.054]force_abbrev=0 bde=0 cvt_null_date=0
[23228-0.054]getCommonDefaults:setting ODBC.INI position of 000002E99B1911C0
[23228-0.055]ci=000002E99B1911C0 globals.extra_systable_prefixes = ''
[23228-0.058]calling getDSNdefaults
[23228-0.058]checking libpq library
[23228-0.058]psqlodbc path based libpq loaded module=00007FF9CB5A0000
[23228-0.058]libpq hmodule=00007FF9CB5A0000
[23228-0.058]libpq_exist=1
[23228-11.607]ds_options_update: got ci = 000002E99B1911C0
[23228-13.054]GetProcAddres for GetMsdtclog
[28052.23228(Mon Mar 18 22:54:31 2024)]DETACHING PROCESS
[23228-14.287]GetProcAddres for SetMsdtclog
[23228-16.251]DETACHING PROCESS
Just an Update, I have modified source Denodo Query without having NULL columns in the SELECT statement and executed without any issues. Thanks all for your support. and this can be closed.
Thank You.
Yeah I see conn_settings='(null)',disallow_premature=-1) in your connection string. Glad to hear this worked out.