Search found 98 matches
- 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?
- 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...
- Fri Jan 15, 2016 2:01 pm
- Forum: Integration Development
- Topic: could not execute batch command.[SQL: SQL not available]
- Replies: 11
- Views: 2423
- 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...
- 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...
- 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...
- 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...
- 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.
- Thu Aug 06, 2015 11:39 am
- Forum: Integration Development
- Topic: Access to the path 'SoftProServer4.0' is denied.
- Replies: 11
- Views: 1735
- Wed Aug 05, 2015 5:17 pm
- Forum: Integration Development
- Topic: Access to the path 'SoftProServer4.0' is denied.
- Replies: 11
- Views: 1735
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...