Re: Unable to Start Service

#1

What is logged in the event application log? It should provide some
info. If it does not, add -o <filespec> to your parameters so that we
can see what the console has logged.

-chris

Mel wrote:

Quote:

Hi,

We have a Virtual Machine that is running Windows Server
2008 R2. On this server we have SQL Anywhere 10.0.1
installed. We have setup a service with the following
parameters:

-c 40M
-n XXXDataSvc
C:\XXX\xxxData.db

When we try and start the service Sybase freezes and has to
be closed. When Sybase is re-opened the status of the
service reads "Start Pending". We are able to open the
database in Sybase so we are sure there is no problems with
the db file itself. Also this exact setup was working on our
old server, which is running Windows Server 2003.

Any help or ideas on solving this issue would be really
appreciated.

Thank you,
Mel

#2

Hi Chris,

I haven't been able to locate an existing log. Is there a
standard file path in SQL Anyhere 10 where this is stored?

I also tried specifying my own file path like this:
C:\ProgramFiles\SQL Anywhere 10\AppLog\sybaseLog.txt

But no output was logged to the file when trying to start
the service.

Thanks,
Mel

Quote:

What is logged in the event application log? It should
provide some info. If it does not, add -o <filespec> to
your parameters so that we can see what the console has
logged.

-chris

Mel wrote:
Hi,

We have a Virtual Machine that is running Windows Server
2008 R2. On this server we have SQL Anywhere 10.0.1
installed. We have setup a service with the following
parameters:

-c 40M
-n XXXDataSvc
C:\XXX\xxxData.db

When we try and start the service Sybase freezes and has
to be closed. When Sybase is re-opened the status of the
service reads "Start Pending". We are able to open the
database in Sybase so we are sure there is no problems
with the db file itself. Also this exact setup was
working on our old server, which is running Windows
Server 2003.
Any help or ideas on solving this issue would be really
appreciated.

Thank you,
Mel

#3

Event logging is provided by the OS.

Go to Control Panel | Adminstrative Tools | Event Viewer and look at
"Application" log.

-chris

Mel wrote:

Quote:

Hi Chris,

I haven't been able to locate an existing log. Is there a
standard file path in SQL Anyhere 10 where this is stored?

I also tried specifying my own file path like this:
C:\ProgramFiles\SQL Anywhere 10\AppLog\sybaseLog.txt

But no output was logged to the file when trying to start
the service.

Thanks,
Mel

What is logged in the event application log? It should
provide some info. If it does not, add -o <filespec> to
your parameters so that we can see what the console has
logged.

-chris

Mel wrote:
Hi,

We have a Virtual Machine that is running Windows Server
2008 R2. On this server we have SQL Anywhere 10.0.1
installed. We have setup a service with the following
parameters:

-c 40M
-n XXXDataSvc
C:\XXX\xxxData.db

When we try and start the service Sybase freezes and has
to be closed. When Sybase is re-opened the status of the
service reads "Start Pending". We are able to open the
database in Sybase so we are sure there is no problems
with the db file itself. Also this exact setup was
working on our old server, which is running Windows
Server 2003.
Any help or ideas on solving this issue would be really
appreciated.

Thank you,
Mel

#4

Ok, thank you. I located the event log via your
instructions.

When trying to strt the service the following three events
are logged (One information event and twi error events):

1. Info: SQLANYs_CHSDataSvc: Starting service
SQLANYs_CHSDataSvc
2. Error: SQLANYs_CHSDataSvc: A database server with that
name has already started
3. Error: SQLANYs_CHSDataSvc: Could not start server

Thanks,
Mel

Quote:

Event logging is provided by the OS.

Go to Control Panel | Adminstrative Tools | Event Viewer
and look at "Application" log.

-chris

Mel wrote:
Hi Chris,

I haven't been able to locate an existing log. Is there
a standard file path in SQL Anyhere 10 where this is
stored?
I also tried specifying my own file path like this:
C:\ProgramFiles\SQL Anywhere 10\AppLog\sybaseLog.txt

But no output was logged to the file when trying to
start the service.

Thanks,
Mel

What is logged in the event application log? It should
provide some info. If it does not, add -o <filespec
to >> your parameters so that we can see what the console
has >> logged.

-chris

Mel wrote:
Hi,

We have a Virtual Machine that is running Windows
Server >>> 2008 R2. On this server we have SQL Anywhere
10.0.1 >>> installed. We have setup a service with the
following >>> parameters:

-c 40M
-n XXXDataSvc
C:\XXX\xxxData.db

When we try and start the service Sybase freezes and
has >>> to be closed. When Sybase is re-opened the status
of the >>> service reads "Start Pending". We are able to
open the >>> database in Sybase so we are sure there is no
problems >>> with the db file itself. Also this exact
setup was >>> working on our old server, which is running
Windows >>> Server 2003.
Any help or ideas on solving this issue would be
really >>> appreciated.

Thank you,
Mel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Unable to Start Service

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: Unable to Start Service - 07-15-2010 , 08:11 PM

Re: Unable to Start Service - 07-16-2010 , 09:20 AM

Re: Unable to Start Service - 07-16-2010 , 09:44 AM

Re: Unable to Start Service - 07-16-2010 , 10:29 AM