none
Allways Encryption 2016 - End up with error .

    Question

  • HI,

    I think i have already posted similar Query in the recent past, but however i didn't get an complete Answer  to my post . so would like to post this in more brief way . 

    I started encrypting the Column DOB , with datatype datetype , and the table has many other columns,w hich i am not focousing now , and the total rows is around 2000. 

    When i follow the below steps and try to configure , i end up with error, saying system out of memory , where as i have ample amount of memory  in my system and allocated to sql as well. 

    Can you please suggest me how to proceed with , if you can show me some best URL is also fine

    I did so far is 

    1. create master key in that DB

    2. create column key 

    3. log in to security folder in that DB then click on encryption button , and follow the wizard 

    4. After following the last slide will be taking one hour , end up with Error saying system out of memory erro .

    Can you please help me to have a smooth flow of creation . 

    !!!!!!!!    Thanks in advance for your help     !@!!!!!!!!!

    Thanks 

     


    hemadri

    Thursday, November 10, 2016 1:35 PM

All replies

  • Which version of SQL server?

    Can you paste exact error here? With ample amount of memory and only 2K records Out of memory should not be an issue.

    Can you use TSQL code instead. Below link have step by step method for column encryption.

    https://www.mssqltips.com/sqlservertip/2431/sql-server-column-level-encryption-example-using-symmetric-keys/


    Kindly mark the reply as answer if they help

    Friday, November 11, 2016 10:59 AM
  • Hi , 

    I am sharing the error log of the encryption 

    ====================================

    Nov 11 2016 17:07:09: Log opened. TraceLevel:Informational
    Nov 11 2016 17:08:15 [Informational] WizardSummary: Message:Source database settings.

    Nov 11 2016 17:08:15 [Informational] WizardSummary: Message: Source server name: BHCMWARCNV02.

    Nov 11 2016 17:08:15 [Informational] WizardSummary: Message: Source database name: HRMS40.

    Nov 11 2016 17:08:15 [Informational] WizardSummary: Message:Encrypt column date_of_birth.

    Nov 11 2016 17:08:15 [Informational] WizardSummary: Message:  Table name: epin_employee.

    Nov 11 2016 17:08:15 [Informational] WizardSummary: Message:  Encryption key name: CEK_Auto1.

    Nov 11 2016 17:08:15 [Informational] WizardSummary: Message:  Encryption type: Deterministic.

    Nov 11 2016 17:08:18 [Informational] WizardSummary: Message:Source database settings.

    Nov 11 2016 17:08:18 [Informational] WizardSummary: Message: Source server name: BHCMWARCNV02.

    Nov 11 2016 17:08:18 [Informational] WizardSummary: Message: Source database name: HRMS40.

    Nov 11 2016 17:08:18 [Informational] WizardSummary: Message:Encrypt column date_of_birth.

    Nov 11 2016 17:08:18 [Informational] WizardSummary: Message:  Table name: epin_employee.

    Nov 11 2016 17:08:18 [Informational] WizardSummary: Message:  Encryption key name: CEK_Auto1.

    Nov 11 2016 17:08:18 [Informational] WizardSummary: Message:  Encryption type: Deterministic.

    Nov 11 2016 17:08:20 [Informational] WorkitemExecution: Message:Work item 'Performing encryption operations' started..

    Nov 11 2016 17:08:20 [Informational] TaskUpdates: Message:Task: 'Performing encryption operations' -- Status: 'Started' -- Details: 'Task 'Performing encryption operations' started ....'.

    Nov 11 2016 17:55:26 [Informational] TaskUpdates: Message:Task: 'Performing encryption operations' -- Status: 'Failed' -- Details: 'Task failed due to following error: Exception of type 'System.OutOfMemoryException' was thrown.'.

    Nov 11 2016 17:55:26 [Informational] WorkitemExecution: Message:Work item 'Performing encryption operations' stopped..

    Nov 11 2016 17:55:26 [Error] WorkitemExecution: Message:Work item 'Performing encryption operations' did not complete. Details: Exception of type 'System.OutOfMemoryException' was thrown..

    Nov 11 2016 17:55:26 [Informational] Log Closed: Message:Job processing completed.

    ===================================================


    hemadri

    Monday, November 14, 2016 5:38 AM