Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a job to load data from MSSQL server to HANA.
The jobs loads data in batch using looping over dates.
The data in one table is around 9.2 Million and the job gets stuck there in TAC and did not show any error or something.
Is it because of huge data ?
If yes then how can i increase the performace ?
Hello Prakhar, I would try to increase the JVM memory settings the minimum and the maximum by in the job design in the studio under the run tab increase the -Xms and -Xmx settings a nominal amount and see if the performance is increased. Also you may want to see if the data did make it to its endpoint and maybe look at the TAC logs to see if just the data from the jobserver is not being fed back to the database that then is not visualized for you properly.
If this second scenario is correct then you can increase the memory for the TAC under the apache-tomcat/bin/setenv.sh or setenv.bat
Also under the apache-tomcat/webapps/org.talend.administrator-xxx.xxx/WEB-INF/classes/configuration and quartz .properties files need to be configured.
Here is the recommendation guide because it could be that your TAC does not have enough threads to manage the updates from the jobserver to the backend TAC DB.
https://help.talend.com/r/aCVAW0cboS1qd4dvfRSDLw/V2xdM2gRRYU84_ntj9KFYg