Hi, I get the following log from the Fossology copyright agent, which fails to find all copyright notices: --- 2019-10-02 14:46:47 copyright [0] :: JOB[1821].copyright[1163.localhost]: "ERROR: ERROR: column "ct_pk" does not exist" 2019-10-02 14:46:47 copyright [0] :: JOB[1821].copyright[1163.localhost]: "LINE 1: ...k = 12) inner join pfile on (PF = pfile_pk) WHERE ct_pk IS n..." 2019-10-02 14:46:47 copyright [0] :: JOB[1821].copyright[1163.localhost]: " ^" 2019-10-02 14:46:47 copyright [0] :: JOB[1821].copyright[1163.localhost]: "On: SELECT pfile_pk FROM ( SELECT distinct(pfile_fk) AS PF FROM uploadtree_a WHERE upload_fk = 213 and (ufile_mode&x'3C000000'::int)=0 ) AS SS left outer join copyright on (PF = pfile_fk and agent_fk = 12) inner join pfile on (PF = pfile_pk) WHERE ct_pk IS null or agent_fk <> 12" ---
I had a similar error in 3.5.0 and recently updated to 3.6.0. Since the error persisted, I decided to ask for help from the list. The problem seems to repeat across uploads. The agent seems to process copyright notices partially, but clearly leaves quite a bit unprocessed. I'm running Fossology on Debian 8. I collected the logs from the output in the web UI/Show Jobs/copyright/log. Appreciate any help. Best Martin Martin von Willebrand, Attorney-at-law, Partner HH Partners, Attorneys-at-law Ltd Bulevardi 7, 5th floor P.O. Box 232, 00101 Helsinki, Finland Tel: +358 9 177 613, Fax: +358 9 653 873 GSM: +358 40 770 1818 martin.vonwillebr...@hhpartners.fi<mailto:martin.vonwillebr...@hhpartners.fi> www.twitter.com/mvonwi<http://www.twitter.com/mvonwi> www.hhpartners.fi<http://www.hhpartners.fi/> Validos ry, Chairman, www.validos.org<http://www.validos.org/> HH Partners shines in international rankings. See details at hhpartners.fi.<https://www.hhpartners.fi/en/law-firm-rankings/> ________________________________ Privileged and confidential information may be contained in this message. If you are not addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, kindly notify us by reply e-mail and delete this message immediately. Thank you. -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#3304): https://lists.fossology.org/g/fossology/message/3304 Mute This Topic: https://lists.fossology.org/mt/34369588/21656 Group Owner: fossology+ow...@lists.fossology.org Unsubscribe: https://lists.fossology.org/g/fossology/unsub [arch...@mail-archive.com] -=-=-=-=-=-=-=-=-=-=-=-