Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Report error 56029 Dat...
Finance | Project Operations, Human Resources, ...
Suggested answer

Report error 56029 Database Vendor Code 208

(0) ShareShare
ReportReport
Posted on by emilesenglish 20

I have a report that has been modified to include data from a table that is in the same database but has a different schema.  I have two databases: a test database and the production database.  The report runs fine in the production database but will not run in the Test database.  I receive the error: "Report execution failed.  Error =  56029"  also "Details: [Database Vendor Code: 208]".  I've tried everything I can think of including a value in the "Overridden Qualified Table Name" in Crystal reports and nothing works.

Thanks,

Miles

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Report error 56029 Database Vendor Code 208

    Hello Miles

    208 is an 'invalid object name' error.  The error will probably show the table or view name.  Frequently you get an error like that when the report is using a custom table or view.  Example:  Assume I create a custom table xAPTran and attach that to the AP Trial Balance report.  Then I create a new database and try to run that report on the new database where I have not created that custom table yet.  I'm going to get a 'vendor error 208'.  The 'vendor' is SQL Server, so the error is saying I'm encountering a SQL Server error 208, 'invalid object name' I believe that the error message, probably will tell you what object name is invalid.

    Best Regards,

    Jana MacDonald

    MS Dynamics Support

  • emilesenglish Profile Picture
    emilesenglish 20 on at
    RE: Report error 56029 Database Vendor Code 208

    Thank you for the response.  I have tried this already (actually a few times) and I never get any issues/or messages.  Just that the message that the " database is up to date"

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,270 on at
    RE: Report error 56029 Database Vendor Code 208

    Miles

    When you open the report in crystal, click on verify database, and if you get a message that a field is not found then you may need to verify your tables in the database.

    Let me know if you are getting any messages.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans