ERROR 3399: Failure in UDx RPC call InvokeSetupUDL(): UDx side process has exited abnormally
I had ODBCLoader configured to query SybaseIQ data. I upgraded Vertica from 8.0.0-2 to 8.0.1 earlier this month. After that, I re-compiled the ODBCLoader, re-install the new library. Now, the ODBCLoader no longer works.
The error message on vsql:
ERROR 3399: Failure in UDx RPC call InvokeSetupUDL(): UDx side process has exited abnormally
The following is from the log file:
2017-01-25 11:29:15.715 Init Session:7ff7acdfa700 [Session] <INFO> [Query] TX:0(ert_moncust_node0003-453071:0x7647f) copy moncust.dstfactor WITH SOURCE ODBCSource() PARSER ODBCLoader(connect='DSN=IQPGMQS2B; UID=zzhang3; PWD=passwd',query='select * from ceshist.dstfactor;');
2017-01-25 11:29:15.717 Init Session:7ff7acdfa700-c000000001ecf8 [Txn] <INFO> Begin Txn: c000000001ecf8 'copy moncust.dstfactor WITH SOURCE ODBCSource() PARSER ODBCLoader(connect='DSN=IQPGMQS2B; UID=zzhang3; PWD=passwd',query='select * from ceshist.dstfactor;');'
2017-01-25 11:29:15.720 Init Session:7ff7acdfa700-c000000001ecf8 [EE] <INFO> Trying to set up a new UDx side process
2017-01-25 11:29:15.745 Init Session:7ff7acdfa700-c000000001ecf8 [LocalPlanner] <INFO> finalizeThreadsToUseForLoad(): max_threads_allowed = 48, targetThreads = 1
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [VMPI] <INFO> Hurry: processing for session ert_moncust_node0003-453071:0x7647f, call 5 of type 8
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceling state NO EXECUTION(0): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceled state NO EXECUTION(0): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceling state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: already canceled c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceled state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [VMPI] <INFO> Hurry: processing for session ert_moncust_node0003-453071:0x7647f, call 5 of type 8
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceling state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: already canceled c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceled state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceling state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: already canceled c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceled state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [VMPI] <INFO> Hurry: processing for session ert_moncust_node0003-453071:0x7647f, call 5 of type 8
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceling state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: already canceled c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceled state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceling state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: already canceled c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceled state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [VMPI] <INFO> Hurry: processing for session ert_moncust_node0003-453071:0x7647f, call 5 of type 8
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceling state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: already canceled c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceled state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceling state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: already canceled c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceled state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceling state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: already canceled c000000001ecf9
2017-01-25 11:29:15.767 Spread Client:7ff7aebfd700 [Dist] <INFO> Dist::cancelPlan: canceled state CANCELED(4): c000000001ecf9
2017-01-25 11:29:15.768 Init Session:7ff7acdfa700-c000000001ecf8 <ERROR> @v_vert_moncust_node0003: VP001/3399: Failure in UDx RPC call InvokeSetupUDL(): UDx side process has exited abnormally
LOCATION: makeUDxRemoteProcedureCallHandlingErrors, /scratch_a/release/svrtar11561/vbuild/vertica/EE/EEUtil/UDxFenceSupport.cpp:497