web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / show error and failed ...
Microsoft Dynamics GP (Archived)

show error and failed to access to the tables from GP App but the data still inside the tables

(0) ShareShare
ReportReport
Posted on by Community Member

b1bf207e_2D00_b508_2D00_481b_2D00_8d0b_2D00_e3ea22afbdf9.jpg

Hello there,

In my company we use an very old verion of Dynamics, so we are to make it retired during this year, but we can't at the moment, 1 month ago we have started faceing many issue and most of time It show that's attached photo.

can someone just explain to me what's mean that error.

Thanks

*This post is locked for comments

I have the same question (0)
  • Tim Wappat Profile Picture
    Tim Wappat 5,713 on at

    This is a SQL server problem rather than an GP application problem.

    The database is unwell, you may need to involve a SQL server DBA to help you out, depending on your skill levels.

    Check out the article here: support.microsoft.com/.../how-to-troubleshoot-msg-605-with-sql-server

    This is the starting point on your journey.
    Run DBCC CHECKDB and it should report the error.

    Try the fixes that article points to. If you are unsure get a specialist involved. Make certain you have back ups too as you are in a high risk position right now.

    Check your SQL server logs and the event logs of the server it runs on. This may be the sign of an underlying hardware failure or other server problem.

    Good luck on resolving your problem.

    Tim.

  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Backup your database and run the following:

    ALTER DATABASE YourDb SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
BEGIN TRANSACTION;
DBCC CHECKDB ('YourDb', REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE YourDb SET MULTI_USER;


    Make sure you hold on to the results report.

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans