Hi Support,
I am trying to use encryption feature on attributes but there is some issue. Anyone who is already using please light :idea: me on. Version 8.0 (2365).
Here is the example..
I have already created my symmetric key and certificate in the db.
I have a attribute DOB (Date of Birth). I open the encryption window to setup the mechanisim.
Enter the Key Name:
Choose Encryption mechanism - Symmeteric Key
(Notice the third option label changes from "certificate name" to "Key name")
Key Name : I believe sort of glitch and it should be the certificate name. So I've put the value of certificate name.
below are the logs when try to create the record or view.
Unable to open encryption key SECDEMOKey Encryption for this key will not work
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the symmetric key 'SECDEMO', because it does not exist or you do not have permission.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662)
at com.bas.basserver.persistence.dbplugins.MSSQLServerInterface.A(Unknown Source)
at com.bas.basserver.persistence.dbplugins.MSSQLServerInterface.connectionCreated(Unknown Source)
at com.bas.basserver.persistence.DatabaseEnvironment.getConnection(Unknown Source)
at com.bas.basserver.persistence.EntityDBPersister.F(Unknown Source)
at com.bas.basserver.persistence.EntityDBPersister.insertEntity(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.insertEntity(Unknown Source)
at com.bas.basserver.executionengine.A.H.A(Unknown Source)
at com.bas.basserver.executionengine.A.H.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.doCreateEntity(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.createEntity(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498-)
at com.bas.basserver.bsmanager.E.B(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68-)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(AbstractSimplePipe.java:222)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68-)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(AbstractSimpleSource.java:403)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1049)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1012)
at com.bas.openadaptor.MTJMSListener$JMSMessageHandler.run(MTJMSListener.java:275)
at java.lang.Thread.run(Thread.java:745)
No data appear when view the same saved record.
