Вернуться   AXForum > Microsoft Dynamics CRM > Dynamics CRM: Blogs
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

Опции темы Поиск в этой теме Опции просмотра
Старый 30.10.2008, 01:59   #1  
Blog bot is offline
Blog bot
24,022 / 809 (75) +++++++
Регистрация: 28.10.2006
If you haven't done so, please read the post about the Service Tier before reading this:-)

A very typical scenario with both partners and customers is to have more than one database. This can be because you have a development database and a production database - or it could be the partner having a copy of all customer databases locally for troubleshooting.

You could of course install the Service Tier locally on all computers - and then change the CustomSettings.config to point to a new database every time you need to logon, but that doesn't really sound like something we want people to do.

The setup we would like to have is:
  • One or more SQL Server boxes with a bunch of databases on
  • One or more Service Tier boxes with at least one Service Tier pr. database
  • The Client installed locally on all machines being able to connect to these Service Tiers.
This post will go into detail about how to accomplish this.

The Simple Story!
To make a long story short - adding a Service Tier isn't any harder than copying the Service directory to another directory (maybe called test) and then registering a new service based on the executable in that folder using the SC command:

SC CREATE testServiceTier binpath= "C:Program FilesMicrosoft Dynamics NAV60testMicrosoft.Dynamics.Nav.Server.exe" start= auto obj= "NT AuthorityNetworkService"

This would actually work if you change the CustomSettings.config to use a different port than 7046 - so why write a big post about it?

And why it isn't that simple after all!
You typically want to use the same port for all your Service Tiers - allowing you to distinguish them on the instance name, and since the default Service Tier doesn't have a dependency on NetTcpPortSharing - you cannot just start adding new ones.

You want a consistent naming algorithm for your Service Tiers, and you want to make sure, that if you create a new Service Tier, it doesn't inherit settings from one of the other Service Tiers by coincidence.

And last but not least, you often want to create a Web Service listener to sit next to your Service Tier (that is of course if you intend to use Web Services).

So - I created a bunch of .BAT files which would do the job for me. Feel free to look at the .BAT files, copy them, use them, modify them, but I do encourage you to send any improvements of the .BAT files to me, so that I can make them available to the community.

Note that I am NOT a .BAT file expert - but I did learn a LOT by creating these .BAT files.

The first 3 .BAT files I created are called:

CreateService.bat, DeleteService.bat and RecreateOriginalService.bat

I think the names speaks for themselves. These .BAT files then have dependencies on another .BAT file, a .VBS script and a new CustomSettings.template - all of these will be included in this post (I hope you are not in a hurry)

The .BAT files needs to be placed in the NAV installation directory (which typically would be C:Program FilesMicrosoft Dynamics NAV60) - and the very first thing you want to do, is to run the RecreateOriginalService.bat.

IF NOT "%1" == "" GOTO usage
IF EXIST "%NAVPATH%serviceMicrosoft.Dynamics.Nav.Server.exe" GOTO NavPathOK
ECHO Unable to locate installation service directory
ECHO Maybe you already ran recreateoriginalservice.bat
goto :eof
IF NOT EXIST "%NAVPATH%service.orgMicrosoft.Dynamics.Nav.Server.exe" GOTO orgok
ECHO Directory already exists
ECHO Maybe you already ran recreateoriginalservice.bat
GOTO :eof
SC stop MicrosoftDynamicsNavWS
SC stop MicrosoftDynamicsNavServer
SC delete MicrosoftDynamicsNavWS
SC delete MicrosoftDynamicsNavServer
RENAME Service
CALL createservice DynamicsNAV auto dummy dummy
COPY /Y customsettings.template service.orgcustomsettings.config
GOTO :eof
ECHO Usage:
ECHO recreateoriginalservice.bat

A couple of comments to the  "source":
  • %~dp0 returns the directory in which the .BAT file is placed (with trailing backslash C:Program FilesMicrosoft Dynamics NAV60)
  • SLEEP.BAT is a small .BAT file which sleeps in a number of seconds (approx.)
  • SC stop <service> - tries to stop a Service (the Service is set in STOP_PENDING mode)
  • SC delete <service> - tries to delete a Service (note that if the Service isn't stopped it will put the Service into a DELETE_PENDING mode which then sometimes requires a server reboot).
  • CustomSettings.template is the original CustomSettings.Config with a few modifications.
  • CreateService.bat is called with two dummy parameters - look below for further explanation
The way this .BAT file works is, that it removes the default installed Service Tier, Renames the Service Directory to and adds the original Service Tier again (using the CustomSettings.config that already was in the Service Directory). After this, it copies in a new CustomSettings.config template with specific fields that later can be auto-replaced by the CreateService.bat. CreateService will create a Service in a directory called the same as the instance name - so after running RecreateOriginalService.bat you will find 2 new directories in the NAV path: DynamicsNAV and instead of the original Service directory.

RecreateOriginalService.bat checks whether it has ran already - so please do not create a Service Tier called Service - you can probably guess why by looking at the .bat file. Also you cannot create services called Classic, Database, RoleTailored Client or OutlookAddin - but who wants to do that anyway.

As you saw, RecreateOriginalService.bat uses a .BAT file called SLEEP.BAT. The main purpose of this .BAT file is to wait for a number of seconds - and there really isn't any command line tool, which works in all versions of Windows that can do this - so I made this one

@ping -n 2 -w 1000 > nul
@ping -n %1% -w 1000 > nul

Works fine - but is kind of strange to look at (that is why it got its own .BAT file).
Vista, Windows Server 2003 and 2008 has a command called TIMEOUT, but that doesn't work on XP.

The CustomSettings.template is a copy of the original CustomSettings.config with 3 changes:

<add key="DatabaseServer" value="#DBSERVER#"></add>
<add key="DatabaseName" value="#DATABASE#"></add>
<add key="ServerInstance" value="#INSTANCE#"></add>

replacing the original DatabaseServer, DatabaseName and ServerInstance with three "variables".

When CreateService.bat is called it will replace these variables with values given on the command line, this way you can create a Service Tier without having to edit the config file afterwards. (very useful when doing testing on multiple Service Tiers)

Now this is the fun stuff...

IF "%1" == "" GOTO usage
IF "%START%" == "" SET START=demand
IF "%START%" == "auto" goto startok
IF "%START%" == "demand" goto startok
IF "%START%" == "disabled" goto startok
ECHO Illegal value for 4th parameter
GOTO usage
IF "%WHICH%" == "" SET WHICH=both
IF "%WHICH%" == "both" goto whichok
IF "%WHICH%" == "servicetier" goto whichok
IF "%WHICH%" == "ws" goto whichok
ECHO Illegal value for 5th parameter
GOTO usage
SET type=own
IF "%WHICH%" == "both" SET type=share
IF EXIST "%NAVPATH%service.orgMicrosoft.Dynamics.Nav.Server.exe" GOTO NavPathOK
ECHO Unable to locate original Service directory
ECHO Maybe you need to run recreateoriginalservice.bat
goto :eof
IF EXIST "%NAVPATH%%SERVICE%Microsoft.Dynamics.Nav.Server.exe" GOTO serviceexists
replacestringinfile.vbs #INSTANCE# %SERVICE% "%SERVICEDIR%customsettings.config"
IF '%DBSERVER%' == '' GOTO editconfig
replacestringinfile.vbs #DBSERVER# %DBSERVER% "%SERVICEDIR%customsettings.config"
IF '%DATABASE%' == '' GOTO editconfig
replacestringinfile.vbs #DATABASE# %DATABASE% "%SERVICEDIR%customsettings.config"
GOTO configdone
NOTEPAD %SERVICEDIR%customsettings.config
SC CONFIG NetTcpPortSharing start= demand
if "%WHICH%" == "ws" goto onlyws
SC CREATE MicrosoftDynamicsNavServer$%SERVICE% binpath= "%SERVICEDIR%Microsoft.Dynamics.Nav.Server.exe $%SERVICE%" DisplayName= "NAV Server %SERVICE%" type= %type% start= %START% obj= "NT AuthorityNetworkService" depend= NetTcpPortSharing
SET DEP=/MicrosoftDynamicsNavServer$%SERVICE%
if "%WHICH%" == "servicetier" goto notws
SC CREATE MicrosoftDynamicsNavWS$%SERVICE% binpath= "%SERVICEDIR%Microsoft.Dynamics.Nav.Server.exe $%SERVICE%" DisplayName= "NAV Server %SERVICE% WS" type= %type% start= %START% obj= "NT AuthorityNetworkService" depend= HTTP/NetTcpPortSharing%DEP%
IF "%START%" == "demand" GOTO :eof
IF "%START%" == "disabled" GOTO :eof
if "%WHICH%" == "ws" goto startws
SC START MicrosoftDynamicsNavServer$%SERVICE%
if "%WHICH%" == "servicetier" goto :eof
SC START MicrosoftDynamicsNavWS$%SERVICE%
goto :eof
ECHO Service already exists
GOTO :eof
ECHO Could not create service directory
GOTO :eof
ECHO Usage:
ECHO CreateService servicetiername [databaseserver] ["databasename"] [demand^|auto^|disabled] [both^|servicetier^|ws]

As you can see in the usage section, you can start the .BAT file with 5 parameters - but only the first is mandatory.

The first parameter is the Service Tier name, and this becomes the name of the directory which holds the executable and the configuration file for this Service Tier (therefore - that one cannot be defaulted)

You should think that host and databasename are mandatory, but if you look in the .bat file it will actually start up notepad and ask you to complete the config file if you don't specify these parameters (this is the reason why RecreateOriginalService.bat calls CreateService with DynamicsNAV dummy dummy - we don't want notepad - and remember the original config file was still there - so no replacements are made).

CreateService.bat can create both Service Tiers and Web Service listeners and default is to create both (using a shared process). It can set the services to auto start, demand start or to be disabled by default.

The Services created by CreateService.bat are called MicrosoftDynamicsNavServer$<instancename> and MicrosoftDynamicsNavWS$<instancename> and the Service description is Nav Server <instancename> and Nav Server <instancename> WS to make sure that they are listed underneath each other in the services list.

The Web Service listener is created with a dependency to the Service Tier (if you create both), so that when restarting the Service Tier - it automatically restarts the Web Service Listener as well - and both services are created with a dependency to NetTcpPortSharing.

I use the replacestringinfile VB Script (can be found later in this post) to replace the template variables in the config file with the values specifies on the command line.

I guess the best way of describing the functionality of CreateService.bat is to give a bunch of examples - that you can validate against the above source.

C:Pro....60>CreateService.bat test

Creates a Service Tier and a Web Service listener with the instance name test and opens Notepad to allow you to specify databaseserver and database name. Both Services are set to start manually and they share one process.

C:Pro....60>CreateService.bat test localhost "Demo Database NAV (6-0)"

Creates a Service Tier and a Web Service listener with the instance name test, pointing to the demo database on localhost. Both Services are set to start manually and they share one process.

C:Pro....60>CreateService.bat test localhost "Demo Database NAV (6-0)" auto servicetier

Creates a Service Tier with the instance name test, pointing to the demo database on localhost. The Service Tier has its own process and starts automatically.

C:Pro....60>CreateService.bat test localhost "Demo Database NAV (6-0)" demand ws

Creates a Web Service listener with the instance name test, pointing to the demo database on localhost. The Service Tier has its own process and is set to start manually.

C:Pro....60>CreateService.bat test mydbserver "Demo Database NAV (6-0)" auto servicetier
C:Pro....60>CreateService.bat test mydbserver "Demo Database NAV (6-0)" auto ws

Creates a Service Tier and a Web Service listener with the instance name test, pointing to the demo database on mydbserver. Both Services are set to start automatically and they each have their own process.

for /L %p in (1,1,50) DO ( createservice.bat test%p localhost "Demo Database NAV (6-0)" )

Creates 50 Service Tiers and Web Service listeners pointing to the demo database on localhost. All pairs share a process and all are set to demand load. Yes, I know that I am probably the only one in this world who would do something like this - but I just wanted to see how many Service Tiers I could install.

The result of that investigation is "unlimited" - I didn't run into any barrier (of course there is a barrier with memory and disk space) by just installing a huge amount of Service Tiers that are set to start manually.

The picture is totally different if I set the Service Tiers to auto start - approx. 50 started Service Tiers managed to eat my available memory and my machine declined to start more services.

DeleteService really isn't that bad. The majority of work here is to make sure that it is a service tier before killing the service, deleting it and removing the directory structure of the service without asking for permission. Should be safe though...

IF "%1" == "" GOTO usage
IF EXIST "%NAVPATH%service.orgMicrosoft.Dynamics.Nav.Server.exe" GOTO NavPathOK
ECHO Unable to locate original Service directory
ECHO Maybe you need to run recreateoriginalservice.bat
goto :eof
IF EXIST "%1Microsoft.Dynamics.Nav.Server.exe" GOTO serviceexists
ECHO Service doesn't exist
GOTO usage
SC query MicrosoftDynamicsNavServer$%1 | FINDSTR "STOPPED"
SC stop MicrosoftDynamicsNavWS$%1
SC stop MicrosoftDynamicsNavServer$%1
SC delete MicrosoftDynamicsNavWS$%1
SC delete MicrosoftDynamicsNavServer$%1
rd %1 /S /Q
GOTO :eof
ECHO Usage:
ECHO DeleteService servicename

A couple of comments to the source:
  • rd %1 /S /Q - removes a directory structure without asking for permission
  • SC query MicrosoftDynamicsNavServer$%1 | FINDSTR "STOPPED" will check whether the Service Tier is stopped
  • DeleteService does absolutely nothing to the database - it only unhooks a service and removes the directory in which it was installed.
BTW - if you tried to create the 50 Service Tiers with CreateService - you can delete them using:

for /L %p in (1,1,50) DO ( deleteservice.bat test%p )

As you saw, CreateService needs to replace a "variable" in a file with a value - like #DBSERVER# -> localhost etc. and there is no command line tool to do that. But fortunately we have the Internet - and I found a nice VBScript on which does exactly what I want:

Dim FileName, Find, ReplaceWith, FileContents, dFileContents
Find = WScript.Arguments(0)
ReplaceWith = WScript.Arguments(1)
FileName = WScript.Arguments(2)

'Read source text file
FileContents = GetFile(FileName)

'replace all string In the source file
dFileContents = replace(FileContents, Find, ReplaceWith, 1, -1, 1)

'Compare source And result
if dFileContents <> FileContents Then
'write result If different
WriteFile FileName, dFileContents

Wscript.Echo "Replace done."
If Len(ReplaceWith) <> Len(Find) Then 'Can we count n of replacements?
Wscript.Echo _
( (Len(dFileContents) - Len(FileContents)) / (Len(ReplaceWith)-Len(Find)) ) & _
" replacements."
End If
Wscript.Echo "Searched string Not In the source file"
End If

'Read text file
function GetFile(FileName)
If FileName<>"" Then
Dim FS, FileStream
Set FS = CreateObject("Scripting.FileSystemObject")
on error resume Next
Set FileStream = FS.OpenTextFile(FileName)
GetFile = FileStream.ReadAll
End If
End Function

'Write string As a text file.
function WriteFile(FileName, Contents)
Dim OutStream, FS

on error resume Next
Set FS = CreateObject("Scripting.FileSystemObject")
Set OutStream = FS.OpenTextFile(FileName, 2, True)
OutStream.Write Contents
End Function

Please go to the Web Site and rate the article if you use the script - I gave it 5 stars:-)

That's all good - but how do I populate the combo box with Service Tiers in the Role Tailored Client?

When you try to select a new service tier in the Role Tailored Client, you choose Select Server in the Microsoft Dynamics NAV menu:

This pops up the Select Server and Company dialog:


But you will notice that the drop down with server names is empty and will only get populated every time you successfully connect to a Service Tier.

If you want to populate this list, you will need to alter the Client Configuration file, which is stored locally on each Client - the path of the file is:

Cocuments and Settings<username>Local SettingsApplication DataMicrosoftMicrosoft Dynamics NAV on my Windows XP and my Windows 2003 Server box and

C:Users<username>AppDataLocalMicrosoftMicrosoft Dynamics NAV on my Vista box.

the config file is called ClientUserSettings.config and the key you want to alter is called UrlHistory. If you modify the key to be:

<add key="UrlHistory" value="localhost/DynamicsNAV,localhost/test" />

You will now have these two selections in the dropdown.

That's it for now

Having these .BAT files in place will allow you to manage your Service Tiers easier.

Please remember that these .BAT files are just listed here as examples and there is absolutely no guarantee that they will work for the purpose you want them to. That is however the nice thing about .BAT files - they can be modified using notepad.

Oh yes - and the price for reading this far is, that you get to download the .BAT files from a ZIP file here

I am also working on creating a couple of .BAT files, which should be placed on the Client to allow remote starting of Service Tiers along with startup of the Role Tailored Client (now where we are creating Services as manual start) - more on this in a later post.

I also think that it would be beneficial for people to get info about challenges for installing a Database Server and a Service Tier in a 3T environment, I do think this is described in the Documentation for NAV.


Freddy Kristiansen

PM Architect

Microsoft Dynamics NAV

Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.

Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Часовой пояс GMT +3, время: 03:14.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.