IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
i get an java.lang.NullPointerException error when i try to create a Folder Data Source referring to a folder on local disk with Excel files.
I've tested with simple c:\TEST\a.xlsx
The a.xlsx contains a single value "A" in the A1 cell.
So no special symbols in both, file path or the Excel document itself. Also, no other files are present in the folder.
I am running QMF 18.104.22.168 on Win 11, and currently am not able to try a different version, because business relevant scheduled tasks are running on it.
And i think it should work anyway, as that's how QMF12 was designed...
I've tried to query the copy of the file on another machine with QMF11 on Win 11, using the JDBC-ODBC drivers and it's working properly, so i have no suspicion of the file being corrupted or read protected.
I'd appreciate any advice that would not suggest reinstalling the 22.214.171.124 or even going to a higher version (as far as i know, it's unable to run QMF 12.2 via .bat at the moment, so that version is a strict no-go for our needs anyway).
Thank You very much and have a nice day
Thank you Matus for your post. As I confirmed with you, this error is returned from QMF for Workstation installed on a VM machine, not on your local machine. To investigate the problem further using logs and additional information, we recommend you to please open a case by going to https://www.ibm.com/mysupport/s/?language=en_US
Sorry for late reply.
Yes, still working on the access to be able to open the case. I'll submit it as soon as I'm able as the issue is ongoing even after fresh installation.
Thanks and have a nice day