Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum / Error when running his...
Microsoft Dynamics GP forum
Suggested answer

Error when running historical trial balance

(0) ShareShare
ReportReport
Posted on by amadpear 5

Hello,

We have an issue that I cannot seem to crack. When running a 800+ page historical trial report in GP 2016. It would appear to lose connection (guessing) to the server after 80% of report is completed and spits out the error. Error Code: -2147467259, Method `CreateADOConnection` of object `DUserinfo` failed, fetchField.

I can replicate this issue on all but 1 machine where a previously employed made an undocumented change in order for it to work.

Has anyone come across this and or know how to resolve?

Thanks!

Categories:
Reporting and BI
  • amadpear Profile Picture
    amadpear 5 on at
    RE: Error when running historical trial balance

    I am not sure about the customization, but I think it may have been related to UAC as I disabled it and no longer receive the  CreateADOConnection error, but now I am getting an out of memory on all but 1 workstation. GP never uses more than 1gig itself and I have adjusted the virtual memory but the issue still remains. I've read a few posts about it possibly being a corrupted dictionary, but on all machines except the one? Seems more like a system configuration change that might need to happen but for the life of me I can't figure out what.

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,863 on at
    RE: Error when running historical trial balance

    Is there some kind of VBA customization on the report? That is the first thing that popped in my head when seeing the error message.

    Do you know what was exactly modified on the report?

    Joe

  • Flood6 Profile Picture
    Flood6 5 on at
    RE: Error when running historical trial balance
    However, if there are errors on the trial balance, until you locate and correct ... are the history of what the business did during the accounting period.
    peryourhealth
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Error when running historical trial balance

    I really can't find much, other than with the error # of -2147467259 in regards to the CreateADOConnection method, it sounds like the connection with the GP databases is being dropped or lost, which may also make sense as to why the report works on only 1 machine, but not  the others.

    I wonder if there is some type of timeout setting or something that may have been done on the one workstation that wasn't done on the others?

    Hopefully others in the community may have experienced this type of issue and/or have more to add to this.

    Thanks

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans