Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Error in Management Reporter when running Data Mart integration

Posted on by Microsoft Employee

Hello,

I am trying to run the data mart integration into a clients db in management reporter build 2.1.1037.15.  When I do this, the deployment log comes up with the following error:

[Fiscal Year to Fiscal Year] has encountered an error. Processing will be aborted. Error text: Login failed for user 'CD8359B5576446f85EB67E824B4770'.

this occurs on each integration piece..ex. fiscal year to fiscal year, company to company, etc...

Is anyone else running into this or is there a known fix for it?

Thanks,

Seth

*This post is locked for comments

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Error in Management Reporter when running Data Mart integration

    Yeah, check out this thread ... it worked for me.

    community.dynamics.com/.../224765.aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in Management Reporter when running Data Mart integration

    Was a resolution found for this?  I am running into the same issue.

    Thanks,

    Mark

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error in Management Reporter when running Data Mart integration

    I don't know what this message is exactly looking for but would look at fiscyr in:

    gltran, curyacct, accthist

    Select fiscyr from gltran order by gltran.fiscyr

    Select fiscyr from gltran order by gltran.fiscyr desc

    OR

    select max (fiscyr) from gltran

    select min (fiscyr) from gltran

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Error in Management Reporter when running Data Mart integration

    Hey Seth!

    Yes I am running into it as well. I have an open question it from a few weeks ago.

    ...b

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans