You need to sign in to do that
Don't have an account?
Coral Racing
Data Loader Error
Hello
I am using Data Loadr for the first time to update a small number of records on a Custom object in my Sandbox.
Initialization is successful but the upsert fails due to a trigger issue I think as i get the following error?
IncidentTrigger_After: execution of AfterInsert
caused by: System.DmlException: Insert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [LastName]: [LastName]
Trigger.IncidentTrigger_After: line 40, column 1
Can anyone help as to what the issue might be?
I thought about making the trigger inactive in the sandbox to see if this would help, but I cannot seem to do this.
Thanks
Sonya
I am using Data Loadr for the first time to update a small number of records on a Custom object in my Sandbox.
Initialization is successful but the upsert fails due to a trigger issue I think as i get the following error?
IncidentTrigger_After: execution of AfterInsert
caused by: System.DmlException: Insert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [LastName]: [LastName]
Trigger.IncidentTrigger_After: line 40, column 1
Can anyone help as to what the issue might be?
I thought about making the trigger inactive in the sandbox to see if this would help, but I cannot seem to do this.
Thanks
Sonya
I ended up Exporting the Object Data changing the field that I needed to update then upserted the new data
Sonya
All Answers
The error is showing that some field values is not found in your record which are in your file. So Let check the field which is required in and field the record having that value or not.
Many thanks
Sonya
Thanks
Sonya
Client ID: id value of incorrect type: xxxxxx
When you are populating Lookup fields using the Data Loader, your import file must contain the salesforce.com Record ID of the record you want to link to, not the Name of the record to link to. (Because the Name is not a valid Record ID you receive the "id value of incorrect type: " error).
For example, the error you provided indicates that you were trying to populate the "Client" field, which is a Lookup to Client, say "ABC". To accomplish this, your import file will need to contain ABC's Client Record ID (00X7000000XXXXX) rather than his Name.
Hope this helps!
I ended up Exporting the Object Data changing the field that I needed to update then upserted the new data
Sonya