FeedItems out of order in Salesforce

Description

201 courses are impacted for this.

Salesforce bulk_load does not preserve order, meaning that our comments that our users read are out of date.

We'll need to rectify this, and our plan going forward is as follows.

Warning: DO NOT DELETE ANY PUB ORGS, COURSES, COURSE RUNS, OR CASES

  1. Verify that there have been no new FeedItem comments added to Salesforce. If there are, manually drop the historical FeedItems for that Case. OTHERWISE, bulk drop them for that salesforce_case_id. Verified!

  2. Modify the bulk load script when creating comments to pass in a flag that will overwrite the CreatedAt stamp, but ONLY from the bulk load script, not on new comments

  3. Enable the Create Audit Fields flag in Salesforce to allow us to overwrite the CreatedAt timestamps Done for sandbox + prod

  4. Re-run the bulk load commands for all partners

 

Steps to Reproduce

None

Status

Story Points

None

Assignee

Jeff LaJoie

Reporter

Jeff LaJoie

Labels

Reach

None

Impact

None

Customer

None

Partner Manager

None

URL

None

Contributor Name

None

Groups with Read-Only Access

None

Actual Points

None

Category of Work

None

Stakeholders

None

Sprint

None

Priority

Unset
Configure