Table 2000000009 has no name

karthisaha

Hi Everyone,

Recently we are facing a error "Table 2000000009 has no name " while syncing users / importing objects / compiling objects which are using session table as a variable.


Additional info:
This database is working fine from last two year but recently have this error for certain actions.
Database version is NAV 2009 SP1 - Classic only. no RTC.
Size is around 150 GB.

My analysis,

1. Tried to compile all objects and especially system tables in NAV
2. This error denotes session table which is virtual table in NAV and view in SQL. I have checked this view and compared with other database view. There is no any difference.


Thanks in advance.

ara3n

Somebody probably modified the session view on sql server. Open SQL SMS and make sure the view is correct.

karthisaha

Hi ara3n,
Thanks for your reply.

I have checked that view and moreover compared this to another database session view, all are similar.
Please let me know how to check the view in sql?

GreatScott000

Any resolution to this?

karthisaha

No... Still struggling with this...
could not find root cause of this problem ](*,)

Johannes_Nielsen

I have this same error on 2009 R2

Johannes_Nielsen

It was a dev db.
Ended up just restoring a base backup.