Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi,

Good Day!

I'm working on an ASP.NET MVC application with EF 4.3 and SA 11.0.1 2808 as my database server but got stuck on data update. Savechanges() function throw an UpdateException. I've read link EBF 2813 resolved this issue but I don't see that EBF on the sybase download page. When will it be posted?

UpdateException:

System.Data.UpdateException was unhandled by user code
  Message=An error occurred while updating the entries. See the inner exception for details.
  Source=System.Data.Entity
  StackTrace:
       at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
       at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)
       at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
       at System.Data.Objects.ObjectContext.SaveChanges()
       at AssortmentManager.Controllers.OperationController.Edit(operation operation) in D:\projects\WEBCSHARP\AssortmentManager\AssortmentManager\Controllers\OperationController.cs:line 80
       at lambda_method(Closure , ControllerBase , Object[] )
       at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
       at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<invokeactionmethodwithfilters>b__12()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
  InnerException: iAnywhere.Data.SQLAnywhere.SAException
       Message=Column 'WINFS' not found
       Source=SQL Anywhere .NET Data Provider
       ErrorCode=-2147467259
       NativeError=-143
       StackTrace:
            at iAnywhere.Data.SQLAnywhere.SACommand.ExecuteNonQuery()
            at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
            at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
       InnerException:

asked 11 Jul '12, 18:09

cirxesoul's gravatar image

cirxesoul
16114
accept rate: 0%

edited 11 Jul '12, 18:34

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050

It is impossible to know or predict when any particular build will be posted.

However, 2808 went up in May so maybe another one will be posted soon. Anything at or above 2813 qualifies.

(11 Jul '12, 18:37) Breck Carter

Yes! SQL Anywhere - Express Bug Fix, Update of 11.0.1 to build 2825 is up! I'm going to try this and give everyone a heads up if this fixes the data provider bug.

Tests done and indeed it's fixed. Thank you! SQL Anywhere ROCKS!

permanent link

answered 19 Jul '12, 21:20

cirxesoul's gravatar image

cirxesoul
16114
accept rate: 0%

edited 19 Jul '12, 22:09

now I can enjoy HTML5 ASP.NET MVC, KendoUI with the coolest RDBMS ever!!!

(19 Jul '12, 22:12) cirxesoul
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×69

question asked: 11 Jul '12, 18:09

question was seen: 5,454 times

last updated: 19 Jul '12, 22:12