tag:blogger.com,1999:blog-6056741580548629232024-02-19T14:26:02.127-08:00All About ERP - Microsoft Dynamic NavisionUnknownnoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-605674158054862923.post-7087622546834330302018-07-08T21:51:00.003-07:002018-07-08T21:51:40.175-07:00How to replicate specific data from 1 table to other table using LS Retail<div dir="ltr" style="text-align: left;" trbidi="on">
How to replicate specific data from 1 table to other table using LS Retail<br />
<br />
Key :<br />
Replicate specific data from 1 table to other table using LS Retail<br />
Dynamic Navision Classic 2009<br />
LS Retail Data director<br />
Replication<br />
<br />
Case :<br />
Replicate all item on table 27 with Base Unit of Measure "PC"<br />
<br />
Environment :<br />
LS Retail Data director 2.28.5<br />
NAV 2009 Classic<br />
<br />
Steps :<br />
Open NAV<br />
Access LS Retail Scheduler<br />
<b><i>Input the ID, From-table ID, To-table ID, Replication Method : Normal</i></b><br />
<b><i><br /></i></b>
Then access menu From-Table Filters by click button Subjob/From-Table Filters<br />
<b><i>Input Field No. 8, Filter Type : Filter, Value 1 : PC</i></b><br />
<b><i><br /></i></b>
Then Running the scheduler, check your data, if the replication process running successfully or not.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjdvdvsiZ9R6kp-MjYhTG5synHP_JDdNaO2xDzzI6huS3C1IUdld5H9xrjsnpke8mO22dp4YsmoxHD-Qm0_SX0N3mxfSgwikRvEruqImPRKaK2y5w36Dfb-p1y8ET8MpBKG9xxGBzGxQUj/s1600/How+to+replicate+specific+data+from+1+table+to+other+table+using+LS+Retail.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="579" data-original-width="623" height="594" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjdvdvsiZ9R6kp-MjYhTG5synHP_JDdNaO2xDzzI6huS3C1IUdld5H9xrjsnpke8mO22dp4YsmoxHD-Qm0_SX0N3mxfSgwikRvEruqImPRKaK2y5w36Dfb-p1y8ET8MpBKG9xxGBzGxQUj/s640/How+to+replicate+specific+data+from+1+table+to+other+table+using+LS+Retail.PNG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-605674158054862923.post-27084535812667433472018-07-05T20:56:00.003-07:002018-07-08T21:55:58.482-07:00LS Retail Error : EXCEPTION: Error 15990801: T8240 C15990801<div dir="ltr" style="text-align: left;" trbidi="on">
Error captured on event viewer :<br />
<br />
<blockquote class="tr_bq">
EXCEPTION: Error 15990801: T8240 C15990801 There was a time-out in an attempt to establish a connection with the server (TCP/IP error ETIMEDOUT).<br />
See the network documentation for additional information. Contact your system manager if you need assistance.</blockquote>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHxd1hyOCCJZbw7HYrCcKWvSuJ29SyD-pxhvbTczEiCLUNkuFZQ-vV16Qy61HkByg67zsSKriLVUhvTBo19tGtQo6nrK3gqVIZ3QIn_p7EfF88igxUY27Acw-xlUI1fCIDFiJZC1R-VX_5/s1600/EXCEPTION+-+Error+15990801+T8240+C15990801.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="EXCEPTION: Error 15990801: T8240 C15990801 There was a time-out in an attempt to establish a connection with the server (TCP/IP error ETIMEDOUT)." border="0" data-original-height="436" data-original-width="628" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHxd1hyOCCJZbw7HYrCcKWvSuJ29SyD-pxhvbTczEiCLUNkuFZQ-vV16Qy61HkByg67zsSKriLVUhvTBo19tGtQo6nrK3gqVIZ3QIn_p7EfF88igxUY27Acw-xlUI1fCIDFiJZC1R-VX_5/s1600/EXCEPTION+-+Error+15990801+T8240+C15990801.PNG" title="EXCEPTION: Error 15990801: T8240 C15990801 There was a time-out in an attempt to establish a connection with the server (TCP/IP error ETIMEDOUT)." /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Application :<br />
LS Retail Data Director<br />
NAV dynamics 2009<br />
Solution for my case :<br />
<blockquote class="tr_bq">
I just upgrade my Dynamic NAV license, but I am forgot to update it on LS Retail DD,<br />
So I upload the latest license and the problem was resolved.</blockquote>
Steps :<br />
<br />
<ol style="text-align: left;">
<li><b>Open data director setting</b></li>
<li><b>Click button "Dynamics Nav"</b></li>
<li><b>Click button "Load NAV License" to chose the correct NAV license (fin.flf)</b></li>
<li><b>Click b"OK" </b></li>
</ol>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhB7U_tUih3liz-JQiKi8RWv5lz9pdzsxDHigeokMleADwW4AT_EGYcTBWEpQx1gLRS8tM0dCR8ul5PiaDeph4GYosx80rkJz4Q58zoX0swUTQNTlyDkRKhH8oNYnN7wXcErbYT-7ahfyZn/s1600/Data+director+settings+-+version+2.28.5.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Data director setting - microsoft dynamic NAV plugin settings" border="0" data-original-height="472" data-original-width="500" height="603" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhB7U_tUih3liz-JQiKi8RWv5lz9pdzsxDHigeokMleADwW4AT_EGYcTBWEpQx1gLRS8tM0dCR8ul5PiaDeph4GYosx80rkJz4Q58zoX0swUTQNTlyDkRKhH8oNYnN7wXcErbYT-7ahfyZn/s640/Data+director+settings+-+version+2.28.5.PNG" title="Data director setting - microsoft dynamic NAV plugin settings" width="640" /></a></div>
<br />
<br />
<br /></div>
Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-605674158054862923.post-62101884107277550502018-03-13T00:57:00.001-07:002018-03-13T00:57:24.352-07:00Microsoft Dynamics NAV 2009 Web Services<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Bellow is step by step on how to create Microsoft Dynamic NAV 2009 Web Service :<br />
<br />
1. Ensure you already prepare every element that required to running codeunit web service, bellow is the format :<br />
<div>
<blockquote class="tr_bq" style="color: #2a2a2a; font-family: "Segoe UI", "Lucida Grande", Verdana, Arial, Helvetica, sans-serif; line-height: 18px; padding-bottom: 15px;">
<span style="font-size: x-small;"><i>http://<Server>:<WebServicePort>/<ServerInstance>/WS/<CompanyName>/Codeunit/<ServiceName></i></span></blockquote>
<blockquote class="tr_bq">
<span style="font-size: x-small;">Ex. Bellow of the detail of each element :<br />Server : 192.168.10.1<br />Server instance : webservice01<br />WS : WS (the value must be WS)<br />Company name : test_company<br />Codeunit : Codeunit (the value must be Codeunit)<br />Service name : the codeunit service that you created in NAV</span></blockquote>
<br />
2. Copy Service folder from default path : C:\Program Files (x86)\Microsoft Dynamics NAV\60\<b>Service</b></div>
<br />
<blockquote class="tr_bq">
Than rename the folder name to be, for ex. <b>NewService, N</b>ow you have new service folder path : C:\Program Files (x86)\Microsoft Dynamics NAV\60\<b>NewService</b></blockquote>
3. Open Command Prompt than running bellow script (ensure to running it as administrator)<br />
<blockquote class="tr_bq">
SC CREATE "MicrosoftDynamicsNAVWS<b>$WS2</b>" binpath= "C:\Program Files (x86)\Microsoft Dynamics NAV\60\<b>NewService</b>\Microsoft.Dynamics.Nav.Server.exe <b>$WS2</b>" DisplayName= "Microsoft Dynamics NAV Web Services2nd" start= auto obj= "NT Authority\NetworkService" type= Share depend= NetTcpPortSharing</blockquote>
<br />
<b>Where Bold Parameters are mandatory. </b><br />
<br />
These parameters identifies that the service to be created is a web service -<br />
<b>MicrosoftDynamicsNAVWS </b><br />
<b>$WS2</b><br />
<b>type= Share</b><br />
<div>
<br /></div>
<br />
Additional Information :<br />
Codeunit web service<br />
NAV Classic 2009<br />
Windows Server 2008 R2 Enterprise<br />
<br />
<div style="max-width: calc(100% - 25px); padding-right: 25px !important; position: relative !important; width: 596.125px;">
<span style="color: #006d8c; font-family: segoe-ui_semibold, Segoe UI Semibold, Segoe WP, Helvetica Neue, Helvetica, sans-serif;">Note</span></div>
<div style="max-width: calc(100% - 25px); padding-right: 25px !important; position: relative !important; width: 596.125px;">
<span style="color: #006d8c; font-family: segoe-ui_semibold, Segoe UI Semibold, Segoe WP, Helvetica Neue, Helvetica, sans-serif;">The company name is case-sensitive.</span></div>
<br />
Reference :<br />
https://msdn.microsoft.com/en-us/library/dd355398.aspx<br />
https://docs.microsoft.com/en-us/dynamics-nav/walkthrough--creating-and-using-a-codeunit-web-service--soap-<br />
https://saurav-nav.blogspot.co.id/2013/05/running-multiple-web-service-in-nav.html<br />
http://help.sana-commerce.com/sana-commerce-83/advanced-installation-topics/multiple-nav-2009-server-services/create-a-second-service<br />
https://www.archerpoint.com/blog/Posts/setting-ssl-web-services-nav-2009-r2-and-server-2008-r2<br />
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-605674158054862923.post-43722296108498715452016-12-19T18:49:00.000-08:002016-12-19T18:49:37.529-08:00Error when try to access NAV client using database server<div dir="ltr" style="text-align: left;" trbidi="on">
Bellow error message appear when try to access classic NAV using database server. It caused by user Network Service does not have write and read access to the database.fdb<br />
<br />
<blockquote class="tr_bq">
<b>---------------------------</b><b>Microsoft Dynamics NAV Classic</b><b>---------------------------</b><b>The operating system cannot access to the file D:\xxxx.fdb .</b><b><br /></b><b>Verify that the file type and attributes are correct.</b><b><br /></b><b>---------------------------</b><b>OK </b><b>---------------------------</b></blockquote>
<div>
<br /></div>
<div>
<span style="background-color: white; font-family: "Segoe UI", "Segoe UI Web", "Segoe UI Symbol", "Helvetica Neue", "BBAlpha Sans", "S60 Sans", Arial, sans-serif; font-size: 15px;">To resolve this problem, you must give the NT Authority\Network Service logon account read and write access to the Database.fdb file. To do this, follow these steps:</span></div>
<div>
<ol class="sbody-num_list" style="background-color: white; box-sizing: border-box; font-family: "Segoe UI", "Segoe UI Web", "Segoe UI Symbol", "Helvetica Neue", "BBAlpha Sans", "S60 Sans", Arial, sans-serif; font-size: 15px; margin: 0px;">
<li style="box-sizing: border-box; margin-bottom: 20px;">In Windows Explorer, locate the folder that contains the Database.fdb file.</li>
<li style="box-sizing: border-box; margin-bottom: 20px;">Right-click the Database.fdb file, and then click <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Properties</span>.</li>
<li style="box-sizing: border-box; margin-bottom: 20px;">In the <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Properties</span> dialog box, click the <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Security</span> tab, and then click <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Add</span> just under the <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Group or user names</span> area.</li>
<li style="box-sizing: border-box; margin-bottom: 20px;">In the <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Select Users, Computers, or Groups</span> dialog box, type <span class="sbody-userinput" style="box-sizing: border-box; outline: none;">Network Service</span>, and then click <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">OK</span>. <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">NETWORK SERVICE</span> is added to the <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Group or user names</span> area in the <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Properties</span> dialog box.</li>
<li style="box-sizing: border-box; margin-bottom: 20px;">Click <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">NETWORK SERVICE</span>, and then click to select the following check boxes in the <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Allow</span> column in the <span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Permissions for NETWORK SERVICE</span> area:<ul class="sbody-free_list" style="box-sizing: border-box; list-style: disc; margin: 0px; padding: 0px 20px;">
<li style="box-sizing: border-box; margin-bottom: 20px;"><span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Read</span></li>
<li style="box-sizing: border-box; margin-bottom: 20px;"><span class="uiterm" style="box-sizing: border-box; font-weight: 700;">Write</span></li>
</ul>
</li>
</ol>
<span style="background-color: white; font-family: "Segoe UI", "Segoe UI Web", "Segoe UI Symbol", "Helvetica Neue", "BBAlpha Sans", "S60 Sans", Arial, sans-serif; font-size: 15px;">Alternatively, you can use the local system account.</span></div>
<div>
<span style="background-color: white; font-family: "Segoe UI", "Segoe UI Web", "Segoe UI Symbol", "Helvetica Neue", "BBAlpha Sans", "S60 Sans", Arial, sans-serif; font-size: 15px;"><br /></span></div>
<blockquote class="tr_bq">
<span style="background-color: white; font-family: "Segoe UI", "Segoe UI Web", "Segoe UI Symbol", "Helvetica Neue", "BBAlpha Sans", "S60 Sans", Arial, sans-serif; font-size: 15px;">Reference : </span><span style="font-family: Segoe UI, Segoe UI Web, Segoe UI Symbol, Helvetica Neue, BBAlpha Sans, S60 Sans, Arial, sans-serif;"><span style="font-size: 15px;">https://support.microsoft.com/en-us/kb/903196</span></span></blockquote>
<br />
<i>Note : This resolution has been tested and work well on windows 7 pro 64 bit, NAV classic version 2009 R2 </i><br />
<blockquote class="tr_bq">
</blockquote>
<div>
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-605674158054862923.post-51642831129968446942016-10-24T04:05:00.003-07:002016-10-24T04:05:46.456-07:00Error when try to send email via Dynamic NAV 2009 R2 after install new classic client version<div dir="ltr" style="text-align: left;" trbidi="on">
Error when try to send email via Dynamic NAV 2009 R2<br />
<br />
Error Message :<br />
<blockquote class="tr_bq">
<br />
<b>This message is for C/AL programmers:</b><br />
<b>Could not create an instance of the OLE control or Automation server identified by</b><br />
<b>GUID={68AEAA7B-9523-3511-AF5F-F2381D2C6F04} 1.0:{F9DAE2A4-D2F8-37C3-86D5-E4FFE166D860}:Unknown Automation Server.Unknown Class.</b></blockquote>
Condition :<br />
OS Version Windows 7 32 Bit<br />
This problem happen after install the new client Dynamic NAV from Client version 32012 to be 38039<br />
NAV Client (V32012) using mail library version 1.0 and<br />
NAV Client (V38039) using mail library version 7.3<br />
<br />
Cause :<br />
- In my case the problem is caused by new client version use higher email library version (Microsoft.Navision.Mail.dll)<br />
<div style="text-align: left;">
<span style="font-size: large;"><b><br /></b><b>Solution :</b></span></div>
- Error message tell you that the mail library version should be <b><span style="font-size: large;">1.0 </span></b>so please check the registry and ensure key is available and use correct parameter<br />
<br />
<blockquote class="tr_bq">
GUID={68AEAA7B-9523-3511-AF5F-F2381D2C6F04} <b><span style="font-size: large;">1.0</span></b>:{F9DAE2A4-D2F8-37C3-86D5-E4FFE166D860}</blockquote>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHxAYFCzpbCeOMeq97eKWB-7LXjQwoOUYTlJZNcJy02r_295MLkKaFZLPkPywGsunzeaPUWtdj9UOsTNtLS96ntRJcgZiWHAdMuBqkW-x7tpzuGaHiwtaYCvKtfkeRmrJ7lVVL8U-ZkvnX/s1600/Registry+-+Microsoft.NAvision.Mail+VErsion+1.0.JPG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="328" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHxAYFCzpbCeOMeq97eKWB-7LXjQwoOUYTlJZNcJy02r_295MLkKaFZLPkPywGsunzeaPUWtdj9UOsTNtLS96ntRJcgZiWHAdMuBqkW-x7tpzuGaHiwtaYCvKtfkeRmrJ7lVVL8U-ZkvnX/s640/Registry+-+Microsoft.NAvision.Mail+VErsion+1.0.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Figure 1. Registry key Microsoft.Navision.Mail.dll Version 1.0</td></tr>
</tbody></table>
- Then check the version of the library, you can find the Microsoft.Navision.Mail.dll library in<br />
<blockquote class="tr_bq">
C:\Program Files\Common Files\Microsoft Dynamics NAV\Mail\Microsoft.Navision.Mail.dll</blockquote>
<br />
Please ensure that the version is 1.0!!! if not please replace it with version 1.0<br />
in figure bellow show you that system installed wrong library mail version 7.3xxx it should be 1.0xxx :<br />
<br />
note : you can check the library version by right click in the file then select tab details<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqyyY9ZDINYcfs72yL3ASlG3Hx51JETzFY1-nYEaPzpzltOv2iNHP7teZvsi9tbgSjh90xHNeaipJOeHFOR1fWWbGsZ3X5wi7dkWlOPbeJDiItSJNp2fkEKSmPNovdmw_jRF8qDwnSjLUy/s1600/Product+version+of+Microsoft.Navision.Mail.dll.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqyyY9ZDINYcfs72yL3ASlG3Hx51JETzFY1-nYEaPzpzltOv2iNHP7teZvsi9tbgSjh90xHNeaipJOeHFOR1fWWbGsZ3X5wi7dkWlOPbeJDiItSJNp2fkEKSmPNovdmw_jRF8qDwnSjLUy/s1600/Product+version+of+Microsoft.Navision.Mail.dll.jpg" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Product version of Microsoft.Navision.Mail.dll<br /><br /></td></tr>
</tbody></table>
Then just replace that library with version 1.0, you can find it in the master file installation :<br />
<blockquote class="tr_bq">
NAV Client Installer\Common\Microsoft Dynamics NAV\Mail</blockquote>
<br />
After you finish it, please close your NAV client then check it again.<br />
<br />
<div>
<br /></div>
</div>
Unknownnoreply@blogger.com6tag:blogger.com,1999:blog-605674158054862923.post-32126842024047161642016-10-19T20:15:00.001-07:002016-12-19T18:51:24.501-08:00Error when try to to install DLL files using regsvr32 on Windows - The module "LNLTools.dll" was loaded but the call to DllRegisterServer failed with error code 0x8002801c<div dir="ltr" style="text-align: left;" trbidi="on">
Error when try to to install DLL files using regsvr32 on Windows<br />
<br />
Error Message :<br />
<blockquote class="tr_bq">
<b>[Window Title]</b><b>RegSvr32</b><b><br /></b><b>[Content]</b><b>The module "LNLTools.dll" was loaded but the call to DllRegisterServer failed with error code 0x8002801c.</b></blockquote>
<br />
Cause :<br />
This problem is caused by you running CMD (Command Prompt) is not using run as Administrator.<br />
<br />
Solution :<br />
Run CMD using RUN as Administrator</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-605674158054862923.post-48284716750356127142015-10-06T17:14:00.001-07:002015-10-06T17:14:15.047-07:00How to add permission - view server state - SQL server 2008<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
Till now I don not understand why some user need to add permission view server state. This permssion is needed when user try to login into NAV 2009 R2 using classic client.</div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
if you don not add that permission into your user id then NAV will show an error message bellow :</div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
<i>"<b style="color: #045287; font-family: 'Trebuchet MS', 'Lucida Grande', Verdana, sans-serif; font-size: 14px; line-height: 20px; text-align: left;">You cannot start Microsoft Dynamics because you do not have the VIEW SERVER STATE permission on SQL Server.</b>"</i></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt_OF-ROD8hQtt8YYQGAhiOrcpBlsAfyapP3nt0q1NOAVHBv0rs-8hswq5r8LWOIAEOT-JSxvOHvS-8aQdg80uDzXufAEDj83NBrg6TOj4wClIHWEGEHVACXGmqrQz2c6OwItpuWjHCC0M/s1600/Add+permission+-+VIEW+SERVER+STATE+SQL+Server.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="368" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt_OF-ROD8hQtt8YYQGAhiOrcpBlsAfyapP3nt0q1NOAVHBv0rs-8hswq5r8LWOIAEOT-JSxvOHvS-8aQdg80uDzXufAEDj83NBrg6TOj4wClIHWEGEHVACXGmqrQz2c6OwItpuWjHCC0M/s640/Add+permission+-+VIEW+SERVER+STATE+SQL+Server.PNG" width="640" /></a></div>
<br />
<br />
<br />
<ol style="text-align: left;">
<li>Open SQL Server Management Studio</li>
<li>Right click on your server name then click properties</li>
<li>Select properites</li>
<li>Select user id</li>
<li>In the Grant column please tick View server state for the following user id</li>
<li>Click OK button</li>
</ol>
<br />
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-605674158054862923.post-21848351289923187462013-06-11T21:53:00.000-07:002013-06-11T23:23:02.448-07:00Error during report compile in Dynamic Navision 2009 Classic<div dir="ltr" style="text-align: left;" trbidi="on">
In Microsoft Dynamic Navision 2009 Classic, after you modify something on the report like "textbox" you will get error message like this :<br />
<br />
<div style="text-align: left;">
<b><i>"Error while validating RDL content: The Value expression for textbox ... Report Item expressions can only refers to fields within the current data set scope or, if inside an aggregate, the specified data set scope"</i></b></div>
<br />
How to handle that :<br />
if you are only use Microsoft Dynamic Navison in <b>Classic Version</b>, just delete the layout after change the textbox in Section Designer and then compile the report again.<br />
<br />
Open Designer (Ctrl+F2) - Click Menu Tools - Delete Layout<br />
<br />
Other Source :<br />
http://blogs.msdn.com/b/nav/archive/2009/07/02/strange-errors-come-during-change-sourceexpr-value-in-nav-report-designer.aspx<br />
<br /></div>
Unknownnoreply@blogger.com0