Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Limitation on rows in TOS

Is there a limitation on the no of rows in trial version of TOS ?   my job is not loading the data after 20000rows.. looks like it is not updating more than that.

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Take a look at this: https://stackoverflow.com/questions/44188234/azure-exceeded-the-memory-limit-of-20-mb-per-session-fo...

 

It shows that this is likely an Azure configuration limitation. I do not believe this is a Talend issue.

View solution in original post

23 Replies
Anonymous
Not applicable
Author

No there is a no limitation on the number of rows that Talend will process. I have processed 100s of millions in the Open Source Edition. What are you trying to do? This could be a memory limitation or an issue caused by data.

Anonymous
Not applicable
Author

when you say memory limitation , could you explain more on this.?
 i am trying to load data from oracle to ms-sql..

Anonymous
Not applicable
Author

The limit of what your system can handle and your JVM settings have been set to. Look up "Talend JVM settings" on line. Talend do not impose any limits on developers.

TRF
Champion II
Champion II

Hi,

Do you have any error message?

Are you running the job from the Studio? 

If so, how many rows are counted after tOracleInputComponent (should appear in green on the link after the component)?

Anonymous
Not applicable
Author

can you comment on this job ? this has only 1642 rows , but it still does not complete... Attached screenshot


Screenshot_2.png
TRF
Champion II
Champion II

 

You need to commit your transaction at the end using a tMSSqlCommit component (or use an existing connection which configured with autocommit)

Anonymous
Not applicable
Author

please help me with this error..  in the component list i do not see any option.


Screenshot_3.png
Anonymous
Not applicable
Author

Can you show your Output component's Advanced Settings?

Anonymous
Not applicable
Author

here it is. 


Screenshot_4.png