SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only
  • 1.  error uploading excel file (error starting Java virtual machine)- unable to open

    Posted Wed November 20, 2024 09:37 AM
    Hi,
    I have been trying to import an excel file but getting an error as below, Unable to start Java virtual machine, unable to open file. please help with a solution. This is my first import into SPSS. Thank you.

    error trying to import excel file


    ------------------------------
    Zvikomborero Madzivire
    ------------------------------


  • 2.  RE: error uploading excel file (error starting Java virtual machine)- unable to open

    Posted Thu November 21, 2024 02:25 PM

    Hi @Zvikomborero Madzivire. That error indicates that the Statistics backend process cannot start the Java JVM for the backend process in order to perform an import. That is an unusual error that points to something different about your environment. Recommend filing a Support case to get to the bottom of this.

    In the short run you should be able to save your Excel .xlsx file as an older format .xls format workbook and import that.

    Regards,



    ------------------------------
    Curtis Browning
    SPSS Statistics Architect
    ------------------------------



  • 3.  RE: error uploading excel file (error starting Java virtual machine)- unable to open

    Posted Thu November 21, 2024 09:44 PM

    Thank you. It eventually started working.



    ------------------------------
    Zvikomborero Madzivire
    ------------------------------



  • 4.  RE: error uploading excel file (error starting Java virtual machine)- unable to open

    Posted Fri November 22, 2024 02:15 AM

    I get the same result when I try to open files which have been exported as Excel files from our SAP BO system. But the problem is solved by simply opening the Excel files and saving them again. Using an older format has not been not necessary. 



    ------------------------------
    Robert Lundqvist
    ------------------------------



  • 5.  RE: error uploading excel file (error starting Java virtual machine)- unable to open

    Posted Mon November 25, 2024 09:25 AM

    FYI, we have an interim fix in the works for this issue. The IF will be created for both Statistics 29 and 30.



    ------------------------------
    Curtis Browning
    SPSS Statistics Architect
    ------------------------------



  • 6.  RE: error uploading excel file (error starting Java virtual machine)- unable to open

    Posted Mon November 25, 2024 09:34 AM
    I had a similar issue when using spss batch facility & not being able to open excel files from within spss.  Simply opening & saving them was a work around also.

    Sent from my iPhone





  • 7.  RE: error uploading excel file (error starting Java virtual machine)- unable to open

    Posted Mon November 25, 2024 11:35 AM

    Hi @Art Jack and @Robert Lundqvist. If either of you have Excel files that were created by either SPSS Statistics or SPSS Modeler that you are unable to read back in to Statistics without first opening and saving in Excel, please feel free to reach out to me privately if you are able to share those files so we can test them in-house.

    Thanks



    ------------------------------
    Curtis Browning
    SPSS Statistics Architect
    ------------------------------



  • 8.  RE: error uploading excel file (error starting Java virtual machine)- unable to open

    Posted Mon November 25, 2024 03:30 PM

    Hi Curtis, I attempted to recreate the issue with v29 but it's working properly.  Up until this past summer we were still using v26.  Thanks for your response.  - Arthur



    ------------------------------
    Art Jack
    ------------------------------