Tag: Navision

Categories
Dynamics NAV Microsoft

Encryption key was not found.

Encryption key was not found.

When you try to insert a new Credit Card in Microsoft Dynamics NAV 2013 appears the above error message.

Encryption key was not found

Solution:

  1. In the Search box, enter Payment Services Connection Setup, and then choose the related link.
  2. On the Actions tab, in the Encryption group, choose Generate Key to generate the encryption key that is stored on the Microsoft Dynamics NAV Server.

Experience: I suggest you if you use the Generate Key functionality to download and store in a secure backup the key generated using the button Download Key on the Actions tab, in the Encryption group.

Reference: How to: Set Up a Payment Services Connection

Did my solution solve your problem? Leave a reply.

Categories
Dynamics NAV Microsoft SQL Server

Microsoft Dynamics NAV – “The following ODBC error occurred: Error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length State ID: HY090”

—————————
Microsoft Dynamics NAV Development Environment
—————————
The following ODBC error occurred:

Error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
State ID: HY090
—————————
OK
—————————

When you try to read a Microsoft Dynamics NAV (formerly Microsoft Business Solutions Navision) BLOB Data Type field with an ODBC connection or simply to do a Backup of Navision show the following this error message:

Invalid string or buffer length

Cause:

When you use Microsoft Dynamics NAV BLOB field with Compressed Property to No and SubType Property to Memo is possible to write values from 4 bytes to 2 GB.

Solution:
Write something (like 4 spaces) in the field to cover the 4 byte in all the rows with blob field containing less then 4 bytes.

You can run a query in SQL Server like this:

SELECT *
FROM [TableName]
where DATALENGTH([ImageColumn]) < 4

Did my solution solve your problem? Leave a reply.