After upgrade from 14.4 to 14.5 the im is not starting in Vaap

Products

CA Identity Suite

Issue/Introduction

1. Could see these errors in server.log of IM reporting a problem in ca-standalone-full-ha.xml files.

[0m[31m17:11:32,535 ERROR [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0055: Caught exception during boot: org.jboss.as.controller.persistence.ConfigurationPersistenceException: WFLYCTL0085: Failed to parse configuration
at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:143)
at org.jboss.as.server.ServerService.boot(ServerService.java:403)
at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:416)
at java.lang.Thread.run(Thread.java:750)
Caused by: javax.xml.stream.XMLStreamException: com.ctc.wstx.exc.WstxUnexpectedCharException: Illegal character ((CTRL-CHAR, code 1))
at [row,col {unknown-source}]: [205,125]
at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:651)
at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:205)
at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:122)
at org.jboss.staxmapper.XMLExtendedStreamReaderImpl.handleAny(XMLExtendedStreamReaderImpl.java:69)
at org.jboss.as.server.parsing.StandaloneXml_16.parseServerProfile(StandaloneXml_16.java:673)
at org.jboss.as.server.parsing.StandaloneXml_16.readServerElement(StandaloneXml_16.java:243)
at org.jboss.as.server.parsing.StandaloneXml_16.readElement(StandaloneXml_16.java:140)
at org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:144)
at org.jboss.as.server.parsing.StandaloneXml.readElement(StandaloneXml.java:52)
at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:122)
at org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:76)
at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:126)
... 3 more
Caused by: com.ctc.wstx.exc.WstxUnexpectedCharException: Illegal character ((CTRL-CHAR, code 1))
at [row,col {unknown-source}]: [205,125]
at com.ctc.wstx.sr.StreamScanner.throwInvalidSpace(StreamScanner.java:689)
at com.ctc.wstx.sr.BasicStreamReader.readTextPrimary(BasicStreamReader.java:4652)
at com.ctc.wstx.sr.BasicStreamReader.nextFromTree(BasicStreamReader.java:2962)
at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1122)
at com.ctc.wstx.sr.BasicStreamReader.getElementText(BasicStreamReader.java:688)
at org.jboss.staxmapper.XMLExtendedStreamReaderImpl.getElementText(XMLExtendedStreamReaderImpl.java:144)
at org.jboss.as.connector.util.AbstractParser.rawElementText(AbstractParser.java:61)
at org.jboss.as.connector.subsystems.datasources.DsParser.parseDataSource_4_0(DsParser.java:1960)
at org.jboss.as.connector.subsystems.datasources.DsParser.parseDataSources(DsParser.java:229)
at org.jboss.as.connector.subsystems.datasources.DsParser.parse(DsParser.java:189)
at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$DataSourceSubsystemParser.readElement(DataSourcesExtension.java:644)
... 14 more

[0m[31m17:11:32,536 FATAL [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0056: Server boot has failed in an unrecoverable manner; exiting. See previous messages for details.
[0m[0m17:11:32,555 INFO [org.jboss.as] (MSC service thread 1-3) WFLYSRV0050: WildFly Full 23.0.0.Final (WildFly Core 15.0.0.Final) stopped in 15ms
[0m

Environment

Vapp 14.5 upgraded from 14.4

Cause

Looking to file /opt/CA/wildfly-idm/standalone/configuration/ca-standalone-full-ha.xml line 205 as mentioned in the log:

Caused by: javax.xml.stream.XMLStreamException: com.ctc.wstx.exc.WstxUnexpectedCharException: Illegal character ((CTRL-CHAR, code 1)) at [row,col {unknown-source}]: [205,125]

The configuration file has in the line 205 after the <ip-address> one "backslash idm" (\idm) as shows:

203 </datasource>
204 <datasource jta="false" jndi-name="java:/iam/im/jdbc/jdbc/objectstore" pool-name="iam_im-imobjectstoredb-ds" enabled="true" use-java-context="true">
205 <connection-url>jdbc:sqlserver://<ip-address>\idm:56482;selectMethod=cursor;DatabaseName=IM;encrypt=false;trustServerCertificate=true</connection-url>
206 <driver>sqljdbc</driver>

Resolution

1. The solution is go to IGA Virtual Appliance -> Setup -> External Database -> Edit -> Identity Manager

A. Type: MSSQL
B. IP Adress: shoud be only the ip address, this also accepts the <ipaddress>/idm, but this is wrong, keep only the ip address.
C. Port: SQL Port number
D. Database Name: Database Name
E. Database Instance: SQL instance name
F. Username: The database user name
G. Password: The Password from user
H. Connection URL: jdbc:sqlserver://<ipaddress>:PortNumber;selectMethod=cursor;DatabaseName=

2. Make sure the Connection URL has nothing like \idm after the ipaddress.