The offset field must be of type ObjectId.
Object ID fields include an embedded timestamp. The origin uses the embedded timestamp to determine where in the collection to begin reading based on the start timestamp that you provide.
Open issue to track usage of non-ObjectId offset fields:
https://issues.streamsets.com/browse/SDC-2683