You can successfully run a business adapter data import but have rejected records that aren't imported to the FlexNet Manager Suite database. When this occurs, you will see the message, Null or empty value was found in criteria field [Column Name], where [Column Name] is the column's name from the source table.
This error is visible in Business Adapter Studio in View > History if Business Adapter Studio is connected to the database and your data is imported directly.
If you are importing from the beacon, you can see the error in the System Menu > System Health > System Tasks.
Then select the rejection message link in the Summary column.
Values in columns marked as Use this property for matching existing data are required. To resolve this issue, populate the source table for all cells within the column.
To resolve this, you can do one of the following options:
a. Delete the rows that no longer contain any data, or
b. Copy only the cells that contain data, or
c. Create a new Excel file with only cells that contain data
on
Feb 09, 2023
12:50 PM
- edited on
Mar 29, 2023
10:58 AM
by
HollyM