Creditor Transaction Archiving fix to "String or binary data would be truncated".

Owned by Beth Blok (Unlicensed)
Last updated: Jul 14, 2023 by Julie Hanlon
1 min read

Problem

Running the Creditor Archiving function errors after a few minutes with 'String or binary data would be truncated

Solution

SQL skills are required

A sound knowledge of SQL Studio Management is required to complete this task



The problem is caused by the archiving stored procedure for creditor transactions using temp tables that expect CurrencyID of CHAR(20) instead of CurrencyID of CHAR(36). Patched stored procedures for 7.0.175.0 and 7.2.1 are attached.  Download the relevant SQL script and apply to the database.

7.2.1

7.0.175





Related issues

[DEV-8003] Creditor Transaction Archiving errors with "String or binary data would be truncated". - Jiwa Service (atlassian.net)