Overview:
An Admin user prepares a CSV file to upload to Network through a Source Subscription job. The CSV file contains a column of an alternate key field. After running the source subscription job, an error appears in the job result and prevents the field to be updated.
Error: An attempt is being made to update a null or empty alternate key <hco_hcode__c> from <null> to <HXXXXX>
Root Cause:
The Network product currently (V17R1) does not support updating a null alternate key to another value.
Solution:
When initially loading an alternate key field, avoid leaving it with a null value. Use an empty value such as: '' or a dummy value instead.
If null is set to the alternate key field, open a ticket with Veeva Support to manually update the null value from the backend.
Related Documentation:
N/A
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.