Print Page | Close Window

Exception: "transaction has aborted" When Implementing code sample with DevArt dotConnect for postgres

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2534
Printed Date: 13-May-2026 at 12:56am


Topic: Exception: "transaction has aborted" When Implementing code sample with DevArt dotConnect for postgres
Posted By: yasirhantoush
Subject: Exception: "transaction has aborted" When Implementing code sample with DevArt dotConnect for postgres
Date Posted: 28-Feb-2011 at 2:37am
Hello everyone,

I am trying to use DevArt dotConnect for a postgres database.
I am following the Code Sample:Hello DevForce.
I followed every step using Northinwind db and it was working fine.
Then I did same typical steps only this time using a DevArt dotConnect connection instead,, and it fails with the exception:
    - IdeaBlade.EntityModel.EntityServerException:The transaction has aborted
    - FailureType: IdeaBlade.EntityModel.PersistenceFailure.Other

This is the StackTrace:

   at IdeaBlade.EntityModel.EntityManager.HandleEntityServerException(Exception ex, Boolean tryToHandle, PersistenceOperation operation, Boolean throwOnError)
   at IdeaBlade.EntityModel.EntityManager.HandleEntityServerException(Exception ex, Boolean tryToHandle, PersistenceOperation operation, Boolean throwOnError)
   at IdeaBlade.EntityModel.EntityManager.ExecuteServerQuery(IEntityQuerySurrogate entityQuery)
   at IdeaBlade.EntityModel.EntityManager.ExecuteFetch(IEntityFinder finder)
   at IdeaBlade.EntityModel.EntityQueryFinder.Execute()
   at IdeaBlade.EntityModel.EntityManager.ExecuteQueryCore(IEntityQuery query, Boolean isAsync)
   at IdeaBlade.EntityModel.EntityManager.ExecuteQuery[T](IEntityQuery`1 query)
   at IdeaBlade.EntityModel.EntityQueryExtensions.Execute[T](IEntityQuery`1 query)
   at IdeaBlade.EntityModel.EntityQuery`1.GetEnumerator()
   at WpfApplication1.MainWindowViewModel.FirstSample() in D:\ITProjects\Scrap\WpfApplication1\WpfApplication1\MainWindowViewModel.cs:line 37
   at WpfApplication1.MainWindowViewModel.Start() in D:\ITProjects\Scrap\WpfApplication1\WpfApplication1\MainWindowViewModel.cs:line 22
   at WpfApplication1.MainWindow.Window_Loaded(Object sender, RoutedEventArgs e) in D:\ITProjects\Scrap\WpfApplication1\WpfApplication1\MainWindow.xaml.cs:line 32 ...

Any ideas what is the problem?

Thanks.


Replies:
Posted By: sbelini
Date Posted: 04-Mar-2011 at 3:32pm
yasirhantoush,
 
Sorry for the delayed reply,
 
I am in the process of investigating your issue.
 
Silvio.

Posted By: yasirhantoush
Date Posted: 05-Mar-2011 at 12:19pm
Hello sbelini,

Thanks for the follow up.

I Found out that whenever I set the DevForce Enabled = False in the model properties, it works absolutely fine.
That means when I am using the Entity Framework without DevForce.

Thanks.
Yasir.

Posted By: sbelini
Date Posted: 05-Mar-2011 at 1:23pm
Yasirhantoush,
 
Thanks for the update.
 
Can you enable DevForce back and try the following:
 
TransactionSettings.Default = new TransactionSettings (System.Transactions.IsolationLevel.ReadCommitted,
                                                                                     new TimeSpan(0, 1, 0),
                                                                                     false);
 
Let me know if the issue still persists after that.
 
Silvio.

Posted By: yasirhantoush
Date Posted: 06-Mar-2011 at 3:24am
Hello Silvio,

After adding the .Net reference System.transactions, and adding the provided code, it is working now.

Thanks.
 
Yasir.


Print Page | Close Window