LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: lae_errors

This post has been created for discussion of error code brain.node.office.errorReadingFileAs.

Please reply to this thread with any description of error conditions, diagnostic information, and recommended resolutions.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

This is generally just a warning and not an error.
The warning will be written to the log when trying to read an Excel File where the file does not match it's expected format.
If the file has a .xls extension, it will first try and read the file as if it where a XLS format file, if this fails you will get the error message above.
Then, it will proceed trying to read it as an XLSX format file.
If both of these fail, then you will receive an error.
Similarly, for a .xlsx extension it will first try and read as an XLSX format, then an XLS format if the first attempt fails.
Again if both fail, you will receive an error on the node.

The reasons that this could fail could be numerous.
It could just be a non-Excel file, like a file in a CSV format or text format or something.
Alternately, it could be a file that was not created through Excel but in a 3rd party product.

While the node should work with any XLS or XLSX format saved through Excel or saved via any 3rd party product that follows these format specifications, there may be other tools which produce XLS/XLSX files which do not exactly match the format dictated by Excel. In such cases, you may be able to open the file in Excel (if Excel is lenient about its format) but may not be able to load into the LAE.

First, you should probably check that the file can actually be opened in Excel.
If it can, then you should try to save a copy from Excel to another XLS/XLSX file.
If you can load this copy of the file, without a problem then it would suggest that the original file was not produced by Excel but by another 3rd party tool which is not producing files in the same format that Excel does.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: enchigamon

Hi,

Is there a different way this works on a local client and a server installation ? Because I've got an .xlsm which imports just fine when I run on my local desktop.
The server runs on Linux, should this have an impact on functionality? What's this POI stuff that the error refers to ?

Log from desktop :

16:21:59 >>Msg: NODEDONE from localhost:7721#1
>> result:0
>> node:5449ffcf560f5f9b
>> startTimeMillis:1414682508119
>> endTimeMillis:1414682519189
>> output:5449ffcf560f5f9b.out1=file:c:/Lavastorm/LAETemp/tmp/brain/Volymprognos+Generis/default/temp.HP10032837.15244.0.1414682512569.5449ffcf560f 5f9b.brd
>> outputlinecount:5449ffcf560f5f9b.out1=34377
>> outputdatasize:5449ffcf560f5f9b.out1=2652335
>> outputcolumnnames:5449ffcf560f5f9b.out1=Numerisk tidsserie (Description) M�tning (Datatyp i tidsserie) M�tning (Allokerings-Id)
>> outputcolumntypes:5449ffcf560f5f9b.out1=string string string
>> errlogfile:file:c:/Lavastorm/LAETemp/tmp/brain/Volymprognos+Generis/default/temp.HP10032837.10104.451.1414682508149.5449ffcf56 0f5f9b.log
>> errlog:WARN: File: S:\DOM1\IFM_Data\Report\Volymprognos\Volymprognos_ anl�ggningar_2014-10-27.xlsm has an unsupported file type. Allowable file types: {xls, xlsx}. Will attempt to read as xlsx, then xls.
>> errlog:Error Code: brain.node.office.unsupportedFileTypeAttemptOther
>>
16:21:59 - DONE Processing Node "Prognosanl�ggningar fr�n Generis" ("5449ffcf560f5f9b") on localhost:7721#1 - Last execution 11 seconds - Result Code: 0
16:21:59 >>Msg: DONE from localhost:7721#1

But when I run on our server I get the following error.

16:23:38 >>Msg: NODEDONE from lavaserver:7721#1
>> result:1
>> node:5449ffcf560f5f9b
>> startTimeMillis:1414682616334
>> endTimeMillis:1414682617940
>> output:5449ffcf560f5f9b.out1=file:/u02/app/lavastorm/tmp/brain/Volymprognos+Generis+-+Serverversion/default/temp.sl04693.9308.0.1414682617133.5449ffcf560f5f9b .brd
>> errlogfile:file:/u02/app/lavastorm/tmp/brain/Volymprognos+Generis+-+Serverversion/default/temp.sl04693.25147.90661.1414682616334.5449ffcf560 f5f9b.log
>> errlog:WARN: File: /u03/app/lavastorm/Natavrakning/01_Volymprognos/Indata/Volymprognos_anlaggningar_2014-10-22.xlsm has an unsupported file type. Allowable file types: {xls, xlsx}. Will attempt to read as xlsx, then xls.
>> errlog:Error Code: brain.node.office.unsupportedFileTypeAttemptOther
>> errlog:
>> errlog:WARN: Error reading Excel file (/u03/app/lavastorm/Natavrakning/01_Volymprognos/Indata/Volymprognos_anlaggningar_2014-10-22.xlsm) as type XLSX. Cause: Error reading Excel file (/u03/app/lavastorm/Natavrakning/01_Volymprognos/Indata/Volymprognos_anlaggningar_2014-10-22.xlsm) as type XLSX. Cause: Can't open the specified file: '/u03/app/lavastorm/Natavrakning/01_Volymprognos/Indata/Volymprognos_anlaggningar_2014-10-22.xlsm'
>> errlog:Error Code: brain.node.office.errorReadingFileAs
>> errlog:
>> errlog:WARN: Error reading Excel file (/u03/app/lavastorm/Natavrakning/01_Volymprognos/Indata/Volymprognos_anlaggningar_2014-10-22.xlsm) as type XLS. Cause: Error reading Excel file (/u03/app/lavastorm/Natavrakning/01_Volymprognos/Indata/Volymprognos_anlaggningar_2014-10-22.xlsm) as type XLS. Cause: The supplied data ap
pears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)
>> errlog:Error Code: brain.node.office.errorReadingFileAs
>> errlog:
>> errlog:ERROR: Error reading Excel file (/u03/app/lavastorm/Natavrakning/01_Volymprognos/Indata/Volymprognos_anlaggningar_2014-10-22.xlsm)
>> errlog:Error Code: brain.node.office.errorReadingFile
>>
16:23:38 - DONE Processing Node "Prognosanl�ggningar fr�n Generis" ("5449ffcf560f5f9b") - result code is 1 on lavaserver:7721#1- Last execution 1.41 seconds
16:23:38 >>Msg: DONE from lavaserver:7721#1

BR
Martin

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

What version of our software is on your desktop and what version is on the server?
I've not tried XLSM files before but as a general rule, if you can read it on your desktop, you should be able to read it on the Server.


The other small question is how did you transfer the file to the server? Is there some chance that the upload went bad?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: enchigamon

The server and desktop have recently been upgraded to 5.0.0.1. The files are uploaded by sftp and then reanmed on the server. I dowloaded the uploaded file back to my desktop, and then I get the same error.
It seems that this is not a error in lavastorm, but rather in my transfer process. When I did renaming before the transfer everything executed smoothly. Thanks for the quick answer

07:10:11 >>Msg: SERVERVERSION from localhost:7721#1
>> version:5.0.0
>> buildVersion:5.0.0.1.29

07:11:38 >>Msg: SERVERVERSION from lavaserver:7721#2
>> version:5.0.0
>> buildVersion:5.0.0.1.29

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Make sure that you are specifying the "binary" option when you do the SFTP transfer. If you leave it with the default ASCII, it will foul up excel files.