Leave feedback
  • Question

    Unable to query by metadata in PPQ

Enter a new topic
  • Coll Nicolson Coll Nicolson
    0 likes 2463 views

    When I run this which should hit every doc in the Doc Broker Plus:

    <?xml version="1.0" encoding="utf-8"?>
    <s-dbs action="process">
     <database>
      <docset metainfo="legacyCustomerID!='00'"/>
     </database>
    </s-dbs>

    I am getting this:

    0311 194235 (0048) 3 File outconnector: File /opt/streamserve/eomworkdirs/bigtest.ps created.
    0311 194320 (0506) 0 directoryscanner/1.0: /opt/streamserve/eomworkdirs/collbrokertest/*.ppq found:  /opt/streamserve/eomworkdirs/collbrokertest/legCust003001487_process_delete.ppq
    0311 194321 (4290) 0 StrsID completed successfully (StrsID):1411
    0311 194321 (1719) 2 JobBegin:directoryscanner=PPQ_IN
    0311 194321 (1155) 0 Beofre PPQ
    0311 194321 (1155) 0 idocstat
    0311 194321 (1155) 0 idocnum
    0311 194321 (1155) 0 legcustid
    0311 194321 (1726) 2 Collect Event:___DBEvent1___ < directoryscanner=PPQ_IN
    0311 194321 (5026) 3 Sender of job set to:
    0311 194321 (1730) 3 preproc message:___DBEvent1___ < directoryscanner=PPQ_IN
    0311 194321 (1731) 2 Doing message:___DBEvent1___ < directoryscanner=PPQ_IN
    0311 194321 (1739) 2   Process:DRPGen_TestFile_Default (v. 0) > TestFile(file=/opt/streamserve/eomworkdirs/bigtest.ps,No,true)
    0311 194321 (3689) 1 Post-processor reading meta-info. Port:TestFile
    0311 194321 (0077) 0 Cannot get filter clause. Job selection: , document selection: , document metadata selection: legacyCustomerID!='00'.
    0311 194321 (0016) 0 Cannot retrieve documents.
    0311 194321 (5139) 0 Cannot post-process documents job. Port: TestFile
    0311 194321 (1155) 0 After PPQ
    0311 194321 (1155) 0 idocstat
    0311 194321 (1155) 0 idocnum
    0311 194321 (1155) 0 legcustid
    0311 194321 (1723) 2 JobEnd:directoryscanner=PPQ_IN

    0311 194321 (0201) 1 Failed to process queue item 9E401AE4-BBFB-E9B1-E040-A8C05B890AE5

    I am following the filter clause syntax in the DocBorkerPlus documentation, with many attempted scenarios, but nothing.  I have pasted the App Domain Doc Types file below which shows the GlobalDocumentType that is used everywhere in the app.

    What am I missing?

     

    Thanks,

    Coll

     

    <?xml version="1.0" encoding="utf-8" ?>
    <strs xmlns="http://schemas.streamserve.com/designcenterresource/2.0" xmlns:xs="http://www.w3.org/2001/XMLSchema">
      <documentTypes xmlns="http://schemas.streamserve.com/documenttype/1.0">

    <documentType xmlns="http://schemas.streamserve.com/documenttype/1.0" xmlns:xs="http://www.w3.org/2001/XMLSchema" name="GlobalDocType" guid="2af43b39-bf52-4f7a-b7c7-73d3c704ede2" revision="3">
          <metadataTypes>
          </metadataTypes>
          <samples>
          </samples>
        <metadataGroup name="STATIC" guid="STATIC">
          <metadataTypes>
            <metadata   name="FixedMetaData.ExternalID" scope="BBC0626F-EE2C-47A9-BC02-D5CB4D15C438" type="xs:string" guid="7C52DDAF-0FA4-4845-88A1-4ECF8B63EABA" archived="true"     message="true" postprocess="true"/>
            <metadata   name="FixedMetaData.Receiver" scope="BBC0626F-EE2C-47A9-BC02-D5CB4D15C438" type="xs:string" guid="0526456B-2F9D-400F-B847-1C7E103B5AE3" archived="true"     message="false" postprocess="false"/>
            <metadata   name="FixedMetaData.Sender" scope="BBC0626F-EE2C-47A9-BC02-D5CB4D15C438" type="xs:string" guid="938CB835-58C1-4123-90D4-039172D7A325" archived="true"     message="false" postprocess="false"/>
            <metadata   name="BlobInfo.ContentType" scope="BBC0626F-EE2C-47A9-BC02-D5CB4D15C438" type="xs:string" guid="118EA52C-567E-4369-9AC3-2EF14A8AE0A5" archived="true"     message="false" postprocess="false"/>
            <metadata   name="BlobInfo.ExpiringDateTime" scope="BBC0626F-EE2C-47A9-BC02-D5CB4D15C438" type="xs:dateTime" guid="862BD02D-BB75-4125-BDCE-5377F9016895" archived="true"     message="false" postprocess="false"/>
            <metadata   name="BlobInfo.TotalBlobSize" scope="BBC0626F-EE2C-47A9-BC02-D5CB4D15C438" type="xs:double" guid="CFFA8C19-3C46-48E1-A029-37A14DD27B3A" archived="true"     message="false" postprocess="false"/>
            <metadata   name="Part.TrackerID" scope="BBC0626F-EE2C-47A9-BC02-D5CB4D15C438" type="xs:string" guid="0DB19BF7-9474-4785-A3DB-841A49F145D9" archived="true"     message="false" postprocess="true"/>
            <metadata   name="Part.ApplicationDomainID" scope="BBC0626F-EE2C-47A9-BC02-D5CB4D15C438" type="xs:string" guid="C86E986C-2BD7-42E9-80D3-612C0D08A422" archived="true"     message="false" postprocess="true"/>
          </metadataTypes>
          <samples>
          </samples>
          </metadataGroup>
        <metadataGroup name="GlobalDocMetadata" guid="623f9a3a-d081-4230-8a59-815daa7c8a3e">
          <metadataTypes>
            <metadata   name="customerID" scope="" type="xs:string" guid="6e9f030a-19a8-417e-b9e2-919546cd5990" archived="true"     message="true" postprocess="true"/>
            <metadata   name="legacyCustomerID" scope="" type="xs:string" guid="96ae9a05-6502-41c3-824a-48061ec2a61f" archived="true"     message="true" postprocess="true"/>
            <metadata   name="routingCode" scope="" type="xs:string" guid="762d6b6a-d054-4d55-bbf7-c74e5cbbf57a" archived="true"     message="true" postprocess="true"/>
            <metadata   name="deliveryDivisionNumber" scope="" type="xs:string" guid="4011a82b-b9ef-46ed-bb48-23888e2a0c51" archived="true"     message="true" postprocess="true"/>
            <metadata   name="otSapObject" scope="" type="xs:string" guid="e13928b6-e0d6-476d-b85f-a7b9ba1069a8" archived="true"     message="true" postprocess="true"/>
            <metadata   name="otObjectID" scope="" type="xs:string" guid="ee4368b8-1327-49b1-85ce-2181c137a78c" archived="true"     message="true" postprocess="true"/>
            <metadata   name="otARObject" scope="" type="xs:string" guid="ecea811b-7256-4340-ba09-868cea99eff5" archived="true"     message="true" postprocess="true"/>
            <metadata   name="otArchiveID" scope="" type="xs:string" guid="8b7eb2a4-55ff-40b7-9e45-0092aaf721ff" archived="true"     message="true" postprocess="true"/>
            <metadata   name="otDocClass" scope="" type="xs:string" guid="d4402227-ae03-4c35-b6f7-337aa4fd543d" archived="true"     message="true" postprocess="true"/>
            <metadata   name="emailAddressList" scope="" type="xs:string" guid="9d2d14b9-58b6-4bea-96d7-aba8eeea7feb" archived="true"     message="true" postprocess="true"/>
            <metadata   name="faxNumberList" scope="" type="xs:string" guid="b4c6e93b-c81f-4eb5-b585-6eb3d1e64f45" archived="true"     message="true" postprocess="true"/>
            <metadata   name="docStatus" scope="" type="xs:string" guid="e907a205-efaf-4d24-bcf6-54d392eb8fad" archived="true"     message="true" postprocess="true"/>
          </metadataTypes>
          <samples>
          </samples>
          </metadataGroup>
        </documentType>
      </documentTypes>
    </strs>

    Saturday 12 March, 2011
  • Jose Silva Jose Silva
    0 likes

    I have identical problem, but no solution yet.

    Thursday 24 March, 2011
  • Anders Henriksson Anders Henriksson StreamServe Employee
    0 likes

    Have you tried <docset metainfo="legacyCustomerID!=00"/> i.e. 00 without single quotes? 

    Thursday 24 March, 2011
  • Daniel Grindelid Daniel Grindelid
    0 likes

    I also have this problem. And I think I have tried nearly every combination of quoting, using <jobset sel="all"> and <docset sel="all"> in several combinations. But the result is the same: Cannot get filter clause...

     

     

    Friday 10 June, 2011
  • Benjamin Baker Benjamin Baker StreamServe Employee
    0 likes

    Have you tried changing the metadata type legacyCustomerID from string to numeric in the document type?

    Friday 10 June, 2011

 

Latest from the blogs