Central Database offload timeout configuration

Solved34 viewscentral database offload offloading
1
0 Comments

Hi all,

We have from time to time a sqlexception from offloading data to a SQL central database. Below is the message in the SLDBConnection log.

---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
at SLCassandraClassLibrary.DBGateway.CentralDatabaseManager.ForwardData(SLSql centralConnection, String data)
at SLCassandraClassLibrary.DBGateway.CentralDatabaseManager.ForwardData(SLSql centralConnection)

This has caused some files to appear in the C:\Skyline DataMiner\System Cache\Offload\Data\failure\ folder. Is there a way to increase this timeout?

Thank you in advance.

Kind Regards,

Hugo Lopes [SLC] [DevOps Advocate] Selected answer as best 12 hours ago

1 Answer

2
1.44K 0 Comments

Hi Hugo,

Unfortunately this is not possible. However keep in mind the default timeout for our queries (including the upsert of the offloaded data) has a timeout of 30 minutes, which should be more than sufficient.

Our recommendation would be to investigate why the query takes over 30 minutes as the value there will be much greater than increasing a timeout.

Hugo Lopes [SLC] [DevOps Advocate] Selected answer as best 12 hours ago