Dear Sakthi,
Exception can be caught using the Try Catch block. There is a good explanation on the use of try catch here.
If you are already using try catch, please post your code for us to take a look at it.
Hope it helps.
Best regards,
Pedro Magueija
Dear Friend,
Already I have used the Try .. Catch. But I could not catch the Time out Exception.
When we do goods receipt in large No.(for ex: 5000 item ) with serial number in DI API. Assigning serial no for item in for loop.
Even After increase the SQL Server connection time out, System is getting hanging without giving any error message or Exception.
In this case How to handle Connection time out
Help me...
Regards,
K Sakthivel
Hi Shaktivel,
Your problem is probably the Company object time out. I don't think it is related to the SQL Server connection timeout, unless you are using an ODBC connection.
Are you also using UI API on your addon? If you are you can try to keep the connection alive by clicking an item on your form every 100 rows. This is not the perfect solution but I don't know any other way of keeping the connection alive.
You can see a similar thread here.
Hope it helps.
Best regards,
Pedro Magueija
Dear Friend,
Already I have used the Try .. Catch. But I could not catch the Time out Exception.
When we do goods receipt in large No.(for ex: 5000 item ) with serial number in DI API. Assigning serial no for item in for loop.
Even After increase the SQL Server connection time out, System is getting hanging without giving any error message or Exception.
In this case How to handle Connection time out
Help me...
Regards,
K Sakthivel
Hi K Sakthivel,
If you are looping through the itemcodes with an SqlDataReader, that SqlDataReader is probably locking the OITM records that you are trying to update.
Try using an SqlDataAdapter and DataSet instead of a SqlDataReader
Regards,
Johan
