0

We have an issue whenever we restore production DBs to QA/local environment our Content management doesn't come up though content delivery is all fine

What I did so far: Earlier we noticed that our Core/EventQueue table had lots of entries so we reduced agent's time to 4 hours and can see the effect(Not too many rows) but still it's failing. Any help would be appreciated

New contributor
sumit tandon is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

2 Answers 2

1

Some of the steps that you could take are:

  • Compare the System specs of PRD with QA and update if required. RAM, Number of CPU cores along with hard disk capacity
  • Clear the Event Queue and History tables
  • Assuming you are using XP, check if features like Content Testing, Path Analyzer are used in the Project. If not, disable them
  • There may be a lot of content users in the PRD, you may decide to clear them
  • Check the Contact Lists and Segmented Lists in the Marketing Control Panel. If the number is high, you may want to remove some
  • Check the scheduled jobs and tasks running. You may want not want to run them in QA/local
  • Check the Sitecore logs if there are any errors there
6
  • @sumit.upadhay it fails in Prod too whenever we do Blue/Green deployment So I'm not sure about these steps yesterday
  • @sumit.upadhay The only thing I could try was clearing EventQueue and History tables but that didn't solve the problem Though I noticed it took sometime in warm up , anything to look for that yesterday
  • Do you see anything in the logs? yesterday
  • Nope, nothing related yesterday
  • are you trying from within the server or from outside? yesterday
0

After restoring db from production to your local environment, clean EventQueue and History tables in both core and master databases.

Otherwise, your local instance will try to process every single entry from those tables at startup and that will pretty much make it unresponsive if you have plenty of entries there.

3
  • I'm still seeing this issue I had below entries -- I went to database and deleted those still it couldn't warm up cm instance core/EventQues 20k+ core/History 47 master/EventQues 6k+ master/History 9 million Jun 22 at 7:22
  • @Marek.Musielak check this, tried suggested fix but no luck Jun 22 at 12:17
  • @marek.musielak any other workaround or something to try ? yesterday

Your Answer

sumit tandon is a new contributor. Be nice, and check out our Code of Conduct.

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.