I'm new here

Trying to debug a Content2 Exception

Good morning,

I am trying to debug a very strange TypeValidation error in my contentstore, where FirstSpirit tries to convert a text field to an FS_ID integer field. The error is thrown on page generation, and when trying to edit the Content2 elements in ContentCreator web edit.

The stack trace includes:

05.07.2014 10:34:56 ERROR 05.07.2014 10:34:56.303 {pID=82694,g-sec=133809,g-node=133805} ( FormFields.fs_id: wrong type, expected class java.lang.Integer, provided class java.lang.String

FSVersion=;JDK=1.7.0_45 64bit Oracle Corporation;OS=Linux 2.6.32-358.23.2.el6.x86_64 amd64;Date=05.07.2014 10:34:56

de.espirit.or.TypeViolation: FormFields.fs_id: wrong type, expected class java.lang.Integer, provided class java.lang.String

  at de.espirit.or.impl.schema.Conversion$

  at Method)

  at de.espirit.or.impl.schema.Conversion.convert(

  at de.espirit.or.impl.schema.Conversion.convert(



  at de.espirit.firstspirit.client.access.editor.AbstractOptionsEditorValue.addKeyValueBasedReference(


and ends with:

  at de.espirit.or.impl.schema.Conversion$

... 104 more

Caused by: java.lang.NumberFormatException: For input string: "Email Address"

  at java.lang.NumberFormatException.forInputString(

  at java.lang.Integer.parseInt(

  at java.lang.Integer.<init>(

... 109 more

The schema definition is a simple one-to-many relationship.

Forms Schema Definition.png

The text "Email Address" is the value of a record in FormFields.FieldName.

I can't work out why FirstSpirit is trying to convert "Email Address" to  FormFields.fs_id.

My only thought is that it's something to do with the section template form, which contains several <CMS_INPUT_COMBOBOX> elements which let the user select from the table join:

<CMS_INPUT_COMBOBOX name="st_formfields_name" sortOrder="ascending" useLanguages="no">

    <CMS_INCLUDE_OPTIONS type="database">


        <LABEL lang="*">#item.FieldName</LABEL>



      <QUERY name="properties.select_form_fields"/>




      <LANGINFO lang="*" label="Item name"/>



The query "properties.select_form_fields" is a simple one:

<QUERY entityType="FormFields">

    <FILTERPARAM parameter="formname" datatype="java.lang.String" value=""/>

    <EQ attribute="forms.FormName" parameter="formname"/>


Can anyone see any obvious errors in the above code?

Many thanks,


0 Kudos
3 Replies
I'm new here

Hi Liam,

looks like you try to write an String value into an Integer field.

Im guessing there is something wrong in your field mappings. I had a similar error with exact that cause.



0 Kudos
I'm new here

Hi Liam,

pleas have a look on your definition of CMS_INCLUDE_OPTIONS.

You added the optional tag <key>. The configured field is used to store the value. If you omit this tag, the id will be used to store the value.

Thanks Jan Tilo,

We will investigate this further. I suspect that you are right with the <KEY>.


0 Kudos