I need help installing open refine (otherwise known as Google Refine) on my windows 7 lap top

2,059 views
Skip to first unread message

David Mills

unread,
Jun 14, 2014, 7:11:25 PM6/14/14
to openr...@googlegroups.com
I am running Windows 7 home premium (32 bit) with about 3 gigs ram. i have ample space on my hard drive.  I went to openrefine.org. I clicked on download, then windows kit under Google refine-stable version.

The zip file was downloaded. I double clicked the zip file and a bunch of files opened up.  I am supposed  a to be able to get open refine by clicking on google-refine.exe or refine.bat.  In either case  a black box comes up and disappears in a second or two. There was a message in the black box (I could only read it by clicking several times) that read "could not find or load google-refine.exe"

I am running the latest version of Java.

What can I possibly do? I can't load Google refine and I need it!

I've searched all over the web. I find plenty of questions but now answers! I need answers!


Please help!


David Mills

Thad Guidry

unread,
Jun 15, 2014, 6:08:30 PM6/15/14
to openr...@googlegroups.com
You probably need to open a command window manually (open as Administor by right clicking on Command Window executable) then cd to the path where you unzipped OpenRefine..then type refine.bat to start it...it should then auto launch your default browser, if not open your browser to http://127.0.0.1:3333

Let us know if you have more problems.


--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

David Mills

unread,
Jun 15, 2014, 11:56:48 PM6/15/14
to openr...@googlegroups.com
Ok I downloaded open refine from windows kit on openrefine.org.  I copied zip file from downloads directory to desktop. I doble clicked on zip file. I opened new command window. changed directory to desktop. then typed in refine.bat.  I got message that "refine.bat is not recognized as an internal or external command  operable program or batch file. I also opened my  browser and typed into url the numbers you told me to. Google chrome could not connect.

Looks like I am still at square one. Why oh why is this so hard??

David

Ricardo L. Gomez

unread,
Jun 16, 2014, 12:14:31 AM6/16/14
to openr...@googlegroups.com
all you have to do is to extract to a folder in your desktop and then double-click the google refine application icon (the diamond)


Martin Magdinier

unread,
Jun 16, 2014, 8:47:23 AM6/16/14
to openrefine

Looking at the twitter feed and support list it looks like several people have similar issue with windows 7.

Anyone is aware of a recent change in 7 specific environment (OS update, java update ....)?

David Mills

unread,
Jun 16, 2014, 8:51:35 AM6/16/14
to openr...@googlegroups.com
double clicking on the zip file.. it goes where it goes. And in any case.. the google-refine.exe and refine.bat files don't load.  I've tried everything. It just doesn't work.


On Saturday, June 14, 2014 6:11:25 PM UTC-5, David Mills wrote:

Thad Guidry

unread,
Jun 16, 2014, 11:44:16 AM6/16/14
to openr...@googlegroups.com
Can you try to right click on the google-refine.exe file and choose Open as Administrator ?  It may be an issue with User Account Protection security being on.


--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

David Mills

unread,
Jun 16, 2014, 12:43:25 PM6/16/14
to openr...@googlegroups.com
when I right click on google-refine.exe I don't get the option to open as administrator. I get a whole bunch of  PKCom.en_US-secure-secure files


On Saturday, June 14, 2014 6:11:25 PM UTC-5, David Mills wrote:

Thad Guidry

unread,
Jun 16, 2014, 2:09:28 PM6/16/14
to openr...@googlegroups.com
It sounds like you have not extracted the ZIP file yet...and the google-refine.exe is still contained INSIDE the zip file... please extract the zip file FIRST.  If you do not know how to extract a zip file on Windows, then please do a web search on "how to extract a zip file on Windows" or something similar.



--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

David Mills

unread,
Jun 16, 2014, 3:54:32 PM6/16/14
to openr...@googlegroups.com
I did that. still same result. I've clicked on the zip file which extracts it, clicked on google-refine.exe and the application doesn't open.. black box comes up then disappears. Don't tell me I haven't done steps a b c when I have many times over and am still not getting the program. Maybe we should just close this thread..  no one has an answer. just like the other internet forums, lots of questions but no answers.


On Saturday, June 14, 2014 6:11:25 PM UTC-5, David Mills wrote:

gchat...@gmail.com

unread,
Aug 6, 2014, 10:08:46 AM8/6/14
to openr...@googlegroups.com
I've had the exact same problem as Mr. Mills, although I've gotten a step farther. (And, yes, thank you, I've extracted the zip file...)

I went to the command line (cmd.exe), tried running google-refine.exe from there, and got some errors that may be helpful to know. They are as follows:

Error occurred during initialization of VM
Could not reserve enough space for object heap
Error: Could not create the Java Virtual Machine
Error: A fatal exception has occurred. Program will exit.

And then, bam, back to the command prompt.

So, I need some space, it seems. But where? And how do I get it?

-G.

Owen Stephens

unread,
Aug 12, 2014, 4:02:01 PM8/12/14
to openr...@googlegroups.com
I'm afraid not really my area of expertise, but in case this is of any help - googling the "Could not reserve enough space for object heap" error gives some pointers.

You could try initialising OpenRefine with a smaller amount of memory - e.g.:

refine.bat /m 512m

(see https://github.com/OpenRefine/OpenRefine/wiki/FAQ:-Allocate-More-Memory). However, this is likely to cause problems when you actually try to use the program.

Alternatively, a suggestion at http://stackoverflow.com/questions/18040361/java-could-not-reserve-enough-space-for-object-heap-error is to make sure you are using the 64-bit version of Java if you are on a 64-bit OS. You can download this from https://www.java.com/en/

Sorry I can't give you any more detailed help - good luck

Matthew Johnson

unread,
Aug 16, 2014, 5:28:09 PM8/16/14
to openr...@googlegroups.com
I'm having the same problem where when I click on openrefine (after extracting the folder), the command line opens up for about 2 seconds then disappears This sounds like a problem that is affecting many people. This seems like a fantastic application but these problems are incredibly frustrating. Any tips from the openrefine community would be extremely appreciated.

Thad Guidry

unread,
Aug 16, 2014, 10:40:19 PM8/16/14
to openr...@googlegroups.com
Don't click on the OpenRefine.exe ...instead type in a command window....

refine.bat

or

refine.bat /m 4096m

to allocate 4gigs to Refine on the java heap it uses.




--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

gchat...@gmail.com

unread,
Aug 18, 2014, 2:35:08 PM8/18/14
to openr...@googlegroups.com
Thanks for the recommendation, Thad. I gave it a try and got another error.

First of all, I did make sure 64-bit java was installed. (I apparently have both 32 and 64 at this point...) 

First when I first tried to run it, I got an error that recommended setting the JAVA_HOME variable to the jre7 directory location. So I did.

Even after installing 64, I got this error in the command window:

Invalid maximum heap size: -Xmx4096m
The specified size exceeds the maximum representable size.
Error: Could not create the Java Virtual Machine. 
Error: A fatal exception has occurred. Program will exit.

Then I noticed that Java was installed in two directories: 

- C:\Program Files\Java (aka c:\Progra~1\Java)
- C:\Program Files (x86)\Java (aka c:\Progra~2\Java)

The documentation originally said to use the x86 path (Progra~2), and this is what I was doing, but it wasn't working. When I switched the JAVA_HOME variable to Progra~1, it seems to have worked. I got "Google Refine" to open in Chrome.

Hope this makes sense - typed it once and Chrome ate it, so hopefully I've remembered everything in this second pass through...

Gena

Gena Chattin

unread,
Aug 18, 2014, 4:23:28 PM8/18/14
to openr...@googlegroups.com
Hi Thad, 

Thanks for the recommendation. The first time I tried this, it asked me to set the JAVA_HOME variable, which I did. It recommended the instructions here: https://confluence.atlassian.com/display/DOC/Setting+the+JAVA_HOME+Variable+in+Windows. The value I set to JAVA_HOME was C:\Progra~2\Java\jre7. 

Then I got the following error when I tried the command you suggested after setting JAVA_HOME:

Invalid maximum heap size: -Xmx4096m
The specified size exceeds the maximum representable size.
Error: Could not create the Java Virtual machine.
Error: A fatal exception has occurred. Program will exit.

Pretty sure (other than the JAVA_HOME variable that I just set) that all my Java settings on this computer are whatever comes as default. 

Any ideas?

Gena


--
You received this message because you are subscribed to a topic in the Google Groups "OpenRefine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openrefine/vUzqJqJ-sAA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openrefine+...@googlegroups.com.

Thad Guidry

unread,
Aug 18, 2014, 4:47:18 PM8/18/14
to openr...@googlegroups.com
Awesome Gena,

So it sounds like OpenRefine is now running against the 64bit JRE7 path....Good... 64bit programs are typically auto-installed on Windows 64bit path of "C:\Program Files" and where 32bit programs are typically auto-installed into "C:\Program Files (x86)"

You can certainly buy more RAM if your motherboard supports it and crank up the setting of the java heap size in the Refine.ini file if you want or need to.

So sorry that Refine does gobble up quite a bit of RAM for some operations, since it is not highly optimized in this area for it's storage and Undo/Redo playback...something we wanted to fix but still have not and may never at this rate.

However, remember that OpenRefine was not really designed to work with extremely large files.  Most of us have and use other ETL tools and programs to do the heavy lifting in that area when we need to.  But many of us have used OpenRefine with multi gigabyte files when allocated with enough RAM though.

Let us know if you have any more issues !
Enjoy !



--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Jim Macknik

unread,
Jan 23, 2015, 12:50:27 PM1/23/15
to openr...@googlegroups.com
David - I had the exact same issues you have been running into, running Windows 7 Enterprise 64-bit. Could not get anything to work. Had the latest Java installed (8_31 as of this posting), set my JAVA_HOME, etc.

The error when running the google-refine.exe, though, gave me the clue - it indicated it couldn't find the the Development Kit environment. I didn't have the JDK installed - I had the JRE.

Downloaded the latest 64-bit JDK (same version as the JRE), changed the JAVA_HOME to point to the jdk dir instead of the jre, and running the google-refine.exe app started up perfectly. Google refine opened up in Chrome and it looks like it's purring like a kitten.

If you need more specifics, please feel free to reach out. Happy to help if I can.

qi cui

unread,
Jan 29, 2015, 10:48:49 AM1/29/15
to openr...@googlegroups.com

Normally, you only need JRE if you are running standalone application. OpenRefine is a web application which need compiling on the fly when providing the service. In this case, you need JDK installed.

Ty Tagami

unread,
Jun 22, 2015, 12:43:11 PM6/22/15
to openr...@googlegroups.com
I had the flashing command window problem, too. I thought I was encountering this new issue because our IT department had recently upgraded my laptop to 64 bit from 32 bit (it worked fine on 32 bit). But it was much simpler than that: It turns out my problem was that I was only unzipping the .exe file. You need to unzip the entire download folder, then click on the .exe. Now, it works fine.


On Saturday, June 14, 2014 at 7:11:25 PM UTC-4, David Mills wrote:
Reply all
Reply to author
Forward
0 new messages