QuoteReplyTopic: Transaction Timeout -> fine in dev ,no in stage Posted: 02-Oct-2012 at 7:15am
Hello, I've a sp that takes some time to execute (It calculates a lot of positions on DB), from SQL Management studio takes 10 minutes, executing it from my developing platform (we've the DB that's over la intranet) tooks around 16minutes... and it works...when I execute it on the stage enviorment I got a transaction timed out....
for both the methos is the same
public OperationResult Generate(DateTime scadenza, Action onSuccess = null, Action<Exception> onFail = null) { var query = entityManagerProvider.Manager.myqueryQuery(12345,date);
TransactionSettings settings = new TransactionSettings(System.Transactions.IsolationLevel.Serializable, new TimeSpan(0, 0, 30, 0, 0));
QueryStrategy qs = new QueryStrategy(QueryStrategy.DataSourceOnly, settings);
query.CommandTimeout = 1800; var op = query.With(qs).ExecuteAsync();
I spotted the problem..... would have wasted almost a month....it was the user for staging enviorment.... it was not liked by a linked server that was called from the SP...using the production user fixed the problem
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum