Harvesting empty, custom, optional int property fails

[GoogleCodeExporter]

For a custom property in an aspect:

<property name="myns:someValue">
    <title>Some Value</title>
    <type>d:int</type>
    <mandatory>false</mandatory>
</property>

if there is no value set then harvesting logs the following FATAL message

 2013-05-02 09:39:54,173  FATAL [reporting.script.AlfrescoReporting] [http-8080-6] java.sql.SQLException: Incorrect integer value: '' for column 'myns_someValue' at row 1
 java.sql.SQLException: Incorrect integer value: '' for column 'myns_someValue' at row 1

The obvious work around is to set some well known value but that's not ideal

Original issue reported on code.google.com by ian.well...@gmail.com on 3 May 2013 at 8:14

[GoogleCodeExporter]

Hi Ian,

Thanks for your issue. I will try to look into this asap. Seems like an 
annoying one with a feasible fix... Keep you posted!

Original comment by tjarda.p...@incentro.com on 3 May 2013 at 8:45

[GoogleCodeExporter]

Hi Ian,

Tracked the issue, bug appears fixed. Into some tests. Fix won't be Today 
though...
(Actually affected null values in all types but VARCHAR. Strange it appears 
only now...)

Original comment by tjarda.p...@incentro.com on 3 May 2013 at 9:30

• Changed state: Started

[GoogleCodeExporter]

This is confirmed working.
The issue was that all non-VARCHAR() fields generated errors in harvesting.

Will be delivered in version 0.8.0.2.

Original comment by tjarda.p...@incentro.com on 14 May 2013 at 8:48

• Changed state: Verified

[GoogleCodeExporter]

Fixed in the 0.8.0.2 release, ready for download.

Original comment by tjarda.p...@incentro.com on 27 May 2013 at 8:21