November Happy Hour will be moved to Thursday December 5th.

Mediachase_ECF50_MDP_Key issue

Vote:
 

Hi 

 

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
Vote:
 

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

#84466
Apr 02, 2014 13:33
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
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
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
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
Vote:
 

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

#84478
Apr 02, 2014 14:31
Vote:
 

Any suggestion Paul?

#84483
Apr 02, 2014 14:46
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
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
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.