Can you post the part of schema.xml where the fields are defined.
The error seems to be an incompatibility between your schema and what your
are trying to import.
By the way, I think you should have further informations for this error on
your log.
Best,
Sébastien
Le sam. 15 déc. 2018 à 05:51, Alexis Aravena Silva <aarav...@itsofteg.com>
a écrit :
> Ok.
>
>
> My dih.xml is this:
>
>
> <dataConfig> <dataSource type="JdbcDataSource"
> driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> url="jdbc:sqlserver://DESKTOP-AD46GSU\SQL2017;databaseName=sila"
> user="user" password="password"/> <document> <entity name="laboratorio"
> pk="idLaboratorio" query="select top 1 idLaboratorio, nombre, razonSocial,
> rut from laboratorio"> <field column="idLaboratorio" name="idLaboratorio"/>
> </entity> </document> </dataConfig>
>
>
> This is the response when I execute the data import in debug mode (is ok):
>
>
> {
> "responseHeader": {
> "status": 0,
> "QTime": 86
> },
> "initArgs": [
> "defaults",
> [
> "config",
> "dihconfig.xml"
> ]
> ],
> "command": "full-import",
> "mode": "debug",
> "documents": [
> {
> "rut": [
> "61.601.000-k"
> ],
> "idLaboratorio": [
> 1
> ],
> "razonSocial": [
> "Subsecretaría de Salud Pública"
> ],
> "nombre": [
> "Laboratorio Ambiental de la SEREMI de Salud de Antofagasta"
> ]
> }
> ],
> "verbose-output": [],
> "status": "idle",
> "importResponse": "",
> "statusMessages": {
> "Total Requests made to DataSource": "1",
> "Total Rows Fetched": "1",
> "Total Documents Processed": "0",
> "Total Documents Skipped": "0",
> "Full Dump Started": "2018-12-15 04:46:50",
> "Total Documents Failed": "1",
> "Time taken": "0:0:0.34"
> }
> }
>
>
> But Solr does not create the document and the log shows:
>
> Error creating document : SolrInputDocument(fields:
> [rut=61.601.000-k,​ idLaboratorio=1,​ razonSocial=Subsecretaría
> de Salud Pública,​ nombre=Laboratorio Ambiental de la SEREMI de Salud
> de Antofagasta])
>
> ________________________________
> From: Erick Erickson <erickerick...@gmail.com>
> Sent: Saturday, December 15, 2018 12:38:12 AM
> To: solr-user
> Subject: Re: Error at import data from SQL Server 2017 (Solr 7.5.0)
>
> Images and the like are aggressively stripped by the e-mail server,
> so there's no error information in your post.
>
> Exactly _how_ are you importing? Data Import Handler? If so, please
> show your config as well.
>
> Best,
> Erick
>
> On Fri, Dec 14, 2018 at 4:19 PM Alexis Aravena Silva
> <aarav...@itsofteg.com> wrote:
> >
> > Hello,
> >
> >
> > I'am using Solr 7.5 and I have the following error at import data from
> SQL Server:
> >
> >
> >
> >
> > The message doesn't say anything else, that's why, I don't know what is
> wrong, could you help me with this please.
> >
> >
> > Note: I assigned write access for everyone group but nothing happens.
> >
> >
> > Regards,
> > Alexis Aravena S.
> >
> >
> >
>
