Remedy - Server - ERROR (90) Connection refused error when running the arsrename utility

Knowledge Article

Article Number

000242306

Old Article Number

000138764

Article Type

Solutions to a Product Problem

Title

Remedy - Server - ERROR (90) Connection refused error when running the arsrename utility

Summary

Why am I getting an ERROR 90 in the middle of running arsrename utility?

Product

Remedy AR System Server

Component

Remedy AR System Server

Applies to

ARS 9.x

Problem

When running arsrename utility the following error can be observed:
..................................
ERROR - Error occured while scanning form - <form_name> ERROR (90): Cannot establish a network connection to the AR System server; Connection refused: connect <AR_Server_Name>: <AR_Port>
..................................

Enabling the arsrename utility logging in debug mode (article: Remedy - Server - How to enable debug logging for the arsrename utility ) the following full error message is observed recreating the same scenario:
....................................
DEBUG - Match number of entires on form - AR System Metadata: field for Qualification - [Operation=1,Operand Left=[Operation=4,Operand Left=[Operation=1,Operand Left=[Operand Type=[type=1],Operand=20018],Operand Right=[Operand Type=[type=2],Operand=978]],Operand Right=<null>],Operand Right=[Operation=2,Operand Left=[Operation=4,Operand Left=[Operation=1,Operand Left=[Operand Type=[type=1],Operand=20502],Operand Right=[Operand Type=[type=2],Operand=4]],Operand Right=<null>],Operand Right=[Operation=4,Operand Left=[Operation=1,Operand Left=[Operand Type=[type=1],Operand=20502],Operand Right=[Operand Type=[type=2],Operand=5]],Operand Right=<null>]]] - is - 15
DEBUG - Retrieved entries in chunk - 15 and adding them in total entries to be returned.
DEBUG - Number of character fields on a form - FIN:CostCenterUDAAssociations is - 15
DEBUG - Skipping reserved field - 1
DEBUG - Skipping reserved field - 2
DEBUG - Skipping reserved field - 4
DEBUG - Skipping reserved field - 5
DEBUG - Skipping reserved field - 15
DEBUG - Skipping reserved field - 179
DEBUG - After skipping reserved fields, final number of character fields on a form - FIN:CostCenterUDAAssociations is - 9
DEBUG - Total Entries in the form - FIN:CostCenterUDAAssociations are - 1131815
Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
   at java.lang.String.substring(Unknown Source)
   at com.bmc.arsys.api.Entry.buildGLEWFResponse(Entry.java:367)
   at com.bmc.arsys.api.RpcHandConverter.fromRpcGetListEntryWithField(RpcHandConverter.java:3962)
   at com.bmc.arsys.api.ProxyJRpc.ARGetListEntryWithFields(ProxyJRpc.java:1463)
   at com.bmc.arsys.api.ARServerUser.getListEntryObjects(ARServerUser.java:4618)
   at com.bmc.arsys.artools.dbscan.DBScanner.scanEntriesInChunk(Unknown Source)
   at com.bmc.arsys.artools.dbscan.DBScanner.dbScan(Unknown Source)
   at com.bmc.arsys.artools.dbscan.DBScanner.performFindOperation(Unknown Source)
   at com.bmc.arsys.artools.dbscan.DBScanner.performOperation(Unknown Source)
   at com.bmc.arsys.artools.dbscan.DBScanner.execute(Unknown Source)
   at com.bmc.arsys.artools.dbscan.DBScanner.main(Unknown Source)
....................................

Cause

Not enough memory allocated for the arsrename java process.

Solution

This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

As observed in the debug output and since the utility is reading data in a field, most likely some field on the last form referenced, has a diary field with a lot of data.
The way to proceed is by increasing the memory by editing the arsrename file using the -Xmx parameter for which the default is 1024m.

Windows
Locate the arsrename.bat in the AR System install dir\ARSystem\artools folder:
Example out of the box batch file:
........................
@echo off
set AR_INSTALL_DIR=../
:: Set AR Home first.
set AR_HOME=C:/Program Files/BMC Software/ARSystem/
:: Set AR Api's path.
set AR_API_LIB=%AR_HOME%/Arserver/api/lib
:: Set ARTools home.
set ARTOOLS_HOME=%AR_HOME%/artools
set path=%ARTOOLS_HOME%;%path%
set VERSION=91_build002
if "%JAVA_HOME%" == "" GOTO NO_JAVA
"%JAVA_HOME%\bin\java" -Xmx1024m -classpath "%ARTOOLS_HOME%;%ARTOOLS_HOME%/etc/arsrename;%ARTOOLS_HOME%/lib/artools%VERSION%.jar;%AR_API_LIB%/arapi%VERSION%.jar;%AR_API_LIB%/arapiext%VERSION%.jar;
%AR_API_LIB%/log4j-1.2.14.jar;%AR_API_LIB%/arutil%VERSION%.jar;" com.bmc.arsys.artools.dbscan.DBScanner %*
GOTO END
:NO_JAVA
@echo JAVA_HOME env variable is not defined.
:END
........................
Increase the heap setting to: -Xmx4096m
Save the file and launch the utility again.

Linux
Locate the arsrename.sh in the /opt/bmc/ARSystem/artools folder.
Edit the file. Example:
............
#!/bin/sh
# Set AR Installation directory
AR_INSTALL_DIR=../
# Set AR Home first
AR_HOME=/opt/bmc/ARSystem
# Set ARTool home.
ARTOOLS_HOME=$AR_HOME/artools
# Set location for AR Api's
AR_API_LIB=$AR_HOME/api/lib
LD_LIBRARY_PATH=$ARTOOLS_HOME:$LD_LIBRARY_PATH

VERSION=91_build005
if [ -z $JAVA_HOME ]
then
echo "JAVA_HOME not defined" && exit 1
fi
$JAVA_HOME/bin/java -Xmx1024m -classpath $ARTOOLS_HOME:$ARTOOLS_HOME/etc/arsrename:$ARTOOLS_HOME/lib/artools$VERSION.jar:$AR_API_LIB/arapi$VERSION.jar:$AR_API_LIB/arapiext$VERSION.jar:$AR_API_LIB/log4j-1.2.14.jar:$AR_API_LIB/arutil$VERSION.jar com.bmc.arsys.artools.dbscan.DBScanner "$@"
............
Increase the heap setting to: -Xmx4096m
Save the file and launch the utility again.

Note, if you are using an exclusion file make sure the correct file is appended in the command using the correct path.

Attachment(s):