SRM: The import-properties task has the following errors: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Résumé: The socketTimeout can be increased if the import-porperties task keeps failing on socket timeouts due to heavily loaded apg databases.

Cet article concerne Cet article ne concerne pas Cet article n’est associé à aucun produit spécifique. Toutes les versions du produit ne sont pas identifiées dans cet article.
Consulter d’autres ressources

Symptômes

The import properties task has the following errors on connectivity to apg databases: 
160627 07:07:57 : com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
160627 07:07:57 :
160627 07:07:57 : The last packet successfully received from the server was 180,025 milliseconds ago. The last packet sent successfully to the server was 180,025 milliseconds ago.

The cause of the exception is:
aused by: java.net.SocketTimeoutException: Read timed out

The socketTimeout as set for each database in APG/Web-Servers/Tomcat/Default/conf/server.xml was in this particular case set to 180000 milliseconds.

Cause

The socketTimeout will be used in the import-properties task to wait for pulling in data from the data_property table.If this time is exceeded due to a heavily loaded database at that time, the task will fail.

Résolution

We can increase the socketTimeout setting in the APG/Web-Servers/Tomcat/Default/conf/server.xml file to e.g. 5 minutes (300000 milliseconds) as per below: 
<!-- Defines the connection to the APG timeseries database for MySQL. -->
	<Resource name="jdbc/APG-DB" auth="Container" type="javax.sql.DataSource" maxActive="20" maxIdle="20" validationQuery="SELECT 1" testOnBorrow="false" testWhileIdle="true" validationQueryTimeout="5" timeBetweenEvictionRunsMillis="10000" minEvictableIdleTimeMillis="60000" maxWait="30000" username="apg" password="watch4net" driverClassName="com.mysql.jdbc.Driver" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true" url="jdbc:mysql://<db hostname>:53306/apg?autoReconnect=true&amp;socketTimeout=300000"/>
 

Produits concernés

SRM
Propriétés de l’article
Numéro d’article: 000059197
Type d’article: Solution
Dernière modification: 29 juil. 2025
Version:  4
Trouvez des réponses à vos questions auprès d’autres utilisateurs Dell
Services de support
Vérifiez si votre appareil est couvert par les services de support.