Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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
  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Invalid Object Name

    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!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Invalid Object Name

    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?

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,214 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