Mobilink 11.0.1 fails as a service

[tommangano]

I've tried to get ML to start as a service on W2003 and
W2008 Server (not SBS) using Sybase Central. IF (and i mean
if) the service starts, it hogs the processor. Usually it
doesn't start at all. I've also tried to get it to run as a
service by running the following from the CMD prompt, which
is supposed to create a service (bat file is attached also):

@echo off
setlocal

set _SABIN=%SQLANY11%\bin32
set _DBN=MLSync
set _SERVER_NAME=%_DBN%
set _DSN=%_DBN%
set ML_PORT=83

REM
==========================================================================
REM Collect information
REM
==========================================================================
REM By default, run both mobilink and rsoe as commands using
the portable
REM configuration. Options are to enable:
REM - run the hosted configuration
REM - run as services
REM - run either mobilink or rsoe

REM Default options
SET _DO_SERVICE=0
FOR %%A IN (%*) DO (
IF [%%A]==[service] SET _DO_SERVICE=1
)

REM
==========================================================================
REM Start the MobiLink Server
REM
==========================================================================

SET ML_OPTIONS=
SET ML_OPTIONS=%ML_OPTIONS% -c
"uid=dba;pwd=sql;DSN=palatine"
SET ML_OPTIONS=%ML_OPTIONS% -fr
SET ML_OPTIONS=%ML_OPTIONS% -v+ -vh
SET ML_OPTIONS=%ML_OPTIONS% -zu+
SET ML_OPTIONS=%ML_OPTIONS% -dl -w 5 -cn 10 -hwh+
SET ML_OPTIONS=%ML_OPTIONS% -x tcpip(port=2439) -xo
tcpip(port=2440)

set ML_CMDLINE=mlsrv11 %ML_OPTIONS%

:mlservice
if [%_DO_SERVICE%]==[0] GOTO exec_ml
REM Create a service
"%_SABIN%\dbsvc" -i -s automatic -as -t MobiLink -w %_DBN%
%ML_CMDLINE%
"%_SABIN%\dbsvc" -u %_DBN%
goto done_exec_ml

:exec_ml
@echo start %ML_CMDLINE%
start %ML_CMDLINE%
:done_exec_ml

:done
endlocal

[Unknown]

A quick guess ...

Is DSN=palatine a system data source?

Once create what does

dbsvc -g MLSync

show you?

"Tom Mangano" wrote in message news:4b292da6.369...@sybase.com...

[mitch]

On Dec 16, 1:18 pm, "Nick Elson [Sybase iAnywhere]"

<@nick@dot@elson@at@sybase@dot@com@> wrote:
> A quick guess ...
>
>         Is DSN=palatine a system data source?
>
> Once create what does
>
>     dbsvc -g MLSync
>
> show you?
>

> "Tom Mangano" wrote in messagenews:4b292da6.369...@sybase.com...

Thanks for responding so quickly.

Yes, palatine is a system data source.
We have about 5 customers all with the same issue.
Some are running 2003 server.
Some are running 2008 server.

Most of the time the service starts, but it just hangs the machine,
using 90% of the CPU.

When we start it as an application it runs fine.

I've tried creating the service using dbsvc, I got the same results.
I've tried creating the service using sybase central, and got the same
results.

I will run the
dbsvc -g MLSync

This afternoon.

Thanks in advance.

[mitch]

Whoops, one other data point.

This is normally how we launch mlsrv11

mlsrv11 -v+ -fr -vh -c "dsn=db1" -x tcpip(port=2439) -xo tcpip
(port=2440) -zu+ -dl -w 5 -cn 10 -hwh+

[mitch]

On Dec 16, 2:05 pm, mitch <mitch92...@gmail.com> wrote:

Whoops, one other data point.

This is normally how we launch mlsrv11

mlsrv11 -v+ -fr -vh -c "dsn=db1" -x tcpip(port=2439) -xo tcpip

(port=2440) -zu+ -dl -w 5 -cn 10 -hwh+

[Jeff Albion [Sybase iAnywhere]]

Hi Tom,

Which build of 11.0.1 is this? (dbsrv11 -v) Which consolidated database
are you using? Which version of the ODBC driver are you using? (
http://www.sybase.com/detail?id=1062511 ).

Tom Mangano wrote:
> I've tried to get ML to start as a service on W2003 and
> W2008 Server (not SBS) using Sybase Central. IF (and i mean
> if) the service starts, it hogs the processor. Usually it
> doesn't start at all. I've also tried to get it to run as a
> service by running the following from the CMD prompt, which
> is supposed to create a service (bat file is attached also):

A few things to try:

- What happens if you just simply run the MobiLink server from the
command-line?

e.g.

mlsrv11 -c "uid=dba;pwd=sql;DSN=palatine" -fr -v+ -vh -zu+ -dl -w 5 -cn
10 -hwh+ -x tcpip(port=2439) -xo tcpip(port=2440)

- What happens if you add a "-o mlsrv11.txt" to the end of the
start-line when creating the service? What's contained inside the
console log when you try to start the service?

- If the service doesn't start "at all", what is recorded in the system
event logs when this happens?

- Try removing the "-i" switch from dbsvc command ("Interact With
Desktop"). This feature is no longer supported by Microsoft on Windows
Vista, 7, or 2008 and cause odd behaviours with Terminal Services on
older versions.

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

[Jeff Albion [Sybase iAnywhere]]

Hi Mitch,

mitch wrote:
>> Yes, palatine is a system data source.

> Whoops, one other data point.
>
> This is normally how we launch mlsrv11
>
> mlsrv11 -v+ -fr -vh -c "dsn=db1" -x tcpip(port=2439) -xo tcpip
> (port=2440) -zu+ -dl -w 5 -cn 10 -hwh+

What's the difference between "DSN=db1" and "DSN=palatine" ? Is this
discrepancy on purpose?

Why are you including the "-hwh+" switch in this command? This is not an
exposed switch and should be removed.

Also, just as a quick FYI, -zu+ and -fr aren't recommend switches for
production and are usually used only in development. (-zu+ allows anyone
to authenticate, and -fr allows the possibility to lose data due to
missing synchronization scripts).

[mitch]

On Dec 16, 2:18 pm, "Jeff Albion [Sybase iAnywhere]"

> SQL Anywhere Patches and EBFs :http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywh...

> Report a Bug/Open a Case :http://case-express.sybase.com/cx/

The palatine/db1 was just a copy and paste issue.

The .bat file that Tom posted was an earlier attempt to create the
service.

The mlsrv11.exe line that you just commented on was copied out of a
batch file that we
use to launch it as an application.

I will try removing the switch's you suggested.

Thanks

[ilovein...@gmail.com]

On Thursday, 17 December 2009 02:00:31 UTC+5:30, mitch wrote:
> On Dec 16, 2:18 pm, "Jeff Albion [Sybase iAnywhere]" <firstname.lastn...@ianywhere.com> wrote:> Hi Mitch,> > mitch wrote:> >> Yes, palatine is a system data source. > > Whoops, one other data point.> > > This is normally how we launch mlsrv11> > > mlsrv11 -v+ -fr -vh -c "dsn=db1" -x tcpip(port=2439) -xo tcpip > > (port=2440) -zu+ -dl -w 5 -cn 10 -hwh+> > What's the difference between "DSN=db1" and "DSN=palatine" ? Is this > discrepancy on purpose?> > Why are you including the "-hwh+" switch in this command? This is not an > exposed switch and should be removed.> > Also, just as a quick FYI, -zu+ and -fr aren't recommend switches for > production and are usually used only in development. (-zu+ allows anyone > to authenticate, and -fr allows the possibility to lose data due to > missing synchronization scripts).>> Regards,> > --> Jeff Albion, Sybase iAnywhere> > iAnywhere Developer Community :http://www.sybase.com/developer/library/sql-anywhere-techcorner > iAnywhere Documentation :http://www.ianywhere.com/developer/product_manuals > SQL Anywhere Patches and EBFs :http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywh... > Report a Bug/Open a Case :http://case-express.sybase.com/cx/The palatine/db1 was just a copy and paste issue.The .bat file that Tom posted was an earlier attempt to create the service.The mlsrv11.exe line that you just commented on was copied out of a batch file that weuse to launch it as an application.I will try removing the switch's you suggested.Thanks


HI tom ,
i have the same issue of hanging up the issue of system when i am trying to launch the mobile link server