Decryption by IDM Script executed by JobServer

martin ehlert over 2 years ago

Hi everyone,

I try to iterate all history dbs for some needed operations.

Therefore I read the DialogHistoryDB table and try to use the TransportConnectionString for the connection.

This string is encrypted, so I have to decrypt it.

The methods

- Session.Decrypt

- Session.Encryption.Decrypt

- Session.Encryption.DecryptPartial

all don´t work. Error message is

Encryption error. The data was probably encrypted with the wrong public key.
[System.Security.Cryptography.CryptographicException] Key does not exist.

I think in the past I did this once successfully (as a job server side task) but can´t get it working now. Some ideas what could cause the problem?

Thank you in advance.

0 Markus Weiss-Ehlers over 2 years ago

Where (MainDB / HistoryDB) using what tool are you using to run your script? The message points to a missing or wrong public key/private key combination while decrypting.

What version are you using?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 martin ehlert over 2 years ago in reply to Markus Weiss-Ehlers

We use version 9.1.

The job (and script) is executed on main DB by the job server.

Meanwhile I used the way to decrypt the value via parameter of a process chain with checkbox "partial encrypted" for this parameter checked. This is working as expected, but not the most clean solution.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel