Hey guys.
I want to evaluate Solr as search engine, but now I have got an "Invalid
Date String"-Exception.
Here is the Error Message:
--------------------------------------------
WARNUNG: Error creating document :
SolrInputDocument[{machineId=machineId(1.0)={1151665},
priceBrutto=priceBrutto(1.0)={56525.0},
priceNetto=priceNetto(1.0)={47500.0}, city=city(1.0)={Stiens},
zipcode=zipcode(1.0)={9051}, manufacturerName=manufacturerName(1.0)={},
manufacturerId=manufacturerId(1.0)={163}, model=model(1.0)={BB950R},
offerStatus=offerStatus(1.0)={commercial}, typeId=typeId(1.0)={168},
countryIsocode=countryIsocode(1.0)={NL},
yearConstruction=yearConstruction(1.0)={2003},
typeName=typeName(1.0)={Pressen}, lon=lon(1.0)={0.10050304},
lat=lat(1.0)={0.92957632}, de_b=de_b(1.0)={0}, nl_b=nl_b(1.0)={1},
uk_b=uk_b(1.0)={0}, pl_b=pl_b(1.0)={0}, fr_b=fr_b(1.0)={0},
hu_b=hu_b(1.0)={0}, 426_t=426_t(1.0)={Pers heeft +/- 57000 pakken gemaakt.},
attributes=attributes(1.0)={[Weitere Beschreibung des Angebots Pers heeft
+/- 57000 pakken gemaakt., Erstzulassung / Inbetriebnahme [B@1266f55,
Zentralschmierung, Weitwinkel-Gelenkwelle, Tandemachse, Schneidwerk, Knoter
Reinigungsgebläse, elektronische Überwachung, Ballenauswerfer, Bauart
Quaderballenpresse]}, 481_dt=481_dt(1.0)={[B@1266f55},
178_b=178_b(1.0)={true}, 175_b=175_b(1.0)={true}, 164_b=164_b(1.0)={true},
146_b=146_b(1.0)={true}, 112_b=112_b(1.0)={true}, 74_b=74_b(1.0)={true},
46_b=46_b(1.0)={true}, 188_i=188_i(1.0)={40}}]
org.apache.solr.common.SolrException: Invalid Date String:'[B@1266f55'
at org.apache.solr.schema.DateField.parseMath(DateField.java:163)
at
org.apache.solr.schema.TrieDateField.createField(TrieDateField.java:171)
at
org.apache.solr.schema.SchemaField.createField(SchemaField.java:94)
at
org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:246)
at
org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:60)
at
org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:75)
at
org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImportHandler.java:292)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:392)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
--------------------------------------------
and the dataimport.xml
-------------------------------------------
<dataConfig>
<script>
<![CDATA[
function attributesFunction(row) {
if(row.get('att_unit') != null &&
row.get('att_unit').equals('null') &&
row.get('att_unit').equals('Null')) {
row.put('attributes', row.get('att_name') + ' '
+ row.get('atr_value') +
row.get('att_unit'));
} else {
row.put('attributes', row.get('att_name') + ' '
+ row.get('atr_value'));
}
if (row.get('att_type').equals('int')) {
row.put(row.get('attribute_id') + '_i',
row.get('atr_value'));
} else if (row.get('att_type').equals('float')) {
row.put(row.get('attribute_id') + '_f',
row.get('atr_value'));
} else if (row.get('att_type').equals('string')) {
row.put(row.get('attribute_id') + '_s',
row.get('atr_value'));
} else if (row.get('att_type').equals('text')) {
row.put(row.get('attribute_id') + '_t',
row.get('atr_value'));
} else if (row.get('att_type').equals('datetime')) {
row.put(row.get('attribute_id') + '_dt',
row.get('atr_value'));
}
row.remove('attribute_id');
row.remove('att_name');
row.remove('att_unit');
row.remove('atr_value');
row.remove('att_type');
return row;
}
]]>
</script>
<dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/mydb" user="root" password=""/>
<document name="machines">
<entity name="machineIds" query="SELECT distinct(machine_id) as
machineId
FROM machines_published_for_clients mpc where mpc.mpc_status='active'">
<field column="machine_id" name="machineId" />
<entity name="machineData" query="SELECT m.mch_year_construction,
m.mch_offerer_status, m.mch_date_create, if(m.mch_location_zipcode_geoformat
is null, m.mch_location_zipcode, m.mch_location_zipcode_geoformat) as plz,
m.mch_location_city, m.country_isocode, m.mch_type_description,
m.manufacturer_id,m.mch_manufacturer_name, if (m.machine_type_id is null, 0
, m.machine_type_id) as type_id, calc_curr(m.mch_price_net,
m.currency_isocode, 'EUR') as mch_price_netto, calc_curr(
m.mch_price_net*(((select vat_rate from vat_rates_available vra where
vra.vat_rate_id = m.vat_rate_id)/100)+1), m.currency_isocode,'EUR') as
mch_price_brutto from machines m where
m.machine_id=${machineIds.machineId}">
....
<!-- Datetime -->
<entity name="attributesDateTime"
transformer="script:attributesFunction"
query="SELECT att.attribute_id, thl.thl_translation as att_name,
att.att_unit, if(av.atr_value = '0000-00-00 00:00:00', null , av.atr_value)
as atr_value, att.att_type FROM attribute_values_datetime av join
attributes att on att.attribute_id = av.attribute_id join texts t on
t.text_key=att.att_name join texts_has_languages thl on t.text_id =
thl.text_id where av.machine_id=${machineIds.machineId} and language_isocode
= 'de';" />
</entity>
....
</entity>
</document>
</dataConfig>
---------------------------
I want that all attributes get into the multivalued text field "attribute"
and for faceting they should got their own dynamic field. Has someone an
idea how to fix this problem?
Best Regards
Alexander
--
View this message in context:
http://lucene.472066.n3.nabble.com/Datetime-problems-with-dataimport-tp2545654p2545654.html
Sent from the Solr - User mailing list archive at Nabble.com.
