TDM Confirm table with 1200 tables errors in the portal 4.9

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We have a schema with 1200 tables. When we select the tables to confirm them, the job never finishes.

None of the table selected are confirmed. It does work on a small set of table 120.

Table size of 130  takes  around 2 minutes, and for  Table size 980 it took 13mins. 

Environment

Release : 4.9

Component : CA Test Data Manager

Cause

When user clicks on Confirm button we pass the table Id through request header, due to the large number of tables, request header size surpasses the default size which defined in the server. That is why server rejects the request and it looks like hang.

Resolution

There are no limits on the number to tables you can confirm, only those imposed by the DB engines.

Find the below solution-

You are using port 8443 that is for HTTPS


1. Go to - C:\Program Files\CA\CA Test Data Manager Portal\tomcat\conf\server.xml
2. Find below lines and add maxHttpHeaderSize="10000000" as attribute

      <Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true" scheme="https" secure="true" clientAuth="false" sslProtocol="TLSv1.2" keystoreFile="${tdmweb.keystorePath}" keystorePass="${tdmweb.keystorePassword}" keyAlias="${tdmweb.keyAlias}" ciphers="TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256, TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256, TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384,TLS_DHE_RSA_WITH_AES_256_GCM_SHA384,TLS_DHE_RSA_WITH_AES_128_GCM_SHA256" connectionTimeout="60000" maxHttpHeaderSize="10000000" />

 

3. Restart the TDM Portal service