Five Stars

Timeout error - DI OpenSource


I am creating a Job just reading from an oracle source (500,000 rows) and writing directly in a csv. It given me Timeout error after writng 50,000 lines, when i increased  xms to 512m & xmx to 512g it gives below error message after reading all lines but it took around 2 hours to read all lnes. we have 48 gb RAM in the machine and no other users are there. when i am executing the DB source it's working fine and returning output in some seconds.


Any help will be appreciated. 


Exception in thread "main" java.lang.OutOfMemoryError
at java.lang.AbstractStringBuilder.hugeCapacity(Unknown Source)
at java.lang.AbstractStringBuilder.newCapacity(Unknown Source)
at java.lang.AbstractStringBuilder.ensureCapacityInternal(Unknown Source)
at java.lang.AbstractStringBuilder.append(Unknown Source)
at java.lang.StringBuilder.append(Unknown Source)
at local_project.a_basic_job_0_1.A_Basic_Job$1Util_tLogRow_2.format(
at local_project.a_basic_job_0_1.A_Basic_Job.tOracleInput_2Process(
at local_project.a_basic_job_0_1.A_Basic_Job.runJobInTOS(
at local_project.a_basic_job_0_1.A_Basic_Job.main(

Eight Stars

Re: Timeout error - DI OpenSource

You can increase the heap from the Run->Advanced settings tab




Five Stars

Re: Timeout error - DI OpenSource

If you see my earlier mail, i already did the same changes but still it's throwing error after reading all data. 

More important its taking so much time to read the data.