NegativeArraySizeException

I once loaded a file which has more than 600k lines but after a few minutes I tried loading the same file into the same workflow after doing some changes into the files. However this time the file is not getting loaded and shows an error (“NegativeArraySizeException”) : -1. Latest KNIME version with 32GB ram laptop. If these information helps. please help me.

Thanks and regards

Hi @psycho ,

I think questions that anybody trying to assist you here might ask:

  • what type of file?
  • what node you are using to read it?
  • what is the actual size (in KB, MB etc) of the file?
  • what does “after doing some changes into the files” mean?
1 Like
  • what type of file? excel
  • what node you are using to read it? both excel and file reader
  • what is the actual size (in KB, MB etc) of the file? 256MB
  • what does “after doing some changes into the files” mean? LIKE we added a column at the end. Simple Yes or No column. thats all after that it started giving me that error.

So it’s a .xlsx file, or a different extension?

Did you the modify the file in Excel, or using KNIME, or some other way ?

Does the file still open ok if opened directly in Excel?

Is the file saved on a local drive, or are you using a network share or is it a “cloud storage location” (on a local drive) such as using onedrive, googledrive, dropbox etc ?

1 Like

o it’s a .xlsx file, or a different extension? .xlsx file

Did you the modify the file in Excel, or using KNIME, or some other way ? yes i modified it in excel

Does the file still open ok if opened directly in Excel? no not yet

Is the file saved on a local drive, or are you using a network share or is it a “cloud storage location” (on a local drive) such as using OneDrive, googledrive, dropbox etc ? Its saved on business one drive folder

So you are saying you cannot open the file directly in excel either?

If you copy the file to a local drive (outside of onedrive ) can you open it from there?

1 Like

But we are not supposed to save docs in our local PCs.

Is that policy because of there being sensitive information in the documents or is it simply to ensure that everything is backed up in the event that the pc breaks?

I’m not going to encourage you to do something against policy but my theory is that business onedrive may be causing the problem here. That can be ruled out by troubleshooting. In this case by testing what happens if the file is saved elsewhere. If that isn’t an option, it’s going to be more tricky to help.

Now my understanding is that you have an xlsx file that you cannot open in KNIME, but you say you also cannot open in Excel. This means it isn’t specifically a KNIME problem, but instead is a problem with either the file or the storage location. It could be the file is corrupt in which case there is nothing that I can suggest other than ask if you have a backup copy? ( If you are using business onedrive, you probably have an option somewhere to recover an old version, for example)

If the file is on a cloud service such as business onedrive it could be that it isn’t properly available locally, because maybe it is marked as “cloud only”.

Can you see if the file is correctly sync’d and marked as “available offline”?

Copying it to a local device would force it to be downloaded and it could probably then be opened. If it still cannot be opened then it would suggest that the file had been corrupted in some way.

1 Like

I will try to get the approval and will let you know what the outcome is.