Hi,
I have sql server 2008 with sp1.
I use XML features of the sql server and I have some xml schema attached to the xml column.
The issue is I have some element in the xml schema defined like below:
<xs:element name="BodyBack" type="xs:base64Binary" minOccurs="0" />
When I try to insert some xml content with base64 encoded value, the server encounters the problem with info like below:
Location: tmpilb.cpp:2580
Expression: fFalse
SPID: 53
Process ID: 3344
Description: Attempt to access expired blob handle (3)
Location: tmpilb.cpp:2580
Expression: fFalse
SPID: 53
Process ID: 3344
Description: Attempt to access expired blob handle (3)
Msg 3624, Level 20, State 1, Line 474
A system assertion check has failed. Check the SQL Server error log for details.
...
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command.
The results, if any, should be discarded.
SQL Server should optimize space/data pages usage when it stores content for binary xml element(when it knows it from XML schema).
Some info about the mapping between XML and SQL Server data types is here:
http://msdn.microsoft.com/en-us/library/aa258643(SQL.80).aspx
and here:
http://msdn.microsoft.com/en-us/library/ms172701.aspx
Does anybody know any simple workaround for this issue (I'd like to avoid creating some code in .NET as an extension to sql server functionality)?
Regards,
Alek