Friday, February 24, 2012

RTC Report Error The provided metadata is not valid.


Hi all,

While trying to open the Report Layout of a Report i faced a strange error that says.
---------------------------
Microsoft Dynamics NAV Classic
---------------------------
The provided metadata is not valid.
---------------------------

I searched on the web and after finding the solution, i was kind of felling angry.

At one end Microsoft says that when you are trying to run any application in windows 7 try RUN AS Administrator.I had set most of my application to default RUN AS ADMINISTRATOR.

Microsoft says the resolution of the issue i was facing is-

This error can happen when the following conditions are true:

1) You are using Windows Vista and User Access Control (UAC) is turned on.
2) The executable file that runs the Visual Studio development environment (devenv.exe) is set to run as an administrator.
3) The executable file that runs the Classic client with Microsoft SQL Server (finsql.exe) is not set to run as an administrator.

To resolve this issue, set both finsql.exe and devenv.exe to run as an administrator.

Here is the post where i found the solution

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Wednesday, February 22, 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 created.
For Hidden tables, you need to work around.


Steps 
1) Go to File, Alter Database. Select Option Tab.
2) Check Single user & Uncheck Enable for Microsoft Dynamics NAV Server, as shown in image below.










3) Click Ok, after that you will receive message as shown below hit ok.













4) After process get completed, Check Enable for Microsoft Dynamics NAV Server as shown in image below.











5) Click ok on the message that appear. It will process all objects (visible & hidden) as shown below.











6) Once process get completed, goto alter database and uncheck the single user.










Now stop and start the NAV Server service and Run the Role tailored client. It will start working without any issues.

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/



Tuesday, February 14, 2012

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
http://saurav-nav.blogspot.in/

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 Key
2000000070 Error List


Try out the contents by designing a form to the tables by
- open Object Designer
- create new form
- select table from list
- create tabular type form using the wizard
- add all fields
- preview

and you might the answer of your question?

Thanks & Regards
Saurav Dhyani
http://saurav-nav.blogspot.in/

Thursday, February 9, 2012

RTC Report designing NAV2009 Videos


Hi all,

While browsing for RTC Report Development i found out something, which i thought to share will all.


Some videos for Report Designing in RTC have been uploaded in YouTube. 

Have a look on the playlist here.

Thanks & Regards,
Saurav Dhyani

Friday, February 3, 2012

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.