Limitation on rows in TOS

[Anonymous]

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.

[Anonymous]

As a test, can you reduce the "Commit every" to 1000 and the "Use Batch Size" to 1000. Then try running it.

[TRF]

OK, I forgot the option "Commit every"...

Can you share the basic settings too?

[Anonymous]

After reducing the "Commit every" to 1000 and the "Use Batch Size" to 1000, the data is loaded for one job which has 1642 rows,

 the second job which has 52000 rows  is still not updated.. I have hard coded it to 1000 as well.. please suggest

[TRF]

Try to add an explicit tMSSqlCommit at the end.

[Anonymous]

what do i fill here ? attached screenshot

Screenshot_6.png

[Anonymous]

This is likely caused by your Input component. Can you show us your job and component config? Do you get an error? Are ANY rows being loaded to your database out of the 52000?

[TRF]

You need a MS SQL Connection (tMSSQLConnection component to be added at the beginning then to be reused for tMSSQLOutput and tMSSQLCommit components)

[Anonymous]

No, rows are not loaded to the database. attached screenshot

Screenshot_7.png

[TRF]

Are you able to use a tLogRow component after the tMSSQLOutput (connected with the Reject flow)?

[Anonymous]

Ah, I see you are using the Oracle componenst :-).In your Advanced settings of your Input component, tick use cursor.