Please use our GitHub Issues page for all new support inquiries. If you need to contact us directly, please e-mail [email protected]

Dear OpenShapa Developers

I tried to import data files generated on MacShapa but I encountered a problem during the migration

I followed the very clear description of the steps found on the website (

Unfortunately, after running the script the following message appeared :

Converting /Users/clementguerin/Documents/Recherche/Ordonnancement/OpenShapa/S01_C2I1R1.db ** SCRIPT ERRROR ** @Line -1:'org.jruby.exceptions.RaiseException: Native Exception: 'class org.openshapa.models.db.legacy.SystemErrorException'; Message: Database::colNameInUse(name): name is invalid; StackTrace: org.openshapa.models.db.legacy.SystemErrorException: Database::colNameInUse(name): name is invalid at org.openshapa.models.db.legacy.Database.colNameInUse( '

This message is really not understandable for me that's why i beg your help please

I would appreciate your attention to this matter

Clément Guerin

asked 28 Oct '11, 19:12

clementguerin's gravatar image

accept rate: 0%

The error you are getting is because OpenSHAPA does not appear to accept the column names coming from your MacSHAPA file. Would you be able to list the names and types from your MacSHAPA file?

(30 Oct '11, 12:44) Clinton Clinton's gravatar image

Thank you for your answer Clinton. In this MacShapa file there are 4 column (variables) : 1) "VerbSuj" => text type 2) "Commentaires" => text type 3) "Activité" => predicate type 4) "Action" => predicate type


(30 Oct '11, 22:34) clementguerin clementguerin's gravatar image

The column "Activité" appears to be causing OpenSHAPA the problems, it doesn't appear to like the accented "é". The temporary work around would be to replace it with a regular 'e'. We are currently implementing some new features that will greatly improve multiple language support in OpenSHAPA.

permanent link

answered 31 Oct '11, 11:18

Clinton's gravatar image

accept rate: 36%

Thanks Clinton

I modified the accented "é" by a regular "e" but another message appeared

Converting /Users/clementguerin/Documents/Recherche/Ordonnancement/OpenShapa/S01_C2I1R1.db ** SCRIPT ERRROR ** @Line -1:'org.jruby.exceptions.RaiseException: bad value for range'

I can send you the MacShapa file if necessary.

permanent link

answered 31 Oct '11, 20:07

clementguerin's gravatar image

accept rate: 0%

Yeah. Fire across the MacSHAPA file and we will take a look. I might be that more accented characters are in the file.

(01 Nov '11, 10:03) Clinton Clinton's gravatar image

I guess you're right about accented characters (french verbal reports) Do i need to send the file at the following adress : [email protected], and indicating "for Clinton" or something like that ? Many thanks

(02 Nov '11, 17:46) clementguerin clementguerin's gravatar image

Yeah fire it over to that email address - looks like can't add attachments to this yet. Also have a try at removing accented characters from the file.

(03 Nov '11, 14:13) Clinton Clinton's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 28 Oct '11, 19:12

question was seen: 6,053 times

last updated: 03 Nov '11, 14:13

powered by OSQA