If there are issues with a source table, you can run a successful business adapter data import that results in rejected records. Any rejected records don't get imported to the FlexNet Manager Suite database. When this issue 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 Jun 13, 2023 11:50 AM by HollyM
Thanks for this useful article!
I have stated for the full version of the Business Adapter Studio (the non-beacon version, on premise) , selecting "Use Physical Table" was also solving the issue. More information on the Business Adapter Studio in the June 2023 SAM Best Practice Webinar!
Best regards,
Nicolas