Windows .NET Framework Update Breaks READTABLE()

dpb
2019 5 15
2 个回答
更新时间：2019 5 16
2 次查看（30 天）

0 个投票

Not so much a Q? as a report...
Got up this AM to discover Windwoes had installed Office and OS update. After the interminable reboot and rebuilding all the work in progress - NOT! first thing to happen was all scripts/functions with READTABLE() failed with internal error.
Reboot "just in case" something didn't get finished updating did not solve the problem.
Regressed that update back out and all returned to being functional again.
Win7 Pro, R2017b

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Guillaume
Guillaume 2019-5-15
It's unlikely that a windows update would affect readtable and even more unlikely that it would have anything to do with .Net since readtable has nothing to do with .Net (and matlab uses a completely different technology from .Net).
In any case, if you get an error, please state the full text of the error message.
Also, an example of code that causes the problem. Could it rather be that the update somehow messed up your file system and hence the files you're trying to access are no longer where they were.
Steven Lord
Steven Lord 2019-5-15
Do you happen to have available the number or name of the specific update(s) that were installed and that you had to regress to avoid the problem?
dpb
dpb 2019-5-15
Clearly the update did the dirty...no change excepting regressing fixed the issue. The readtable internals referenced stuff it appeared. I was in a time crunch to begin with so to have been so rudely interrupted overnight was not a pleasant surprise in the early AM...when get back to the home office tonight I can scrape the messages; just not time this AM, sorry.
Steven, I neglected to write it down when I did the regression; I realized shoulda' but when I went back to the whizard the uninstalled updates weren't listed and I was out of time...I'll try to dig out what it was later on this evening after -- altho ofomh I don't know precisely where to go to get the desired info but I suppose a KB search may lead me somewhere...

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Jeremy Hughes
Jeremy Hughes 2019-5-15

0 个投票

Try,
readtable(filename,'Basic',true) % or UseExcel false in a more recent release.
dpb
dpb 2019-5-16
编辑：dpb 2019-5-16

0 个投票

Steven, the update was/is 2019-05 Security and Quality (HAH! -- dpb) Rollup for .NET Framework...(KB4499406) Published 5/14/2019
Unfortunately, since I had to restart after the regression, the error messages that were generated are gone and I'm not redoing the upgrade at least at the present time with the time crunch am under.
It was an internal error, NOT a ML error, though as @G is/was thinking...
ADDENDUM:
Well, it reinstalled it again last night, so here's the first message -- it actually occurred on the detectImportOptions call; --
>> spentRestricted,findRestricted
Error using matlab.io.spreadsheet.internal.Worksheet/readStrings
An internal error occurred.
Error in matlab.io.TextVariableImportOptions/readSpreadsheetVariable (line 114)
data = sheet.readStrings(subrange,varopts.Type);
Error in detectImportOptions>getSpreadsheetOpts (line 495)
names = tvio.readSpreadsheetVariable(sheet,nameRowRange,typeIDs(headerRows+1,:));
Error in detectImportOptions (line 234)
opts = getSpreadsheetOpts(filename,res.NumVariables,res.NumHeaderLines,emptyColType,args);
Error in findRestricted (line 25)
optSchol=detectImportOptions(fullfile(wkdir,d.name));
>>
Followed up to try to just readtable, got
>> tAppl=readtable(fullfile(wkdir,d.name));
Error using readtable (line 198)
An internal error occurred.
>>

类别

在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

提问:

dpb
dpb
2019-5-15

编辑：

dpb
dpb
2019-5-16

Community Treasure Hunt

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

Start Hunting!

Translated by