ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Encrypted password shown in log Javelin workflow and portal
book
Article ID: 132801
calendar_today
Updated On:
Products
CA Test Data Manager (Data Finder / Grid Tools)
Issue/Introduction
When using an encrypted password (created from the Javelin menu) it is shown decrypted/plain text in the logfile when used in a Javelin SQL Server element. The reason we use SQL Server encryption instead of the ENCRYPTXREF is that the performance of this FDM function is terrible.
t takes approximately 5 minutes to mask one value in 10.000 records.
With tables exceeding millions of records this would take days.
Using the EncryptByPassphrase function in SQL server solves this for us.
The only problem now is that the password is shown.
Environment
Release: Component: ITKOTD
Resolution
As per development, this is working as designed.
Logging is part of the Microsoft framework used by Javelin and there is nothing that can be done from a Microsoft perspective.