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.

asked 16 Oct '13, 14:28

elindalyne's gravatar image

elindalyne
101339
accept rate: 0%


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

answered 16 Oct '13, 14:46

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

edited 16 Oct '13, 14:48

2

Thanks for the info! We updated the data provider within the application and so far we haven't seen anymore connection pooling errors.

(17 Oct '13, 10:26) elindalyne

I had the same exception with EF6, Server 12.0.1.4165, Ado.NET Provider 12.0.1.41654 ?, but in my case it was caused by different threads accessing the same db context which of course is not supported. The scenario can easily be reproduced by starting several threads accessing the same context.

(02 Dec '14, 02:53) dIeGoLi

Same error with driver version 16.0.0.20764 and db version 16.0.0.2038. Any suggestion?

permanent link

answered 16 Nov '15, 03:22

shs4u's gravatar image

shs4u
11122
accept rate: 0%

2

> Any suggestion?

Yes. Please make the effort to start a new question, with all the supporting information (error message, etcetera). It is unlikely to be the "Same error" because the other error has a solution.

(16 Nov '15, 07:56) Breck Carter
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:

×65
×12

question asked: 16 Oct '13, 14:28

question was seen: 1,444 times

last updated: 16 Nov '15, 07:58