Intermittent Save Report to File error

[jyang72211]

In my program, regularly I will get the error below from NI_report.lvclasss:Save Report to file.vi.  I digged deeper, and I found that the error comes from a SaveAs method under _Workbook inside the NI_ReportGEnerationToolkit.lvlib:Excel_Save_Workbook.vi.  Its input contains Filename, Password, and FileFormat.  The Filename is 199 characters, the FileFormat is -4143 for .xls and Pasword is blank.  I thought the number of characters is a bit suspicious.  If it is a problem, howcome the error is not consistant?  How do I get over that limitation?  I thougth window 7 allow at least 250?

Error -2146827284 occurred at Unknown System Error in NI_ReportGenerationToolkit.lvlib:Excel_Save_Workbook.vi->NI_Excel.lvclass:Save Report to File.vi->[TSV2 File] - Save Event Log Result File.vi->[TSV2 File] - Create Event Log Result File.vi->[TSV2 Analysis] - Analyze Event File.vi->[TSV2 Test System] - Main.vi

This error code is undefined. Undefined errors might occur for a number of reasons. For example, no one has provided a description for the code, or you might have wired a number that is not an error code to the error code input.

Additionally, undefined error codes might occur because the error relates to a third-party object, such as the operating system or ActiveX. For these third-party errors, you might be able to obtain a description of the error by searching the Web for the error code (-2146827284) or for its hexadecimal representation (0x800A03EC).

[mikeporter]

Have you done what the error code told you to do? Checked the web?

What did you find? 

What have you tried?

Mike...

PS: why is the file name length suspicious? What is the usual length of your file names? What is the name that is being generated?

[jyang72211]

I did a search on the decimal error code, but I didn't find much.  However, after i read your message,I did a search on the hex error code, and I found much more.  It seems like the problem is due to the fact that I am saving the file in *.xls instead of *.xlsx, but the proposed reasons that I found on my reserach are not the cause of my problem.  I was actually save file in *.xlsx, and there was an excel problem that was resolved when save in *.xls.  I forgot what problem it was though.

I was looking at the code and I saw that it did a blank save to creat the file and save again after the file is populated with data.  The 1st save looks suspious, so I removed it, and I hope it will solve the problem.  

I just thought that the length is suspicious beacuse the lenght is 199.  It look like it is at some sort of limit.  The usual lenght of file is about 190.