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 26 Sep '16, 14:03

pmagdon's gravatar image

pmagdon
214610
accept rate: 0%


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 27 Feb, 14:42

Mino%20Togna's gravatar image

Mino Togna ♦♦
2423
accept rate: 7%

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 26 Sep '16, 15:38

Mino%20Togna's gravatar image

Mino Togna ♦♦
2423
accept rate: 7%

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 24 Feb, 16:53

wexxo's gravatar image

wexxo
351411
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×42

question asked: 26 Sep '16, 14:03

question was seen: 306 times

last updated: 27 Feb, 14:42

Open Foris Support - 2014