cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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.

history import.png

If you are importing from the beacon, you can see the error in the system menu.pngSystem Menu > System Health > System Tasks.

sys tasks.png

Then select the rejection message link in the Summary column.

rejection messages.png

Common causes and resolutions

  • The column specified in the error message may be marked as Use this property for matching existing data, but the source table doesn't contain any values in that 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.

  • The Excel sheet used for the source table contains removed entries, and the reader is still importing the blank rows as entries.

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

Was this article helpful? Yes No
100% helpful (2/2)
Comments
nrousseau1
By Level 10 Champion
Level 10 Champion

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

Version history
Last update:
‎Jun 13, 2023 11:50 AM
Updated by: