Synchronizing the Device Application Returns Only One Row of Data

Problem: If the enterprise back-end database table has no primary key and contains multiple rows of identical information in every column, a device application user can synchronize only one row.

Explanation: If a device application user tries to create multiple rows that are identical in every column, it succeeds to update the back-end database, but only displays one column on the client and the cache database (CDB).

Solution: verify the back-end database has a primary key.