We use DBAmp to import records from another system. Everything works fine except for when creating a new record. The record does not roll-up via the summary field on it's parent. Any ideas or other information that might be helpful to help me solve this problem?
My understanding is upon any DML of children records of a Master-Detail relationship should kick of the asynchronous recalculation of any roll-up summary fields on the master record. Checking the Master Object, a recalculation is is still processing if there is a little purple icon next to the roll-up summary field.
If I am mistaken above, a work-around is to simulate your own roll-up summary by (1) creating a field on the Master and (2) writing a trigger on the Child that calculates the roll-up value if the field-to-be-rolled-up changes.
The work-around isn't too difficult to write, but it's not the desirable solution -- the Master-Detail should already be doing this!
My guess is that you are processing a lot of records causing a lengthy recalculation. If true, then the recalculation should occur eventually. If false, this issue has to have been documented somewhere before -- though that "Force a manual recalculation" option may be there for a reason.
"Roll-up summary fields may take up to 30 minutes to recalculate"
Check out this doc on Bulk API and search for "Roll-up summary":
I bet your 3rd party software is using Bulk API, and maybe the ordering of how you're upserting records is causing "lock contention" with the Master records hence causing a roll-up summary failure.