Hello.I have a question about "BulkInsert" Forge Component.
In properties of BulkInsert action, there is no settings for timeout period like normal SQL or Aggregate has.
Does it have a fixed value? or does it depend on some external settings (e.g. SQL server's setting or platform's settings)?
Thanks in advence.
S. Endo
I think I found the answer and writing it down here for those who had same question.
As I looked through the BulkInsert's code, it seems it does have fixed timeout.For SQL Server, it's 300s.
It seems it's hard-coded thus there's no way to change the value other than modifying the code.
Correct me if there's any mistakes.
Cheers,
Hi @Shinichiro Endo ,
You can try changing your module Server Request timeout property and this might fix your issue.
Put something greater than 10 & check.
Regards,
Manish Jawla
Hi @Manish Jawla ,thank you for replying.
As per my understanding, module's "Server Request Timeout" setting manipulates timeout period for server request from client.
However I believe BulkInsert's time out is for server to external connection like in SQL component.
And I've tested BulkInsert with insert which takes 2 minutes to complete, it didn't time out.Therefore I don't think that setting would affect the time out period.