I am doing a Custom Constituent Import, and the operation failed with an error that looks like this:
EXT_ERR_COUNT=0, PROGRESS_SEGMENT=9, WITH_SYNC_SKIPPED=0, USER_GROUPING_REMOVED=0, USER_CENTER_OPTED_OUT=0, USER_CENTER_OPTED_IN=0, USER_CENTER_ADDED=0, NEW=0, ERRORS=0, USER_INTEREST_REMOVED=0, COLLISIONS=0, USER_INTEREST_ADDED=0, UNCHANGED=0, PROGRESS=9, USER_CENTER_REMOVED=0, EXT_NEW_COUNT=0, GIFTS=0, EXT_DEL_COUNT=0, CV_MOD_COUNT=0, CV_NEW_COUNT=0, USER_GROUPING_ADDED=8, EXT_MOD_COUNT=0, DUPES_HELD_BACK=0, XREF_MISSING=0, MOD=0, report CONS_ID= 3324994, SKIP_GROUP_ID1=38081, current CursorUtil.selectRecords: Error Unable to execute prepare statement java.sql.SQLException: ORA-01722: invalid number generated by query SELECT cons_id skip_lookup_cons_id,active skip_lookup_active,admin_status skip_lookup_admin_status,member_id skip_lookup_member_id,exchange_id skip_lookup_exchange_id,primary_email skip_lookup_primary_email,accepts_email skip_lookup_accepts_email,first_name skip_lookup_first_name,last_name skip_lookup_last_name,upload_checksum skip_lookup_upload_checksum,download_checksum skip_lookup_download_checksum,membership_level_id skip_lookup_mbr_level_id,modify_date skip_lookup_modify_date,datasync_date skip_lookup_datasync_date FROM cbcf.constituent con WHERE site_id = XXXX AND cons_id = NVL ([arg-current.FOUND_CONS_ID],[arg-current.CONS_ID])
How do I fix this?
This error is caused by improper formatting in one of your import rows.
In the error output, there is a line that says: PROGRESS=9
This line indicates how far the process moved before running into a problem. Excel will often fix formatting and line break/spacing issues, which can make it hard to locate the problem. Most likely, you will have to look at the file in a plain text editor in order to identify the issue with that row.