---
title: "format error  when creating calc workspace from collec-data file"
url: "https://openforis.support/questions/758/format-error-when-creating-calc-workspace-from-collec-data-file"
tags: ["calc"]
status: "answered"
score: 0
answer_count: 3
asked: "2016-09-26T14:03:50"
last_activity: "2017-02-27T14:42:42"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# format error  when creating calc workspace from collec-data file

Asked by pmagdon on 2016-09-26

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 (score 1, by Mino Togna on 2017-02-27)

Link: https://openforis.support/questions/758/format-error-when-creating-calc-workspace-from-collec-data-file/1100

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


## Answer (score 0, by Mino Togna on 2016-09-26)

Link: https://openforis.support/questions/758/format-error-when-creating-calc-workspace-from-collec-data-file/759

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


## Answer (score 0, by wexxo on 2017-02-24)

Link: https://openforis.support/questions/758/format-error-when-creating-calc-workspace-from-collec-data-file/1095

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)