Why does FASTINSERT crash MATLAB R2014a when working with a Native ODBC Connection and a MATLAB Table?

1 view (last 30 days)
I have a simple Microsoft SQL Database TABLE with one column 'col1' with datatype INT. I connect to this database through "databse.ODBCConnection" and I am trying to insert data through "fastinsert":
data = table;
data.col1 = {'1';'2';'3'}
fastinsert(conn,'myTable',{'col1'},data)
This crashes MATLAB however with the following stack trace:
MATLAB crash <file:c>:\temp\matlab_crash_dump.8732-1:
 
------------------------------------------------------------------------
Access violation detected at Tue Sep 16 09:46:30 2014
------------------------------------------------------------------------
Configuration:
Crash Decoding : Disabled
Default Encoding : windows-1252
MATLAB Architecture: win64
MATLAB Root : C:\MATLAB\R2014a
MATLAB Version : 8.3.0.532 (R2014a)
Operating System : Microsoft Windows 7 Enterprise
Processor ID : x86 Family 6 Model 62 Stepping 4, GenuineIntel
Virtual Machine : Java 1.7.0_11-b21 with Oracle Corporation Java HotSpot(TM) 64-Bit Server VM mixed mode
Window System : Version 6.1 (Build 7601: Service Pack 1)
Fault Count: 1
Abnormal termination:
Access violation
Register State (from fault):
RAX = 0000000000000000 RBX = 0000000000000000
RCX = 0000000007271399 RDX = 0000000000000000
RSP = 00000000040234b0 RBP = 00000000040235b0
RSI = 0000000000000000 RDI = 0000000000000000
R8 = 0000000000000000 R9 = 0000000007260000
R10 = 0000000000000000 R11 = 0000000004023450
R12 = 00000000766d2530 R13 = 0000000000000000
R14 = 0000000061efdf40 R15 = 0000000000000003
RIP = 00000000072713b5 EFL = 00010246
CS = 0033 FS = 0053 GS = 002b
Stack Trace (from fault):
[ 0] 0x00000000072713b5 C:\MATLAB\R2014a\bin\win64\dodbc.dll+00070581 MLInitialize_dodbc+00026149
[ 1] 0x000000000726c13e C:\MATLAB\R2014a\bin\win64\dodbc.dll+00049470 MLInitialize_dodbc+00005038
[ 2] 0x000000000726e6bb C:\MATLAB\R2014a\bin\win64\dodbc.dll+00059067 MLInitialize_dodbc+00014635
[ 3] 0x000000000726e229 C:\MATLAB\R2014a\bin\win64\dodbc.dll+00057897 MLInitialize_dodbc+00013465
[ 4] 0x00000000068a804b C:\MATLAB\R2014a\bin\win64\mcos.dll+00098379 mcos::COSDictionary::getNameID+00002251
[ 5] 0x00000000068a8ccc C:\MATLAB\R2014a\bin\win64\mcos.dll+00101580 mcos::COSDictionary::getNameID+00005452
[ 6] 0x00000000068a4b5f C:\MATLAB\R2014a\bin\win64\mcos.dll+00084831 mcos::COSDataTypePtrHelper::getObject+00003327
[ 7] 0x00000000068a4692 C:\MATLAB\R2014a\bin\win64\mcos.dll+00083602 mcos::COSDataTypePtrHelper::getObject+00002098
[ 8] 0x000000000689ec96 C:\MATLAB\R2014a\bin\win64\mcos.dll+00060566 mcos::AbstractClassInfo::allocateInstance+00004310
[ 9] 0x0000000005fbc2c0 C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00049856 Mfh_MATLAB_fn::dispatch_fh+00000464
[ 10] 0x00000000068fe740 C:\MATLAB\R2014a\bin\win64\mcos.dll+00452416 mcos::COSNameID::COSNameID+00000112
[ 11] 0x0000000005fbc77a C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00051066 Mfunction_handle::dispatch+00000810
[ 12] 0x0000000006137b8a C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00752522 MathWorks::MException::MExceptionEnvelope::GetID+00547322
[ 13] 0x0000000006117a23 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00621091 MathWorks::MException::MExceptionEnvelope::GetID+00415891
[ 14] 0x0000000006117ff2 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00622578 MathWorks::MException::MExceptionEnvelope::GetID+00417378
[ 15] 0x0000000006116d91 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00617873 MathWorks::MException::MExceptionEnvelope::GetID+00412673
[ 16] 0x000000000610c17f C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00573823 MathWorks::MException::MExceptionEnvelope::GetID+00368623
[ 17] 0x0000000006109458 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00562264 MathWorks::MException::MExceptionEnvelope::GetID+00357064
[ 18] 0x000000000612446f C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00672879 MathWorks::MException::MExceptionEnvelope::GetID+00467679
[ 19] 0x00000000061245b8 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00673208 MathWorks::MException::MExceptionEnvelope::GetID+00468008
[ 20] 0x0000000006114a2d C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00608813 MathWorks::MException::MExceptionEnvelope::GetID+00403613
[ 21] 0x000000000611192c C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00596268 MathWorks::MException::MExceptionEnvelope::GetID+00391068
[ 22] 0x00000000061211c9 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00659913 MathWorks::MException::MExceptionEnvelope::GetID+00454713
[ 23] 0x0000000005fbbe4f C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00048719 Mfh_file::dispatch_fh+00000687
[ 24] 0x0000000005fbc77a C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00051066 Mfunction_handle::dispatch+00000810
[ 25] 0x00000000068a4e2c C:\MATLAB\R2014a\bin\win64\mcos.dll+00085548 mcos::COSDataTypePtrHelper::getObject+00004044
[ 26] 0x00000000068a86f0 C:\MATLAB\R2014a\bin\win64\mcos.dll+00100080 mcos::COSDictionary::getNameID+00003952
[ 27] 0x00000000068a8bc4 C:\MATLAB\R2014a\bin\win64\mcos.dll+00101316 mcos::COSDictionary::getNameID+00005188
[ 28] 0x00000000068a4b5f C:\MATLAB\R2014a\bin\win64\mcos.dll+00084831 mcos::COSDataTypePtrHelper::getObject+00003327
[ 29] 0x00000000068a4692 C:\MATLAB\R2014a\bin\win64\mcos.dll+00083602 mcos::COSDataTypePtrHelper::getObject+00002098
[ 30] 0x00000000068bba43 C:\MATLAB\R2014a\bin\win64\mcos.dll+00178755 mcos::COSJITInterface::getDispatcherID+00002499
[ 31] 0x0000000005fbc2c0 C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00049856 Mfh_MATLAB_fn::dispatch_fh+00000464
[ 32] 0x00000000068fe740 C:\MATLAB\R2014a\bin\win64\mcos.dll+00452416 mcos::COSNameID::COSNameID+00000112
[ 33] 0x0000000005fbc77a C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00051066 Mfunction_handle::dispatch+00000810
[ 34] 0x000000000610cdfe C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00577022 MathWorks::MException::MExceptionEnvelope::GetID+00371822
[ 35] 0x0000000006109569 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00562537 MathWorks::MException::MExceptionEnvelope::GetID+00357337
[ 36] 0x000000000612446f C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00672879 MathWorks::MException::MExceptionEnvelope::GetID+00467679
[ 37] 0x00000000061245b8 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00673208 MathWorks::MException::MExceptionEnvelope::GetID+00468008
[ 38] 0x0000000006114a2d C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00608813 MathWorks::MException::MExceptionEnvelope::GetID+00403613
[ 39] 0x000000000611192c C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00596268 MathWorks::MException::MExceptionEnvelope::GetID+00391068
[ 40] 0x00000000061211c9 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00659913 MathWorks::MException::MExceptionEnvelope::GetID+00454713
[ 41] 0x0000000005fbbe4f C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00048719 Mfh_file::dispatch_fh+00000687
[ 42] 0x0000000005fbc77a C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00051066 Mfunction_handle::dispatch+00000810
[ 43] 0x00000000068a4e2c C:\MATLAB\R2014a\bin\win64\mcos.dll+00085548 mcos::COSDataTypePtrHelper::getObject+00004044
[ 44] 0x00000000068a86f0 C:\MATLAB\R2014a\bin\win64\mcos.dll+00100080 mcos::COSDictionary::getNameID+00003952
[ 45] 0x00000000068a8bc4 C:\MATLAB\R2014a\bin\win64\mcos.dll+00101316 mcos::COSDictionary::getNameID+00005188
[ 46] 0x00000000068a4b5f C:\MATLAB\R2014a\bin\win64\mcos.dll+00084831 mcos::COSDataTypePtrHelper::getObject+00003327
[ 47] 0x00000000068a4692 C:\MATLAB\R2014a\bin\win64\mcos.dll+00083602 mcos::COSDataTypePtrHelper::getObject+00002098
[ 48] 0x00000000068bba43 C:\MATLAB\R2014a\bin\win64\mcos.dll+00178755 mcos::COSJITInterface::getDispatcherID+00002499
[ 49] 0x0000000005fbc2c0 C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00049856 Mfh_MATLAB_fn::dispatch_fh+00000464
[ 50] 0x00000000068fe740 C:\MATLAB\R2014a\bin\win64\mcos.dll+00452416 mcos::COSNameID::COSNameID+00000112
[ 51] 0x0000000005fbc77a C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00051066 Mfunction_handle::dispatch+00000810
[ 52] 0x000000000610cdfe C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00577022 MathWorks::MException::MExceptionEnvelope::GetID+00371822
[ 53] 0x00000000061868a7 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+01075367 inEachVisibleName+00016119
[ 54] 0x000000000610ab1a C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00568090 MathWorks::MException::MExceptionEnvelope::GetID+00362890
[ 55] 0x000000000612446f C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00672879 MathWorks::MException::MExceptionEnvelope::GetID+00467679
[ 56] 0x00000000061245b8 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00673208 MathWorks::MException::MExceptionEnvelope::GetID+00468008
[ 57] 0x0000000006114a2d C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00608813 MathWorks::MException::MExceptionEnvelope::GetID+00403613
[ 58] 0x000000000611192c C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00596268 MathWorks::MException::MExceptionEnvelope::GetID+00391068
[ 59] 0x00000000061211c9 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+00659913 MathWorks::MException::MExceptionEnvelope::GetID+00454713
[ 60] 0x0000000005fbc00e C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00049166 Mfh_file::dispatch_fh+00001134
[ 61] 0x0000000005fbc77a C:\MATLAB\R2014a\bin\win64\m_dispatcher.dll+00051066 Mfunction_handle::dispatch+00000810
[ 62] 0x0000000006194a0e C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+01133070 inValidateLoadedObject+00003486
[ 63] 0x000000000619bd95 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+01162645 inResetInterpreter+00005029
[ 64] 0x00000000061a0a05 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+01182213 MathWorks::MException::MExceptionEnvelope::Copy+00010997
[ 65] 0x00000000061a09d2 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+01182162 MathWorks::MException::MExceptionEnvelope::Copy+00010946
[ 66] 0x00000000061a0997 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+01182103 MathWorks::MException::MExceptionEnvelope::Copy+00010887
[ 67] 0x000000000658e89c C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+05302428 inMexPutVariable+00004204
[ 68] 0x000000000658ebf6 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+05303286 inMexPutVariable+00005062
[ 69] 0x000000000658f02e C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+05304366 inMexPutVariable+00006142
[ 70] 0x000000000658f36c C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+05305196 inMexPutVariable+00006972
[ 71] 0x00000000064a0161 C:\MATLAB\R2014a\bin\win64\m_interpreter.dll+04325729 inEvalCmdWithLocalReturn+00000065
[ 72] 0x0000000006afbecd C:\MATLAB\R2014a\bin\win64\libmwbridge.dll+00048845 mnDebugPrompt+00000109
[ 73] 0x0000000006afcfaf C:\MATLAB\R2014a\bin\win64\libmwbridge.dll+00053167 mnParser+00000735
[ 74] 0x00000000fd0afae4 C:\MATLAB\R2014a\bin\win64\mcr.dll+00195300 mcrInstance::mnParser_on_interpreter_thread+00000036
[ 75] 0x00000000fd093af0 C:\MATLAB\R2014a\bin\win64\mcr.dll+00080624 mcr::runtime::setInterpreterThreadToCurrent+00029488
[ 76] 0x00000000fd093b50 C:\MATLAB\R2014a\bin\win64\mcr.dll+00080720 mcr::runtime::setInterpreterThreadToCurrent+00029584
[ 77] 0x00000000fab6e026 C:\MATLAB\R2014a\bin\win64\uiw.dll+00581670 UIW_IsUserMessage+00000086
[ 78] 0x00000000fab6e705 C:\MATLAB\R2014a\bin\win64\uiw.dll+00583429 UIW_SetGLIMUserMsg+00000117
[ 79] 0x00000000fab6e789 C:\MATLAB\R2014a\bin\win64\uiw.dll+00583561 UIW_SetGLIMUserMsg+00000249
[ 80] 0x0000000076f687fe C:\windows\system32\USER32.dll+00165886 GetMenuBarInfo+00000638
[ 81] 0x0000000076f4f5fb C:\windows\system32\USER32.dll+00062971 SystemParametersInfoW+00000235
[ 82] 0x0000000076f54895 C:\windows\system32\USER32.dll+00084117 IsProcessDPIAware+00000465
[ 83] 0x00000000770904e5 C:\windows\SYSTEM32\ntdll.dll+00328933 KiUserCallbackDispatcher+00000031
[ 84] 0x0000000076f5908a C:\windows\system32\USER32.dll+00102538 PeekMessageW+00000186
[ 85] 0x0000000076f550fe C:\windows\system32\USER32.dll+00086270 GetKeyState+00000238
[ 86] 0x0000000076f53a6f C:\windows\system32\USER32.dll+00080495 PeekMessageA+00000087
[ 87] 0x00000000fab1bd4b C:\MATLAB\R2014a\bin\win64\uiw.dll+00245067 UIW_SetCurrentDialog+00000731
[ 88] 0x00000000fab6fbe2 C:\MATLAB\R2014a\bin\win64\uiw.dll+00588770 ws_FreeSystemFont+00000482
[ 89] 0x00000001000e2ed0 C:\MATLAB\R2014a\bin\win64\libmwservices.dll+00995024 services::system_events::PpeDispatchHook::~PpeDispatchHook+00053488
[ 90] 0x00000001000e36a5 C:\MATLAB\R2014a\bin\win64\libmwservices.dll+00997029 services::system_events::PpeDispatchHook::~PpeDispatchHook+00055493
[ 91] 0x00000001000e4330 C:\MATLAB\R2014a\bin\win64\libmwservices.dll+01000240 services::system_events::PpeDispatchHook::~PpeDispatchHook+00058704
[ 92] 0x00000001000ed4c6 C:\MATLAB\R2014a\bin\win64\libmwservices.dll+01037510 sysq::removeProcessPendingEventsHook+00011030
[ 93] 0x00000001000ed7ca C:\MATLAB\R2014a\bin\win64\libmwservices.dll+01038282 svWS_ProcessPendingEvents+00000138
[ 94] 0x00000000fd094b6d C:\MATLAB\R2014a\bin\win64\mcr.dll+00084845 mcr::runtime::setInterpreterThreadToCurrent+00033709
[ 95] 0x00000000fd094e3b C:\MATLAB\R2014a\bin\win64\mcr.dll+00085563 mcr::runtime::setInterpreterThreadToCurrent+00034427
[ 96] 0x00000000fd088b75 C:\MATLAB\R2014a\bin\win64\mcr.dll+00035701 mcrInstantiationError::operator=+00003221
[ 97] 0x00000000fd08bea2 C:\MATLAB\R2014a\bin\win64\mcr.dll+00048802 mcr_invoke_on_interpreter_thread+00001602
[ 98] 0x00000000fa7e6e5d C:\MATLAB\R2014a\bin\win64\MVMLocal.dll+00159325 mvm_server::inproc::LocalFactory::createMVM+00040653
[ 99] 0x000000000714afaa C:\MATLAB\R2014a\bin\win64\mvm.dll+00569258 mvm::detail::SessionImpl::privateSession+00001754
[100] 0x000000000714d32a C:\MATLAB\R2014a\bin\win64\mvm.dll+00578346 mvm::detail::SessionImpl::privateSession+00010842
[101] 0x000000000714ce85 C:\MATLAB\R2014a\bin\win64\mvm.dll+00577157 mvm::detail::SessionImpl::privateSession+00009653
[102] 0x0000000140004f79 C:\MATLAB\R2014a\bin\win64\MATLAB.exe+00020345
[103] 0x0000000140006a07 C:\MATLAB\R2014a\bin\win64\MATLAB.exe+00027143
[104] 0x0000000076e359ed C:\windows\system32\kernel32.dll+00088557 BaseThreadInitThunk+00000013
[105] 0x000000007706ba01 C:\windows\SYSTEM32\ntdll.dll+00178689 RtlUserThreadStart+00000033
If this problem is reproducible, please submit a Service Request via:
http://www.mathworks.com/support/contact_us/
A technical support engineer might contact you with further information.
Thank you for your help.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 16 Sep 2014
There is a bug in Database Toolbox R2014a in the way that FASTINSERT does not verify datatypes correctly when calling FASTINSERT with a MATLAB Table as input. This can then lead to a crash if there is a mismatch between MATLAB and Database datatypes.
To prevent this crash from occurring please make sure that your datatypes are correct before inserting the data. In the example above, data.col1 should be a vector of numerics instead of strings.

More Answers (0)

Categories

Find more on Data Types in Help Center and File Exchange

Tags

No tags entered yet.

Products


Release

R2014b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!