Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Windows 8 Workstation ...
Microsoft Dynamics SL (Archived)

Windows 8 Workstation Error 56029 Releasing Batch - 2 issues

(0) ShareShare
ReportReport
Posted on by Community Member

When releasing batches in GL I receive System error 6201 : Report execution failed error 56029. Error printing report.  The table  'GLTran' could not be found. 

This is only happening on one workstation.  It is a Windows 8 workstation. 

We are also receiving another error when releasing any other batches (AR, AP and a second error in GL) Failed to retrieve data from database.  Error in File 01acctdi (the account distribution report).

I have this fixed on all other workstation but the same fixes do not work on the windows 8 workstation.  Any ideas?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Windows 8 Workstation Error 56029 Releasing Batch - 2 issues

    Ann,

    Does this workstation happen to have the FRx client installed on it?  There is a hot fix needed for SL 2011 where FRx is installed.  This hot fix corrects some triggers needed by FRx.  While the hot fix does not directly sound like your issue, I found that, without it, clients would randomly, it seems, get situations where SQL would not return data.  You want to download and install B2551470_FRx_SL2011_93Fix whenever you have SL 2011 and FRx triggers have been set.  Not sure this will correct your problem but give it a try if you have not.

  • Community Member Profile Picture
    Community Member on at
    RE: Windows 8 Workstation Error 56029 Releasing Batch - 2 issues

    I have a couple of workstations that don't print the 01AcctDi report when printing batch control reports from all modules (AP, AR, PO).  This problem started when we upgraded to SP1.  We just upgraded to SP2 and it is still happening.  We are all on Windows 7.  The error message received on one workstation is:

    System Message 6201

    Report execution failed.  Error = 56029

    Error Printing Report

    Failed to retrieve data from the database.

    Details:  [Database Vendor Code: 229]

    Failed to retrieve data from the database.

    Error in File 01acctdi {D89BC91D-5DD4-45D2-B449-0BDDE4B59B30}.rpt:

    Failed to retrieve data from the database.

    Details:  [Database Vendor Code: 229].

     

    Has anyone figured out a solution to this problem?

  • Mark Asmus Profile Picture
    Mark Asmus on at
    RE: Windows 8 Workstation Error 56029 Releasing Batch - 2 issues

    Ann,

    Can you paste in the exact error?  That is strange that it only seems to be the one report on the one machine.   Can the same user run the report without error from another machine?

  • Community Member Profile Picture
    Community Member on at
    RE: Windows 8 Workstation Error 56029 Releasing Batch - 2 issues

    Ok So Removing the ODBC sql dsn files for the system and application database resolved the 1st issue but I am still having an issue with the 01AcctDI - failed to retrieve data from database.  I checked the user's rights - he is an admin so he has initialize for everything.

  • Community Member Profile Picture
    Community Member on at
    RE: Windows 8 Workstation Error 56029 Releasing Batch - 2 issues

    PS We recently upgraded from Dynamics 7 FP1 to Dynamics 2011 FP1

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,140 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,895 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans