Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SF_Replicate not replicating all records

We noticed we were missing some records when we ran SF_REFRESH.

i did a full SF_REPLICATE, but I am still missing records.

I can see the record when querying through the View, but it does not show up in my replicated table.

I noticed on the Replicate that it does not do even chunks of 100,000 records.

I am running this:

exec [salesforce backups].dbo.sf_Replicate 'Salesforce_PROD','Lead','pkchunk'

Attached is the output showing less than 100k blocks coming through.

1 person has
this problem
+1
Reply
  • How do I determine why a LEAD record would show up in a VIEW against SalesForce, but not in the Replicated table?

    Do VIEWs show archived records?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • Lead records cannot be archived.

    The pkchunk output is not a problem because the difference is due to deleted rows in that batch that are not brought down.

    What is the from table of your salesforce view ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • The followingis the DDL for the VIEW I am using to read the SF data.

    I see the record through this view, but not in the replicated data.

    CREATE VIEW [dbo].[Lead_View] WITH VIEW_METADATA AS SELECT [Address2__c],[AnnualRevenue],[anonymousIP__c],[AppointmentMade__c],[ApptDate__c],[Area_of_Interest__c],[Attention_Needed__c],[CallToAction__c],[CallType__c],[campaign_content__c],[Campaign_Name__c],[CampaignID__c],[CampaignSource__c],[CampaignTacticName__c],[City],[ClassName__c],[CommunicationPreference__c],[CommunicationType__c],[Company],[ConvertedAccountId],[ConvertedContactId],[ConvertedDate],[ConvertedOpportunityId],[Country],[CreatedById],[CreatedDate],[Databaseid__c],[Description],[Disposition__c],[DoNotCall],[Donotmail__c],[Email],[EmailBouncedDate],[EmailBouncedReason],[eMailOptIn__c],[eMailOptInDate__c],[EMPID__c],[EncounterDate__c],[EndDateTime__c],[Event_Sponsor__c],[Event_Type__c],[EventAttendanceIndicator__c],[EventDateTime__c],[EventID__c],[EventName__c],[Fax],[FILENAME__c],[FirstName],[GeocodeAccuracy],[HasOptedOutOfEmail],[HasOptedOutOfFax],[Hospital__c],[HowHeard__c],[hra_BMI_Category__c],[Id],[Ifs_Best_Time_to_Call__c],[Ifs_Best_Way_to_Contact__c],[Industry],[InquiryID__c],[InsuranceName__c],[Is_Invalid_Data__c],[IsConverted],[IsDeleted],[IsUnreadByOwner],[Jigsaw],[JigsawContactId],[LastActivityDate],[LastModifiedById],[LastModifiedDate],[LastName],[LastReferencedDate],[LastTransferDate],[LastViewedDate],[Latitude],[LeadID__c],[LeadSource],[LOADTIMESTAMP__c],[Longitude],[MasterRecordId],[MiddleName],[mkto71_Acquisition_Date__c],[mkto71_Acquisition_Program__c],[mkto71_Acquisition_Program_Id__c],[mkto71_Inferred_City__c],[mkto71_Inferred_Company__c],[mkto71_Inferred_Country__c],[mkto71_Inferred_Metropolitan_Area__c],[mkto71_Inferred_Phone_Area_Code__c],[mkto71_Inferred_Postal_Code__c],[mkto71_Inferred_State_Region__c],[mkto71_Lead_Score__c],[mkto71_Original_Referrer__c],[mkto71_Original_Search_Engine__c],[mkto71_Original_Search_Phrase__c],[mkto71_Original_Source_Info__c],[mkto71_Original_Source_Type__c],[mkto_age__c],[mkto_asthmaRiskCategory__c],[mkto_backNeckImpairment__c],[mkto_Behavior_Score__c],[mkto_bmiCategory__c],[mkto_breastCancer5Year__c],[mkto_breastCancerLifetimeRisk__c],[mkto_Business_Fax__c],[mkto_Business_Phone__c],[mkto_communicationTypes__c],[mkto_ContactInterest__c],[mkto_contactReason__c],[mkto_ConversionDate__c],[mkto_Converted__c],[mkto_dateOfBirth__c],[mkto_DemographicScore__c],[mkto_diabetesRisk__c],[mkto_Do_Not_Call_2__c],[mkto_Do_Not_Mail_1__c],[mkto_doNotCall__c],[mkto_Email_Opt_Out__c],[mkto_Email_Opt_Out_date__c],[mkto_Email_Opt_Out_Reason__c],[mkto_Emailable__c],[mkto_EmailDomain__c],[mkto_emailInvalid__c],[mkto_EngagementDate__c],[mkto_ethnicity__c],[mkto_Event_Location__c],[mkto_eventOptIn__c],[mkto_eventRegistration__c],[mkto_ExcludefromLifecycle__c],[mkto_ExcludefromScoring__c],[mkto_Gender__c],[mkto_heardAbout__c],[mkto_hospitalCode__c],[mkto_hospitalOptIn__c],[mkto_InactiveDate__c],[mkto_incontinenceSymptoms__c],[mkto_InterestBariatric__c],[mkto_InterestCardiology__c],[mkto_InterestEmergency__c],[mkto_interestObstetrics__c],[mkto_interestOrthopedics__c],[mkto_InterestPediatrics__c],[mkto_Is_Employee__c],[mkto_Joint__c],[mkto_JointAssessment__c],[mkto_JointBMICategory__c],[mkto_Language__c],[mkto_lastReferredEnrollment__c],[mkto_lastReferredVisit__c],[mkto_Lead_Role__c],[mkto_Lead_Type__c],[mkto_LifecycleStatus__c],[mkto_lifetimeRiskCategory__c],[mkto_lungScreening__c],[mkto_MarketingSuspendedReason__c],[mkto_newsletterOptIn__c],[mkto_Original_Lead_Source__c],[mkto_orthoActivityAffected__c],[mkto_orthoOsteoarthritisJointDisease__c],[mkto_orthoPainType__c],[mkto_PadRiskCategory__c],[mkto_Phone__c],[mkto_phoneOptOut__c],[mkto_prostateRiskCategory__c],[mkto_qoLImpact__c],[mkto_Rating__c],[mkto_Reengagement_Date__c],[mkto_riskCategory30Years__c],[mkto_riskCategory__c],[mkto_Seminar_Date__c],[mkto_serviceInformationOptIn__c],[mkto_specialOffer__c],[mkto_strokeRiskCategory__c],[mkto_Subscriptions__c],[mkto_weightLossRec__c],[mkto_weightLossSurgeryRec__c],[MobilePhone],[MRN__c],[Name],[Name_Match_Status__c],[NPI__c],[NumberOfEmployees],[OtherPhone__c],[OtherPhysicianID__c],[OtherPhysicianIDType__c],[OwnerId],[Phone],[PhotoUrl],[PhysicianAddressLine1__c],[PhysicianAddressLine2__c],[PhysicianCity__c],[PhysicianFirstName__c],[PhysicianLastName__c],[PhysicianState__c],[PhysicianZip__c],[PostalCode],[Processing_Status__c],[Rating],[Reason__c],[Salutation],[screening__c],[ServiceID__c],[ServiceLine__c],[ServiceType__c],[SessionID__c],[SessionStatus__c],[SourcePersonID__c],[SourcePhysicianID__c],[SourceSystem__c],[Specialtyofinterest__c],[StartDateTime__c],[State],[Status],[Street],[Suffix],[Sync_Issue__c],[SyncToMarketo__c],[SystemModstamp],[Title],[Website],[Wunderman_Id__c] FROM SALESFORCE_PROD...[Lead]
    GO
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • Let's schedule a web meeting so I can take a look.

    Can you send some times available to support@forceamp.com ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • These are my calls:

    exec [salesforce backups].dbo.sf_Refresh 'Salesforce_PROD','Lead','no','no'--,'bulkapi'
    SELECT * FROM [salesforce backups].[dbo].[Lead] where id = '00Q1R000015qtS8' -- missing
    select * FROM SALESFORCE_PROD...[Lead] where id = '00Q1R000015qtS8' -- found

    exec [salesforce backups].dbo. sf_Replicate 'Salesforce_PROD','Lead','pkchunk';
    SELECT * FROM [salesforce backups].[dbo].[Lead] where id = '00Q1R000015qtS8' -- misssing
    select * FROM SALESFORCE_PROD...[Lead] where id = '00Q1R000015qtS8' -- found
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated