Loading

Energy & Utilities Cloud Service Point Bulk Upload Fails on Required Premises Fields

Publiceringsdatum: Oct 16, 2026
Beskrivning

Issue

When you upload a CSV file of Service Points with the Energy & Utilities Cloud Service Point bulk upload, the upload fails if your org requires custom fields on the Premises object. The failure occurs even when every CSV row contains a valid Premise Id and that Premises record already has values in the required fields.

Symptoms

  • The upload fails with this message: "Upload process failed. Something went wrong, please contact your System Administrator."
  • The debug log shows this exception: DmlExecutionException: Insert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [Custom field] Here, [Custom field] is the required Premises field.
  • If you add Premises fields as columns in the CSV file to supply those values, the upload rejects the file with: "Incorrect CSV. Please correct the label for fields: [Custom field]"

Root Cause

For every CSV row, the bulk upload inserts a generic Premises record. This happens whether or not the row contains a Premise Id. The upload populates only the system-generated Name on this generic Premises record and leaves all other Premises fields blank.

When a row includes a Premise Id, the upload links the new Service Point to that existing Premises record. The generic Premises insert still runs as well. If any Premises custom field is required, the generic insert fails with REQUIRED_FIELD_MISSING, and the upload fails. The values already on the referenced Premises record don't prevent this failure.

You can't supply the missing values in the CSV file. The upload template accepts only Service Point fields, so any Premises field added as a column causes the "Incorrect CSV" error.

Lösning

Workaround

Make the affected Premises custom fields not required, then run the upload again.

  1. Set up debug logging for the user who runs the upload. From Setup, in the Quick Find box, enter Debug Logs, select Debug Logs, and click New. Select that user, a time period, and a debug level, then save.
  2. Run the upload again to reproduce the failure.
  3. In the debug log, find the REQUIRED_FIELD_MISSING exception and note each field listed under "Required fields are missing".
  4. From the object management settings for Premises, go to Fields. Click the label of each listed custom field, click Edit, deselect Required, and save.
  5. Remove any Premises field columns from the CSV file so it contains only Service Point fields.
  6. Upload the CSV file again.
  7. Confirm that the upload completes without the "Upload process failed" message, and that each new Service Point links to the Premises record referenced in its CSV row.

Notes

  • A custom field marked Required must have a value whenever a record is saved, including saves through the API and automated processes. When you deselect Required, that requirement is removed everywhere, not only for the bulk upload. For details, see "Require Field Input to Ensure Data Quality" in Salesforce Help.
  • With the workaround in place, the upload still creates one generic Premises record per CSV row, populated with only a system-generated Name. Review whether these records affect your data-management and reporting processes.

If the upload still fails after you complete these steps, contact Salesforce Support and include the debug log from the failed upload.

Knowledge-artikelnummer

005461854

 
Laddar
Salesforce Help | Article