2

We upgraded from Sites 8.5 to Sites 9.1 and we noticed in some cases the items not getting cleared from the State Store DB. Can we clean up the data, if so what this the procedure?

Improve this question
1
  • Please can you provide more details on why the items are not getting removed from state store , do you see any error on the logs
    – Anand N S ♦
    Jan 11, 2021 at 15:05

2 Answers 2

Reset to default
2

Please refer to this link for more details on how to Scheduling a periodic cleanup of the State Store database

Improve this answer
1
  • Thanks Shiva and Anand
    – user202
    Jan 12, 2021 at 12:11
1

As Anand posted, you can schedule clean up of obsolete records from the state store database.

In upgrade scenarios, I would recommend the following link from the SDL KB article. There link details hotfixes, settings and the tuning information which might be useful to the issue that you are facing.

delete from EXECUTION; delete from EXECUTION_PROPERTY; delete from PIPELINE; delete from STEP; COMMIT;

The short answer to your question is to run something like the below on the state store database.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.