Vertica database setup with voltage SecureData
after initial databse session,
testing syntax as follow,
SELECT VoltageSecureProtect('123-45-6789' USING PARAMETERS format='Numeric');
database retrun following error.
08:47:19 FAILED [SELECT - 0 rows, 0.024 secs] [Code: 5861, SQL State: VP001] [Vertica]VJDBC ERROR: Error calling setup() in User Function VoltageSecureProtect at [/data/qb_workspaces/jenkins2/ReleaseBuilds/Grader/REL-9_2_1-x_grader/build/udx/supported/voltagesecure/VoltageBase.hpp:222], error code: 15, message: Error initializing: Unrecognized Voltage SecureData error encountered. Please contact Voltage SecureData support for help.
What are the additional steps required for me to resolve above error?
I have performed the following steps as documented in Vertica.
1. Verify that Vertica has the right root certificate authority (CA) to authenticate with SecureData.
2. Grant users access to the SecureData library.
3. Configure parameters to tell Vertica how to access SecureData.
Any help with be appreciated, Thanks.