Actually, I am not setting anywhere the timeout. What would be the default timeout value? I verified the source code but could not find the value. Also, the process was not taking more than a minute for my operation. I hope, the default value should be more than a minute.
Another question I have is on the logging/Exception handling. Where is the code to handle exceptions raised in the execution? I want to check the reason for termination or not functioning my app as expected. On Thursday, 4 May 2017 13:44:26 UTC+5:30, Ayende Rahien wrote: > Check for timeout in the bulk insert, I would guess. > > *Hibernating Rhinos Ltd * > > Oren Eini* l CEO l *Mobile: + 972-52-548-6969 > > Office: +972-4-622-7811 *l *Fax: +972-153-4-622-7811 > > > > On Wed, May 3, 2017 at 1:45 PM, Vijay Sheganti <[email protected] > <javascript:>> wrote: > >> Yes. >> I am reading data from the source and target using InputCommandOperation >> (2 diff classes) and joining to check for existence in the target table. If >> the records do not exist in the target, inserting them using >> SQLBulkInsertOperation. >> As I am not seeing any records in target table for all the source data, I >> have modified my query which pulls data from source to pull a specific >> number of records.During this experiment, I found it's inserting 60K >> records and not more than that. >> >> Verified space in DB and my code. Not sure what else should I do. >> Thankful for any help on this. >> >> On Wednesday, May 3, 2017 at 1:57:53 PM UTC+5:30, Ayende Rahien wrote: >>> >>> Are you doing that as a single transaction? >>> >>> *Hibernating Rhinos Ltd * >>> >>> Oren Eini* l CEO l *Mobile: + 972-52-548-6969 >>> >>> Office: +972-4-622-7811 *l *Fax: +972-153-4-622-7811 >>> >>> >>> >>> On Wed, May 3, 2017 at 11:26 AM, Vijay Sheganti <[email protected]> >>> wrote: >>> >>>> I have a package which reads data from the source and insert to target >>>> table based on the record existence. Everything works fine when the source >>>> record count is up to 60000. Will there be any settings or reasons for >>>> such >>>> behaviour? BTW, the source contains 700K records. I wanted to load all in >>>> a single run. >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Rhino Tools Dev" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> To post to this group, send email to [email protected]. >>>> Visit this group at https://groups.google.com/group/rhino-tools-dev. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "Rhino Tools Dev" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/rhino-tools-dev. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/rhino-tools-dev. For more options, visit https://groups.google.com/d/optout.
