Problem: An exception—The pattern is too long—is reported while trying to update an existing value on a back-end database, via mobile device.
Explanation: This case may happen when a mobile business object's (MBO's) operation definition is generated by dragging and dropping a database table to the object diagram in Sybase Unwired WorkSpace.
The error is caused by an incorrect LIKE clause. The LIKE clause should not be used by a text data type whose length is greater than 254 characters, or a binary data type. The LIKE clause is the Sybase Unwired WorkSpace's best effort to resolve operations executed against tables that do not contain a primary key.
Solution: Redesign the back-end database to contain a primary key on the offending table.