B@1266f55
It looks like you are using MySQL.
The data field needs to be in yyyy-MM-dd'T'hh:mm:ss format.
I would probably concert datetime in Mysql to varchar() in this format.
On 2/21/11 8:40 AM, "MOuli" <zar...@hotmail.de> wrote:
>
>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(RunUpdatePr
>ocessorFactory.java:60)
> at
>org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:75)
> at
>org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImportHa
>ndler.java:292)
> at
>org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.jav
>a:392)
> at
>org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:2
>42)
> 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:3
>89)
> at
>org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:37
>0)
>
>--------------------------------------------
>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-tp254
>5654p2545654.html
>Sent from the Solr - User mailing list archive at Nabble.com.
