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]
-=-=-=-=-=-=-=-=-=-=-=-
