SAP Netweaver JCO library error

Matillion ETL
1

We have an issue with the SAP Netweaver component and how it utilizes the JCO library.

Systematically we run into an error saying that we have opened to many connections to the jco library. How can this be?

0694G00000GzATfQAN_0D54G0000824JSHSA2
0694G00000GzATfQAN_0D54G0000824JSHSA21110×269 16.8 KB

Is there a way to increase the limit of 202 connections or is it a way to make Matillion release the threads earlier in order to limit how many connections Matillion binds up to the library at any given time?

2

Have anyone been able to successfully use Matillion against SAP ECC?

3

We have been able to increase the 202 conversation limit, by setting the java options parameter to the environment variables.

$ cat /usr/share/tomcat8/bin/setenv.sh

export CATALINA_OPTS="$CATALINA_OPTS -Djco.cpic_maxconv=2000"