Internal Server Error while loading data into Data Stewardship Console (DSC)

Symptoms

You see the following error while loading data into DSC:

org.talend.datastewardship.server.task.creation.TaskLoadException: Internal Server Error 
 at org.talend.datastewardship.server.task.creation.TaskLoadClient.doLoad(TaskLoadClient.java:92) 
 at employermdm_dev.employer_survivorship_0_1.Employer_Survivorship.tMysqlInput_1Process(Employer_Survivorship.java:3975) 
 at employermdm_dev.employer_survivorship_0_1.Employer_Survivorship.runJobInTOS(Employer_Survivorship.java:5352) 
 at employermdm_dev.employer_survivorship_0_1.Employer_Survivorship.main(Employer_Survivorship.java:4950) 
 [FATAL]: employermdm_dev.employer_survivorship_0_1.Employer_Survivorship - tStewardshipTaskOutput_1 Internal Server Error

 

Diagnosis

The default value of maxPostSize is 2M. This error occurs when transferring larger amounts of data.

 

Solution

  1. Open MDM\apache-tomcat\conf\server.xml for editing.
  2. Add maxPostSize="8000000" as shown below to set maxPostSize to 8 MB (adjust this value based on your needs).
  3. <Connector port="8180" protocol="HTTP/1.1" 
     connectionTimeout="20000" 
     redirectPort="8543" maxPostSize="8000000" />
  4. Restart MDM and Data Stewardship (if DSC is embedded in MDM, restarting the MDM server is enough).
  5. Delete old data/tasks in the DSC Web UI.
  6. Open the Job in Studio > Run tab > Advanced settings > JVM, then increase the following parameters' values as shown (adjust the values based on your needs):
     -Dtaskload_connect_timeout=7200000 
     -Dtaskload_read_timeout=7200000
Version history
Revision #:
4 of 4
Last update:
‎02-09-2018 04:03 PM
Updated by: