PostgreSQL connection failing from FDM and Portal masking

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Getting below error when trying to connect to PostgreSQL DB from FDM and run a masking job on TDM Portal:

hostname.dbname: main - java.lang.IllegalArgumentException: Invalid connection URL, expected key=value pairs, found $eCy\}] java.lang.IllegalArgumentException: Invalid connection URL, expected key=value pairs, found $eCy\}] at org.mariadb.jdbc.internal.common.Utils.setUrlParameter(Utils.java:523) at org.mariadb.jdbc.internal.common.Utils.setUrlParameters(Utils.java:537) at org.mariadb.jdbc.Driver.setURLParameters(Driver.java:121) at org.mariadb.jdbc.Driver.connect(Driver.java:99) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at com.ca.fdm.database.connection.JDBCDriverUtils.createConnection(JDBCDriverUtils.java:18) at com.ca.fdm.database.connection.URLOnlyConnectionProcessor.getConnection(URLOnlyConnectionProcessor.java:31) at com.ca.fdm.database.impl.AbstractURLJDBCDatabaseAccess.connectToDatabase(AbstractURLJDBCDatabaseAccess.java:26) at com.ca.fdm.database.impl.PostgresJDBCDatabaseAccess.connectToDatabase(PostgresJDBCDatabaseAccess.java:18) at com.grid_tools.products.datamasker.profilegenerator.MainProfileGenerator.loadProfile(MainProfileGenerator.java:429) at com.grid_tools.products.datamasker.Datamasker.main(Datamasker.java:867) Error connecting with connection parameters (2) hostname.dbname: Masking process exited with non-zero code: 1

hostname.dbname: Connection error org.postgresql.util.PSQLException: FATAL: password authentication failed for user "username" at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:698) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:207) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:273) at org.postgresql.Driver.makeConnection(Driver.java:446) at org.postgresql.Driver.connect(Driver.java:298) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at com.ca.fdm.database.connection.JDBCDriverUtils.createConnection(JDBCDriverUtils.java:18) at com.ca.fdm.database.connection.URLOnlyConnectionProcessor.getConnection(URLOnlyConnectionProcessor.java:31) at com.ca.fdm.database.impl.AbstractURLJDBCDatabaseAccess.connectToDatabase(AbstractURLJDBCDatabaseAccess.java:26) at com.ca.fdm.database.impl.PostgresJDBCDatabaseAccess.connectToDatabase(PostgresJDBCDatabaseAccess.java:18) at com.grid_tools.products.datamasker.profilegenerator.MainProfileGenerator.loadProfile(MainProfileGenerator.java:429) at com.grid_tools.products.datamasker.Datamasker.main(Datamasker.java:867) Error connecting with connection parameters (2) hostname.dbname: Masking process exited with non-zero code: 1

Environment

TDM 4.11

Cause

The first error was due to the corrupted Maria DB jar. 

The second error was due to FDM inability to handle spaces in the postgreSQL password.

Resolution

For the first error, remove Maria DB jar from FDM lib folder. 

For the second error apply below FDM patch:

https://ftp.broadcom.com/user/downloads/pub/TDM/FDM/FastDataMasker-4.11.63.0.zip