Hi Rinat,
PFA the XML
<?xml version='1.0' encoding='UTF-8'?>
<server xmlns="urn:jboss:domain:1.7">
<extensions>
<extension module="org.jboss.as.clustering.infinispan"/>
<extension module="org.jboss.as.cmp"/>
<extension module="org.jboss.as.connector"/>
<extension module="org.jboss.as.deployment-scanner"/>
<extension module="org.jboss.as.ee"/>
<extension module="org.jboss.as.ejb3"/>
<extension module="org.jboss.as.jacorb"/>
<extension module="org.jboss.as.jaxr"/>
<extension module="org.jboss.as.jdr"/>
<extension module="org.jboss.as.jmx"/>
<extension module="org.jboss.as.jpa"/>
<extension module="org.jboss.as.jsf"/>
<extension module="org.jboss.as.jsr77"/>
<extension module="org.jboss.as.logging"/>
<extension module="org.jboss.as.mail"/>
<extension module="org.jboss.as.messaging"/>
<extension module="org.jboss.as.naming"/>
<extension module="org.jboss.as.pojo"/>
<extension module="org.jboss.as.remoting"/>
<extension module="org.jboss.as.sar"/>
<extension module="org.jboss.as.security"/>
<extension module="org.jboss.as.threads"/>
<extension module="org.jboss.as.transactions"/>
<extension module="org.jboss.as.web"/>
<extension module="org.jboss.as.webservices"/>
<extension module="org.jboss.as.weld"/>
</extensions>
<system-properties>
<property name="org.apache.tomcat.util.http.Parameters.MAX_COUNT" value="5000"/>
</system-properties>
<management>
<security-realms>
<security-realm name="ManagementRealm">
<authentication>
<local default-user="$local" skip-group-loading="true"/>
<properties path="mgmt-users.properties" relative-to="jboss.server.config.dir"/>
</authentication>
<authorization map-groups-to-roles="false">
<properties path="mgmt-groups.properties" relative-to="jboss.server.config.dir"/>
</authorization>
</security-realm>
<security-realm name="ApplicationRealm">
<authentication>
<local default-user="$local" allowed-users="*" skip-group-loading="true"/>
<properties path="application-users.properties" relative-to="jboss.server.config.dir"/>
</authentication>
<authorization>
<properties path="application-roles.properties" relative-to="jboss.server.config.dir"/>
</authorization>
</security-realm>
</security-realms>
<audit-log>
<formatters>
<json-formatter name="json-formatter"/>
</formatters>
<handlers>
<file-handler name="file" formatter="json-formatter" path="audit-log.log" relative-to="jboss.server.data.dir"/>
</handlers>
<logger log-boot="true" log-read-only="false" enabled="false">
<handlers>
<handler name="file"/>
</handlers>
</logger>
</audit-log>
<management-interfaces>
<native-interface security-realm="ManagementRealm">
<socket-binding native="management-native"/>
</native-interface>
<http-interface security-realm="ManagementRealm">
<socket-binding http="management-http"/>
</http-interface>
</management-interfaces>
<access-control provider="simple">
<role-mapping>
<role name="SuperUser">
<include>
<user name="$local"/>
</include>
</role>
</role-mapping>
</access-control>
</management>
<profile>
<subsystem xmlns="urn:jboss:domain:logging:1.5">
<console-handler name="CONSOLE">
<level name="DEBUG"/>
<formatter>
<named-formatter name="COLOR-PATTERN"/>
</formatter>
</console-handler>
<periodic-rotating-file-handler name="FILE" autoflush="true">
<formatter>
<named-formatter name="PATTERN"/>
</formatter>
<file relative-to="jboss.server.log.dir" path="server.log"/>
<suffix value=".yyyy-MM-dd"/>
<append value="true"/>
</periodic-rotating-file-handler>
<logger category="com.arjuna">
<level name="WARN"/>
</logger>
<logger category="org.apache.tomcat.util.modeler">
<level name="WARN"/>
</logger>
<logger category="org.jboss.as.config">
<level name="DEBUG"/>
</logger>
<logger category="sun.rmi">
<level name="WARN"/>
</logger>
<logger category="jacorb">
<level name="WARN"/>
</logger>
<logger category="jacorb.config">
<level name="ERROR"/>
</logger>
<logger category="ims.Main">
<level name="INFO"/>
</logger>
<root-logger>
<level name="INFO"/>
<handlers>
<handler name="CONSOLE"/>
<handler name="FILE"/>
</handlers>
</root-logger>
<formatter name="PATTERN">
<pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>
</formatter>
<formatter name="COLOR-PATTERN">
<pattern-formatter pattern="%K{level}%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>
</formatter>
</subsystem>
<subsystem xmlns="urn:jboss:domain:cmp:1.1"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:deployment-scanner:1.1">
<deployment-scanner path="deployments" relative-to="jboss.server.base.dir" scan-interval="5000" deployment-timeout="600"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:ee:1.2">
<ear-subdeployments-isolated>false</ear-subdeployments-isolated>
<spec-descriptor-property-replacement>false</spec-descriptor-property-replacement>
<jboss-descriptor-property-replacement>true</jboss-descriptor-property-replacement>
<annotation-property-replacement>false</annotation-property-replacement>
</subsystem>
<subsystem xmlns="urn:jboss:domain:ejb3:1.5">
<session-bean>
<stateless>
<bean-instance-pool-ref pool-name="slsb-strict-max-pool"/>
</stateless>
<stateful default-access-timeout="5000" cache-ref="simple"/>
<singleton default-access-timeout="5000"/>
</session-bean>
<mdb>
<resource-adapter-ref resource-adapter-name="${ejb.resource-adapter-name:hornetq-ra}"/>
<bean-instance-pool-ref pool-name="mdb-strict-max-pool"/>
</mdb>
<pools>
<bean-instance-pools>
<strict-max-pool name="slsb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>
<strict-max-pool name="mdb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>
</bean-instance-pools>
</pools>
<caches>
<cache name="simple" aliases="NoPassivationCache"/>
<cache name="passivating" passivation-store-ref="file" aliases="SimpleStatefulCache"/>
</caches>
<passivation-stores>
<file-passivation-store name="file"/>
</passivation-stores>
<async thread-pool-name="default"/>
<timer-service thread-pool-name="default" default-data-store="default-file-store">
<data-stores>
<file-data-store name="default-file-store" path="timer-service-data" relative-to="jboss.server.data.dir"/>
</data-stores>
</timer-service>
<remote connector-ref="remoting-connector" thread-pool-name="default"/>
<thread-pools>
<thread-pool name="default">
<max-threads count="10"/>
<keepalive-time time="100" unit="milliseconds"/>
</thread-pool>
</thread-pools>
<iiop enable-by-default="false" use-qualified-name="false"/>
<default-security-domain value="other"/>
<default-missing-method-permissions-deny-access value="true"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:infinispan:1.5">
<cache-container name="web" aliases="standard-session-cache" default-cache="local-web" module="org.jboss.as.clustering.web.infinispan">
<local-cache name="local-web" batching="true">
<file-store passivation="false" purge="false"/>
</local-cache>
</cache-container>
<cache-container name="hibernate" default-cache="local-query" module="org.jboss.as.jpa.hibernate:4">
<local-cache name="entity">
<transaction mode="NON_XA"/>
<eviction strategy="LRU" max-entries="10000"/>
<expiration max-idle="100000"/>
</local-cache>
<local-cache name="local-query">
<transaction mode="NONE"/>
<eviction strategy="LRU" max-entries="10000"/>
<expiration max-idle="100000"/>
</local-cache>
<local-cache name="timestamps">
<transaction mode="NONE"/>
<eviction strategy="NONE"/>
</local-cache>
</cache-container>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jacorb:1.4">
<orb socket-binding="jacorb" ssl-socket-binding="jacorb-ssl">
<initializers security="identity" transactions="spec"/>
</orb>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jaxr:1.1">
<connection-factory jndi-name="java:jboss/jaxr/ConnectionFactory"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jca:1.1">
<archive-validation enabled="true" fail-on-error="true" fail-on-warn="false"/>
<bean-validation enabled="true"/>
<default-workmanager>
<short-running-threads>
<core-threads count="50"/>
<queue-length count="50"/>
<max-threads count="50"/>
<keepalive-time time="10" unit="seconds"/>
</short-running-threads>
<long-running-threads>
<core-threads count="50"/>
<queue-length count="50"/>
<max-threads count="50"/>
<keepalive-time time="10" unit="seconds"/>
</long-running-threads>
</default-workmanager>
<cached-connection-manager/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jdr:1.0"/>
<subsystem xmlns="urn:jboss:domain:jmx:1.3">
<expose-resolved-model/>
<expose-expression-model/>
<remoting-connector/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jpa:1.1">
<jpa default-datasource="" default-extended-persistence-inheritance="DEEP"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jsf:1.0"/>
<subsystem xmlns="urn:jboss:domain:jsr77:1.0"/>
<subsystem xmlns="urn:jboss:domain:mail:1.2">
<mail-session name="default" jndi-name="java:jboss/mail/Default">
<smtp-server outbound-socket-binding-ref="mail-smtp"/>
</mail-session>
<mail-session name="java:/Mail" jndi-name="java:/Mail">
<smtp-server outbound-socket-binding-ref="mail-smtp"/>
</mail-session>
</subsystem>
<subsystem xmlns="urn:jboss:domain:messaging:1.4">
<hornetq-server>
<persistence-enabled>true</persistence-enabled>
<security-enabled>false</security-enabled>
<cluster-user>guest</cluster-user>
<cluster-password>guest</cluster-password>
<journal-type>NIO</journal-type>
<journal-file-size>102400</journal-file-size>
<journal-min-files>2</journal-min-files>
<connectors>
<netty-connector name="netty" socket-binding="messaging"/>
<netty-connector name="netty-throughput" socket-binding="messaging-throughput">
<param key="batch-delay" value="50"/>
</netty-connector>
<in-vm-connector name="in-vm" server-id="0"/>
</connectors>
<acceptors>
<netty-acceptor name="netty" socket-binding="messaging"/>
<netty-acceptor name="netty-throughput" socket-binding="messaging-throughput">
<param key="batch-delay" value="50"/>
<param key="direct-deliver" value="false"/>
</netty-acceptor>
<in-vm-acceptor name="in-vm" server-id="0"/>
</acceptors>
<security-settings>
<security-setting match="#">
<permission type="send" roles="guest"/>
<permission type="consume" roles="guest"/>
<permission type="createNonDurableQueue" roles="guest"/>
<permission type="deleteNonDurableQueue" roles="guest"/>
</security-setting>
</security-settings>
<address-settings>
<address-setting match="#">
<dead-letter-address>jms.queue.DLQ</dead-letter-address>
<expiry-address>jms.queue.ExpiryQueue</expiry-address>
<redelivery-delay>0</redelivery-delay>
<max-size-bytes>10485760</max-size-bytes>
<page-size-bytes>2097152</page-size-bytes>
<address-full-policy>PAGE</address-full-policy>
<message-counter-history-day-limit>10</message-counter-history-day-limit>
</address-setting>
</address-settings>
<jms-connection-factories>
<connection-factory name="InVmConnectionFactory">
<connectors>
<connector-ref connector-name="in-vm"/>
</connectors>
<entries>
<entry name="java:/ConnectionFactory"/>
</entries>
<client-failure-check-period>3000</client-failure-check-period>
<connection-ttl>6000</connection-ttl>
</connection-factory>
<connection-factory name="RemoteConnectionFactory">
<connectors>
<connector-ref connector-name="netty"/>
</connectors>
<entries>
<entry name="java:jboss/exported/jms/RemoteConnectionFactory"/>
</entries>
<client-failure-check-period>3000</client-failure-check-period>
<connection-ttl>6000</connection-ttl>
</connection-factory>
<connection-factory name="wpConnectionFactory">
<connectors>
<connector-ref connector-name="netty"/>
</connectors>
<entries>
<entry name="jms/wpConnectionFactory"/>
<entry name="wpConnectionFactory"/>
<entry name="java:jboss/exported/jms/wpConnectionFactory"/>
</entries>
<client-failure-check-period>3000</client-failure-check-period>
<connection-ttl>6000</connection-ttl>
</connection-factory>
<pooled-connection-factory name="hornetq-ra">
<transaction mode="xa"/>
<connectors>
<connector-ref connector-name="in-vm"/>
</connectors>
<entries>
<entry name="java:/JmsXA"/>
</entries>
<client-failure-check-period>3000</client-failure-check-period>
<connection-ttl>6000</connection-ttl>
</pooled-connection-factory>
</jms-connection-factories>
<jms-destinations>
<jms-queue name="ExpiryQueue">
<entry name="java:/jms/queue/ExpiryQueue"/>
</jms-queue>
<jms-queue name="DLQ">
<entry name="java:/jms/queue/DLQ"/>
</jms-queue>
<jms-queue name="testQueue">
<entry name="queue/test"/>
<entry name="java:jboss/exported/jms/queue/test"/>
</jms-queue>
<jms-queue name="iam_imAnalyticsNotificationQueue">
<entry name="iam/im/jms/queue/analytics/AnalyticsNotificationQueue"/>
</jms-queue>
<jms-queue name="iam.im.jms.queue.RuntimeStatusDetailQueue">
<entry name="queue/iam/im/jms/queue/RuntimeStatusDetailQueue"/>
<entry name="java:jboss/exported/jms/queue/iam/im/jms/queue/RuntimeStatusDetailQueue"/>
</jms-queue>
<jms-queue name="iam.im.jms.queue.StatusNotificationsQueue">
<entry name="queue/iam/im/jms/queue/StatusNotificationsQueue"/>
<entry name="java:jboss/exported/jms/queue/iam/im/jms/queue/StatusNotificationsQueue"/>
</jms-queue>
<jms-queue name="iam.im.jms.queue.com.netegrity.ims.msg.queue">
<entry name="queue/iam/im/jms/queue/com.netegrity.ims.msg.queue"/>
<entry name="java:jboss/exported/jms/queue/iam/im/jms/queue/com.netegrity.ims.msg.queue"/>
</jms-queue>
<jms-queue name="iam.im.jms.queue.wpEventQueue">
<entry name="queue/wpEventQueue"/>
<entry name="java:jboss/exported/jms/queue/wpEventQueue"/>
</jms-queue>
<jms-queue name="iam.im.jms.queue.wpServAutoActQueue">
<entry name="queue/wpServAutoActQueue"/>
<entry name="java:jboss/exported/jms/queue/wpServAutoActQueue"/>
</jms-queue>
<jms-queue name="iam.im.jms.queue.wpUtilQueue">
<entry name="queue/wpUtilQueue"/>
<entry name="java:jboss/exported/jms/queue/wpUtilQueue"/>
</jms-queue>
<jms-topic name="testTopic">
<entry name="topic/test"/>
<entry name="java:jboss/exported/jms/topic/test"/>
</jms-topic>
<jms-topic name="iam.im.jms.topic.ServerCommandTopic">
<entry name="topic/iam/im/jms/topic/ServerCommandTopic"/>
<entry name="java:jboss/exported/jms/queue/iam/im/jms/topic/ServerCommandTopic"/>
</jms-topic>
</jms-destinations>
</hornetq-server>
</subsystem>
<subsystem xmlns="urn:jboss:domain:naming:1.4">
<remote-naming/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:pojo:1.0"/>
<subsystem xmlns="urn:jboss:domain:remoting:1.2">
<connector name="remoting-connector" socket-binding="remoting" security-realm="ApplicationRealm"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:resource-adapters:1.1">
<resource-adapters>
<resource-adapter id="iam_im.ear#policyserver.rar">
<archive>
iam_im.ear#policyserver.rar
</archive>
<transaction-support>NoTransaction</transaction-support>
<connection-definitions>
<connection-definition class-name="com.netegrity.ra.policyserver.impl.PSManagedConnectionFactory" jndi-name="java:/iam/im/rar/PolicyServer" pool-name="policyserver" use-ccm="true"/>
</connection-definitions>
</resource-adapter>
<resource-adapter id="iam_im.ear#workflow.rar">
<archive>
iam_im.ear#workflow.rar
</archive>
<transaction-support>NoTransaction</transaction-support>
<connection-definitions>
<connection-definition class-name="com.netegrity.ra.workflow.impl.WFManagedConnectionFactory" jndi-name="java:/iam/im/rar/Workflow" pool-name="workflow" use-ccm="true"/>
</connection-definitions>
</resource-adapter>
</resource-adapters>
</subsystem>
<subsystem xmlns="urn:jboss:domain:sar:1.0"/>
<subsystem xmlns="urn:jboss:domain:security:1.2">
<security-domains>
<security-domain name="other" cache-type="default">
<authentication>
<login-module code="Remoting" flag="optional">
<module-option name="password-stacking" value="useFirstPass"/>
</login-module>
<login-module code="RealmDirect" flag="required">
<module-option name="password-stacking" value="useFirstPass"/>
</login-module>
</authentication>
</security-domain>
<security-domain name="jboss-web-policy" cache-type="default">
<authorization>
<policy-module code="Delegating" flag="required"/>
</authorization>
</security-domain>
<security-domain name="jboss-ejb-policy" cache-type="default">
<authorization>
<policy-module code="Delegating" flag="required"/>
</authorization>
</security-domain>
<security-domain name="iam_im-imobjectstoredb">
<authentication>
<login-module code="com.netegrity.jboss.datasource.PicketBoxPasswordEncryptedLogin" flag="required" module="com.ca.iam.idmutils">
<module-option name="userName" value="idmuser"/>
<module-option name="password" value="{PBES}:umuYmaDpGGGIhnNU9O2qBA=="/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:name=iam/im/jdbc/jdbc/objectstore,service=NoTxCM"/>
</login-module>
</authentication>
</security-domain>
<security-domain name="iam_im-imtaskpersistencedb">
<authentication>
<login-module code="com.netegrity.jboss.datasource.PicketBoxPasswordEncryptedLogin" flag="required" module="com.ca.iam.idmutils">
<module-option name="userName" value="idmuser"/>
<module-option name="password" value="{PBES}:umuYmaDpGGGIhnNU9O2qBA=="/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:name=iam/im/jdbc/jdbc/idm,service=NoTxCM"/>
</login-module>
</authentication>
</security-domain>
<security-domain name="iam_im-imarchivedb">
<authentication>
<login-module code="com.netegrity.jboss.datasource.PicketBoxPasswordEncryptedLogin" flag="required" module="com.ca.iam.idmutils">
<module-option name="userName" value="idmuser"/>
<module-option name="password" value="{PBES}:umuYmaDpGGGIhnNU9O2qBA=="/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:name=iam/im/jdbc/jdbc/archive,service=NoTxCM"/>
</login-module>
</authentication>
</security-domain>
<security-domain name="iam_im-imauditdb">
<authentication>
<login-module code="com.netegrity.jboss.datasource.PicketBoxPasswordEncryptedLogin" flag="required" module="com.ca.iam.idmutils">
<module-option name="userName" value="idmuser"/>
<module-option name="password" value="{PBES}:umuYmaDpGGGIhnNU9O2qBA=="/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:name=iam/im/jdbc/auditDbDataSource,service=LocalTxCM"/>
</login-module>
</authentication>
</security-domain>
<security-domain name="iam_im-imreportsnapshotdb">
<authentication>
<login-module code="com.netegrity.jboss.datasource.PicketBoxPasswordEncryptedLogin" flag="required" module="com.ca.iam.idmutils">
<module-option name="userName" value="idmuser"/>
<module-option name="password" value="{PBES}:umuYmaDpGGGIhnNU9O2qBA=="/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:name=iam/im/jdbc/jdbc/reportsnapshot,service=NoTxCM"/>
</login-module>
</authentication>
</security-domain>
<security-domain name="iam_im-imworkflowdb">
<authentication>
<login-module code="com.netegrity.jboss.datasource.PicketBoxPasswordEncryptedLogin" flag="required" module="com.ca.iam.idmutils">
<module-option name="userName" value="idmuser"/>
<module-option name="password" value="{PBES}:umuYmaDpGGGIhnNU9O2qBA=="/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:name=jdbc/WPDS,service=LocalTxCM"/>
</login-module>
</authentication>
</security-domain>
</security-domains>
</subsystem>
<subsystem xmlns="urn:jboss:domain:threads:1.1"/>
<subsystem xmlns="urn:jboss:domain:transactions:1.5">
<core-environment>
<process-id>
<uuid/>
</process-id>
</core-environment>
<recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>
<coordinator-environment default-timeout="300"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:web:2.2" default-virtual-server="default-host" instance-id="${jboss.node.name}" native="false">
<connector name="http" protocol="HTTP/1.1" scheme="http" socket-binding="http"/>
<connector name="ajp" protocol="AJP/1.3" scheme="http" socket-binding="ajp" enabled="true"/>
<virtual-server name="default-host" enable-welcome-root="true">
<alias name="localhost"/>
<alias name="example.com"/>
</virtual-server>
</subsystem>
<subsystem xmlns="urn:jboss:domain:webservices:1.2">
<modify-wsdl-address>true</modify-wsdl-address>
<wsdl-host>${jboss.bind.address:127.0.0.1}</wsdl-host>
<endpoint-config name="Standard-Endpoint-Config"/>
<endpoint-config name="Recording-Endpoint-Config">
<pre-handler-chain name="recording-handlers" protocol-bindings="##SOAP11_HTTP ##SOAP11_HTTP_MTOM ##SOAP12_HTTP ##SOAP12_HTTP_MTOM">
<handler name="RecordingHandler" class="org.jboss.ws.common.invocation.RecordingServerHandler"/>
</pre-handler-chain>
</endpoint-config>
<client-config name="Standard-Client-Config"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:weld:1.0"/>
</profile>
<interfaces>
<interface name="management">
<inet-address value="${jboss.bind.address.management:127.0.0.1}"/>
</interface>
<interface name="public">
<inet-address value="${jboss.bind.address:127.0.0.1}"/>
</interface>
<interface name="unsecure">
<inet-address value="${jboss.bind.address.unsecure:127.0.0.1}"/>
</interface>
<interface name="any">
<any-ipv4-address/>
</interface>
</interfaces>
</server>
Original Message:
Sent: 10-11-2019 08:25 AM
From: Rinat Matityahu
Subject: SQL Exception in JBOSS post upgrade to 14.2
Am after the parameters of the data sources.
Original Message:
Sent: 10-10-2019 02:14 AM
From: NEERAJ Gupta
Subject: SQL Exception in JBOSS post upgrade to 14.2
Hi Rinat,
We are having JBOSS 6.4EAP and we have applied Java OPTS and JMS thread pool tuning.
We have taken reference of the below document as well : https://docops.ca.com/ca-identity-manager/14-2/EN/installing/install-on-jboss-or-wildfly/fine-tune-jboss-or-wildfly-configurations
Which parameter details are required of standalone.xml, I will share those details.
Original Message:
Sent: 10-09-2019 10:59 AM
From: Rinat Matityahu
Subject: SQL Exception in JBOSS post upgrade to 14.2
Have you applied any tuning settings within this environment?
Which JBoss version do you have in place?
Can you share the standalone.xml in use?
Original Message:
Sent: 10-09-2019 04:58 AM
From: NEERAJ Gupta
Subject: SQL Exception in JBOSS post upgrade to 14.2
Hi Marconi,
Thanks for the inputs.
The logs are in DEBUG state only, moreover this connection closed error is we are getting every time whenever a bulk upload having more than 20 records is applied on system, moreover there is no network issue as we are getting this error only in case of bulk load, moreover we have checked at DB end there is no issue in trace logs as well.
Can you suggest something else.
Thanks
Ank
Original Message:
Sent: 10-07-2019 11:17 AM
From: Marconi Ochinang
Subject: SQL Exception in JBOSS post upgrade to 14.2
According to the follow part of the erro "com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed" Just by
coincidence, could there have been a change on the network to close the connection. Also, you could set the IDM logging to debug, and also set a trace on the database to help get more information.
Original Message:
Sent: 10-07-2019 02:41 AM
From: Shiva Gupta
Subject: SQL Exception in JBOSS post upgrade to 14.2
Hi All,
We have upgraded CA IDM from 12.6.8 to 14.2 and moreover applied CR4 patches. Now when we are applying any kind of bulk load having more than 20 records on the IDM portal, we are getting SQL exception and due to which we are facing performance issues and on daily basis some tasks remain in the in-progress state. The exception is :
PersistenceProvider: JMS:ID:76343a27-e8a6-11e9-b2d8-a770c45b8b34: fetchObjectById: tried '3' times, exception getting object by id: be7117af-a03ecdf4-be69a9da-1f04cee: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:228) [sqljdbc.jar:]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1007) [sqljdbc.jar:]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:3173) [sqljdbc.jar:]
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:748)
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:734)
at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:405)
at com.netegrity.ims.persistence.DBDAOFactory.fetchObjectById(DBDAOFactory.java:169) [ims.jar:]
at com.netegrity.ims.persistence.DBDAOFactory.getObjectById2(DBDAOFactory.java:252) [ims.jar:]
at com.netegrity.ims.persistence.PersistenceProvider.getTaskSessionFromResultSet(PersistenceProvider.java:3973) [ims.jar:]
at com.netegrity.ims.persistence.PersistenceProvider.getTaskSession(PersistenceProvider.java:351) [ims.jar:]
at com.netegrity.ims.IMSEvent.getTaskSession(IMSEvent.java:498) [ims.jar:]
at com.ca.identitymanager.provisioning.listener.ProvisioningTransactionProtectionListener.complete(ProvisioningTransactionProtectionListener.java:133) [identitymanager.jar:]
at com.netegrity.ims.bootstrap.IMSMessageListener.processEventToNextSavePoint(IMSMessageListener.java:432) [ims.jar:]
at com.netegrity.ims.bootstrap.IMSMessageListener.processToEndState(IMSMessageListener.java:213) [ims.jar:]
at com.netegrity.ims.bootstrap.IMSMessageListener.onMessage(IMSMessageListener.java:175) [ims.jar:]
at com.netegrity.ejb.message.subscriber.SubscriberMessageBean.onMessage(SubscriberMessageBean.java:71) [ims.jar:]
at sun.reflect.GeneratedMethodAccessor133.invoke(Unknown Source) [:1.8.0_144]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_144]
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_144]
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:104) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:60) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
It will be really helpful is someone can provide a cause and solution for the above exception.
Thanks
Ank