TableData does not exist

aleix1979

Hullo!

I hava a rather unusual error.

Developing in a SQL database I'm creating, filling and doing operations in a new table. Well, it happens that when I open the same database and company with another user I get "TableData 50001 does not exist" :shock: :-s

If I enter the database with the previous user the data still there. I must make clear that both are Windows login users with the same roles :-k

Any ideas?

aleix1979

And yes, I have syncronised :P

Marije_Brummel

Is it a view to a SQL table?

aleix1979

Sorry maybe I didn't explain myself ok :oops:

The table has been created in Navision. It just happen to be that the Navision Database is stored in SQL and therefore that would have ment the creation of a SQL table.

I never found that :bug: before.

Marije_Brummel

And what about the SQL view flag? Is it false?

aleix1979

I'm afraid I don't know what you mean Mark. :oops:

I've quickly looked the internet and the Enterprise Manager for this SQL view flag but still can't find it.

Can you point me to the right direction? Tell me where to chech? [-o<

Please

Marije_Brummel

Unfortunately I do not have a SQL database here so I cannot check, but I got the same message a couple of days ago and found out that the tabledefinition in Navision was linked to a SQL View, after I had created this view everything worked just fine, but the link can also be set accidentaly in your case.

It is one of the tableproperties in the tabledesigner.

aleix1979

I see what you mean.

I have the property "Linked Object" to no (default). So I understand that should work alright. :P

Any ideas where the :bug: may come from?

Marije_Brummel

Yes, in that case this cannot cause the error.

jmmaniago

NOT so related with the issue BUT I got the same error so might give an idea to others.

In NAV 2009, I created a View directly in SQL DB and run a package I have. I have to deploy the objects one-by-one from the package to check which object causes the error.

Found out I need to delete the records on the existing object I am replacing.
That resolved the issue I have.

zohaibu95@hotmail.com

May be your table is not compiled or it does not exists. I can't tell you exact problem as i m not able to see the database.

zaidtariq

Hi @aleix1979
You may also try the following solutions:
1) Open the SQL Management Studio and Grant the permission of your user as "db_owner". (Ref: http://www.archerpoint.com/blog/Posts/tabledata-2000000001-does-not-exist)
2) Backup Object (TB50001). Delete it and re-import.

zohaibu95@hotmail.com

zaidtariq wrote: »

Hi @aleix1979
You may also try the following solutions:
1) Open the SQL Management Studio and Grant the permission of your user as "db_owner". (Ref: http://www.archerpoint.com/blog/Posts/tabledata-2000000001-does-not-exist)
2) Backup Object (TB50001). Delete it and re-import.

Your point 1 is valid for only system tables.

Mathan

This is post is actually 11 years old.! And thanks for the suggesting the answer.