Dear all,
In our production environment, there is network connectivity issues time to time. Network goes out for few seconds and comes back. So we would like to enable HPC to retry the SQL commands if they fail the first time.
Is there any way I can configure my SQL connection settings so that the SQL command can be retried. For an example, we have below exception while updating the job properties, and we believe this is due to the network issue. can we provide some retry option
here?
Server stack trace:
at Microsoft.Hpc.Scheduler.Store.TransactionProcessor.RunTransaction(Boolean shouldRetry)
at Microsoft.Hpc.Scheduler.Store.SchedulerStoreInternal.Object_SetProps(ConnectionToken& token, ObjectType obType, Int32 obId, StoreProperty[] props)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Hpc.Scheduler.Store.ISchedulerStoreInternal.Object_SetProps(ConnectionToken& token, ObjectType obType, Int32 obId, StoreProperty[] props)
at Microsoft.Hpc.Scheduler.Store.StoreServer.Object_SetProps(ObjectType obType, Int32 obId, StoreProperty[] props)
at Microsoft.Hpc.Scheduler.Store.SchedulerStoreSvc.SetPropsOnServer(ObjectType obType, Int32 itemId, StoreProperty[] props)
at Microsoft.Hpc.Scheduler.SchedulerJob.Commit()
at HPC.JobManager.JobManager.UpdateJobProperties(String jobId, Dictionary`2 changedProperties) in C:\RST_Deploy\TempDeployPkg\SourceCode\RstSvn\src\BatchExecution\WindowsHPC\HPC.JobManager\JobManager.cs:line 382
Puneet Sharma
