Problem in doing the Data Encryption Using "Always Encrypted" functionality in Navision

Jagadeesh_B
Jagadeesh_B Member Posts: 1
in NAV Three Tier
I have created table "PAN" in Navision dev environment, in SQL management studio i did encryption for the one of the field in the PAN table,

then later if I run the table form RTC i am getting the following error

Table content in the PAN table on SQL Server contains a value that is not compatible with the corresponding data type that is defined for the table.

Field: PAN_Number
Type: Code
SQL type: varbinary

The table design may have been changed outside Microsoft Dynamics NAV.

Page Edit - PAN must close.

how i can solve this problem??

Answers

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,692
    edited 2018-04-24
    Updating NAV table via SQL is generally not supported and not recommmended. NAV has built in validation which prevent certain charactes/values to be stored in the table. By writting table outside NAV you are bypasing those validations, and in your case you have stored values in the table which NAV cannot read back.

    The problem can be sorted by reverting the encrypted column back to the orignal valued or by clearing column content.




    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;
  • NavNab
    NavNab Member Posts: 181
    Despite what @Slawek_Guzek already explained, if you still want to do it SQL way and if you're 100% sure of what you're doing... then for your case I believe that you have to UPPERCASE the data in your column (because type Code in NAV is an alphanumeric field and always in uppercase)
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,692
    I don't think that uppercasing column data will help in this case.
    Jagadeesh_B wrote: »
    The table design may have been changed outside Microsoft Dynamics NAV.
    The more correct sentence would be The table design may have been changed outside Microsoft Dynamics NAV.


    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;

Categories