8.4 Data Extract MessageBus configuration
Symptoms
The second Task/UI server won't start when using activeMQ, and this error message appears on the log. WARN main activemq.transport.failover.FailoverTransport:283 - Transport (tcp://localhost:61616) failed, attempting to automatically reconnect java.io.IOException: Wire format negotiation timeout: peer did not send his wire format.
Diagnosis
This occurs when multiple IIQ servers are being used. The host/port pair are entered into the database during initial IIQ setup using the default /WEB-INF/config/dataextract/MessageBus.xml file. Subsequent servers are confused by the localhost host entry.
This can be changed and imported after modifying the /WEB-INF/config/dataextract/MessageBus.xml file.
<entry key="clientConnectionString" value="failover:(tcp://localhost:61616)?initialReconnectDelay=10&maxReconnectAttempts=10&randomize=false&startupMaxReconnectAttempts=10&jms.watchTopicAdvisories=false&jms.redeliveryPolicy.initialRedeliveryDelay=900000&jms.redeliveryPolicy.redeliveryDelay=900000"/>
It can also be updated within the IIQ UI at Global Settings>Messaging Configuration>Connection Settings>Client Connection String
Solution
Replace tcp://localhost:61616 with a resolvable host or ip address. (tcp://IIQHost1.example.com:61616 or tcp://10.10.10.10:61616)
If the hostname can change, an IP address is the most stable.
If failover is desired a second comma separated entry can be added (tcp://IIQHost1.example.com:61616,tcp://IIQHost2:61616)
Update
When adding a secondary Message Server to the configuration, be sure to update the iiq.properties file with the correct port if you do not use the same port. The 0.0.0.0 means it is listening to any incoming IP on that port.
activeMQMessageServiceManager.brokerUri=tcp://0.0.0.0:61616?transport.trace=true&transport.soTimeout=10000
When configuring the message configuration client connection string for the first time, use the default values and change the port(s) in the UI first, then change it in the iiq.properties file to ensure the connections can happen on restart.
When adding new servers afterwards, update the client connection string in the UI before starting a new failover host, change to the configured port in the iiq.properties file on the new host, then start the host.
Another gotcha is you need to have the ports open in the firewall for each host, since it will timeout without a good indication of why it timed out.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
i am installing identityiq 8.4 and using mssql and the port is 1433. Everytime, I run core-deploy and it failed to connect to database.
ERROR Could not create plugin of type class org.apache.logging.log4j.core.appender.RollingFileAppender for element RollingFile: java.lang.IllegalStateException: ManagerFactory [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory@12299890] unable to create manager for [/opt/icam/logs/tomcat/icam.log] with data [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$FactoryData@2fba3fc4[pattern=/opt/icam/logs/tomcat/icam.log.%d{yyyy-MM-dd}.gz, append=true, bufferedIO=true, bufferSize=8192, policy=CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=false)]), strategy=DefaultRolloverStrategy(min=1, max=7, useMax=true), advertiseURI=null, layout=%d{ISO8601} %5p %c{4}.%M:%L - %m%n, filePermissions=null, fileOwner=null]] java.lang.IllegalStateException: ManagerFactory [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory@12299890] unable to create manager for [/opt/icam/logs/tomcat/icam.log] with data [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$FactoryData@2fba3fc4[pattern=/opt/icam/logs/tomcat/icam.log.%d{yyyy-MM-dd}.gz, append=true, bufferedIO=true, bufferSize=8192, policy=CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=false)]), strategy=DefaultRolloverStrategy(min=1, max=7, useMax=true), advertiseURI=null, layout=%d{ISO8601} %5p %c{4}.%M:%L - %m%n, filePermissions=null, fileOwner=null]]
ERROR Could not create plugin of type class org.apache.logging.log4j.core.appender.RollingFileAppender for element RollingFile: java.lang.IllegalStateException: ManagerFactory [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory@12299890] unable to create manager for [/opt/icam/logs/tomcat/icam.log] with data [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$FactoryData@2fba3fc4[pattern=/opt/icam/logs/tomcat/icam.log.%d{yyyy-MM-dd}.gz, append=true, bufferedIO=true, bufferSize=8192, policy=CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=false)]), strategy=DefaultRolloverStrategy(min=1, max=7, useMax=true), advertiseURI=null, layout=%d{ISO8601} %5p %c{4}.%M:%L - %m%n, filePermissions=null, fileOwner=null]] java.lang.IllegalStateException: ManagerFactory [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory@12299890] unable to create manager for [/opt/icam/logs/tomcat/icam.log] with data [org.apache.logging.log4j.core.appender.rolling.RollingFileManager$FactoryData@2fba3fc4[pattern=/opt/icam/logs/tomcat/icam.log.%d{yyyy-MM-dd}.gz, append=true, bufferedIO=true, bufferSize=8192, policy=CompositeTriggeringPolicy(policies=[TimeBasedTriggeringPolicy(nextRolloverMillis=0, interval=1, modulate=false)]), strategy=DefaultRolloverStrategy(min=1, max=7, useMax=true), advertiseURI=null, layout=%d{ISO8601} %5p %c{4}.%M:%L - %m%n, filePermissions=null, fileOwner=null]]
WARN springframework.context.support.ClassPathXmlApplicationContext.refresh:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'versionChecker' defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check AccessHistory database version: Unable to connect to: jdbc:sqlserver://mssql-server:1433;databaseName=identityiq;
Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver
how to resolve this issue, this took a month to install and never work at all to make it work on rhel 8
thank you.
Bach-Nga
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
2024-02-29 09:19:41,032 main ERROR Null object returned for RollingFile in Appenders.
2024-02-29 09:19:41,032 main ERROR Unable to locate appender "file" for logger config "root"
iiq.hostname : nediacsailpoint8.dodiis.ic.gov-console
2024-02-29T09:19:42,293 WARN main springframework.context.support.ClassPathXmlApplicationContext:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'versionChecker' defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check AccessHistory database version: Unable to connect to: jdbc:sqlserver://10.0.160.62:1433;databaseName=identityiqah;
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'versionChecker' defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check AccessHistory database version: Unable to connect to: jdbc:sqlserver://mssql-server:1433;databaseName=identityiqah;
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
that would be your database schema for identityiqah.database_version not matching . you need to run the correct sql script for upgrade or patch .
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
Dear Team,
We recently upgraded to version 8.4P1 and enabled the Access History feature. After restarting the servers, we encountered the following error.
we are still encountering an error (logs mentioned below). We have some concerns regarding the iiq.properties file. I’ve attached the file for your review—could you please validate it and let us know if any changes are necessary?
We observerd below entry was missing in the iiq.prop filefile so we entered the same:
activeMQMessageServiceManager.activemqJdbcAdapter=org.apache.activemq.store.jdbc.adapter.OracleJDBCAdapter
2025-02-21T10:47:37,339 ERROR https-jsse-nio-18443-exec-1 sailpoint.web.DebugBean:1965 - Unable to retrieve the activemq monitoring details.
sailpoint.tools.GeneralException: An exception has occurred when closing the message service.
at sailpoint.messagebus.monitoring.impl.ActiveMQMonitoringServiceImpl.getMonitoringView(ActiveMQMonitoringServiceImpl.java:70) ~[identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.web.DebugBean.onLoadStatsBtn(DebugBean.java:1954) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
at org.apache.el.parser.AstValue.invoke(AstValue.java:238) [jasper-el.jar:9.0.100]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:229) [jasper-el.jar:9.0.100]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) [javax.faces-2.2.20.jar:2.2.20]
at org.primefaces.behavior.ajax.AjaxBehaviorListenerImpl.processArgListener(AjaxBehaviorListenerImpl.java:76) [primefaces-8.0.12.jar:8.0.12]
at org.primefaces.behavior.ajax.AjaxBehaviorListenerImpl.processAjaxBehavior(AjaxBehaviorListenerImpl.java:66) [primefaces-8.0.12.jar:8.0.12]
at javax.faces.event.AjaxBehaviorEvent.processListener(AjaxBehaviorEvent.java:113) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.behavior.BehaviorBase.broadcast(BehaviorBase.java:106) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:805) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.UICommand.broadcast(UICommand.java:300) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:198) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:658) [javax.faces-2.2.20.jar:2.2.20]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:357) [tomahawk20-1.1.14.jar:1.1.14]
at sailpoint.web.MyFacesExtensionsFilter.doFilter(MyFacesExtensionsFilter.java:62) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) [tomcat-websocket.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:129) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at sailpoint.web.SailPointResponseFilter.doFilter(SailPointResponseFilter.java:76) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at sailpoint.web.PageAuthorizationFilter.doFilter(PageAuthorizationFilter.java:102) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at sailpoint.web.PageAuthenticationFilter$Chainlink.doFilter(PageAuthenticationFilter.java:290) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.service.PageAuthenticationService.handleFinally(PageAuthenticationService.java:644) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.web.PageAuthenticationFilter$MyHandler.handle(PageAuthenticationFilter.java:333) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.web.PageAuthenticationFilter.doFilter(PageAuthenticationFilter.java:127) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at sailpoint.web.SailPointContextRequestFilter.doFilter(SailPointContextRequestFilter.java:68) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at sailpoint.web.util.MethodFilter.doFilter(MethodFilter.java:51) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at sailpoint.web.SailPointPollingRequestFilter.doFilter(SailPointPollingRequestFilter.java:151) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at sailpoint.web.util.TimingFilter.doFilter(TimingFilter.java:88) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at sailpoint.web.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:63) [identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) [catalina.jar:9.0.100]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) [catalina.jar:9.0.100]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) [catalina.jar:9.0.100]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) [catalina.jar:9.0.100]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) [catalina.jar:9.0.100]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) [catalina.jar:9.0.100]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660) [catalina.jar:9.0.100]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.100]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) [catalina.jar:9.0.100]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396) [tomcat-coyote.jar:9.0.100]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) [tomcat-coyote.jar:9.0.100]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937) [tomcat-coyote.jar:9.0.100]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1793) [tomcat-coyote.jar:9.0.100]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) [tomcat-coyote.jar:9.0.100]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190) [tomcat-util.jar:9.0.100]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:9.0.100]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) [tomcat-util.jar:9.0.100]
at java.lang.Thread.run(Thread.java:840) [?:?]
Caused by: sailpoint.tools.GeneralException: Unable to start activemq connection. Make sure the broker is available and ready to receive messages.
at sailpoint.messagebus.impl.ActiveMQMessageService.startConnection(ActiveMQMessageService.java:409) ~[identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.messagebus.impl.ActiveMQMessageService.<init>(ActiveMQMessageService.java:94) ~[identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.messagebus.api.MessageServiceFactory.createMessageService(MessageServiceFactory.java:74) ~[identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.messagebus.monitoring.impl.ActiveMQMonitoringServiceImpl.getMonitoringView(ActiveMQMonitoringServiceImpl.java:59) ~[identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
... 80 more
Caused by: javax.jms.JMSException: Connection refused
at org.apache.activemq.util.JMSExceptionSupport.create(JMSExceptionSupport.java:80) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.ActiveMQConnection.syncSendPacket(ActiveMQConnection.java:1423) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.ActiveMQConnection.ensureConnectionInfoSent(ActiveMQConnection.java:1488) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.ActiveMQConnection.start(ActiveMQConnection.java:530) ~[activemq-client-5.17.6.jar:5.17.6]
at sailpoint.messagebus.impl.ActiveMQMessageService.startConnection(ActiveMQMessageService.java:395) ~[identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.messagebus.impl.ActiveMQMessageService.<init>(ActiveMQMessageService.java:94) ~[identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.messagebus.api.MessageServiceFactory.createMessageService(MessageServiceFactory.java:74) ~[identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
at sailpoint.messagebus.monitoring.impl.ActiveMQMonitoringServiceImpl.getMonitoringView(ActiveMQMonitoringServiceImpl.java:59) ~[identityiq.jar:8.4p1 Build e243e6f4783-20240325-035201]
... 80 more
Caused by: java.net.ConnectException: Connection refused
at sun.nio.ch.Net.pollConnect(Native Method) ~[?:?]
at sun.nio.ch.Net.pollConnectNow(Net.java:672) ~[?:?]
at sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:547) ~[?:?]
at sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:602) ~[?:?]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) ~[?:?]
at java.net.Socket.connect(Socket.java:633) ~[?:?]
at org.apache.activemq.transport.tcp.TcpTransport.connect(TcpTransport.java:525) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.transport.tcp.TcpTransport.doStart(TcpTransport.java:488) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:55) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.transport.AbstractInactivityMonitor.start(AbstractInactivityMonitor.java:172) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.transport.InactivityMonitor.start(InactivityMonitor.java:52) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.transport.TransportFilter.start(TransportFilter.java:64) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.transport.WireFormatNegotiator.start(WireFormatNegotiator.java:72) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.transport.failover.FailoverTransport.doReconnect(FailoverTransport.java:1026) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.transport.failover.FailoverTransport$2.iterate(FailoverTransport.java:151) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:133) ~[activemq-client-5.17.6.jar:5.17.6]
at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:48) ~[activemq-client-5.17.6.jar:5.17.6]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
... 1 more
IIQ File:
======
##### iiq.properties #####
#
# (c) Copyright 2008 SailPoint Technologies, Inc., All Rights Reserved.
#
# This file contains configuration settings for IdentityIQ. For your unique
# environment, you will need to adjust the properties below.
#
# IdentityIQ can either create its own datasource or use a datasource that is
# managed by an application server. Depending on the type of database being
# used, you will need to do the following:
#
# 1) Uncomment the correct sessionFactory.hibernateProperties.hibernate.dialect
# and ensure that all other dialects are commented out.
# 2) If using MS SQL Server, also uncomment the quartz properties:
# scheduler.quartzProperties.org.quartz.jobStore.driverDelegateClass and
# scheduler.quartzProperties.org.quartz.jobStore.selectWithLockSQL.
#
#
# IDENTITYIQ MANAGED DATASOURCES ONLY
#
# In addition to the steps above, if IdentityIQ is creating its own datasource
# (ie - not using an application server managed datasource), you will need to
# perform the following steps:
#
# 1) Modify dataSource.username and dataSource.password to include the username
# and password of the database user. The password may be an encrypted using
# the "encrypt" command when running "iiq console".
# 2) Configure the dataSource.url to connect to the database, and uncomment the
# appropriate dataSource.driverClassName.
# 3) Optionally configure other connection pool settings.
#
#
# APPLICATION SERVER MANAGED DATASOURCES ONLY
#
# In addition to the steps above, if IdentityIQ is using an application server
# managed datasource, you will need to perform the following steps:
#
# 1) Configure the datasource in your application server. This usually involves
# putting the JDBC driver jar file in a common location and configuring
# properties for your database connection and pool settings. Consult the
# documentation for the application server for more information. Also,
# ensure that the JDBC driver jar file is not in the WEB-INF\lib directory
# of the IdentityIQ web application.
# 2) Change jndiDataSource.jndiName to point to the location in JNDI in which
# the datasource is stored.
# 3) Change configuredDataSource.targetBeanName to "jndiDataSource".
#
##### Application Server Managed Data Source Properties #####
# Depending on the app server, the "java:comp/env/" may not be required.
jndiDataSource.jndiName=java:comp/env/jdbc/testDataSource
# Set to "jndiDataSource" to use an app server managed datasource. Otherwise
# leave the default value "dataSource".
configuredDataSource.targetBeanName=dataSource
# These settings are for the activemq broker. At this time this should remain
# set to type activemq. This is only needed for running an embedded message
# broker within IdentityIQ, and is ignored when the message broker is external
messageServiceFactory.type=activemq
activeMQMessageServiceManager.brokerUri=tcp://0.0.0.0:61616?transport.trace=true&transport.soTimeout=10000
activeMQMessageServiceManager.activemqLocker=org.apache.activemq.store.jdbc.LeaseDatabaseLocker
# ActiveMQ Broker System Usage limit sizing in Megabytes
activeMQMessageServiceManager.memoryLimit=1024
activeMQMessageServiceManager.storeLimit=100000
activeMQMessageServiceManager.tempLimit=50000
##### Data Source Properties #####
#dataSource.maxWait=10000
#dataSource.maxActive=150
#dataSource.minIdle=5
dataSource.maxWaitMillis=10000
dataSource.maxTotal=150
#dataSource.minEvictableIdleTimeMillis=300000
#dataSource.maxOpenPreparedStatements=-1
##### MySQL #####
## URL Format: dataSource.url=jdbc:mysql://<host_name>:<port>/<dbname>?useServerPrepStmts=true&tinyInt1isBit=true&useUnicode=true&characterEncoding=utf8
#dataSource.url=jdbc:mysql://localhost/identityiq?useServerPrepStmts=true&tinyInt1isBit=true&useUnicode=true&characterEncoding=utf8
#dataSource.driverClassName=com.mysql.jdbc.Driver
#sessionFactory.hibernateProperties.hibernate.dialect=sailpoint.persistence.MySQL5InnoDBDialect
##### p6spy #####
## You also need to modify spy.properties to have the name of the real driver class
#dataSource.driverClassName=com.p6spy.engine.spy.P6SpyDriver
##### Oracle #####
dataSource.username=identityiq
dataSource.password=password
#dataSource.password=pass
## URL Format: dataSource.url=jdbc:oracle:<drivertype>:<username/password>@<database>:<port>:<sid>
dataSource.url=jdbc:oracle:thin:@access-dev-scan.ad.local:1514/IDENTIQ_T1
dataSource.driverClassName=oracle.jdbc.driver.OracleDriver
sessionFactory.hibernateProperties.hibernate.dialect=sailpoint.persistence.Oracle10gDialect
activeMQMessageServiceManager.activemqJdbcAdapter=org.apache.activemq.store.jdbc.adapter.OracleJDBCAdapter
##### MSSQL Server #####
## URL Format: dataSource.url=jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
#dataSource.url=jdbc:sqlserver://localhost:1433;databaseName=identityiq;
#dataSource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
#sessionFactory.hibernateProperties.hibernate.dialect=sailpoint.persistence.SQLServerPagingDialect
#scheduler.quartzProperties.org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.MSSQLDelegate
#scheduler.quartzProperties.org.quartz.jobStore.selectWithLockSQL=SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?
##### IBM DB2 #####
## URL Format: dataSource.url=jdbc:db2://<host_name>:<port_number>/<database_name>
#dataSource.url=jdbc:db2://localhost:50000/iiq
#dataSource.driverClassName=com.ibm.db2.jcc.DB2Driver
#sessionFactory.hibernateProperties.hibernate.dialect=sailpoint.persistence.DB2Dialect
##### Plugins ####
# Determines whether or not plugins are enabled, change
# to false if plugins should be disabled globally
plugins.enabled=true
# Determines if SQL scripts should be executed dynamically
# at the time a plugin is installed, upgraded or uninstalled
plugins.runSqlScripts=true
# Determines if XML object files should be imported dynamically
# at the time a plugin is installed, upgraded or uninstalled
plugins.importObjects=true
##### Application Server Managed Plugins Data Source Properties #####
# Depending on the app server, the "java:comp/env/" may not be required.
jndiPluginsDataSource.jndiName=java:comp/env/jdbc/testPluginsDataSource
# Set to "jndiPluginsDataSource" to use an app server managed datasource. Otherwise
# leave the default value "pluginsDataSource".
configuredPluginsDataSource.targetBeanName=pluginsDataSource
##### Plugins Data Source Properties #####
#pluginsDataSource.maxWait=10000
#pluginsDataSource.maxActive=50
#pluginsDataSource.minIdle=5
pluginsdataSource.maxWaitMillis=10000
pluginsdataSource.maxTotal=50
#pluginsDataSource.minEvictableIdleTimeMillis=300000
#pluginsDataSource.maxOpenPreparedStatements=-1
#pluginsDataSource.username=identityiq
#pluginsDataSource.password=identityiq
##### MySQL #####
## URL Format: dataSource.url=jdbc:mysql://<host_name>:<port>/<dbname>?useServerPrepStmts=true&tinyInt1isBit=true&useUnicode=true&characterEncoding=utf8
#pluginsDataSource.url=jdbc:mysql://localhost/identityiqPlugin?useServerPrepStmts=true&tinyInt1isBit=true&useUnicode=true&characterEncoding=utf8
#pluginsDataSource.driverClassName=com.mysql.jdbc.Driver
##### p6spy #####
## You also need to modify spy.properties to have the name of the real driver class
#pluginsDataSource.driverClassName=com.p6spy.engine.spy.P6SpyDriver
##### Oracle #####
## URL Format: dataSource.url=jdbc:oracle:<drivertype>:<username/password>@<database>:<port>:<sid>
pluginsDataSource.username=identityiq
pluginsDataSource.password=password
#pluginsDataSource.password=pass
pluginsDataSource.url=jdbc:oracle:thin:@access-dev-scan.ad.local:1514/IDENTIQ_T1
pluginsDataSource.driverClassName=oracle.jdbc.driver.OracleDriver
##### MSSQL Server #####
## URL Format: dataSource.url=jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
#pluginsDataSource.url=jdbc:sqlserver://localhost:1433;databaseName=identityiqPlugin
#pluginsDataSource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
##### IBM DB2 #####
## URL Format: dataSource.url=jdbc:db2://<host_name>:<port_number>/<database_name>
#pluginsDataSource.url=jdbc:db2://localhost:50000/iiq_pl
#pluginsDataSource.driverClassName=com.ibm.db2.jcc.DB2Driver
##### Access History ####
##### Data Source Properties for Access History #####
dataSourceAccessHistory.maxWaitMillis=10000
dataSourceAccessHistory.maxTotal=50
dataSourceAccessHistory.minIdle=5
#dataSourceAccessHistory.minEvictableIdleTimeMillis=300000
#dataSourceAccessHistory.maxOpenPreparedStatements=-1
##### Oracle #####
## URL Format: dataSource.url=jdbc:oracle:<drivertype>:<username/password>@<database>:<port>:<sid>
dataSourceAccessHistory.url=jdbc:oracle:thin:@aacixtex03-dev-scan.windmill.local:1530/IDENTIQ_T1
dataSourceAccessHistory.driverClassName=oracle.jdbc.driver.OracleDriver
sessionFactoryAccessHistory.hibernateProperties.hibernate.dialect=org.hibernate.dialect.Oracle12cDialect
dataSourceAccessHistory.username=identityiqah
#dataSourceAccessHistory.password=pass
dataSourceAccessHistory.password=passcode
#
# Setting for the BSFManagerPool set on the ruleRunner
#
ruleRunner.maxPoolReuse=1000
bsfManagerPool.maxTotal=30
bsfManagerPool.minEvictableIdleTimeMillis=900000
bsfManagerPool.timeBetweenEvictionRunsMillis=600000
##### Debug Settings #####
# Uncomment to send all SQL queries to std out. This provides a lot of output
# and slows down execution, so use it wisely.
#sessionFactory.hibernateProperties.hibernate.show_sql=true
# Hibernate Transaction Isolation Levels
# 1 = Read Uncommitted, 2 = Read Committed, 4 = Repeatable Read, 8 = Serializable
#sessionFactory.hibernateProperties.hibernate.connection.isolation=1
#
# IIQ Keystore and Master Password properties
#
# file location of the IIQ keystore
# (override of the default $SPHOME/WEB-INF/classes/iiq.dat )
#
#keyStore.file = /example/path/filename
# file location of the IIQ master password file
# (override of the default $SPHOME/WEB-INF/classes/iiq.cfg )
#
#keyStore.passwordFile = /example/path/filename
