Vertica UDx error

avinash1

Hi Team,

When we are inserting data into Vertica table getting below error.

Insert Query:

insert into xyz.vertica_table
(select
9999999999,
'tbl_order_address_20200930.dat',
crm_order_id,
xyz.secureprotect('UniCode',legl_hous_numb),
xyz.secureprotect('UniCode',legl_room),
xyz.secureprotect('UniCode',legl_moo),
xyz.secureprotect('UniCode',legl_vill),
xyz.secureprotect('UniCode',legl_soi),
xyz.secureprotect('UniCode',legl_road),
legl_sub_dist,
legl_dist,
legl_prvn_code,
legl_cnty_code,
legl_pscd_code,
legl_pscd_seqn,
xyz.secureprotect('UniCode',mail_hous_numb),
xyz.secureprotect('UniCode',mail_room),
xyz.secureprotect('UniCode',mail_moo),
xyz.secureprotect('UniCode',mail_vill),
xyz.secureprotect('UniCode',mail_soi),
xyz.secureprotect('UniCode',mail_road),
mail_sub_dist,
mail_disc,
mail_prvn_code,
mail_cnty_code,
mail_pscd_code,
mail_pscd_seqn,
xyz.secureprotect('AlphaNumeric',home_numb),
xyz.secureprotect('AlphaNumeric',offi_numb),
xyz.secureprotect('AlphaNumeric',home_fax),
xyz.secureprotect('AlphaNumeric',cntc_emal),
sms_prfr_lang,
crtd_by ,
crtd_dttm,
updt_by ,
updt_dttm,
xyz.secureprotect('UniCode',cntc_name),
xyz.secureprotect('AlphaNumeric',cntc_numb),
xyz.secureprotect('AlphaNumeric',offi_fax),
xyz.secureprotect('UniCode',mail_addr_1) ,
xyz.secureprotect('UniCode',mail_addr_2) ,
xyz.secureprotect('UniCode',legl_addr_1) ,
xyz.secureprotect('UniCode',legl_addr_2) ,
'2020-09-30',
9999999999,
current_timestamp,
'ver_duser1',
'mnp_tbl_order_address_3g_j_op_ods_vertica_hdfs_load_archival_Daily',
null
from xyz.sample_external_table
);

Error:
[Code: 3399, SQL State: VP001] [Vertica]VJDBC ERROR: Failure in UDx RPC call InvokeProcessBlock(): Error in User Defined Object [secureprotect], error code: 1003
Failed to instantiate LibraryContext object.: C++ toolkit exception thrown; status code: 72; description: VE_ERROR_THREAD_LOCAL_DATA

Regards,
Avi

SergeB

Could open a support ticket so that we can capture more details on your setup?