Hi,
i have a big problem. Solr doesn't index and i have following error:
org.apache.solr.common.SolrException: Document is missing mandatory
uniqueKey field: ID
here my files:
<dataConfig>
<dataSource name="myvialtis" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/myvialtis" user="postgres"
password="postgres" readOnly="true" autoCommit="false"
batchSize="100000"
transactionIsolation="TRANSACTION_READ_COMMITTED"
holdability="CLOSE_CURSORS_AT_COMMIT" />
<document>
<entity rootEntity="true" name="tiers" dataSource="myvialtis"
query="select * from bi_solr_tiers"
transformer="RegexTransformer">
<field name="ID" column="tiers_id" />
<field name="DOC_TYPE" column="tiers_doc_type" />
<field name="ID_CLIENT" column="tiers_id_client" />
<field name="NOM_CLIENT" column="tiers_nom_client" />
<field name="ID_PARENT" column="tiers_id_parent"
splitBy="," />
<field name="ID_PAYS_CLIENT"
column="tiers_id_pays_client" />
<field name="ID_SEGMENT" column="tiers_id_segment" />
<field name="ID_SALE" column="tiers_id_sale" />
<field name="NOM_SALE" column="tiers_nom_sale" />
<field name="U_ID_CLIENT" column="tiers_id_client" />
<field name="U_NOM_CLIENT" column="tiers_nom_client" />
<field name="U_ID_PARENT" column="tiers_id_parent"
splitBy="," />
<field name="U_ID_PAYS_CLIENT"
column="tiers_id_pays_client" />
<field name="U_ID_SEGMENT" column="tiers_id_segment" />
<field name="U_ID_SALE" column="tiers_id_sale" />
<field name="U_NOM_SALE" column="tiers_nom_sale" />
<entity name="tiers_contrat" dataSource="myvialtis"
cacheKey="contrat_id_client"
cacheLookup="tiers.tiers_id_client"
processor="CachedSqlEntityProcessor"
query="select * from bi_solr_contrat">
<field name="ID_PARTENAIRE"
column="contrat_id_partenaire" />
<field name="NOM_PARTENAIRE"
column="contrat_nom_partenaire" />
<field name="TYPE_PARTENAIRE"
column="contrat_type_partenaire" />
<field name="ID_TYPE_SERVICE"
column="contrat_id_type_service" />
<field name="ID_FILIALE"
column="contrat_id_filiale" />
<field name="NOM_FILIALE"
column="contrat_nom_filiale" />
<field name="COMPTE_WEB_POSSIBLE"
column="contrat_compte_web_possible"
/>
<field name="ID_CONTRAT"
column="contrat_id_contrat" />
<field name="ID_STATUT_CONTRAT"
column="contrat_id_statut_contrat" />
<field name="NOM_PRODUIT"
column="contrat_nom_produit" />
<field name="ID_BENEFICIAIRE_CONSO"
column="contrat_id_beneficiaire_conso" />
<field name="ID_BENEFICIAIRE_HONO"
column="contrat_id_beneficiaire_hono"
/>
<field name="ID_PAYEUR_CONSO"
column="contrat_id_payeur_conso" />
<field name="ID_PAYEUR_HONO"
column="contrat_id_payeur_hono" />
<field name="REF_CONTRAT_TVA"
column="contrat_ref_contrat_tva" />
<field name="PAYS_DEPOT_TVA"
column="contrat_pays_depot_tva" />
</entity>
<entity name="tiers_carte" dataSource="myvialtis"
query="select
carte_id_client,
carte_id_carte,
carte_num_carte,
carte_carte_active,
carte_immatriculation,
carte_nom_flotte
from bi_solr_carte"
cacheKey="carte_id_client"
cacheLookup="tiers.tiers_id_client"
processor="CachedSqlEntityProcessor">
<field name="ID_CARTE" column="carte_id_carte"
/>
<field name="NUM_CARTE"
column="carte_num_carte" />
<field name="CARTE_ACTIVE"
column="carte_carte_active" />
<field name="IMMATRICULATION"
column="carte_immatriculation" />
<field name="NOM_FLOTTE"
column="carte_nom_flotte" />
</entity>
<entity name="tiers_invoice" dataSource="myvialtis"
cacheKey="contrat_id_client"
cacheLookup="tiers.tiers_id_client"
processor="CachedSqlEntityProcessor"
query="select
distinct bi_solr_invoice.*,
bi_solr_contrat.contrat_id_client
from bi_solr_invoice
inner join bi_solr_invoice_cnt
on
bi_solr_invoice.invoice_numero_facture=bi_solr_invoice_cnt.numero_facture
inner join bi_solr_contrat on
bi_solr_contrat.contrat_id_contrat=bi_solr_invoice_cnt.id_contrat
where
bi_solr_invoice.invoice_date_emission + interval '6 months' >
date_trunc('day',current_date)">
<field name="NUMERO_FACTURE"
column="invoice_numero_facture" />
<field name="ID_BENEFICIAIRE"
column="invoice_id_beneficiaire" />
<field name="ID_PAYEUR"
column="invoice_id_payeur" />
<field name="DATE_EMISSION"
column="invoice_date_emission" />
<field name="DATE_EMISSION_DD_MM_YYYY"
column="invoice_date_emission_dd_mm_yyyy" />
<field name="DATE_EMISSION_MM_YYYY"
column="invoice_date_emission_mm_yyyy" />
<field name="DATE_EMISSION_YYYY"
column="invoice_date_emission_yyyy" />
<field name="DEVISE" column="invoice_devise" />
<field name="INVOICE_TOTAL_HT"
column="invoice_total_ht" />
<field name="INVOICE_TOTAL_TVA"
column="invoice_total_tva" />
<field name="INVOICE_TOTAL_TTC"
column="invoice_total_ttc" />
</entity>
<entity name="tiers_conso" dataSource="myvialtis"
cacheKey="conso_id_client"
cacheLookup="tiers.tiers_id_client"
processor="CachedSqlEntityProcessor"
query="select
conso_id_client,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where
conso_id_client is not null
and (conso_type_transaction is
null or conso_type_transaction !=
'1')">
<field name="NUM_CARTE"
column="conso_numero_carte" />
<field name="IMMATRICULATION"
column="conso_immatriculation" />
<field name="NOM_FLOTTE"
column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso"
/>
<field name="NOM_GARE_ORIGINE"
column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE"
column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE"
column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE"
column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE"
column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE"
column="conso_sca_sortie" />
<field name="STATUT_CONSO"
column="conso_statut" />
</entity>
<entity name="tiers_conso_remise" dataSource="myvialtis"
cacheKey="conso_id_client"
cacheLookup="tiers.tiers_id_client"
processor="CachedSqlEntityProcessor"
query="select
conso_id_client,
conso_numero_carte,
conso_immatriculation,
conso_nom_flotte,
conso_id_conso,
conso_gare_entree,
conso_gare_sortie,
conso_autoroute_entree,
conso_autoroute_sortie,
conso_sca_entree,
conso_sca_sortie,
conso_statut
from bi_solr_transaction where
conso_id_client is not null
and conso_type_transaction !=
'3'">
<field name="NUM_CARTE"
column="conso_numero_carte" />
<field name="IMMATRICULATION"
column="conso_immatriculation" />
<field name="NOM_FLOTTE"
column="conso_nom_flotte" />
<field name="ID_CONSO" column="conso_id_conso"
/>
<field name="NOM_GARE_ORIGINE"
column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE"
column="conso_gare_sortie" />
<field name="NOM_AUTO_ORIGINE"
column="conso_autoroute_entre" />
<field name="NOM_AUTO_CIBLE"
column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE"
column="conso_sca_entree" />
<field name="NOM_SCA_CIBLE"
column="conso_sca_sortie" />
<field name="STATUT_CONSO"
column="conso_statut" />
</entity>
<entity name="tiers_remise" dataSource="myvialtis"
cacheKey="remise_id_client"
cacheLookup="tiers.tiers_id_client"
processor="CachedSqlEntityProcessor"
query="select
remise_id_client,
remise_numero_carte,
remise_immatriculation,
remise_nom_flotte,
remise_id_remise,
remise_sca_entree
from bi_solr_remise where
remise_id_client is not null">
<field name="NUM_CARTE"
column="remise_numero_carte" />
<field name="IMMATRICULATION"
column="remise_immatriculation" />
<field name="NOM_FLOTTE"
column="remise_nom_flotte" />
<field name="ID_REMISE"
column="remise_id_remise" />
<field name="NOM_SCA_ORIGINE"
column="remise_sca_entree" />
</entity>
</entity>
</document>
</dataConfig>
please help me
--
View this message in context:
http://lucene.472066.n3.nabble.com/org-apache-solr-common-SolrException-Document-is-missing-mandatory-uniqueKey-field-id-tp4237067.html
Sent from the Solr - User mailing list archive at Nabble.com.
