September 2022 - Posts - Hilary Stoupa
in

InfoPath Dev

Hilary Stoupa

September 2022 - Posts

  • DBXL Migration Tool - Handling errors with the GetListItems Method on Reshred All

    The DBXL Migration Tool uses the DBXL Document Service GetListItems method to return a list of documents when performing some actions, like Reshred All Documents (resave the XML data to the SQL database):
    DBXL Migration Tool, Reshred All

    Sometimes, the GetListItems method returns an error which will block you from being able to reshred all the documents for the document type.

    You might see an error in the Qdabra Event Log that looks like this:

    GetListItems encountered a critical error and needs attention:

    User: domain\username
    Url: /QdabraWebService/DbxlDocumentService.asmx
    System.Threading.ThreadAbortException: Thread was being aborted.
       at Qdabra.Dbxl.Implementation.ServiceImplementation.GetFieldValue(Document doc, String field)
       at Qdabra.Dbxl.Implementation.ServiceImplementation.AddRow(ListResults table, Document doc)
       at Qdabra.Dbxl.Implementation.ServiceImplementation.GetListItems(String docTypeName, String viewName, XmlNode query, XmlNode viewFields, String rowLimit, XmlNode queryOptions, StatusInfo& info, Boolean onlyDocumentLevelAccess, String logonUser)

    The stack trace was:    at Qdabra.Dbxl.Implementation.ServiceImplementation.GetFieldValue(Document doc, String field)
       at Qdabra.Dbxl.Implementation.ServiceImplementation.AddRow(ListResults table, Document doc)
       at Qdabra.Dbxl.Implementation.ServiceImplementation.GetListItems(String docTypeName, String viewName, XmlNode query, XmlNode viewFields, String rowLimit, XmlNode queryOptions, StatusInfo& info, Boolean onlyDocumentLevelAccess, String logonUser).

    The Migration Tool may become unresponsive after logging just one line:
    Executing action ListDomainsā€¦

    Instead of using the Reshred All Documents option on the Other Operations tab, you can use a scenario on the Custom tab:
    DBXL Migration Tool, Custom Scenario Tab 1

    Select the "ReshredDocuments.xml" scenario from the Scenario path dropdown. Click the "Load" button, then under the "Scenario runs" column on the left side, select "ReshredDocuments".

    For the docType variable, you need to enter the numeric ID for the document type. You can find that in the document type URL:
    DAT Doc Type URL

    Or on the document type's General tab in DAT:
    DAT, Document Type General Tab
    In the screenshot above, the ID for my document type is "70" as seen in the Form Template Properties section.

    The "listDocumentsMethod" variable needs to be changed from "getlistitems" to "db":
    DBXL Migration Tool, Custom Scenario 2

    Once you have configured these two variables, you can click "Run" and your documents should start to reshred.

Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.