Execute insert tmpje failed - string or binary data would be truncated error when running Historical Actuals Comparison Report

Owned by Knowledge Assistant
Last updated: Oct 24, 2023
1 min read





Description of Issue

Errors received in Historical Actuals Comparison Report when journals have more than 12 characters in the Reference 3 field



Context

  • Historical Actuals Comparison Report

  • Posted Journals

  • Reference 3

  • Error message



Cause

A known defect is causing the error in the report due to a recent change in character capacity for the Reference 3 field of Journals



Resolution

Master work ticket, MUN-390342, has been created and sent to development.



Additional Information

This only occurs when running the report for Current Year using Totals Only in Report options, and when the account balance is Zero.

As a workaround, the report can be run without Totals Only selected in Report Options.