0

enter image description herecould someone please help why tridion sites is throwing database error

error: A database error occurred while executing Stored Procedure "EDA_TRUSTEES_GETTRUSTEETOKEN_82"
Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The wait operation timed out
  Component: Tridion.ContentManager.CoreService Errorcode: 831 User: NT AUTHORITY\NETWORK SERVICE  StackTrace Information Details:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
  • Please include additional information like, is it a fresh installation or an upgraded instance, did it work at any point, etc. – Atila Sos Apr 9 '19 at 8:30
  • @Atila, it is a fresh installation, it works sometime, but sometime it throws db errors – Neetesh Narvaria Apr 9 '19 at 8:41
  • Just to confirm - you've started with a clean database and not a restored (from a previous...) version? If you restored then see tridion.stackexchange.com/questions/19919/… – Dylan .. Mark Saunders Apr 9 '19 at 9:34
  • It is pretty common to see the above error in a restored database as @Dylan already pointed out. If it happens sporadically, it could be an issue with your database. Are you having any maintenance scripts to analyse your database stats? Can you check if all of your stored procedures are successfully compiled? – Shiva Apr 10 '19 at 3:55
1

It looks like a typical Timeout error on a database pointing to lacking database maintenance or database upgraded or restored, It's expected to run the stats update.

The first thing to check is whether you have regular database maintenance performed? If not, do one (and start doing it on a regular basis, if possible daily) and try again. Database maintenance (Tridion specific) described here.

You could increase the timeouts as described here might help to resolve your issue.

I hope it helps

| improve this answer | |
0

Have you tried restarting your CM database server and/or looking at the maximum database memory settings, like this? I had a similar issue and I noticed the CM database server was out of memory, so I restarted it to resolve the issue. Then I noticed the database memory settings were set to the default maximum...

| 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.