Trying to encrypt passwords for use in project publishing variables

Document ID : KB000008450
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Trying to encrypt passwords for use in project publishing variables for use in Javelin.

Getting an error when attempting to replace variable password with an encrypted password. The error message reads as follows: 

Column PD_VALUE has data type varchar2 (255) and is NULLABLE 
^_^KxwsUEquejqz/Ay46XOtYA==^_^ - Invalid column used 

Environment:
TDM 4.3
Cause:

^ is special character in Datamaker. 

Resolution:

Use the Encryption Utility to Encrypt Passwords 
https://docops.ca.com/ca-test-data-manager/4-3/en/administrating/use-the-encryption-utility-to-encrypt-passwords 

^ is special character in Datamaker. you should use @caret()@ instead