DBXL Migration Tool - Handling errors with the GetListItems Method on Reshred All - Hilary Stoupa
in

InfoPath Dev

Hilary Stoupa

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.

Comments

No Comments

About Hilary Stoupa

I wandered into development after working as a business process analyst for a global manufacturing company. I create InfoPath solutions for our clients as well as work as a developer on company tools that extend InfoPath. I've also been instrumental in creating the InfoPath Master Class training provided by Qdabra.

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