From dev-return-19176-archive-asf-public=cust-asf.ponee.io@manifoldcf.apache.org Tue Feb 5 13:33:05 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id C51E118067A for ; Tue, 5 Feb 2019 14:33:04 +0100 (CET) Received: (qmail 74997 invoked by uid 500); 5 Feb 2019 13:33:03 -0000 Mailing-List: contact dev-help@manifoldcf.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@manifoldcf.apache.org Delivered-To: mailing list dev@manifoldcf.apache.org Received: (qmail 74985 invoked by uid 99); 5 Feb 2019 13:33:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2019 13:33:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 22CE81846D6 for ; Tue, 5 Feb 2019 13:33:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -110.301 X-Spam-Level: X-Spam-Status: No, score=-110.301 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id zFFx8xH3Rlua for ; Tue, 5 Feb 2019 13:33:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 43A655FE3C for ; Tue, 5 Feb 2019 13:33:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id C5383E26F2 for ; Tue, 5 Feb 2019 13:33:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 45DE52441A for ; Tue, 5 Feb 2019 13:33:00 +0000 (UTC) Date: Tue, 5 Feb 2019 13:33:00 +0000 (UTC) From: "Donald Van den Driessche (JIRA)" To: dev@manifoldcf.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (CONNECTORS-1579) Error when crawling a MSSQL table MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Donald Van den Driessche created CONNECTORS-1579: ---------------------------------------------------- Summary: Error when crawling a MSSQL table Key: CONNECTORS-1579 URL: https://issues.apache.org/jira/browse/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 lines: =C2=A0 {noformat} 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 dispos= itions not allowed: document '636' at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.checkM= ultipleDispositions(WorkerThread.java:2125) ~[mcf-pull-agent.jar:?] at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.noDocu= ment(WorkerThread.java:1624) ~[mcf-pull-agent.jar:?] at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.noDocu= ment(WorkerThread.java:1605) ~[mcf-pull-agent.jar:?] at org.apache.manifoldcf.crawler.connectors.jdbc.JDBCConnector.processDocum= ents(JDBCConnector.java:944) ~[?:?] at org.apache.manifoldcf.crawler.system.WorkerThread.run(WorkerThread.java:= 399) [mcf-pull-agent.jar:?]{noformat} I looked this error up on the internet and it said that it might have somet= hing to do with using the same key for different lines. I checked, but I couldn't find any duplicates that match any of the selecte= d fields in the JDBC. Hereby my queries: Seeding query {code:java} SELECT pk1 as $(IDCOLUMN) FROM dbo.bb2 WHERE search_url IS NOT NULL AND mimetype IS NOT NULL AND mimetype NOT IN ('unknown/unknown', 'applicati= on/xml', 'application/zip'); {code} Version check query: none Access token query: none Data query:=C2=A0 =C2=A0 =C2=A0 {code:java} SELECT=20 pk1 AS $(IDCOLUMN),=20 search_url AS $(URLCOLUMN),=20 ISNULL(content, '') AS $(DATACOLUMN), doc_id,=20 search_url AS url,=20 ISNULL(title, '') as title,=20 ISNULL(groups,'') as groups,=20 ISNULL(type,'') as document_type,=20 ISNULL(users, '') as users FROM dbo.bb2 WHERE pk1 IN $(IDLIST); {code} The hereby added csv is the corresponding line from the table. [^636_bb2.csv] Could you help me understand this error? =C2=A0 =C2=A0 -- This message was sent by Atlassian JIRA (v7.6.3#76005)