NAV 2013 - Visual Studio Component Require for Report Development.
Reviewed by 0x000216
on
Thursday, October 03, 2013
Rating: 5
Difference between Page Action and Control Action..
Hi all,
While adding actions to pages from view menu we find two options Page Actions & Control Actions as shown below.
Read Complete Article »
While adding actions to pages from view menu we find two options Page Actions & Control Actions as shown below.
Difference between Page Action and Control Action..
Reviewed by 0x000216
on
Saturday, August 31, 2013
Rating: 5
Running Multiple Web Service In NAV 2009, 2009 SP1 & 2009 R2.
Hi all,
In all the previous posts we have discussed about how to create multiple NAV Services to Run Multiple RTC for same or Different version of Role Tailored Client.
But we never discussed about how we can create multiple Web Services.
I required to Publish Multiple Web services and that is the reason i come up with this Post. Hope you will find it use of this post somewhere.
Read Complete Article »
In all the previous posts we have discussed about how to create multiple NAV Services to Run Multiple RTC for same or Different version of Role Tailored Client.
But we never discussed about how we can create multiple Web Services.
I required to Publish Multiple Web services and that is the reason i come up with this Post. Hope you will find it use of this post somewhere.
Running Multiple Web Service In NAV 2009, 2009 SP1 & 2009 R2.
Reviewed by 0x000216
on
Sunday, May 19, 2013
Rating: 5
The date format is incorrect in an Excel worksheet when you export in excel via RTC Client
Hi all,
Today i created a processing only report in navision classic client which used to pull some data into excel.
The format contain the date fields too.
Now while running that report from classic client it works great but while running report from RTC client the date format was incorrect.
If the report would have the field then i would have changed the date format in the RTC Report layout but that was not the case.
Read Complete Article »
Today i created a processing only report in navision classic client which used to pull some data into excel.
The format contain the date fields too.
Now while running that report from classic client it works great but while running report from RTC client the date format was incorrect.
If the report would have the field then i would have changed the date format in the RTC Report layout but that was not the case.
The date format is incorrect in an Excel worksheet when you export in excel via RTC Client
Reviewed by 0x000216
on
Monday, November 26, 2012
Rating: 5
Action Image in Navision 2009, 2009 SP1 & 2009 R2
Hi all,
While Developing Pages for Role Tailored Client we face issues when we create an action an set its prompted to true, and want an image for the action. Below is the screenshot of the page property where we set the image for an action.
Action Image in Navision 2009, 2009 SP1 & 2009 R2
Reviewed by 0x000216
on
Wednesday, November 07, 2012
Rating: 5
Either the caller does not have the required permission or the specified path is read-only.
Hi all,
Sometime while trying to connect to Role tailored client we face an error message which says this -
This can happen with NAV 2009 & later.
Reason -
The reason for error is that the user have not sufficient rights on the service tier or i can say on the service folder in Server.
Resolution -
1) Go to service folder in the server.
2) Right click and select properties.
3) Navigate to security Tab.
4) Click Edit.
5) see user by which you are trying to connect is there, if not add it.
6) If exist check for the permissions in below box.
7) In both the cases assign permission to user.
8) Apply and ok.
9) Restart the service.
10) Connect to RTC Client.
Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/
Sometime while trying to connect to Role tailored client we face an error message which says this -
"Either the caller does not have the required permission or the specified path is read-only."and it looks like -
Reason -
The reason for error is that the user have not sufficient rights on the service tier or i can say on the service folder in Server.
Resolution -
1) Go to service folder in the server.
2) Right click and select properties.
3) Navigate to security Tab.
4) Click Edit.
5) see user by which you are trying to connect is there, if not add it.
6) If exist check for the permissions in below box.
7) In both the cases assign permission to user.
8) Apply and ok.
9) Restart the service.
10) Connect to RTC Client.
Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/
Either the caller does not have the required permission or the specified path is read-only.
Reviewed by 0x000216
on
Tuesday, September 11, 2012
Rating: 5
Debugging in NAV 2009,2009SP1 & NAV2009R2 RTC Client
Hi all,
With the new client version of Navision the debugging process have also been changed.
This post contain details of NAV 2009, NAV 2009 SP1 and NAV 2009 R2 RTC Client.
First step is to Stop the Microsoft Dynamics NAV Server Service.
With the new client version of Navision the debugging process have also been changed.
This post contain details of NAV 2009, NAV 2009 SP1 and NAV 2009 R2 RTC Client.
First step is to Stop the Microsoft Dynamics NAV Server Service.
Then we need to don EnableDebugging in CustomSettings.config found here: C:\Program Files\Microsoft Dynamics NAV\60\Service.
Now start the Microsoft Dynamics NAV Server Service.
Now we have debugging enabled. Now start the RoleTailored client. This will take a bit longer to start up, because C# files are generated for each of the objects. (Pages, Codeunits, Reports etc.) - .cs files will be created.
In this example I will make a codeunit with a simple message and add this to an action on the Customer list.
Create a Codeunit. Ex. 50000
OnRun trigger place the following code: MESSAGE ('Debug test')
Save and compile Codeunit 50000.
Now let us add this codeunit to a action. Design page 22 and navigate to the Actions on page 22.
Insert a new action below the the Customer Action group
Hit F9 and enter this code on the Debug test - OnAction trigger: CODEUNIT.RUN(50000);
Save and compile page 22
we now have all code completed so now let us set a breakpoint in Visual Studio.
Navigate to “C:\ProgramData\Microsoft\Microsoft Dynamics NAV\60\Server\MicrosoftDynamicsNavServer\source\Codeunit” IN WINDOWS 7
Assuming that you have Visual Studio installed, (In my case I’m using Visual Studio 2008 with SP1) open Codeunit50000.cs
If you have UAC turned you will need to open Visual Studio with “Run as administrator”.
Now we need to attach the NAV service. Select “Debug / Attach to process…”
Attach Microsoft.Dynamics.Nav.Server.exe
Your screen should now look like this:
Now add a break point on the message “Debug test”
With this done now let us go to RoleTailored client.
Navigate to Customer List and see that you have a new action called “Debug test” under “Related Information”
Now select “Debug test”
Visual Studio will come back in focus with the breakpoint selected.
Now try to hit F5 and debugging will continue and RoleTailored client will come back in focus and show the message “Debug test”:
"In Next post i will discuss the Debugging Process in NAV 2013 which is an enhanced version of Debugging. i Personally feel that its a better version than debugger in classic client and RTC Client till NAV 2009 R2."
Regards,
Saurav Dhyani
Debugging in NAV 2009,2009SP1 & NAV2009R2 RTC Client
Reviewed by 0x000216
on
Sunday, August 26, 2012
Rating: 5
Microsoft Dynamics NAV Client has stopped working..
Hi all,
some time we face issues when RTC Client Crashes. There can be multiple issues for the same. below is the screen shot for same.
The Event Viewer Details for the Error is -.NET Runtime 2.0 Error Reporting.
EventType clr20r3, P1 microsoft.dynamics.nav.client, P2 6.0.0.0, P3 4d030e65, P4 microsoft.dynamics.nav.client.ui, P5 6.0.0.0, P6 4d030e5c, P7 74e, P8 69, P9 k0r55xemoobpb22dbjzdn4p0sfjo3u25, P10 NIL.
Below is the error message for same.
Generally these issues comes due to issues in Role Center Pages in Navision 2009 and later. You can filter objects by using filter @*Role* in Pages. Below is the List of Pages in NAV 2009 SP1 IN Database.
Case 1 - When the values in cues is negative. Then due to having a negative value in integer field crashes the client. These tables can be found by filtering tables in NAV 2009 & later by @*cue*. Below is the List of Tables in NAV 2009 SP1 IN Database.
Most of the fields in these tables are flowfield, if by anycase the value comes to be Negative the RTC Client Crashes.
Case 2 - A wired cases i found out that Notes(a system part in RTC Pages) have not been supported in NAV 2009 R2 FI version. Every Role Center Page have generally this part.
THERE CAN BE OTHER CASES WHICH YOU MIGHT ENCOUNTER DURING USING RTC.
How to find the cause of the crashing?
Start the Role Tailored Client and start debugger, by selecting the Debug the Program.
For Case 1 - When you start Debugging, it will break at a point where you will find an error as shown in screen below.
The error message says that Argument must be non-negative so it means that the cue of role center page that is loading have a negative value. You can go the tables list provided above, run them and check where its getting a negative value.
For Case 2 - When you start Debugging, it will break at a point where you will find an error as shown in screen below.
The error message says that Form My Notification Must Close so it means that the system is unable to load the Notes part of the page. You can design the page and delete the Notes Part from Role center pages.
The point where debugger stops shows the exact error.
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/
Microsoft Dynamics NAV Client has stopped working..
Reviewed by 0x000216
on
Wednesday, July 04, 2012
Rating: 5
Could not connect to the SQL database. (-2147467259 master ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on.
Hi all,
During Installation of NAV 2009 & Later, sometime we come across an error which says -
Could not connect to the SQL database. (-2147467259 master ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on.
This error can be occured due to multile Reasons, so there are mutiple resoultion for the same.
Resolutions -
1) Did u Run installer as Administrator (If Operating system is Windows 7)?
If not then try intalling using Run as Administrator.
2) Go to services.msc from RUN and check that SQL Server service is running or not. If not start the service and try intalling again.
3) Your Windows does not have sufficient priviledges on the SQL Server. Set up your account with the sysadm server role. Note, that you cannot rely on indirect permissions through Windows group memberships when Vista User Access Control (UAC) is turned on. Try seraching UAC in Control Panel.
4) A previous installation has left the database files (mdf+ldf) sitting in the \Program Files\Microsoft Dynamics NAV\60\Database\ folder and the SQL Server has been reinstalled. This will result in the installer trying to attach an orphaned database. If this is the case, then you should just delete the files or Rename the Database, run the installation once where you select to remove the database components, and run the installation once again where you select to install the demo database.
These are the comman resolutions in this case i was able to find it. I hope someone might be helpfull and it resolve someones issues.
Thanks & Regards,
Saurav Dhyani
Could not connect to the SQL database. (-2147467259 master ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on.
Reviewed by 0x000216
on
Sunday, June 03, 2012
Rating: 5
Microsoft Dynamics NAV RTC The type 'Option' is unsupported for the min/max validation rule.
Hi all,
After an upgrade to NAV 2009 RTC from classic client, a client locked an wiered issue.
While accessing a page from Role center client he was getting the error message
"The type 'Option' is unsupported for the min/max validation rule".
I checked the page, complied the page but no luck.
I checked the tables too that there might be an option field as the message says something about option
but no luck.I was not getting the resolution, so i started deleting the fields from page and i identified the field
which was giving error. To my surprise it was a Option type of field.
I went to properties and identified that the min value for the field have been set to Ship.
I don't know why but when i cleared these two values from field properties, the page started working.
Resolution -
1) Check the properties of Option Type Field In Table.
2) Check the fields in source table and remove the min & Max value for fields.
3) Remove the values for these properties and issue resolved as shown in image below.
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/
Microsoft Dynamics NAV RTC The type 'Option' is unsupported for the min/max validation rule.
Reviewed by 0x000216
on
Friday, June 01, 2012
Rating: 5
Navision RTC Shortcuts vs Classic Shortcuts
Hi all,
With new release of Role Tailored Client the major problem user & consultants faced is of the shortcuts.
The shortcuts that we used till date for the classic client are behaving so wired when we try them on Role Tailored Client.
Like Ctrl + F8 was used to zoom the line but nothing happens in Role Tailored Client.
F3 was used to create a new record but cursor moves to filter field in Role Tailored Client.
and many more.
Yeah Ctrl + O still works in same way as it does in classic client.
Now after release of NAV 7 / 2013 these shortcuts will not be used as classic client does not exist, so i started learning new shortcuts.
While learning these shortcuts i figured out a pattern that these shortcuts are similar to that of any windows application. As for a new document we used Ctrl + N in Microsoft word and excel, new navision RTC shortcuts are similar to these.
so lets study and make our work easy by learning these shortcuts. The list of shortcuts can be found at this link.
Navision Classic & RTC Shortcuts.
Let me know if you find it usefull.
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/
With new release of Role Tailored Client the major problem user & consultants faced is of the shortcuts.
The shortcuts that we used till date for the classic client are behaving so wired when we try them on Role Tailored Client.
Like Ctrl + F8 was used to zoom the line but nothing happens in Role Tailored Client.
F3 was used to create a new record but cursor moves to filter field in Role Tailored Client.
and many more.
Yeah Ctrl + O still works in same way as it does in classic client.
Now after release of NAV 7 / 2013 these shortcuts will not be used as classic client does not exist, so i started learning new shortcuts.
While learning these shortcuts i figured out a pattern that these shortcuts are similar to that of any windows application. As for a new document we used Ctrl + N in Microsoft word and excel, new navision RTC shortcuts are similar to these.
so lets study and make our work easy by learning these shortcuts. The list of shortcuts can be found at this link.
Navision Classic & RTC Shortcuts.
Let me know if you find it usefull.
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/
Navision RTC Shortcuts vs Classic Shortcuts
Reviewed by 0x000216
on
Thursday, May 17, 2012
Rating: 5
Remove RTC Service Address Selection?
Hi all,
while connecting to RTC and we have multiple services we find mutiple URL for the service to connect in the window of select server.
Lets see how we can remove the list.
Resolution -
Once we try to connect to a particular service it get stored in the URLHistory key of the client user setting files which is stored in the "C:\Users\username\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\60". Delete the value from the URLHistory and yes that it, the list will be removed.
I hope you will find the soultion usefull.
Thanks & Regards,
Saurav Dhyani
Remove RTC Service Address Selection?
Reviewed by 0x000216
on
Wednesday, April 18, 2012
Rating: 5
NAV 7 or NAV 2013 Videos
Hi all,
NAV TecDays 2011 just ended. Don't worry if you haven't attended the same. Please go to the link for downloading videos and Presentation of NAV Tecdays 2011..
List of Videos Available on mibuso -
1) NAV TechDays 2011: Let's bring the RoleTailored Client to the next level (Movie)
2) NAV TechDays 2011: Administrating NAV '7.0' with Windows PowerShell 2.0
3) NAV TechDays 2011: Administrating NAV '7.0' with Windows PowerShell 2.0 (Movie)
4) NAV TechDays 2011: Opening Keynote (Movie)
5) NAV TechDays 2011: Developer Tools in NAV '7.0' (Movie)
6) NAV TechDays 2011: Reporting story in NAV '7.0' (Movie)
7) RTC AddIn DragNDrop
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/
NAV TecDays 2011 just ended. Don't worry if you haven't attended the same. Please go to the link for downloading videos and Presentation of NAV Tecdays 2011..
List of Videos Available on mibuso -
1) NAV TechDays 2011: Let's bring the RoleTailored Client to the next level (Movie)
2) NAV TechDays 2011: Administrating NAV '7.0' with Windows PowerShell 2.0
3) NAV TechDays 2011: Administrating NAV '7.0' with Windows PowerShell 2.0 (Movie)
4) NAV TechDays 2011: Opening Keynote (Movie)
5) NAV TechDays 2011: Developer Tools in NAV '7.0' (Movie)
6) NAV TechDays 2011: Reporting story in NAV '7.0' (Movie)
7) RTC AddIn DragNDrop
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/
NAV 7 or NAV 2013 Videos
Reviewed by 0x000216
on
Monday, April 09, 2012
Rating: 5
Multiple RTC on Same Machine with Startup Error Resolved
Hi all,
I was just thinking that there should an way that when we start an diffrent RTC Client that is not installed in machine, we should not get an error.
If you haven't read the post how to do it then go to the link.
Why it happens -
Role Tailored Client trys to pull up the last service that have been used succesfully to connect. As in earlier post we created mutiple services for multiple versions
and every service is running. So how the RTC client will figure out which service to run when we click on shortcut of a particular version RTC.
OLD Story -
If you read this post about the command prompt parameter for Role Tailored client then it would be easier to Understand.
How we make RTC Icon to identify which service file it should Pick?
My current system status -
Services -
Version Port
NAV 2009 4046 & 4047
NAV 2009 SP1 5046 & 5047
NAV 2009 R2 6046 & 6047
Let's Search for a file Clientusersettings, you will find one HIDDEN file inside "C:\Users\username\AppData\Local\Microsoft\Microsoft Dynamics NAV\".
Lets see what this file contain, Below is the image for same.
If you want to find about all parameters then goto the link. I will describe only those are required right now.
Server - consist of Navision Server Name where Service tier exist.
Server Instance - Instance of Service by default it is DynamicsNAV.
ServerPort - Where you want to connect.
URL History - THE URL Of navision that was last connected.
so what i will do is that i will copy this file and will save it inside the same folder where my .exe are present (C:\Program Files (x86)\Microsoft Dynamics NAV\60)
and name them in the format like
FOR 2009 ClientUserSettings2009
FOR 2009 SP1 ClientUserSettings2009SP1
FOR 2009 R2 ClientUserSettings2009R2
Now lets do the configuration -
I went to Desktop where my shortcuts have been created for diffrent versions. I went to properties of every icon and at the end of the Target line i specified the
setting file that need to be used when i will try to run the cient.
-settings:"C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ClientUserSettings2009.config"
-settings:"C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ClientUserSettings 2009SP1.config"
-settings:"C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 R2 IN\ClientUserSettings2009R2.config"
The whole command in Target for NAV 2009 R2 is now -
"C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 R2 IN\RoleTailored Client\Microsoft.Dynamics.Nav.Client.exe" -settings:"C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 R2 IN\ClientUserSettings2009R2.config"
Now when i will click on the particular icon it will start the specified RTC Database without an error.
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/
Multiple RTC on Same Machine with Startup Error Resolved
Reviewed by 0x000216
on
Sunday, April 08, 2012
Rating: 5
ZUP File / Personalization Settings in Navision Role Tailored Client.
Hi all,
I did some changes in the pages & Reports During run time and save the view.Now i wanted to revert those changes to the standard Navision settings.
In Microsoft Dynamics Navision Classic Client we can do this by deleting the zup file as this file store all the personalization settings.But what about the Role tailored Client?
For Role Tailored Client there are two ways to do it -
1) Delete the PersonalizationStore.xml.
This file is located at \Administrator\Application Data\Microsoft\Microsoft Dynamics NAV.This file is used to store all user changes like resizing the columns in the pages. You can delete this file, If you want to roll back all the changes.
The Problem with Way 1 is that it will delete all your settings, what if if you dont want to delete all personalization settings but selective setting. Here is the another way.
2) Go to Object designer, & Run Table 2000000080 Page Data Personalization.
This table contain a record for each personalization done by every user.
so you can filter the user and the object (Page,Report,XMLPORT) from which you want to delete the personalization settings. You cannot see the value that you set as it is stored as BLOB.Refer to screen below.
By Using Way 2 you can delete the selective personalization setting you want to delete.
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/
ZUP File / Personalization Settings in Navision Role Tailored Client.
Reviewed by 0x000216
on
Saturday, March 17, 2012
Rating: 5
RTC Report It is not possible to instantiate the Visual Studio bridge.
Hi all,
As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions -
NAV 2009 R2 - is installed.
NAV 2009 SP1 - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\
NAV 2009 - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\
This approach has been working great for execution of Classic and RTC Clients.
However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error:
---------------------------
Microsoft Dynamics NAV Classic
---------------------------
It is not possible to instantiate the Visual Studio bridge.
---------------------------
OK
---------------------------
After searching for the error i figured out the issue was due to -
Design change in NAV 2009 R2 which uses the .NetBridge rather than the old Visual Studio bridge component.
Solution OR Work Around
The Visual Studio bridge files are included with the binaries in the NAV 2009 SP1 Classic Client folder
so we can avoid the above error by running REGASM.EXE to register the DLL.
The REGASM.EXE is included in the .Net Framework folder so executing the following command from within the NAV 2009 SP1 Classic Client folder will remove the error.
Steps to Resolve the issue
1) Start Command Prompt (* Run as administrator if windows 7)
2) Change directory to location where NAV 2009 SP1 classic is placed.
In my case it is C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\Classic\
So command is CD C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\Classic\.
3) Now find the Location of regasm.exe which is located in .NET Framework
In my machine the path is C:\Windows\Microsoft.NET\Framework64\v2.0.50727\ (for 64 bit)
C:\Windows\Microsoft.NET\Framework\v2.0.50727\ (for 32 bit)
4) Now in command prompt run the command
C:\Windows\Microsoft.NET\Framework64\v2.0.50727\regasm.exe Microsoft.Dynamics.Nav.VisualStudioBridge.DLL (64 bit)
C:\Windows\Microsoft.NET\Framework\v2.0.50727\regasm.exe Microsoft.Dynamics.Nav.VisualStudioBridge.DLL (32 bit)
* you can find Microsoft.Dynamics.Nav.VisualStudioBridge.DLL inside classic folder.
5) If everything is correct, you will receive a message "Type Registered Succesfully" as shown in image below.
Problem Resolved !
Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/
RTC Report It is not possible to instantiate the Visual Studio bridge.
Reviewed by 0x000216
on
Wednesday, February 29, 2012
Rating: 5
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/
RTC Report Error The provided metadata is not valid.
Reviewed by 0x000216
on
Friday, February 24, 2012
Rating: 5
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/
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.
Reviewed by 0x000216
on
Wednesday, February 22, 2012
Rating: 5
RTC Error The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Hi all,
Which doing a implentation i found a error, and i thought of sharing same so that others who face this issue can reslove same without spending time which i did.
Everything done, from syncronization, change listener but the error remains same as shown in screenshot below.
After searching i found out at MSDN that this is due to SQL Server and Firewall.
For SQL Server the ports used is 1433.
Steps to Resolve Error -
1) On the Start menu, click Run, type WF.msc, and then click OK.
2) In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.
3) In the Rule Type dialog box, select Port, and then click Next.
4) In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Click Next.
5) In the Action dialog box, select Allow the connection, and then click Next.
6) In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.
7) In the Name dialog box, type a name and description for this rule, and then click Finish.
After this restart the service and try to connect to Role Tailored Client. You should be able to connect as i did.
Thanks & Regards,
Saurav Dhyani
RTC Error The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Reviewed by 0x000216
on
Saturday, January 14, 2012
Rating: 5