Error 5007

[parissa_wall3]

I am writing to different tabs of an Excel file continuously and simultaneously. It works without an error for short period of time but If I repeat this task for a long time (30 second of data collection that repeats 18 times, it randomly give me this error:   ERROR 5007 OCCURED AT XLR8.LVLIB:  SUB_NO_REFNUM_CUSTOM_ERROR.VI    which means it could not open the file.    the way I wrote the code, it opens the file for each 30 second process and switch between tabs based on where data needs to be stored. I also attached my code. that part of the code works fine but when it repeats , the error pops up.    File notes:    I have 8 different slots (the run simultaneously for 30 seconds)  I have WE SMU/RE SMU/ CE SMU (attached): these run sequentially and repeats 4 times    If I run WE SMU and RE SMU and CE SMU sequentially once or twice the error does not show up, the minuet I keep repeating this sequence it start giving me error.    the other thought that I had was, since I am using simulated devices in labview which generate a lot of data point very quick, it cause the file to crash and not save correctly , while in the real life my device will only capture few hundred data point.

[parissa_wall3]

I also realised that it has something to do with the size of the file, as long as I keep the data file small, no error occurs but when it increases to 1 megabite or more, it start generating error, any suggestion?

[Hans-Joachim]

Hello parissa_wall3,

i looked at your program snipped and i have some sugguestions:

1. don´t write to the excel file parallel. (Array Constant of "Counter ElectrodeX" to an for-structure)

2. Wire through the XLR8 Ref and use always the current Reference, not the first created ref from "Open/Create workbook".

3. Check your memory usage of LabVIEW or your applikation. The next version of XLR8 will include a improved file and memory handling.

Greetings

Hajo

[parissa_wall3]

Hi Hans,  Thanks fro reply.

1. don´t write to the excel file parallel. (Array Constant of "Counter ElectrodeX" to an for-structure):

do you mean I should run "Counter Electrode X (1~8)"  sequentially and not parallel? in CE SMU.vi file?

2. Wire through the XLR8 Ref and use always the current Reference, not the first created ref from "Open/Create workbook".

Does it mean that I have to have a separate Open/Create function in each Subvi? ( "Sot 1-Counter-Sequential.vi)

3. Check your memory usage of LabVIEW or your applikation. The next version of XLR8 will include a improved file and memory handling.

when does the new update release?

[parissa_wall3]

I have to run all 8 subvi in parallel and record the measurments at the same time, that is very critical for my tester. does it help if I write in 8 different files instead of 8 different tabs of the same file?

how can I have the latest XLR8 reference to save the final data? If i insert a new  Open/Create file and send its reference to save and close the file, I will lose all my measurment data, thats why I used the original reference.

Also I tried to send a reference from one of the SUBVI s to save the file after the execution and it gives me a provoke node error after couple of times of runing the code.

[Hans-Joachim]

Hi parissa_wall3,

1. Yes

2. Seperate the DAQ (Parallel) from the Excel Report (sequentiel) and use only one Open/Create functionality. Use the "Refs In/Out" to wire the reference through the functions until you connect it to the "close Workbook".

3. The new Version is in development but i can´t tell you a realease date. You can stay tuned in this community wehre it will be available first to download.

You can also look at the installed examples which show you how to develop with XLR8.

Greetings,

Hajo

[parissa_wall3]

I sent all my data to an array and wrote to the EXCEL only once, it still gives me same error when the file size goes above. 1.8 M.