Event-Log: 300 Error OOXML: CSpreadsheetMLTable::Fetch (): Unknown cell type at row:

[Mario_Pagel]

Hi,

there are a lot of very large event-logfiles located in C:\ProgramData\QlikTech\QlikViewBatch containing the same error, e.g.

Events_V0DMQV006_PID705660_2022-08-05.log:

Server Started Timestamp SeverityID EventID Severity Message SessionId
20220805T055258.000+0200 20220805T055341.000+0200 1 300 Error OOXML: CSpreadsheetMLTable::Fetch (): Unknown cell type at row: 1 fb9dad6-d611-44ba-b116-bc9b319b48b
20220805T055258.000+0200 20220805T055341.000+0200 1 300 Error OOXML: CSpreadsheetMLTable::Fetch (): Unknown cell type at row: 1 fb9dad6-d611-44ba-b116-bc9b319b48b
20220805T055258.000+0200 20220805T055341.000+0200 1 300 Error OOXML: CSpreadsheetMLTable::Fetch (): Unknown cell type at row: 1 fb9dad6-d611-44ba-b116-bc9b319b48b
20220805T055258.000+0200 20220805T055341.000+0200 1 300 Error OOXML: CSpreadsheetMLTable::Fetch (): Unknown cell type at row: 1 fb9dad6-d611-44ba-b116-bc9b319b48b
20220805T055258.000+0200 20220805T055341.000+0200 1 300 Error OOXML: CSpreadsheetMLTable::Fetch (): Unknown cell type at row: 1 fb9dad6-d611-44ba-b116-bc9b319b48b

...

Does anybody  know how to fix it? Or how to stop logging this error? 

Regards

Mario

[Bill_Britt · Accepted solution]

Hi,

The ooxml is used with the load statement to load Excel 2007 and later versions use the ooxml .xslx format.

[C:\Users\bbt.QTSEL\Desktop\47829.xlsx]
(ooxml, no labels, table is Sheet1);

I would suspect that there is something wrong with either the load script of the data file.

[Mario_Pagel]

Hi Bill.

thank you for your answer. Do you know how to detect the assigned task respectively qvw? There is an id (in this case fb9dad6-d611-44ba-b116-bc9b319b48b) in the log, but i can't find anything.

Mario

[Bill_Britt]

Hi,

That ID and search the Session logs and QVS logs.

Bill

[Mario_Pagel · Accepted solution]

Hi Bill,

I was able to detect the tasks with the PID, but not with the ID inside the logs.

thanxs

Mario

[Bill_Britt]

Hi,

So,  the issue is resolved?