manifoldcf-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald Van den Driessche (JIRA)" <>
Subject [jira] [Created] (CONNECTORS-1579) Error when crawling a MSSQL table
Date Tue, 05 Feb 2019 13:33:00 GMT
Donald Van den Driessche created CONNECTORS-1579:

             Summary: Error when crawling a MSSQL table
                 Key: CONNECTORS-1579
             Project: ManifoldCF
          Issue Type: Bug
          Components: JDBC connector
    Affects Versions: ManifoldCF 2.12
            Reporter: Donald Van den Driessche
         Attachments: 636_bb2.csv

When I'm crawling a MSSQL table through the JDBC connector I get following error on multiple

FATAL 2019-02-05T13:21:58,929 (Worker thread '40') - Error tossed: Multiple document primary
component dispositions not allowed: document '636'

java.lang.IllegalStateException: Multiple document primary component dispositions not allowed:
document '636'

at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.checkMultipleDispositions(

at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.noDocument(

at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.noDocument(

at org.apache.manifoldcf.crawler.connectors.jdbc.JDBCConnector.processDocuments(

at [mcf-pull-agent.jar:?]{noformat}
I looked this error up on the internet and it said that it might have something to do with
using the same key for different lines.
I checked, but I couldn't find any duplicates that match any of the selected fields in the

Hereby my queries:
Seeding query
FROM dbo.bb2
WHERE search_url IS NOT NULL
AND mimetype IS NOT NULL AND mimetype NOT IN ('unknown/unknown', 'application/xml', 'application/zip');
Version check query: none
Access token query: none
Data query: 


pk1 AS $(IDCOLUMN), 
search_url AS $(URLCOLUMN), 
ISNULL(content, '') AS $(DATACOLUMN),
search_url AS url, 
ISNULL(title, '') as title, 
ISNULL(groups,'') as groups, 
ISNULL(type,'') as document_type, 
ISNULL(users, '') as users
FROM dbo.bb2

The hereby added csv is the corresponding line from the table.


Could you help me understand this error?



This message was sent by Atlassian JIRA

View raw message