format error when creating calc workspace from collec-data file

  • Asked
  • Active
  • Viewed 6718 times
0

Dear OpenForis Team,

when trying to create a calc workspace by importing a collect-data file we encounter the following Java Format error:

ERROR (CollectDataController.java [importCollectData]:101) - Error extracting survey from Collect backup file 
java.lang.NumberFormatException: For input string: "number(parent()/general_datos/parcela_bosque_tipo=2)"
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Integer.parseInt(Integer.java:580)
    at java.lang.Integer.valueOf(Integer.java:766) ...

The workspace and postgres tables are not created. The data we are importing is one plot only which was sucessfully validated in Collect. Obviously the error is related to the hierarchical code list 'bosque_tipo'. Which can be 1 or 2 in the first level and 11 or 21,22,23 .. in the second level. We don't face any errors in collect (validation is fine) nor in Sakiku where we can create the cubes and generate tables with results.

Any suggestions why Calc cannot handle the Schema?

Greetings from Göttingen

Paul

asked

pmagdon 21●4●9●14 accept rate: 0%

1

Accepted answer

Hi Alex,

are you running the latest Calc ?

If the problem still exists, can you send us the dataset you are trying to import?

Thank you, Mino

permanent link

answered

Mino Togna ♦♦ 521●1●6 accept rate: 12%

0

Accepted answer

Dear Paul,

It seems there's a problem while the survey has been extracted. Could you please send the all error stack trace?

Thank you,

Mino

permanent link

answered

Mino Togna ♦♦ 521●1●6 accept rate: 12%

0

Accepted answer

Dear Mino,

I seem to have a similar problem like Paul, i.e. no error in collect/Saiku, but when I import the collect-data, the import fails and I receive the error message posted below:

Any idea what the problem could be?

Greetings from Georgia!

Alex

Error in 'Import metadata' java.lang.NoSuchMethodError: org.openforis.collect.relational.model.DataTable.getParentKeyColumn()Lorg/openforis/collect/relational/model/DataParentKeyColumn; at org.openforis.calc.collect.CollectMetadataImportTask.createEntity(CollectMetadataImportTask.java:378) at org.openforis.calc.collect.CollectMetadataImportTask.access$000(CollectMetadataImportTask.java:73) at org.openforis.calc.collect.CollectMetadataImportTask$1.visit(CollectMetadataImportTask.java:343) at org.openforis.idm.metamodel.EntityDefinition.dfsTraverse(EntityDefinition.java:264) at org.openforis.idm.metamodel.EntityDefinition.traverse(EntityDefinition.java:246) at org.openforis.idm.metamodel.Schema.traverse(Schema.java:346) at org.openforis.idm.metamodel.Schema.traverse(Schema.java:341) at org.openforis.calc.collect.CollectMetadataImportTask.createEntities(CollectMetadataImportTask.java:339) at org.openforis.calc.collect.CollectMetadataImportTask.updateWorkspaceMetadata(CollectMetadataImportTask.java:299) at org.openforis.calc.collect.CollectMetadataImportTask.execute(CollectMetadataImportTask.java:100) at org.openforis.calc.engine.Worker.run(Worker.java:75) at org.openforis.calc.engine.Job.execute(Job.java:92) at org.openforis.calc.engine.Worker.run(Worker.java:75) at org.openforis.calc.engine.Job.run(Job.java:78) at org.openforis.calc.engine.TaskManager$1.run(TaskManager.java:254) at org.springframework.core.task.SimpleAsyncTaskExecutor$ConcurrencyThrottlingRunnable.run(SimpleAsyncTaskExecutor.java:251) at java.lang.Thread.run(Thread.java:745)

permanent link

answered

wexxo 97●2●31●46 accept rate: 4%

Your answer

Insert an image

Say what the image shows, for people who can't see it.
At least 50 characters

Powered by the Open Foris edition of OSQA Content licensed under CC BY-SA 3.0

This Q&A software is free and open source (GPL). Any organisation can run it for its own community: get the code and instructions at github.com/openforis/osqa.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.