I recently deployed an application using SQL Anywhere v 12.0.1.3942 with the .Net Dataprovider and using Entity Framework 5.
Since deployment a few days ago I've noticed that I'm intermittently getting the following error -
iAnywhere.Data.SQLAnywhere.SAException: Run time SQL error -- *** ERROR *** Assertion failed: 104909 (12.0.1.3942)[] Invalid request on pooled connection
Here is the complete stack trace -
http://pastebin.com/rsbChVXN
So far I haven't been able to find any details on what the potential cause of this may be as I am wrapping my context's in using blocks.
Like I said earlier, its only happened a total of 3 times, but I'd prefer to get to the bottom of this before things potentially get out of hand. Thanks in advance.
entity-framework
connection-pooling
This is a known issue. This can potentially happen if you have a newer version of the database server than the ADO.NET provider.
Specifically,
CR #742355
is implemented on the database server (the server is a higher build than 12.0.1.3924 or 16.0.0.1588), but
CR #741707
is not implemented on the ADO.NET provider (the ADO.NET provider is a lower version than 12.0.1.3924 or 16.0.0.1588).
Deploying the same version of the ADO.NET provider to match the database server version (e.g. 12.0.1.3942) to the client should resolve this issue.
permanent link
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
Powered by
SQL Anywhere 17
Disclaimer: Opinions expressed here are those of the poster and do not
necessarily reflect the views of the company.