search

OHDSI / WhiteRabbit

WhiteRabbit is a small application that can be used to analyse the structure and contents of a database as preparation for designing an ETL. It comes with RabbitInAHat, an application for interactive design of an ETL to the OMOP Common Data Model with the help of the the scan report generated by White Rabbit.
http://ohdsi.github.io/WhiteRabbit
Apache License 2.0
174 stars 85 forks source link

WhiteRabbit_v0.10.4.1->rabbitInAHat.bat does not start on Win10 #314

Closed rjiang9 closed 2 years ago

rjiang9 commented 2 years ago

Describe the bug Downloaded whiteRabbit WhiteRabbit_v0.10.4.1 and uncompressed to the same folder as WhiteRabbit_v0.10.3. When I tried to double click on rabbitInAHat.bat, the CMD window opens and closed immediately and rabbit-in-a-hat does NOT start.

But WhiteRabbit_v0.10.3 works just fine.

To Reproduce Steps to reproduce the behavior:

  1. Go to 'G:\_OHDSI\WhiteRabbit_v0.10.4.1\bin\'
  2. Click on 'rabbitInAHat.bat'

Expected behavior Command line window opens and closes its self right away. Rabbit-in-a-hat does not start.

Desktop (please complete the following information):

MaximMoinat commented 2 years ago

Thanks for reporting. We also encountered this issue while testing this pre-release. Could you check the error message when you run the bat from a command line?

One of the issues we saw is that the path to the bat executable was too long. Moving the files a folder up solved it. It could also be a Windows security issue.

rjiang9 commented 2 years ago

@MaximMoinat : Thank you for the response. Here is what my folders look like:

G:\wr\bin>rabbitInAHat.bat The input line is too long. The syntax of the command is incorrect. G:\wr\bin>

MaximMoinat commented 2 years ago

We have identified the problem; the large number of jar dependencies loaded causes some lines to become too long for Windows to handle.

We are working on a fix.

rjiang9 commented 2 years ago

Thank you for the hard work, @MaximMoinat !

sebastiaan101 commented 1 year ago

I had a similar experience with WR_v010.7 on two Windows 11 computers. Changing the folder didn't work. What did work was

on machine 1 and 2: running the .bat file with a ".\rabbitinahat" command in powershell, instead of "rabbitinahat" - it was advised to use this command 'if you trust the file'. So probably this is related to the windows securtiy issue you mentioned @MaximMoinat. on machine 2 I also had to add the java...\bin folder to the PATH ;-)