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):
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:
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:
Or on the document type's General tab in DAT:
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":
Once you have configured these two variables, you can click "Run" and your documents should start to reshred.