web
You’re offline. This is a read only version of the page.
close
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 / Finance | Project Operations, Human Resources, ... / Invalid Object Name
Finance | Project Operations, Human Resources, ...
Unanswered

Invalid Object Name

(0) ShareShare
ReportReport
Posted on by Community Member

At first, I got these errors upon logging in to GP.  Deleting ACTIVITY and all of those usual suspects did not work. 

So, I fixed this by logging into GP as "sa" and checked to recreate the auto procedures for Posting Definitions Master in SQL Maintenance.

Now, upon logging into GP, I'm getting a GPS Error: 56 and a message saying that RM00101 is an invalid object name.

Please help!

John

pastedimage1595977432160v1.png

pastedimage1595977444442v2.png

pastedimage1595977473893v3.png

pastedimage1595977486416v4.png

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Do you have a backup from before doing anything? This looks like you dropped some tables. Is a restore possible? What were the original errors you were getting?

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at

    Hello John,

    Thank you for posting your question.

    When i review your screenshots, i don't see any reference to the RM00101 table. I do see the error but this is for the SY00500 table. Did you perhaps mean to say the SY00500?

    The error 'Invalid Object Name' usually occurs when the table is missing. Can you query the SY00500? I suspect you can't as i suspect it no longer exists.

    The error 'Create Table permission denied in database 'S2S'. have you tried running the grant script? If this did not work, then i suspect your SQL Permissions are incorrect for the user.

    Here is what i would try.

    1. Restore a copy of live into test or have all users log out of the company and create a backup so we have a restore potin.
    2. Use PSTL to rebuild the SY00500 table.
      1. PSTL > PSTL Main Setup > ToolKit
      2. Click Next to open the Toolkit window.
      3. Mark the 'Recreate SQL Objects' and click next.
      4. Series = Company.
      5. Table = database name/SY00500
      6. Mark the following radial buttons.
        1. Recreated selected table.
        2. Mark the checkbox recreate data for selected table(s).
      7. Click Perform Maintenance.
      8. If the table exists, you should get a warning that Triggers are on this table.
        1. You will need to back these up and save in a safe location so they can be recreated.
        2. To script a trigger out, use the steps below.
          1. Open SQL.
          2. Log in
          3. Expand the Instance.
          4. Expand the company database.
          5. Expand Tables.
          6. Locate the SY00500 and expand it.
          7. Expand Triggers.
          8. Right click on the trigger and select Script trigger as > Create To > New Query Editor.
          9. This will load in a query.
          10. Save the script in a safe location.
      9. Continue through the pops to rebuild the table.
      10. Run the Trigger scripts against the company database to recreate these using the script you created previously.
    3. Run the Grant Script again the company database.
      1. This is located in the GP Code Folder under SQL.
    4. Now see if you have the same issues.
      1. If you no longer have the same issues, you will need to recreate all your batch headers. This can be done by reconciling batches in each module.

    I hope this helps John!

    Thank you!

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans