On 06.02.14 14:46, Karl Wright wrote:
You want to put this in properties.xml:
<property name="org.apache.manifoldcf.db" value="DEBUG"/>
Thanks.
This is a simplified query, the one which is generated by only selecting
the document ingest activity. No results from pgAdmin:
SELECT id AS id,activitytype AS activity,starttime AS
starttime,(endtime-starttime) AS elapsedtime,resultcode AS
resultcode,resultdesc AS resultdesc,datasize AS bytes,entityid AS
identifier FROM repohistory WHERE owner='Web' AND activitytype
IN('document ingest (Solr)') AND starttime>1391691978799 ORDER BY
starttime DESC,id DESC LIMIT 21
I changed the query to the follwing, but still no results:
SELECT id AS id,activitytype AS activity,starttime AS
starttime,(endtime-starttime) AS elapsedtime,resultcode AS
resultcode,resultdesc AS resultdesc,datasize AS bytes,entityid AS
identifier FROM repohistory WHERE owner='Web' AND activitytype like
lower('%Solr%') AND starttime>1391691978799 ORDER BY starttime DESC,id
DESC LIMIT 21
Here you can see all the records without filtering:
SELECT * FROM repohistory WHERE owner='Web' AND starttime>1391691978799
ORDER BY starttime DESC,id DESC LIMIT 21:
===>
21451;1391696150567;1391696110456;1391696069204;"http://www.ibsen.uio.no/brevmottakere.xhtml?bokstav=U";"Web";"fetch";"200";"";
23521;1391696171301;1391696152500;1391696037774;"http://www.ibsen.uio.no/brevmottakere.xhtml?bokstav=O";"Web";"fetch";"200";"";
25106;1391696152607;1391696152549;1391696028769;"http://www.ibsen.uio.no/brevmottakere.xhtml?bokstav=E";"Web";"fetch";"200";"";
19611;1391696022219;1391696011288;1391695908824;"http://www.ibsen.uio.no/brevmottakere.xhtml?bokstav=Y";"Web";"fetch";"200";"";
22560;1391696079440;1391696032220;1391695860158;"http://www.ibsen.uio.no/brevmottakere.xhtml?bokstav=I";"Web";"fetch";"200";"";
46622;1391696133425;1391696110491;1391695857156;"http://www.ibsen.uio.no/brevmottakere.xhtml?bokstav=L";"Web";"fetch";"200";"";
12955;1391695998071;1391695946382;1391695835524;"http://www.ibsen.uio.no/sakprosainnledninger.xhtml";"Web";"fetch";"200";"";
18520;1391696106010;1391696079479;1391695832522;"http://www.ibsen.uio.no/omhis.xhtml";"Web";"fetch";"200";"";
24575;1391696028767;1391696011261;1391695829521;"http://www.ibsen.uio.no/sakprosakronologi.xhtml";"Web";"fetch";"200";"";
10984;1391696028766;1391696011263;1391695826519;"http://www.ibsen.uio.no/tidslinje.xhtml";"Web";"fetch";"200";"";
19612;1391696246952;1391696191497;1391695823518;"http://www.ibsen.uio.no/brevmottakere.xhtml?bokstav=AE";"Web";"fetch";"200";"";
36785;1391696087593;1391696079534;1391695817514;"http://www.ibsen.uio.no/brevmottakere.xhtml?bokstav=P";"Web";"fetch";"200";"";
12863;1391695908818;1391695902124;1391695814513;"http://www.ibsen.uio.no/variasjangre.xhtml";"Web";"fetch";"200";"";
17979;1391696157502;1391696152529;1391695808509;"http://www.ibsen.uio.no/medarbeideroversikt.xhtml";"Web";"fetch";"200";"";
39381;1391696044353;1391696032298;1391695802506;"http://www.ibsen.uio.no/brevmottakere.xhtml?bokstav=K";"Web";"fetch";"200";"";
11154;1391696238768;1391696191522;1391695799504;"http://www.ibsen.uio.no/kontakt.xhtml";"Web";"fetch";"200";"";
31284;1391695857150;1391695852029;1391695793499;"http://www.ibsen.uio.no/errata.xhtml";"Web";"fetch";"200";"";
11230;1391696028766;1391696011262;1391695787497;"http://www.ibsen.uio.no/variainnledninger.xhtml";"Web";"fetch";"200";"";
11227;1391696028765;1391696011264;1391695784495;"http://www.ibsen.uio.no/diktsamlinger.xhtml";"Web";"fetch";"200";"";
12726;1391695929276;1391695902084;1391695781493;"http://www.ibsen.uio.no/diktinnledninger.xhtml";"Web";"fetch";"200";"";
11424;1391695939675;1391695902057;1391695775488;"http://www.ibsen.uio.no/sakprosasjangre.xhtml";"Web";"fetch";"200";"";
