‘Cannot import data due to invalid table filter definition…’ – NiceLabel Cloud API Error Message
Target Audience: Basic User, Advanced User, IT Manager
Article #: 11124
Summary
An incident occurred that caused NiceLabel to generate the error message “Cannot import data due to invalid table filter definition…” This article will describe the conditions under which it occurred as well as the solution to resolve the issue.
The error occurred with the following setup for a NiceLabel solution (combination of label and form):
- Contains the label to be printed.
- Uses the database (MS SQL) residing in the NiceLabel Cloud. The filter on the database included the use of the “LIKE” condition.
- In first print window, NiceLabel uses the Database Table to present the user with a selection of records from a table in the database. The user selects one record from the table and the program. The solution will then switch to 2nd print window.
- The second print window will load another Database Table with the record selected from the first print window using Select Table Row with ‘row number’. It uses Events during the form load. The error occurred at this step.
Explanation
At present, the exact cause for this error is unknown. It is speculated that it has to do with the fact that the database is opened for Read-Write even though NiceLabel solution does not have any operation that updates the database. As more is discovered, this article will be updated.
Solution
The workaround for this error is to set the Database Table on the second Print Window to “Read-Only”. The “Cannot import data…” error message did not recur after that.
If you need further assistance, please contact us.