Search found 98 matches

by mrisen
Tue Jan 19, 2016 8:27 pm
Forum: Integration Development
Topic: could not execute batch command.[SQL: SQL not available]
Replies: 11
Views: 2423

Re: could not execute batch command.[SQL: SQL not available]

Were you able to take a look at the file?
by mrisen
Fri Jan 15, 2016 4:01 pm
Forum: Integration Development
Topic: could not execute batch command.[SQL: SQL not available]
Replies: 11
Views: 2423

Re: could not execute batch command.[SQL: SQL not available]

Ok, I had to lookup how to do that. Looks like a useful thing to know, though I'm not 100% sure how to read the results. There are 2 deadlocks on this graph. Both relating to updating pt.SearchTransaction. One looks like a straightup deadlock while the other does not (all the requests are going in o...
by mrisen
Wed Jan 13, 2016 5:25 pm
Forum: Integration Development
Topic: could not execute batch command.[SQL: SQL not available]
Replies: 11
Views: 2423

Re: could not execute batch command.[SQL: SQL not available]

Here is the full method: public void ApplyTemplateAndDisburse(string orderNumber) { var configuration = GetConfiguration(); using (var selectServer = GetSelectServer(configuration)) { var orderStore = selectServer.GetService<IOrderStore>(); var orderInfo = orderStore.Orders.FirstOrDefault(x => x.Num...
by mrisen
Wed Jan 06, 2016 2:45 pm
Forum: Integration Development
Topic: could not execute batch command.[SQL: SQL not available]
Replies: 11
Views: 2423

Re: could not execute batch command.[SQL: SQL not available]

An error occured on the service boundary.Error: could not execute batch command.[SQL: SQL not available] Stack Trace: at NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps) at NHibernate.AdoNet.AbstractBatcher.ExecuteBatchWithTiming(IDbCommand ps) at NHibernate.AdoNet.AbstractBa...
by mrisen
Mon Jan 04, 2016 3:25 pm
Forum: Integration Development
Topic: could not execute batch command.[SQL: SQL not available]
Replies: 11
Views: 2423

Re: could not execute batch command.[SQL: SQL not available]

at SoftPro.ClientModel.Proxies.ClientProxy`1.OnHandleFaultException(FaultException exception) at SoftPro.ClientModel.Proxies.ClientProxy`1.HandleFaultException(FaultException exception) at SoftPro.Accounting.Client.Transactions.TransactionsManagerServiceClient.ApplyChanges(String reason, List`1 tran...
by mrisen
Thu Dec 31, 2015 6:17 pm
Forum: Integration Development
Topic: could not execute batch command.[SQL: SQL not available]
Replies: 11
Views: 2423

could not execute batch command.[SQL: SQL not available]

In my test environment I often get a could not execute batch command.[SQL: SQL not available] exception when running tests. It only happens when I run many tests at the same time... some sort of race condition. The call that receives the exception is: transactionsManager.ApplyChanges(Constants.TestS...
by mrisen
Wed Sep 02, 2015 1:06 pm
Forum: Integration Development
Topic: ReceivedByID is null
Replies: 4
Views: 756

Re: ReceivedByID is null

The issue ended up being a 1-off item. We fixed it by updating a task, I believe, for one order and saving it.
by mrisen
Wed Aug 05, 2015 5:17 pm
Forum: Integration Development
Topic: Access to the path 'SoftProServer4.0' is denied.
Replies: 11
Views: 1734

Re: Access to the path 'SoftProServer4.0' is denied.

So this is a test box with pretty much a default SoftPro installation. The SoftPro DBs, windows services, and client (and everything else) is on the box. The calling process, which is hosted by IIS, is also on the same box. Looking at other test boxes, this account has been added to the local admini...