When the Backslash (\) is being used in the hostname or Database name. The backslash gets ignored in logs. The logs had different errors/failures on connectivity to the database

The error in cm_import.log shows due to update_repos the backslash (\) gets ignored.

Caused by: org.eclipse.persistence.exceptions.DatabaseException:
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host NLHVS-MSSQ60BA, port 1434 has failed
 

Scenario 1:

IBI_REPOS_DB_DRIVER=org.postgresql.Driver
IBI_REPOS_DB_URL=jdbc:postgresql://localhost:5432/webfocus\BA

Error from the Event log
Caused by: org.eclipse.persistence.exceptions.DatabaseException:
Internal Exception: org.postgresql.util.PSQLException: FATAL: database "webfocusBA" does not exist
Error from application log (cm_import_roles)
[2022-04-29 05:42:45,020] INFO  IBFSPersistenceHelper - Connection failed : Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException-cc--cc-Internal Exception: org.postgresql.util.PSQLException: FATAL: database "webfocusBA" does not exist-cc--cc-Error Code: 0
[2022-04-29 05:42:45,020] WARN  ibfssystem - Repository error:IBFS_220429_054245-1 ERROR_CREATING_ENTITYMANAGER(5002) Error creating entity manager

Scenario 2:

IBI_REPOS_DB_DRIVER=org.postgresql.Driver
IBI_REPOS_DB_URL=jdbc:postgresql://localhost:5432/NLHVS-MSSQ60\BA

Error from the event log
Internal Exception: java.sql.SQLException: No suitable driver found for postgresql://localhost:5432/NLHVS-MSSQ60BA
Error from application log (cm_import_roles)

Error from application log (cm_import_roles)

Exception Description: Unable to acquire a connection from driver [org.postgresql.Driver], user [postgres] and URL [postgresql://localhost:5432/NLHVS-MSSQ60BA]

[2022-04-28 11:27:12,548] WARN  ibfssystem - Repository error:IBFS_220428_112712-1 ERROR_CREATING_ENTITYMANAGER(5002) Error creating entity manager
[2022-04-28 11:27:12,548] FATAL ibfssystem - IBFS_220428_112712-2 ERROR_CREATING_ENTITYMANAGER(5002) Error creating entity manager
com.ibi.ibfs.error.IBFSException: Error creating entity manager

Workaround:
Changing the  Backslash (\) to  Backslash (\\) for the machine name resolves the problem.
From:
IBI_REPOS_DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
IBI_REPOS_DB_URL=jdbc:sqlserver://NLHVS-MSSQ60\BA:1434;DatabaseName=NLWFTEST
To:
IBI_REPOS_DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
IBI_REPOS_DB_URL=jdbc:sqlserver://NLHVS-MSSQ60\\BA:1434;DatabaseName=NLWFTEST