Mediachase_ECF50_MDP_Key issue

Vincent

Vote:

I am currently working on one old commerce project, there is a called customer.SaveChanges() - customer is an instance of CustomerContact object, it will causse the program throw the following exception, is it an known issue that has been fixed?

"Please create a master key in the database or open the master key in the session, xxxx"

I found the following version number from commerce header section, but not able to locate it from http://epiwiki.se/configuration/episerver-version-nummber-vs-release-number page, can anyone tell me which version of commerce framework I am currently using?

Product Version: 5.2 (build: 628)
License: ECF G5 Deployment (EpiServer)

#84463

Apr 02, 2014 13:12

Paul West

Vote:

Do you have any meta fields that have the "Use Encryption" checkbox checked?

#84466

Apr 02, 2014 13:33

Vincent

Vote:

I am a newbie to Commerce, can you tell me how can I easily which field have this enabled?

#84470

Apr 02, 2014 14:10

Vincent

Vote:

I also follow this article http://sdk.episerver.com/commerce/1.1/Content/Developers%20Guide/Architecture/Security%20and%20Encryption/Securing%20Sensitive%20Data.htm to add the key, but when i test it, the error is still there.

#84471

Apr 02, 2014 14:13

Paul West

Vote:

On the commerce manager site in
Administration > Catalog System > MetaFields and Administration > OrderSystem > MetaFields
take a look at all the metafields

Do any have any "Use Encryption" boxes checked ?

#84472

Apr 02, 2014 14:17

Vincent

Vote:

Hi Paul

Thanks for your quick reply. I check all the string properties, none of them have that option enabled.

#84473

Apr 02, 2014 14:23

Vincent

Vote:

I also did search the [MetaField] table isencrypted column, all fields value are zero

#84478

Apr 02, 2014 14:31

Vincent

Vote:

Any suggestion Paul?

#84483

Apr 02, 2014 14:46

Paul West

Vote:

Here is some info we had gathered for a similar issue, if this doesn't help maybe it is best to create a support case with episerver?

...

moving the DB from one environment to another the metadata for either the master key (DBMK) or the certificate got somehow corrupted, or rather out of sync. Please have a look at below links for in details about solution for this issue:
http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/1962ea62-28d8-4331-af6e-a73e1a0d4bcc/
http://davidsalt.com/2012/08/03/sql-error-sql72014-please-create-a-master-key-in-the-database-or-open-the-master-key-in-the-session-before-performing-this-operation/
http://sqluninterrupted.com/2012/03/26/error-15581-please-create-a-master-key-in-the-database-or-open-the-master-key-in-the-session-before-performing-this-operation/

#84486

Apr 02, 2014 15:12

Vincent

Vote:

The fact is I didn't use any encryption for any of the meta fields, is it possible to bypass this check?

#84496

Apr 02, 2014 15:26

Try our conversational search powered by Generative AI!

Mediachase_ECF50_MDP_Key issue