Re: Error at import data from SQL Server 2017 (Solr 7.5.0)

[Alexis Aravena Silva]

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,&#8203; 
idLaboratorio=1,&#8203; razonSocial=Subsecretaría de Salud Pública,&#8203; 
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.
>
>
>