web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter 2012 CU12 Data Mart Refresh (GP connector) - String or binary data would be truncated GL Transaction to Fact Task fails

(0) ShareShare
ReportReport
Posted on by 1,775


GPs GL00102 table allows for up to 51 characters. Management Reporter 2012 CU12's datamart's AccountCategory table's [name] column allows for only 50 characters. This stalls the data mart GL Transaction to Fact task and results in string/binary truncation error.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,061 Moderator on at

    HI 26P2ER (?),

    CU12 was not the most stable release of MR 2012.. I would strongly suggest to upgrade to CU14 at least.

    The latest build CU15 has been release recently, but requires some other significant changes to your server (.NET upgrade).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans