When executing the Snapshot Definition "User Profile Report Snapshot": it will output that it completes for some users but then fail at the same user count with an error:
Failed to execute CaptureSnapshotEvent. ERROR MESSAGE: Exception:CaptureSnapshot event has failed.
Identity Manager 14.5.1
This is being caused by a character limit in the snapshot database being exceeded when trying to write encrypted strings which can be longer than 1024 characters.
Specific investigation indicated that the imPasswordData attribute size is greater than 1024 for many users.
imPasswordData stores password history and other details about password changes and is an encrypted value that can exceed 1024 characters.
This has been reviewed and a patch provided by the Broadcom Engineering team. If you are encountering this problem please reach out to Support and reference this Knowledge document.
The fix will change the export to the snapshot database to exclude encrypted password data eliminating this problem and will be included in a future Service or Cumulative Patch.