ERROR 3399: Failure in UDx RPC call InvokeSetupUDL(): UDx side process has exited abnormally

tzhang

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