Secure Store Service did not performed the operation


Error : Secure Store Service did not performed the operation”

The Error : Along with the grammar issue , ( not that English is my third language ) is a valid one,

With all sorts of errors on the SP log , System and application logs.

This was only a symptom to a bigger problem

Database log file growing out of size (in our case filled the disk space)

 

Those failed write to the DB file from the Log, happen often in slow disk environments (not sure why)

In some case it will show this error on the backup logs (: The transaction log for database ‘Name of DB’ is full)

How to solve this short term problem (PS : this is how I solved it but I am not sure if this is the correct way)

  1. Do no panic, it is a SQL problem.
  2. Go to the SQL Management tools, change the DB Options Recovery mode from Full to Simple.
  3. Perform a full DB Backup to any other disk.
  4. Change the DB Options Recovery mode from Simple back to full.
  5. You should be back online by now.

     

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s