Re: Reliably reproducing Native Exception 0xc0000005 on SQL CE 2.0
- From: "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 07:50:27 -0600
Yes, I can consistently recreate that as well. I ran a compact on your
database
and that didn't help either. Not that it shouldn't work, but why are you
appending GUIDs together in a single column (your concept of asset type
path)?
Why wouldn't this path be inherent in your logical data model?
This query will never run efficiently given that it is non-optimizable -
you have a subquery, a group by, and a LIKE in a single query. The
SQL CE QP is not going to be able to optimize that stmt.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Ken" <kmsuzuki@xxxxxxxxx> wrote in message
news:1112948356.103543.67450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>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
>
.
- Follow-Ups:
- References:
- Prev by Date: Re: Filter rows at subscriber
- Next by Date: Re: parameters in a submitsql cmd string/syncing image columns thru RDA submitsql
- Previous by thread: Reliably reproducing Native Exception 0xc0000005 on SQL CE 2.0
- Next by thread: Re: Reliably reproducing Native Exception 0xc0000005 on SQL CE 2.0
- Index(es):
Relevant Pages
|
