View Issue Details

IDProjectCategoryView StatusLast Update
0001439Database Workbench v5Data Import & Exportpublic2017-04-18 13:25
ReporterJeroen Pluimers Assigned ToMartijn Tonies  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionfixed 
Platformx64OSWindowsOS Version7
Product Version5.2.4 
Fixed in Version5.3.0 
Summary0001439: XLSX export crash when logged in Windows user has Domain named, or a '.' in its name
Description---------------------------
Database Workbench v5.2.4 Pro
---------------------------
Access violation at address 08CFE0FD in module 'dbw5_exim.dll'. Read of address 00000000.
---------------------------
OK
---------------------------
Steps To Reproduce1. Run privately shared query on privately shared DB.
2. Export as XLSX with default settings.
3. Crash

Additional InformationXLS and CSV work fine.

Have not tested other formats than XLSX/XLS/CSV so they need to be regression tested.

Given this is an access violation the error should be reproducible with a broader set of data and likely simpler query and might even be reproducible outside the XLSX realm hence the regression testing.
TagsNo tags attached.

Activities

Martijn Tonies

2016-11-01 15:03

administrator   ~0000408

What settings are you using? I can't reproduce this error.

Jeroen Pluimers

2017-04-12 14:08

reporter   ~0000421

Steps:

1. Open database from private attachment
2. Load query from private attachment
3. Export https://www.dropbox.com/s/yqc3apfkl9ft1np/Screenshot%202017-04-12%2014.01.46.png?raw=1
4. Choose XLSX in https://www.dropbox.com/s/16gcbtd9p56ajk0/Screenshot%202017-04-12%2014.03.04.png?raw=1
5. Choose filename C:\temp\20161027.PARAMSDBWB-5.2.6-PRO.xlsx in https://www.dropbox.com/s/m9pepa7wfgwrpvo/Screenshot%202017-04-12%2014.05.10.png?raw=1
6. Keep "all rows" setting in https://www.dropbox.com/s/rpivfi5juripp59/Screenshot%202017-04-12%2014.05.51.png?raw=1
7. Keep all columns checked in https://www.dropbox.com/s/plagk4m78ma75bd/Screenshot%202017-04-12%2014.06.07.png?raw=1

expected: no access violation
actual: access violation

https://www.dropbox.com/s/7m7ilvvti4m91wy/Screenshot%202017-04-12%2014.06.55.png?raw=1

---------------------------
Database Workbench v5.2.6 Pro
---------------------------
Access violation at address 05C0E271 in module 'dbw5_exim.dll'. Read of address 00000000.
---------------------------
OK
---------------------------

My default FormatSettings:

>FormatSettings
     >SysLocale
          DefaultLCID=$0413 (1043), PriLangID=$13 (19), SubLangID=$01 (1), FarEast=-1, MiddleEast=-1
     <SysLocale
     LocaleId=$0413 (1043), LocaleName=nl-NL, LanguageName=Dutch (Netherlands), LocalizedDisplayName=Dutch (Netherlands), Description=Default Windows Settings
     ShortMonthNames[1]:jan
     ShortMonthNames[2]:feb
     ShortMonthNames[3]:mrt
     ShortMonthNames[4]:apr
     ShortMonthNames[5]:mei
     ShortMonthNames[6]:jun
     ShortMonthNames[7]:jul
     ShortMonthNames[8]:aug
     ShortMonthNames[9]:sep
     ShortMonthNames[10]:okt
     ShortMonthNames[11]:nov
     ShortMonthNames[12]:dec
     LongMonthNames[1]:januari
     LongMonthNames[2]:februari
     LongMonthNames[3]:maart
     LongMonthNames[4]:april
     LongMonthNames[5]:mei
     LongMonthNames[6]:juni
     LongMonthNames[7]:juli
     LongMonthNames[8]:augustus
     LongMonthNames[9]:september
     LongMonthNames[10]:oktober
     LongMonthNames[11]:november
     LongMonthNames[12]:december
     ShortDayNames[1]:zo
     ShortDayNames[2]:ma
     ShortDayNames[3]:di
     ShortDayNames[4]:wo
     ShortDayNames[5]:do
     ShortDayNames[6]:vr
     ShortDayNames[7]:za
     LongDayNames[1]:zondag
     LongDayNames[2]:maandag
     LongDayNames[3]:dinsdag
     LongDayNames[4]:woensdag
     LongDayNames[5]:donderdag
     LongDayNames[6]:vrijdag
     LongDayNames[7]:zaterdag
     CurrencyFormat:2
     NegCurrFormat:12
     ThousandSeparator:.
     DecimalSeparator:,
     CurrencyDecimals:2
     DateSeparator:-
     TimeSeparator::
     ListSeparator:;
     CurrencyString:?
     ShortDateFormat:d/M/yyyy
     LongDateFormat:dddd d MMMM yyyy
     TimeAMString:
     TimePMString:
     ShortTimeFormat:h:mm
     LongTimeFormat:h:mm:ss
     TwoDigitYearCenturyWindow:50
<FormatSettings

Jeroen Pluimers

2017-04-12 16:51

reporter   ~0000422

Failing Process Monitor log because username "JEROEN.COUNTERS" contains a period:

16:27:41,3867817 DBW5Pro.exe 5572 CreateFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp SUCCESS Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
16:27:41,3868174 DBW5Pro.exe 5572 QueryBasicInformationFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp SUCCESS CreationTime: 4-7-2016 16:40:26, LastAccessTime: 12-4-2017 16:25:03, LastWriteTime: 12-4-2017 16:25:03, ChangeTime: 12-4-2017 16:25:03, FileAttributes: DCNCI
16:27:41,3868356 DBW5Pro.exe 5572 CloseFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp SUCCESS
16:27:41,3869491 DBW5Pro.exe 5572 CreateFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwE199.tmp SUCCESS Desired Access: Generic Read, Disposition: Create, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: N, ShareMode: None, AllocationSize: 0, OpenResult: Created
16:27:41,3874604 DBW5Pro.exe 5572 CloseFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwE199.tmp SUCCESS
16:27:41,3875818 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU\AppData\Local\Temp\dbwE199.tmp PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3876633 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU\AppData\Local\Temp PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3877394 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU\AppData\Local PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3878085 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU\AppData PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3879485 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU NAME NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3880905 DBW5Pro.exe 5572 CreateFile C:\Users SUCCESS Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
16:27:41,3881173 DBW5Pro.exe 5572 QueryBasicInformationFile C:\Users SUCCESS CreationTime: 14-7-2009 5:20:08, LastAccessTime: 29-11-2016 13:35:05, LastWriteTime: 29-11-2016 13:35:05, ChangeTime: 29-11-2016 13:35:05, FileAttributes: RDC
16:27:41,3881858 DBW5Pro.exe 5572 CloseFile C:\Users SUCCESS
16:27:41,3882794 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU ACCESS DENIED Desired Access: Read Data/List Directory, Synchronize, Disposition: Create, Options: Directory, Synchronous IO Non-Alert, Open Reparse Point, Attributes: N, ShareMode: Read, Write, AllocationSize: 0
16:27:41,3883691 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU\AppData\Local\Temp\dbwE199.tmp PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3884386 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU\AppData\Local\Temp PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3885074 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU\AppData\Local PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3885743 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU\AppData PATH NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3887106 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU NAME NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:27:41,3888503 DBW5Pro.exe 5572 CreateFile C:\Users SUCCESS Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
16:27:41,3888731 DBW5Pro.exe 5572 QueryBasicInformationFile C:\Users SUCCESS CreationTime: 14-7-2009 5:20:08, LastAccessTime: 29-11-2016 13:35:05, LastWriteTime: 29-11-2016 13:35:05, ChangeTime: 29-11-2016 13:35:05, FileAttributes: RDC
16:27:41,3888886 DBW5Pro.exe 5572 CloseFile C:\Users SUCCESS
16:27:41,3889777 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU ACCESS DENIED Desired Access: Read Data/List Directory, Synchronize, Disposition: Create, Options: Directory, Synchronous IO Non-Alert, Open Reparse Point, Attributes: N, ShareMode: Read, Write, AllocationSize: 0
16:27:41,3890349 DBW5Pro.exe 5572 CreateFile C:\Users\JEROEN~1_xlsxCOU\AppData\Local\Temp\dbwE199.tmp\[Content_Types].xml PATH NOT FOUND Desired Access: Generic Read/Write, Disposition: OverwriteIf, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: N, ShareMode: None, AllocationSize: 0

Jeroen Pluimers

2017-04-12 16:54

reporter   ~0000423

The above note shows that
C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwE199.tmp
is being replaced by
C:\Users\JEROEN~1_xlsxCOU\AppData\Local\Temp\dbwE199.tmp

After the fix, this replacement is being made:

C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88.tmp
into
C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88_xlsxtmp

New log:

16:49:17,0158283 DBW5Pro.exe 5572 CreateFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp SUCCESS Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
16:49:17,0158627 DBW5Pro.exe 5572 QueryBasicInformationFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp SUCCESS CreationTime: 4-7-2016 16:40:26, LastAccessTime: 12-4-2017 16:48:29, LastWriteTime: 12-4-2017 16:48:29, ChangeTime: 12-4-2017 16:48:29, FileAttributes: DCNCI
16:49:17,0158803 DBW5Pro.exe 5572 CloseFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp SUCCESS
16:49:17,0160060 DBW5Pro.exe 5572 CreateFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88.tmp SUCCESS Desired Access: Generic Read, Disposition: Create, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: N, ShareMode: None, AllocationSize: 0, OpenResult: Created
16:49:17,0165093 DBW5Pro.exe 5572 CloseFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88.tmp SUCCESS
16:49:17,0167565 DBW5Pro.exe 5572 CreateFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88_xlsxtmp NAME NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
16:49:17,0169296 DBW5Pro.exe 5572 CreateFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp SUCCESS Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
16:49:17,0169574 DBW5Pro.exe 5572 QueryBasicInformationFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp SUCCESS CreationTime: 4-7-2016 16:40:26, LastAccessTime: 12-4-2017 16:49:16, LastWriteTime: 12-4-2017 16:49:16, ChangeTime: 12-4-2017 16:49:16, FileAttributes: DCNCI
16:49:17,0169743 DBW5Pro.exe 5572 CloseFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp SUCCESS
16:49:17,0170762 DBW5Pro.exe 5572 CreateFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88_xlsxtmp SUCCESS Desired Access: Read Data/List Directory, Synchronize, Disposition: Create, Options: Directory, Synchronous IO Non-Alert, Open Reparse Point, Attributes: N, ShareMode: Read, Write, AllocationSize: 0, OpenResult: Created
16:49:17,0173866 DBW5Pro.exe 5572 CloseFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88_xlsxtmp SUCCESS
16:49:17,0175941 DBW5Pro.exe 5572 CreateFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88_xlsxtmp SUCCESS Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
16:49:17,0176212 DBW5Pro.exe 5572 QueryBasicInformationFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88_xlsxtmp SUCCESS CreationTime: 12-4-2017 16:49:16, LastAccessTime: 12-4-2017 16:49:16, LastWriteTime: 12-4-2017 16:49:16, ChangeTime: 12-4-2017 16:49:16, FileAttributes: DCNCI
16:49:17,0176374 DBW5Pro.exe 5572 CloseFile C:\Users\jeroenp.COUNTERS\AppData\Local\Temp\dbwAC88_xlsxtmp SUCCESS

Issue History

Date Modified Username Field Change
2016-10-27 11:08 Jeroen Pluimers New Issue
2016-11-01 15:03 Martijn Tonies Note Added: 0000408
2016-11-01 15:03 Martijn Tonies Assigned To => Martijn Tonies
2016-11-01 15:03 Martijn Tonies Status new => feedback
2017-04-03 12:03 Martijn Tonies Status feedback => closed
2017-04-03 12:03 Martijn Tonies Resolution open => unable to reproduce
2017-04-12 14:08 Jeroen Pluimers Note Added: 0000421
2017-04-12 14:08 Jeroen Pluimers Status closed => feedback
2017-04-12 14:08 Jeroen Pluimers Resolution unable to reproduce => reopened
2017-04-12 16:49 Martijn Tonies Summary XLSX export always crashes on a particular query and table combination => XLSX export crash when logged in Windows user has Domain named, or a '.' in its name
2017-04-12 16:49 Martijn Tonies Description Updated
2017-04-12 16:51 Jeroen Pluimers Note Added: 0000422
2017-04-12 16:51 Jeroen Pluimers Status feedback => assigned
2017-04-12 16:54 Jeroen Pluimers Note Added: 0000423
2017-04-12 16:56 Martijn Tonies Status assigned => resolved
2017-04-12 16:56 Martijn Tonies Fixed in Version => 5.3.0
2017-04-12 16:56 Martijn Tonies Resolution reopened => fixed
2017-04-18 13:25 Martijn Tonies Status resolved => closed