Example, of 1000 Interactions to be loaded for a source, 50 got loaded before the first job was killed. After the undo, the Number of Solicitations is -50. When the upload is done again and adds the full 1000 Interactions, the Number of Solicitations is -50 + 1000 = 950 rather than the full 1000 it should be.
The solution is to manually set the Number of Solicitations on sources to 0 after an undo of a killed Interactions Upload, or if it is after the second upload already, manually correct set them to the correct amount. If it is too many sources to do manually, you can contact TA support for assistance.
2. Another reason that the Number of Solicitations is not incremented on the Source record is that the Vendor_Flags table is missing the record with the same Vendor_Code as used for the upload file. Here is how to check for the existence of the record:
WHERE VENDOR_CODE = '[Vendor Code'];
If it is missing, SUST or TA Support needs to add the record. A sample of the record is attached to this article (for Vendor_Code = 'CRL').
Please ask the client if they want the following to happen when performing an Interactions Upload job with the specific Vendor_Code:
Do they want to generate SAC values for each new Interaction record?
Do they want the Source record updated (i.e. Number of Solicitations)?
The attached SQL file uses those values (as an example).
Here is a Help doc link to help support this issue: Vendor Flags (Interaction Upload)
3. If the existing Sources do not have a Mail_Date on them, and Number of Solicitations is not null, then updates from a Source Upload will overwrite the Number of Solicitations value. If the Upload value for Number of Solicitations is null, it will set Number of Solicitations on the Source as 0. Only Total_Cost, Number_Solicitations, and sometimes (depending on their upload settings) Cost_Per_Soliciation will get set to 0 if you upload them as null. Everything else that is uploaded as null will not update anything on the Source for that.
See KB Article 62107 for more information on Source Uploads: Why does a Source Upload not update some Source info?