Hi Isomorphic,
we changed from exportClientData() to exportData() a few month ago (on 12.0p, now v12.0p_2020-03-11).
Reason for this were the amount of data possible to export with exportClientData() as well as the fact that we got empty XLSX exports occasionally (which I attributed to network problems and many data back then (was wrong)).
In this case the file is downloaded correctly and opens in LibreOffice or Excel, but is just empty. If you open it as zip file and navigate to xl\worksheets\sheet1.xml and look into it, it becomes clear that it is correct that LibreOffice doesn't display anything:
My question is now why this is happening. I set the log level to trace, but unfortunately this does not help. The relevant part of the logs after the fetch is always:
So logs resulting in a good file and logs resulting in a bad file look the same (there is always a fetch with rows returned also in the case of a bad file).
Again, this also happened occasionally before when we were using exportClientData(), so I think it's something about XLSX generation.
Do you have any idea what might be happening here? Could you add more logging in the area of ExcelDataExport?
Can I enable more logging here somehow already? Perhaps stop the framework from suppressing 3rd party logs via a server.properties setting (if such a thing happens)?
Any advice is appreciated, because it's very frustrating to get such reports and not be able to find out anything about it.
Thank you & Best regards
Blama
we changed from exportClientData() to exportData() a few month ago (on 12.0p, now v12.0p_2020-03-11).
Reason for this were the amount of data possible to export with exportClientData() as well as the fact that we got empty XLSX exports occasionally (which I attributed to network problems and many data back then (was wrong)).
In this case the file is downloaded correctly and opens in LibreOffice or Excel, but is just empty. If you open it as zip file and navigate to xl\worksheets\sheet1.xml and look into it, it becomes clear that it is correct that LibreOffice doesn't display anything:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<dimension ref="A1"/>
<sheetViews>
<sheetView workbookViewId="0" tabSelected="true"/>
</sheetViews>
<sheetFormatPr defaultRowHeight="15.0"/>
<sheetData/>
<pageMargins bottom="0.75" footer="0.3" header="0.3" left="0.7" right="0.7" top="0.75"/>
</worksheet>
Code:
2020-05-06 11:37:31,937 DEBUG c.i.t.Timing [https-openssl-nio-443-exec-4] [builtinApplication.T_RESELLER_fetch] SQLTransform (62 rows): 30ms 2020-05-06 11:37:31,937 INFO c.i.d.DSResponse [https-openssl-nio-443-exec-4] DSResponse: List with 62 items 2020-05-06 11:37:31,937 DEBUG c.i.d.DSRequest [https-openssl-nio-443-exec-4] freeOnExecute is false for request of type fetch on DataSource T_RESELLER - not freeing resources! 2020-05-06 11:37:31,938 DEBUG DSRequestLogger [https-openssl-nio-443-exec-4] DSRequest successful. 2020-05-06 11:37:32,543 DEBUG c.i.r.ExcelDataExport [https-openssl-nio-443-exec-4] Export streaming mode: true 2020-05-06 11:37:32,861 DEBUG c.i.s.SQLTransaction [https-openssl-nio-443-exec-4] getConnection() looked for transactional connection for Leadtributor: hashcode "610595744" 2020-05-06 11:37:32,861 WARN c.i.s.SQLTransaction [https-openssl-nio-443-exec-4] Ending Leadtributor transaction "610595744"
Again, this also happened occasionally before when we were using exportClientData(), so I think it's something about XLSX generation.
Do you have any idea what might be happening here? Could you add more logging in the area of ExcelDataExport?
Can I enable more logging here somehow already? Perhaps stop the framework from suppressing 3rd party logs via a server.properties setting (if such a thing happens)?
Any advice is appreciated, because it's very frustrating to get such reports and not be able to find out anything about it.
Thank you & Best regards
Blama
Comment