format error when creating calc workspace from collec-data file

Question

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

Answer 1

1	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 '17, 14:42 Mino Togna ♦♦ 521●1●6 accept rate: 12%

Answer 2

0	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 Togna ♦♦ 521●1●6 accept rate: 12%

Answer 3

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)

format error when creating calc workspace from collec-data file

Follow this question

Related questions