Reliably reproducing Native Exception 0xc0000005 on SQL CE 2.0

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am reliably reproducing the ExceptionCode 0xc0000005 native exception
on SQL CE 2.0 simply by issuing a particular SELECT statement against
it. If I issue the statement through ADO.NET, I get the Native
Exception window that displays ExceptionCode (among other things)
before the app crashes to the desktop. If I run the statement in the
Query Analyzer tool, it hangs the tool reliably but no Exception is
reported.

------------------
Environment Info
------------------
SQL CE 2.0.4415.0
..NETCF 1.0.3316.00
PocketPC 3.0.11171 Build 11178 (on both ARM and X86)


--------------------------
SQL CE 2.0 database file
--------------------------
http://snice.net/AssetTrackMobile.sdf


------------------------------------------
SQL Statement that causes Native Exception
------------------------------------------
SELECT
ProductSummary.ProductID,ProductSummary.Name,ProductSummary.Number,ProductSummary.ManufacturerID,ProductSummary.ManufacturerName,ProductSummary.AssetTypeID,ProductSummary.AssetTypeName,ProductSummary.DateCreated,ProductSummary.DateModified,ProductSummary.Status,ProductSummary.AssetTypeLineage

FROM ProductSummary
WHERE (ProductSummary.AssetTypeID IN (
SELECT AssetType.AssetTypeID
FROM AssetType
WHERE (AssetType.Path LIKE
'%86171b60-72f7-4b74-96e4-dc1ef32f3f73>%')))
ORDER BY ProductSummary.Number ASC


Oddly enough, omitting the ORDER BY clause allows the statement to run
without raising the NativeException.


If there's someone who is familiar with this problem, I'd appreciate
any insights. I've seen a few people from the SQL CE group at MS
interested in reliable repro please let me know if I can provide
further information on this.

Regards,

Ksuzuki AT gmail DOT com

.

Relevant Pages

  • Ken
    ... I am reliably reproducing the ExceptionCode 0xc0000005 native exception ... on SQL CE 2.0 simply by issuing a particular SELECT statement against ... Query Analyzer tool, it hangs the tool reliably but no Exception is ...
    (microsoft.public.sqlserver.ce)
  • RE: Express refuses to install
    ... Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup ... Action "LaunchPatchedBootstrapAction" will be skipped due to the following ... Action "InvokeSqlSetupDllAction" threw an exception during execution. ... Aborting queue processing as nested installer has completed ...
    (microsoft.public.sqlserver.setup)
  • Re: App_data - ASPNETDB.MDF
    ... If your hosting provider doesn't support Sql Express version, ... retrieving the user's local application data path. ... Anunhandled exception occurred during the execution of the ... Please make sure theuser has a local user profile ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Reliably reproducing Native Exception 0xc0000005 on SQL CE 2.0
    ... SQL CE QP is not going to be able to optimize that stmt. ... >I am reliably reproducing the ExceptionCode 0xc0000005 native exception ... > SQL CE 2.0 database file ...
    (microsoft.public.sqlserver.ce)
  • Re: SQLCommandparameters - viewing prepared statement
    ... corresponding value (we actually often use different levels of logging so at ... throw back Print Statements as well as Sql Error msgs with a Severity level ... If the query threw an exception the evaluated ... the exception that says "incorrect ...
    (microsoft.public.dotnet.framework.adonet)