Troubleshooting - Privacera Vertica Encryption Setup¶

This document provides solutions to common issues encountered during the setup of Privacera Encryption for Vertica.

Verify the Privacera Vertica UDX Version¶

1
2

cd /opt/privacera/encrypt/
cat privacera_version.txt

Verify the Logs¶

1
2

cd /vertica/data/<database-name>/<database_name>_<node-number>_catalog/UDxLogs
tail -f UDxFencedProcessesJava.log

Verify the MD5 Sum of the Privacera Encryption Jar¶

Get the MD5 sum of the Privacera PEG Vertica UDF Jar and note it down¶

1
2

cd /opt/privacera/encrypt/
md5sum privacera-peg-vertica-udf-v2.jar

Get the stage lib MD5 sum by executing the below SQL command¶

1

SELECT lib_name, md5_sum FROM USER_LIBRARIES WHERE lib_name = 'PRIVACERA';

✅ The values of both should match.

Error: Return Status: 500 while executing the UDF¶

1

Unexpected response for POST:https://<PEG_SERVER_API_BASE_URL>/scheme/scheme_by_context, Return status: 500

This error typically occurs when the Encryption service is Disabled or Stopped.

Solution:¶

Go to the Privacera Portal and verify in case of Data Plane:

Log in to the Privacera Portal and, if using the Data Plane, navigate to: Settings > Account > Encryption Settings Ensure that Encryption is Enabled and Running.

If you are using a Self-Managed setup, verify that the Privacera Encryption service is running. If it is not running, refer to the PEG server troubleshooting guide here for steps to resolve the issue.

Error: Function PRIVACERA.unprotect(varchar, unknown, unknown) does not exist, or permission is denied¶

Cause:¶

The user does not have execute access on the function.

Solution:¶

Grant execute access to the user with the following SQL command:

1

GRANT EXECUTE ON FUNCTION PRIVACERA.unprotect TO <username>;

Replace <username> with the actual Vertica database username.

6. Contact Support¶

If none of the above solutions work, contact Privacera support with:

• Log files
• Configuration values (sanitized)
• Environment details (OS, Vertica version, etc.)

Comments