What is "​" in the PublicId? Is it part of the data? Did you check if
the special characters in your data cause the problem?
Steve
###########
Error creating document : SolrInputDocument(fields: [PublicId=10065,​
Id=117])
-----Original Message-----
From: Verthosa <geertver...@gmail.com>
Sent: Friday, November 9, 2018 7:51 AM
To: solr-user@lucene.apache.org
Subject: Sql server data import
Hello, i managed to set up a connection to my sql server to import data into
Solr. The idea is to import filetables but for now i first want to get it
working using regular tables. So i created
*data-config.xml*
<dataConfig>
<dataSource type="JdbcDataSource"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost;databaseName=inConnexion_Tenant2;integratedSecurity=true"
/>
<document>
<entity name="Dashboard" pk="id" query="SELECT Id,PublicId FROM
foundation.Shops">
<field column="Id" name="Id"/>
<field column="PublicId" name="PublicId" />
</entity>
</document>
</dataConfig>
*schema.xml*
i added
<field name="Id" type="string" indexed="true" stored="true" required="true"
multiValued="false" />
<field name="PublicId" type="string" indexed="true" stored="true"
multiValued="false"/>
and changed uniqueKey entry to
<uniqueKey>Id</uniqueKey>
When i want to import my data (which is just data like Id: 5, PublicId:
"test"), i get the following error in the logging.
Error creating document : SolrInputDocument(fields: [PublicId=10065,​
Id=117])
I tried all sorts of things but can't get it fixed. Is anyone want to give me a
hand?
thanks in advance!
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
