Skip to main content

Posts

Showing posts from February, 2012

Metadata for object of type Table with id 20000000xx is in a failed state. This is caused by a previous exception: Object of type Table with id 20000000xx could not be found.

Hi all, Sometime we face the error while trying to connect or change company in Role Center Client. Metadata for object of type Table with id 20000000xx is in a failed state. This is caused by a previous exception:  Object of type Table with id 20000000xx could not be found.  xx Can Be - 01,07,09,10,20,22,24,26,28,29,37,38,39,40,41,42,43,44,45,46,47,48,49,50,52,53,55,56,58,59,63,70. These are the System Hidden Tables in Navision. For the list of hidden tables refer this post . Where is Metadata Stored? Metadata is stored in Table 2000000071 Object Metadata for all navision objects ( visible / hidden). Why this error? This error occured if there in no metadata for any object in the table. When Metadata is Created? This has been created while we restore the database,if you remeber there is a new process in RTC Versions "PROCESSING OBJECTS" after creating keys. How to create Metadata? For Visible objects you can compile the object and the metadata will be

Microsoft Dynamics Latest News...

Hi all, While browsing partner source today, i found out some good articles which i thought would be great to share on BLOG so others can read and use the information. Updates from Microsoft (* for all these links to work u need a partner source / customer source Login) - 1) Microsoft Dynamics NAV Developer Toolkit Being Discontinued as of October 1, 2011 2)  Microsoft Dynamics NAV 2009 R2 Pricing and Licensing Announcement 3)  Microsoft Dynamics KB Articles Now Publicly Available Online 4)  Mainstream Support for Microsoft Dynamics NAV 5.0 Ends April 2012 5)  Statement of Directions for NAV '7' Updated! 6)  A new Create PDF feature is available in the RoleTailored client of Microsoft Dynamics NAV 2009 Thanks & Regards, Saurav Dhyani www.sauravdhyani.com

Navision List of Hidden Tables

Hi all, Most of time we try to figure out the Hidden Tables in Navision. I required the same list, it took a long time to find all hidden tables, so i thought that it might be useful to others too. This list if for Microsoft Dynamics NAV 2009 R2. 2000000001 Object 2000000007 Date 2000000009 Session 2000000010 Database File 2000000020 Drive 2000000022 File 2000000024 Monitor 2000000026 Integer 2000000028 Table Information 2000000029 System Object 2000000037 Performance 2000000038 AIIObj 2000000039 Printer 2000000040 License Information 2000000041 Field 2000000042 OLE Control 2000000043 License Permission 2000000044 Permission Range 2000000045 Windows Language 2000000046 Automation Servers 2000000047 Server 2000000048 Database 2000000049 Code Coverage 2000000050 Windows Object 2000000052 Windows Group Member 2000000053 Windows Access Control 2000000055 SID - Account ID 2000000056 User SID 2000000058 AllObjWithCaption 2000000059 Breakpoints 2000000063

Copy Navision Data Between Databases using SQL Server

Hi all, Microsoft SQL Server has an import and export wizard that assists you in copying Navision data from one database to another. This import and export wizard is available in any version of SQL Server, and it lets you copy tables, data, functions and other database objects. This is beneficial when you want to move your Navision data to a faster server for better querying performance.