Form Migrator Desktop troubleshooting

Troubleshoot common issues with the Desktop Form Migration tool

If you are getting an error when using the Lightning Tools Form Migrator Desktop application, here are some ideas that may help in troubleshooting. If these ideas don't help, please contact our Customer Success (technical support) team at help@lightningtools.com. It will help us troubleshoot if you can please include a screenshot of the error in context, and an Application Log (see below for how to get that).

View Application Log

Before viewing the Application Log for troubleshooting an error, it will help to change the default logging level (under the Edit menu) to Debug.

You can then view the log text file under the Help menu:

This will open a txt file in your text editor (e.g. Notepad), which you can save from there, if you wish. You may be able to determine the issue by reviewing the log yourself, but if not, please submit it to our team as described above.

Troubleshooting

Issues when reading forms

Complexity Score of NC

Scenario: After analyzing forms in your workspace, you have one or more forms with a Complexity Score of NC. If you click the Info icon next to Complexity, you’ll see a brief description of what may cause a form to receive a Complexity Score of NC. It’s likely an unsupported form type (or format) or corrupt.   Some source file formats are XML (for example, Nintex for SharePoint) or JSON-based, so if you add files from a folder on your file system you may end up pulling in files that appear to be a supported format, but when read by Kudzu they are not recognized.

The Source Connection referenced by the selected form no longer exists

This message indicates that the connection used to discover the form has been deleted. You may have created a connection to site X, discovered forms in that site, and then deleted the connection. You can create a new connection by selecting Connections from the Edit menu. The connection manager will display and you can re-add the previously used connection, click Convert, dismiss the "the source connection..." message, and select the newly created connection from the Source Connection dropdown. 

Issues when writing forms

Total size of the columns in this list exceeds the limit

Scenario: You receive “The column cannot be added because the total size of the columns in this list exceeds the limit. Please delete some other columns first” while creating a new SharePoint list that indicates that the list could not be created. SharePoint limits the size of a list item and you’re trying to create a list, likely from an InfoPath form that was deployed to a Form Library, that has too many columns in amount or type. You will need to refactor the form pre-conversion or convert this form manually.
Please refer to the following Microsoft article for more information on SharePoint List column boundaries: Software boundaries and limits for SharePoint 2013 - SharePoint Server | Microsoft Learn 

Exceeds the lookup column threshold

Scenario: You receive “The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold” when accessing a newly-created list the first time. This is again likely related to an InfoPath form that was published to a Form Library that contains more than 12 Lookup type columns.  Go to the List Settings and change the default view (or create a new one) and include fewer Lookup type columns in the view.  Lookup type columns include not only the Lookup column type, but also Person or Group, and Managed Metadata.

The Destination Connection referenced by the selected form no longer exists

Please see the similar message in the “Issues when reading forms” section above.

Was this article helpful?

Can’t find what you’re looking for?

Our world-class Customer Success team is here for you.

Contact Support