Troubleshooting
Problem
When running the ETL jobs from a Rational product or solution, the "java.net.BindException: Address already in use: connect" excption is logged when the job processes data that requires a large number of pagination through the REST service.
Symptom
If the Rational product or solution requires a large number of pages when retrieving a record via REST service, the Rational Insight ODBC/JDBC driver consumes a log of TCP connection ports. If the consumed TCP connections port number reaches the maximum specified by the operation system TCP connection ports, the Java Virtual Machine throws the exception since there are no more TCP connection ports available.
Resolving The Problem
To work around this issue, you can do one of the following:
- Change the default suffix value of the Relative Path to a larger number:
- Open the related XDC file using the XML Data Configuration tool.
- In the Relative Path field of the resources artifacts, change the default suffix value from
size=10to a larger number. For examplesize=1000.
For example, open the workitem301.xdc (For RTC 3.0.1) in the XML Data Configuration tool. Open the resource definition WorkItemHistory and then change the attribute definition of Relative Path, replacing the string size=10 with size=1000.
< /br> - Change the default maximum port number parameter to a larger number:
- Start the Windows Registry Editor.
- Navigate to the sub key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters - In the Edit menu, click New > DWORD Value, and then add the following values:
Name: MaxUserPort
Type: DWORD
Value: 65534(Decimal)
Tip: The default value of this parameter is 5000. The value of this parameter can be set from 5000 to 65534. This parameter controls the maximum port number that is used when a program requests any available user port from the system. Typically, ephemeral (short-lived) ports are allocated between the values of 1024 and 5000 inclusive.
< /br> - Exit the Registry Editor and then restart your machine.
Was this topic helpful?
Document Information
More support for:
Rational Insight
Software version:
1.0, 1.0.0.1, 1.0.0.2, 1.0.1, 1.0.1.1, 1.1
Operating system(s):
Windows
Document number:
465759
Modified date:
16 June 2018
UID
swg21573808