Large model exporting to Excel issue

[TCeagle]

I have a very large model (20 LVs) and data set (10,000 obs) and when I attempt to export results to Excel nothing happens. Program runs fine, exporting doesn't. It works for smaller models and data sets. No error rmessage, nothing. I get the dialog box about saving the file, then nothing. Exporting individual output screen works fine via export button. Exporting to HTML is fine too. I turn off the graphs and exportation of large matrices. My smartppls.ini file has memory set for the following:

-startup
plugins/org.eclipse.equinox.launcher_1.3.100.v20150511-1540.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.300.v20150602-1417
-clean
-data
@user.home/.smartpls3
-clearPersistedState
-vmargs
-DcheckForUpdates=true
-Xmx8192m
-Xms4096m

I have a dual Xeon PC running Windows 7 64 bit with 32 gigabytes of memory. So I don't think my machine is running out of memory. Is there a limit on the Java memory set in the ini file?

Thanks,

Tom Eagle

[jmbecker]

Do you use the Streaming API?

[TCeagle]

Sorry to take so long to reply.

I've tried both with and without Streaming API. I have also tried excluding large matrices, using simple layout, and turning off the graphs. Nothing works. I get no error message after the dialog box about saving the file name. I can export using HTML, but that is a pain to copy into Excel.

Tom

[jmbecker]

Do you have data groups?
We found a small problem in the excel export that it crashes when non alpha-numeric characters are used in group names, because these group names are used as names for excel tabs and excel does not allow all possible characters.

[TCeagle]

Yes I have a lot of data groups and some of those names are quite long. I am only using a '-', a '+', ':', and a '*' in those names in addition to alphabetic characters. I suppose I should remove the use of all those characters and shorten the group names a lot.

Tom

[TCeagle]

I have shortened all my data group names to less than 20 characters and they use nothing but alphabetic characters. The export still bombs. Does the length and wording of the model name also cause the same problem?

Tom

[TCeagle]

Shortening the model names did not work either... I shortened a model name to 'A' and the export to excel still does not work.

I have no problem with smaller data files... Is the dialog trying to exclude large matrices broken. Am I exceeding my Excel 32bit # of row limit. Even when I run a smaller sub-group by itself (9,144 obs) the Excel export does not work.

Tom

[Thismare89]

I came across the same qestion.

[cringle]

Using very short variable names always is a good idea. Also, we suggest excluding large matrices and API streaming. See the the attached screenshot of setting.

Best
Christian