Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / DB Engine / SQL Server CE / November 2007

Tip: Looking for answers? Try searching our database.

Data Abort & Prefetch Abort

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Simone - 08 Nov 2007 14:39 GMT
Hello.

In my PPC2003 application (CF2 Sp2 with SqlCE 3.1) when i try to insert or
update the database (my SDF is on Secure Digital) the Debugger sometimes
returns me messages like this:

Data Abort: Thread=9289e7d8 Proc=902e9c70 'Ten_Ven.exe'
AKY=00004001 PC=00d940bc RA=80048940 BVA=1e00000c FSR=00000007
The thread 0x92463a12 has exited with code 0 (0x0).
Data Abort: Thread=9381c7b4 Proc=902e9c70 'Ten_Ven.exe'
AKY=00004001 PC=00d940bc RA=80048940 BVA=1e00000c FSR=00000007
The thread 0xf24599d2 has exited with code 0 (0x0).
Load module: sqlceer30it.dll
Data Abort: Thread=9289e7d8 Proc=902e9c70 'Ten_Ven.exe'
AKY=00004001 PC=00d940bc RA=80048940 BVA=1e00000c FSR=00000007

Prefetch Abort: Thread=92c85a3c Proc=902e9760 'Ten_Ven.exe'
AKY=00000101 PC=00e1c704 RA=80048940 BVA=00e1c704 FSR=000004f0

Undefined Instruction: Thread=93871000 Proc=902e9760 'Ten_Ven.exe'
AKY=00000101 PC=00e1e0e0 RA=80048940 BVA=4253d24c FSR=000000f5
The thread 0xb3261432 has exited with code 0 (0x0).
Undefined Instruction: Thread=93871000 Proc=902e9760 'Ten_Ven.exe'
AKY=00000101 PC=00e1e0e0 RA=80048940 BVA=12080000 FSR=000004f0
The thread 0x1272fcba has exited with code 0 (0x0).
Undefined Instruction: Thread=92c85a3c Proc=902e9760 'Ten_Ven.exe'
AKY=00000101 PC=00e1e0e0 RA=80048940 BVA=08012a58 FSR=000004f0
The thread 0x72559292 has exited with code 0 (0x0).

If i detach the debugger from my app, sometimes my application crash
suddenly.

I always open/close connection (SqlCeConnection) when i talk to DataBase to
prevent Opened Connections when the PPC go to suspend mode.

Anyone help me?

Thanks in advance.

Simon.
Reply to this Message
Simone - 09 Nov 2007 15:43 GMT
More information. The application crash after a suspend/resume cycle.
This is the BugTrap Log:

MODULE LOAD mscoree.dll PID 0xB2E1974E BASE 0x01580000

MODULE LOAD ole32.dll PID 0xB2E1974E BASE 0x02800000

MODULE LOAD coredll.dll PID 0xB2E1974E BASE 0x01F60000

MODULE LOAD msasn1.dll PID 0xB2E1974E BASE 0x02840000

MODULE LOAD crypt32.dll PID 0xB2E1974E BASE 0x025A0000

MODULE LOAD schannel.dll PID 0xB2E1974E BASE 0x03610000

MODULE LOAD ntlmssp.dll PID 0xB2E1974E BASE 0x03600000

MODULE LOAD spnego.dll PID 0xB2E1974E BASE 0x028B0000

MODULE LOAD msnsspc.dll PID 0xB2E1974E BASE 0x02D00000

MODULE LOAD secur32.dll PID 0xB2E1974E BASE 0x03630000

MODULE LOAD oleaut32.dll PID 0xB2E1974E BASE 0x027D0000

MODULE LOAD ws2.dll PID 0xB2E1974E BASE 0x03680000

MODULE LOAD mscoree2_0.dll PID 0xB2E1974E BASE 0x00F30000

MODULE LOAD ossvcs.dll PID 0xB2E1974E BASE 0x02750000

MODULE LOAD cellcore.dll PID 0xB2E1974E BASE 0x02F50000

MODULE LOAD iphlpapi.dll PID 0xB2E1974E BASE 0x036A0000

MODULE LOAD shutil.dll PID 0xB2E1974E BASE 0x02D20000

MODULE LOAD tshres.dll PID 0xB2E1974E BASE 0x7FFE0000

MODULE LOAD aygshell.dll PID 0xB2E1974E BASE 0x02D70000

MODULE LOAD commctrl.dll PID 0xB2E1974E BASE 0x02DE0000

MODULE LOAD netcfagl2_0.dll PID 0xB2E1974E BASE 0x00EF0000

UA @0:28:19.745 UseAppKey 1 {GOLD + A1} {"\SDMMC Disk\Shortcut to
Ten_Ven.lnk"}

MODULE LOAD netui.dll PID 0xB2E1974E BASE 0x02E40000

MODULE LOAD rsaenh.dll PID 0xB2E1974E BASE 0x015A0000

MODULE LOAD imaging.dll PID 0xB2E1974E BASE 0x03310000

MISC @0:28:22.542

MODULE LOAD compime.dll PID 0xB2E1974E BASE 0x02C70000

MISC @0:28:24.390 Got exit thread event for proc ID 0x53AC38DA, pthread
0x93A40B50, exit code 0x00000000.

MODULE LOAD sqlceme30.dll PID 0xB2E1974E BASE 0x00EE0000

MISC @0:28:28.870

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlcecompact30.dll PID 0xB2E1974E BASE 0x00E90000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E90000

MISC @0:28:36.5

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlcecompact30.dll PID 0xB2E1974E BASE 0x00E90000

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E20000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E20000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E90000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E40000

MODULE LOAD sqlceqp30.dll PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E40000

MISC @0:28:37.700

MODULE UNLOAD PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E40000

MODULE LOAD sqlceqp30.dll PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E40000

MISC @0:28:39.142

MODULE UNLOAD PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E40000

MODULE LOAD sqlceqp30.dll PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E40000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MISC @0:28:40.431

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E40000

MODULE LOAD sqlceqp30.dll PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E40000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MISC @0:28:41.523

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E40000

MODULE LOAD sqlceqp30.dll PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E40000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E40000

MODULE LOAD sqlceqp30.dll PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E40000

MISC @0:28:42.952

MODULE UNLOAD PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E40000

MODULE LOAD sqlceqp30.dll PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E40000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

UA @0:28:50.436 VerifyFG Ten_Ven.exe #NETCF_AGL_BASE_ Prima 0

UA @0:28:50.603 UseKey VK_RETURN

UA @0:28:51.41 UseKey VK_RETURN

UA @0:28:51.455 UseKey VK_RETURN

UA @0:28:51.892 UseKey VK_RETURN

UA @0:28:52.715 AMouseEvent {77, 291} L_DN

UA @0:28:52.715 AMouseMoves {-5, -2} {0, 0}

UA @0:28:52.716 AMouseEvent {72, 289} L_UP

UA @0:28:53.166 VerifyFG Ten_Ven.exe Dialog Attenzione! 0

UA @0:28:53.188 AClickWindow Ten_Ven.exe //Dialog Attenzione! 0 {57, 86}

UA @0:28:53.439 UseButton Yes 8

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00EB0000

MISC @0:28:54.664

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E40000

MODULE LOAD sqlceqp30.dll PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00E40000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00D60000

MODULE UNLOAD PID 0xB2E1974E BASE 0x00EB0000

MISC @0:29:10.748 Got create thread event for proc ID 0x72E19922, pthread
0x92CF9C2C, start address 0x00011DAC.

UA @0:29:13.893 VerifyFG Ten_Ven.exe #NETCF_AGL_BASE_ Menu 0

UA @0:29:13.987 UseKey VK_6

UA @0:29:15.543 VerifyFG Ten_Ven.exe #NETCF_AGL_BASE_ Attenzione! 0

UA @0:29:15.674 UseKey VK_1

UA @0:29:15.823 UseKey VK_1

UA @0:29:16.35 UseKey VK_1

UA @0:29:16.300 UseKey VK_1

UA @0:29:16.509 UseKey VK_1

UA @0:29:16.789 UseKey VK_1

UA @0:29:17.113 UseToolBarItem {} 70 69

UA @0:29:17.724 UseButton OK 0

UA @0:29:18.628 VerifyFG Ten_Ven.exe #NETCF_AGL_BASE_ Attenzione! 0

UA @0:29:18.744 UseKey VK_1

UA @0:29:18.892 UseButton OK 0

MSG @0:29:24.312 +GetPowerManagement

MSG @0:29:24.313 GetVideoPowerState returning VideoPowerOn

MSG @0:29:24.322 PmToVideoPowerState: PM state 4

MSG @0:29:24.551 State: 200000 suspend

MSG @0:29:24.551 SetVideoPowerState to VideoPowerOff

MSG @0:29:24.552 IOCTL_POWER_SET 4

MSG @0:29:24.554 leave Set Ppower STATE PSL

MISC @0:29:24.961 Got create thread event for proc ID 0xB3D527E6, pthread
0x923CA000, start address 0x02865964.

MSG @0:29:24.963 PCMCIA: Before we suspend, let's block until NDS0: has
resumed

MSG @0:29:24.965 Got NDIS State: 0

MSG @0:29:24.965 NDIS got D0!

MSG @0:29:24.966 PCMCIA: Waiting over

MSG @0:29:24.968 leave Set Ppower STATE PSL

MSG @0:29:25.12 PmToVideoPowerState: PM state 0

MSG @0:29:25.35 SetVideoPowerState to VideoPowerOn

MSG @0:29:25.36 IOCTL_POWER_SET 0

MODULE LOAD winsock.dll PID 0xB2E1974E BASE 0x03690000

MODULE LOAD ral.dll PID 0xD36C5422 BASE 0x00EB0000

MODULE LOAD it500.dll PID 0xD36C5422 BASE 0x00EC0000

MODULE LOAD irda_ral.dll PID 0xD36C5422 BASE 0x00EA0000

MODULE LOAD htmlview.dll PID 0x53AC38DA BASE 0x02CD0000

MODULE LOAD cplmain.cpl PID 0x53AC38DA BASE 0x02E60000

MODULE UNLOAD PID 0x53AC38DA BASE 0x02CD0000

MODULE UNLOAD PID 0x53AC38DA BASE 0x02E60000

PROCESS CREATE btcc.exe PID 0x1365963E BASE 0x34000000 PPROC 0x902EA5B8
PTHREAD 0x923C89F0

MODULE LOAD coredll.dll PID 0x1365963E BASE 0x01F60000

MSG @0:29:25.636

--- Bluetooth Com Control [btcc] ---

MSG @0:29:25.636

--- btcc cmd line #AppRunAfterWakeup# ---

MSG @0:29:25.641 btcc: default - dereg and reg

MSG @0:29:25.642 btcc: Opening Software\Intermec\Network\Bluetooth\Wireless
Printing

MSG @0:29:25.642 btcc: RegOpen failed
Software\Intermec\Network\Bluetooth\Wireless Printing

MSG @0:29:25.643 btcc: Read ComHandle (0)

MSG @0:29:25.652 btcc: Using Port [0]

MSG @0:29:25.653 btcc: No current device [1]

MSG @0:29:25.653 btcc: Opening SOFTWARE\Intermec\Network\Bluetooth\Wireless
GPS

MSG @0:29:25.658 btcc: RegOpen failed
SOFTWARE\Intermec\Network\Bluetooth\Wireless GPS

MSG @0:29:25.658 btcc: Read ComHandle (0)

MSG @0:29:25.667 btcc: Using Port [0]

MSG @0:29:25.668 btcc: No current device [2]

MSG @0:29:25.668 btcc: Opening SOFTWARE\Intermec\Network\Bluetooth\Wireless
SPP

MSG @0:29:25.669 btcc: RegOpen failed
SOFTWARE\Intermec\Network\Bluetooth\Wireless SPP

MSG @0:29:25.670 btcc: Read ComHandle (0)

MSG @0:29:25.678 btcc: Using Port [0]

MSG @0:29:25.679 btcc: No current device [3]

MSG @0:29:25.680 btcc: Opening SOFTWARE\Intermec\Network\Bluetooth\Wireless
Scanning

MSG @0:29:25.680 btcc: RegOpen failed
SOFTWARE\Intermec\Network\Bluetooth\Wireless Scanning

MSG @0:29:25.685 btcc: Read ComHandle (0)

MSG @0:29:25.694 btcc: Using Port [0]

MSG @0:29:25.695 btcc: No current device [4]

PROCESS EXIT PID 0x1365963E PPROC 0x902EA5B8 PTHREAD 0x923C89F0

MISC @0:29:25.963 Got create thread event for proc ID 0x53AC38DA, pthread
0x923CA4B8, start address 0x0001383C.

MODULE LOAD htmlview.dll PID 0x53AC38DA BASE 0x02CD0000

MODULE LOAD cplmain.cpl PID 0x53AC38DA BASE 0x02E60000

MODULE UNLOAD PID 0x53AC38DA BASE 0x02CD0000

MODULE UNLOAD PID 0x53AC38DA BASE 0x02E60000

MISC @0:29:27.14 Got create thread event for proc ID 0xB3D527E6, pthread
0x923C89F0, start address 0x028629F4.

MSG @0:29:27.635 SYNC:Received WM_NETCONNECT - 0, for '`USB Default';
fRnaAdrefed: 1

MSG @0:29:27.658 SYNC:Stopping Replication. repllog.cpp:3839

MSG @0:29:27.660 SYNC:Quiting replication. 0 279AA0 2648B0 1 1

MSG @0:29:27.662 SYNC:_REPLLOG: [ThdKeepAlive] finished

MSG @0:29:27.663 SYNC:Stopping Replication. repllog.cpp:3067

UA @0:29:26.606 VerifyFG Ten_Ven.exe #NETCF_AGL_BASE_ Parametri 0

UA @0:29:26.653 UseButton OK 0

MODULE UNLOAD PID 0x72E19922 BASE 0x03650000

MISC @0:29:28.58 Got create thread event for proc ID 0xB3D527E6, pthread
0x923D85D8, start address 0x028629F4.

UA @0:29:27.86 VerifyFG Ten_Ven.exe Dialog Attenzione! 0

UA @0:29:27.130 UseButton Yes 8

MODULE UNLOAD PID 0x72E19922 BASE 0x03660000

MODULE UNLOAD PID 0x72E19922 BASE 0x03640000

MODULE LOAD sqlceer30it.dll PID 0xB2E1974E BASE 0x00E70000

MODULE LOAD sqlcese30.dll PID 0xB2E1974E BASE 0x00E00000

MODULE LOAD sqlceqp30.dll PID 0xB2E1974E BASE 0x00D20000

MISC @0:29:29.77 Got create thread event for proc ID 0xB3D527E6, pthread
0x92CF9C2C, start address 0x028629F4.

PROCESS EXIT PID 0xB2E19A66 PPROC 0x902E9FD0 PTHREAD 0x9271B734

MODULE UNLOAD PID 0x72E19922 BASE 0x02840000

MODULE UNLOAD PID 0x72E19922 BASE 0x025A0000

MODULE UNLOAD PID 0x72E19922 BASE 0x02C40000

MODULE UNLOAD PID 0x72E19922 BASE 0x033F0000

MODULE UNLOAD PID 0x72E19922 BASE 0x03240000

MODULE UNLOAD PID 0x72E19922 BASE 0x026E0000

MODULE UNLOAD PID 0x72E19922 BASE 0x03680000

PROCESS EXIT PID 0x72E19922 PPROC 0x902E9D48 PTHREAD 0x93C8D000

MSG @0:29:29.954 Data Abort: Thread=923c84f8 Proc=902ea4e0 'Ten_Ven.exe'

MSG @0:29:29.955 AKY=01000001 PC=00e54b88 RA=00e54b8c BVA=32000008
FSR=00000007

INCIDENT TYPE EXCEPTION ADDRESS 0x00E54B88 CHANCE first CODE 0xC0000005
FLAGS 0x00000000 THREAD 0xD273B676 OWNER_PID 0xB2E1974E CURRENT_PID
0xB2E1974E NAME Ten_Ven.exe

REGISTERS BEGIN

Psr 0x6000001F

R0 0x00000001

R1 0xFFFFC898

R2 0x6000001F

R3 0xFFFFC800

R4 0xD382B576

R5 0x00000001

R6 0x00000000

R7 0x92845210

R8 0x00000003

R9 0xFFFFC80C

R10 0xFFFFC894

R11 0x00000000

R12 0x800509D0

Sp 0x326AF998

Lr 0x800509D0

Pc 0x800509D0

REGISTERS END

CALLSTACK BEGIN

0x32e54b88 0x000b86c0 0x00000000 0x00000000 0x00000000 R0=0x000b86c0
R1=0x00000000 R2=0x00000000 R3=0x00000000 R4=0x326afc10 R5=0x326afdf8
R6=0x00264640 R7=0x00000000 R8=0x00000001 R9=0x326afdf8 R10=0x00000000
R11=0x326afc28 R12=0x00e5d000 Sp=0x326afbdc Lr=0x00e5299c Pc=0x00e54b88
Psr=0x2000001f

0x32e52998 0x000b86c0 0x00000000 0x00000000 0x00000000 R0=0x000b86c0
R1=0x00000000 R2=0x00000000 R3=0x00000000 R4=0xeb34a79e R5=0x326afdf8
R6=0x00264640 R7=0x00000000 R8=0x00000001 R9=0x326afdf8 R10=0x00000000
R11=0x326afc28 R12=0x00e5d000 Sp=0x326afbe8 Lr=0x00e4c840 Pc=0x00e54b88
Psr=0x2000001f

0x32e4c83c 0x000b86c0 0x00000000 0x00000000 0x00000000 R0=0x000b86c0
R1=0x00000000 R2=0x00000000 R3=0x00000000 R4=0xeb34a79e R5=0x326afdf8
R6=0x00264640 R7=0x00000000 R8=0x00000001 R9=0x326afdf8 R10=0x00000000
R11=0x326afc28 R12=0xfffffb3c Sp=0x326b00ac Lr=0x00e4c840 Pc=0x00e54b88
Psr=0x2000001f

CALLSTACK END

INCIDENT END

Can anyone help me?

> Hello.
>
[quoted text clipped - 36 lines]
>
> Simon.
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.