September 24, 2015 at 3:00 am
Got this error running a query with ssms2014
on SqlServer2014
but db has Compatibiliy level 100 (sql2008)
no sql error code in message and no error found in eventviewr (sqlserver log, windows log, application log ecc)
when i run that query i got this message in "messages" tab, and in results tab i got a strange result, indeed the value returned doesn't exists in table.
ex table1.field1 possible values= 2,3
it returns 1113344
we got that error thru jdbc too
that query use a lot of joins, unfortunatley i can't post it here.
today got this error, so i make a copy of 1 of involved table into another db in the same instance, re run the query on the original db, and it works well.
this happens sometimes, but can't find anything
could be a cache problem? DB has 4,5TB of data, 700-1000 conns and 500GB of ram
any ideas?
September 25, 2015 at 1:55 am
a little update,
the problem seems to be on a PK of one involved table.
Example
test1 - select join of all original tables
tabA
tabB
tabC
when the query return no data, i got a disconnection with fatal error
test2
tabA -
dbtest.dbo.tabB -
tabC
Same as test1
test3
tabA -
dbtest.dbo.tabB without PK
tabC
all OK, with (o row(s) affected)
could be a bug?
September 25, 2015 at 4:48 am
found the error code:
An error occurred while executing batch. Error message is: Internal connection fatal error. Error state: 15, Token : 193
but didn't find anything about it
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply