Database Information in RTC

Administrator

Database Information in RTC
This page will show you the current database that you are connected to and the current Role Center you are using.

You can change the Role Center by clicking on the name.

To use this page, simply add it to all existing Role Centers.

More information on my blog entries

href="http://dynamicsuser.net/blogs/mark_brummel/archive/2009/11/29/tip-18-nav-2009-rtc-which-database-am-i-logged-into.aspx

and

http://dynamicsuser.net/blogs/mark_brum ... enter.aspx

http://www.mibuso.com/dlinfo.asp?FileID=1159

Discuss this download here.

Meenakshi

I get the following error when try to run Page 50000 for database information.

"The object metadata does not exist. Identification field values: Object Type='Page',ObjectID='50000'

Thanks
M

Marije_Brummel

Is the page compiled? Is your database enabled for the NAV Service tier?

My blog explains more in detail how to implement this page.

www.brummelds.com

Meenakshi

I do have the page complied and database enabled for service tier.. I am trying to run the page directly from object Designer in NAV2009 SP1.
Still getting the error

ara3n

try to restart the service tier.

Delete all the records from object tracking table and recompile

Marije_Brummel

Is the database you have imported the page in the default database for the service tier?

The RUN button only works for the current default database.

http://dynamicsuser.net/blogs/mark_brum ... -cons.aspx

Meenakshi

Now I am getting this error when I try to recompile Page 50000, but I do not have table 2000000048 in Cronus database; hence no table data 2000000048 .

---

Microsoft Dynamics NAV Classic

---

TableData 2000000048 does not exist.

---

OK

---

Meenakshi

Mark Brummel wrote:

Is the database you have imported the page in the default database for the service tier?

The RUN button only works for the current default database.

http://dynamicsuser.net/blogs/mark_brum ... -cons.aspx

Yes it is the default database for my RTC client. I am using Cronus database to test this page...

Marije_Brummel

Are you importing this into a 2009 Native database?

Meenakshi

Mark Brummel wrote:

Are you importing this into a 2009 Native database?

Yes, NAV 2009 SP1 Native Cronus database...Should I import it into the NAV2009SP1 SQL database?

Marije_Brummel

Yes, the service tier does not support native databases.

Please use the finsql.exe to connect to the same database as the service tier.

Meenakshi

It works ...Yay =D> .. Thanks for your help!

Marije_Brummel

No problem, thanks you for downloading and using my tools.

awarn

Thanks so much for this - we had something similar in our old classic client development databases and have been missing this functionality.