Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

MR2012 CU14 DataMart Error: A column named 'AttributeValue3' already belongs to this DataTable

Posted on by 110

Hi,

I am stuck on an MR2012 CU14 issue trying to install it on SQL Server 2014. I have over 70 companies and receive this error on some of them:

One or more errors occurred. A column named 'AttributeValue3' already belongs to this DataTable.

  • The error does not identify what company.
  • I went back and enabled the enableglreporting field in SY01500 in small company increments. I could add small batches until I got to around 29 companies and then the error would occur. It doesn't seem to be company specific as I could add Company A at the end and get the error, rebuild the DM and use company A as the first company and not get the error.
  • I have tried CU14 and CU15 with the same results.
  • I have been unable to find anything on the net to help.
  • I am using GP2015.

thx,

Doug

*This post is locked for comments

  • RogerRogerATX Profile Picture
    RogerRogerATX 1,515 on at
    RE: MR2012 CU14 DataMart Error: A column named 'AttributeValue3' already belongs to this DataTable

    Oh you're welcome.  That wasn't an error I had come across but I have had...several like that so I know how you feel!

  • Doug Profile Picture
    Doug 110 on at
    RE: MR2012 CU14 DataMart Error: A column named 'AttributeValue3' already belongs to this DataTable

    That appears to have sorted it out. I updated all the UDF1 fields to the same value.

    Thanks so much for your help. I burned a ton of hours on this last week.

    Doug

  • Doug Profile Picture
    Doug 110 on at
    RE: MR2012 CU14 DataMart Error: A column named 'AttributeValue3' already belongs to this DataTable

    Roger,

    I did not find that in my searching, but I bet that is it! I am also unable to access the UDF fields on the Finance when trying to build rows so I think you may be right!

    I will check it out and reply to the thread.

    thx,

    Doug

  • RogerRogerATX Profile Picture
    RogerRogerATX 1,515 on at
    RE: MR2012 CU14 DataMart Error: A column named 'AttributeValue3' already belongs to this DataTable

    Doug, did you check this one?

    community.dynamics.com/.../150693

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans