Devart Forums

I can’t deploy Devart.Data.SQLite MVC4 web application to a local server. Everything works fine on my localhost.
Here are the steps that I used to build and deploy:
1) In Visual Studios 2012 New ASP.NET MVC 4 (4.5) Web Application
2) Reference purchased version Devart.Data, Devart.Data.SQLite, Devart.Data.SQLite.Web
3) Using ADO.NET Entity Data Model Import a SQLite model which is in the App_Data folder.
4) Run debug mode in visual studios. I am able to read and write to the database.
5) Deploy to a local server using MS Deploy .
6) Open website on server in Chrome. I can read from the database. When I try to create a record I get a Devart.Data.SQLite.SQLiteException: SQLite error cannot rollback - no transaction is active!
7) A SQLite Journal file has been created in the App_Data directory. Once this happens I can no longer access through the web portal. If I delete the Journal file I can once again read from the database and I can see the last transaction and it did save.

Server Error in '/SQliteTest' Application.
________________________________________
SQLite error
cannot rollback - no transaction is active
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Devart.Data.SQLite.SQLiteException: SQLite error
cannot rollback - no transaction is active

Please give us the call stack of the error. Also send us a small test project and specify the steps we should follow to reproduce the problem in our environment.

I would love to send you a test app but you have a 2mb limit on uploads. The zipped up MVC4 test app I wrote is 11mb. Please send me an alternate method of uploading. If you don't get the complete project it will be useless to you!
Here is the call stack:
Server Error in '/SQliteTest' Application.

SQLite error
cannot rollback - no transaction is active

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Devart.Data.SQLite.SQLiteException: SQLite error
cannot rollback - no transaction is active

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SQLiteException (0x1): SQLite error
cannot rollback - no transaction is active]
Devart.Data.SQLite.a7.b(bt A_0) +739
Devart.Data.SQLite.a7.d(bt A_0) +505
Devart.Data.SQLite.bt.b() +246
Devart.Data.SQLite.ah.i() +195
Devart.Data.SQLite.SQLiteDataReader.c() +92
Devart.Data.SQLite.SQLiteCommand.InternalExecute(CommandBehavior behavior, IDisposable statement, Int32 startRecord, Int32 maxRecords) +792
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) +1217
Devart.Common.DbCommandBase.ExecuteNonQuery() +27
Devart.Data.SQLite.SQLiteConnection.Rollback() +372
Devart.Data.SQLite.SQLiteTransaction.Dispose(Boolean disposing) +93
System.Data.EntityClient.EntityTransaction.Dispose(Boolean disposing) +44
System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) +4474902
System.Data.Entity.Internal.InternalContext.SaveChanges() +222
SQLiteMembership.Controllers.UserTestController.Create(UserTest usertest) +253
lambda_method(Closure , ControllerBase , Object[] ) +142
System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +286
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +39
System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +123
System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +473
System.Web.Mvc.Async.<>c__DisplayClass37.<BeginInvokeActionMethodWithFilters>b__36(IAsyncResult asyncResult) +15
System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +33
System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +240
System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +37
System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +53
System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +51
System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +606
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +288

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929

We have sent a link to our ftp server to your e-mail address.