Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

General failure in utility

5 posts in General Discussion Last posting was on 2006-04-24 16:09:52.0Z
carl.atkinson Posted on 2006-04-24 14:20:50.0Z
Sender: 7a5d.444cdc06.1804289383@sybase.com
From: carl.atkinson@naturalconvergence.com
Newsgroups: ianywhere.public.general
Subject: General failure in utility
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <444cdec2.7a79.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Apr 2006 07:20:50 -0700
X-Trace: forums-1-dub 1145888450 10.22.241.41 (24 Apr 2006 07:20:50 -0700)
X-Original-Trace: 24 Apr 2006 07:20:50 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5293
Article PK: 1347

Hi there,

I have a dbvalid command that runs at 2:30 in the morning
via cron and it fails every night with a General failure in
utility error. I have tried to reproduce this problem by
running it manually during the day and I have not been
successfull. Any ideas as to what would cause this error?

Help!


Greg Fenton Posted on 2006-04-24 15:33:23.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: General failure in utility
References: <444cdec2.7a79.1681692777@sybase.com>
In-Reply-To: <444cdec2.7a79.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <444cefc3$1@forums-1-dub>
Date: 24 Apr 2006 08:33:23 -0700
X-Trace: forums-1-dub 1145892803 10.25.98.184 (24 Apr 2006 08:33:23 -0700)
X-Original-Trace: 24 Apr 2006 08:33:23 -0700, gfenton-xp.sybase.com
Lines: 34
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5294
Article PK: 1348


carl.atkinson@naturalconvergence.com wrote:
> I have a dbvalid command that runs at 2:30 in the morning
> via cron and it fails every night with a General failure in
> utility error. I have tried to reproduce this problem by
> running it manually during the day and I have not been
> successfull. Any ideas as to what would cause this error?

Please always post the version and build number of SQL Anywhere that you
are using.

Also note that SQL Anywhere questions are better asked in the newsgroup:

sybase.public.sqlanywhere.general

as that is where the vast majority of the SQL Anywhere community hangs out.

Which OS and version are you running this cron job from?
What do you mean by "General failure"?
What are the exact error messages you are getting?

Instead of manually running the dbvalid from your shell, can you copy
the cron entry and have it run at another specified time? The idea here
is that running it from your shell will have a different environment
(different shell, different env vars, etc...) than from the cron
environment.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Carl Atkinson Posted on 2006-04-24 15:58:59.0Z
Sender: 68a3.444ce303.1804289383@sybase.com
From: Carl Atkinson
Newsgroups: ianywhere.public.general
Subject: Re: General failure in utility
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <444ce506.68b9.1681692777@sybase.com>
References: <444cefc3$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 24 Apr 2006 07:47:34 -0700, 10.22.241.42
Lines: 68
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Apr 2006 07:47:36 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Apr 2006 08:58:59 -0700
X-Trace: forums-1-dub 1145894339 10.22.108.75 (24 Apr 2006 08:58:59 -0700)
X-Original-Trace: 24 Apr 2006 08:58:59 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5295
Article PK: 1349


> carl.atkinson@naturalconvergence.com wrote:
> > I have a dbvalid command that runs at 2:30 in the
> > morning via cron and it fails every night with a General
> > failure in utility error. I have tried to reproduce this
> > problem by running it manually during the day and I have
> > not been successfull. Any ideas as to what would cause
> this error?
>
> Please always post the version and build number of SQL
> Anywhere that you are using.
>
> Also note that SQL Anywhere questions are better asked in
> the newsgroup:
>
> sybase.public.sqlanywhere.general
>
> as that is where the vast majority of the SQL Anywhere
> community hangs out.
>
> Which OS and version are you running this cron job from?
> What do you mean by "General failure"?
> What are the exact error messages you are getting?
>
> Instead of manually running the dbvalid from your shell,
> can you copy the cron entry and have it run at another
> specified time? The idea here is that running it from
> your shell will have a different environment (different
> shell, different env vars, etc...) than from the cron
> environment.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Greg,

Thank you for your quick response. I am running Solaris 9
and SQL Anywhere Version 8.0.2.

The General failure is the response I get via the return
code:

dbvalid -o $VKS_DIR/logs/DBvalide.log -f -c
"$uidpasswdStr;dbn=$VKS_DB_NAME;eng=$valid_db_eng;dbf=$backup_dir/nci.db"
>/dev
/null 2>&1
rc=$?

We always get an rc of 1 which indicates a General failure
in utility.

The log shows:

Adaptive Server Anywhere Validation Utility Version
8.0.2.3608
Unable to start database server


I will try changing the cron time for this command and see
what results we get...

Thank you!


Greg Fenton Posted on 2006-04-24 16:07:40.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: General failure in utility
References: <444cefc3$1@forums-1-dub> <444ce506.68b9.1681692777@sybase.com>
In-Reply-To: <444ce506.68b9.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <444ce710$1@forums-2-dub>
X-Original-Trace: 24 Apr 2006 07:56:16 -0700, gfenton-xp.sybase.com
Lines: 32
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Apr 2006 07:56:17 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Apr 2006 09:07:40 -0700
X-Trace: forums-1-dub 1145894860 10.22.108.75 (24 Apr 2006 09:07:40 -0700)
X-Original-Trace: 24 Apr 2006 09:07:40 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5296
Article PK: 1350


Carl Atkinson wrote:
> Unable to start database server
>

So something in the cron environment is not allowing dbvalid to connect
to the database.

You might consider adding the following to your connection string:

;LOG=/tmp/dbvalid_connection.txt

and after a failed connection attempt check the contents of
/tmp/dbvalid_connection.txt. If you are not sure what it is saying,
post the contents of that file.

BTW: is the database expected to be up and running?
Do you really want to automatically start the database if it is not running?

Typically in a production environment you would not want to autostart
the database. So I would recommend removing the DBF parameter from your
connection string (ENG finds the server, DBN finds the database on the
server, DBF is the database file and is used if the client cannot find
DBN running on ENG).

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Carl Posted on 2006-04-24 16:09:52.0Z
Sender: 68c9.444ce627.1804289383@sybase.com
From: Carl
Newsgroups: ianywhere.public.general
Subject: Re: General failure in utility
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <444ce794.68e2.1681692777@sybase.com>
References: <444cefc3$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 24 Apr 2006 07:58:28 -0700, 10.22.241.42
Lines: 50
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Apr 2006 07:58:29 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Apr 2006 09:09:52 -0700
X-Trace: forums-1-dub 1145894992 10.22.108.75 (24 Apr 2006 09:09:52 -0700)
X-Original-Trace: 24 Apr 2006 09:09:52 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5297
Article PK: 1351


> carl.atkinson@naturalconvergence.com wrote:
> > I have a dbvalid command that runs at 2:30 in the
> > morning via cron and it fails every night with a General
> > failure in utility error. I have tried to reproduce this
> > problem by running it manually during the day and I have
> > not been successfull. Any ideas as to what would cause
> this error?
>
> Please always post the version and build number of SQL
> Anywhere that you are using.
>
> Also note that SQL Anywhere questions are better asked in
> the newsgroup:
>
> sybase.public.sqlanywhere.general
>
> as that is where the vast majority of the SQL Anywhere
> community hangs out.
>
> Which OS and version are you running this cron job from?
> What do you mean by "General failure"?
> What are the exact error messages you are getting?
>
> Instead of manually running the dbvalid from your shell,
> can you copy the cron entry and have it run at another
> specified time? The idea here is that running it from
> your shell will have a different environment (different
> shell, different env vars, etc...) than from the cron
> environment.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Hi Greg, thanks for the quick response! I am running Solaris
9 and the SQL Anywhere version is: 8.0.2.3608

The exact error message is:

Adaptive Server Anywhere Validation Utility Version
8.0.2.3608
Unable to start database server

And the return code that I get from dbvalid is: 1 - General
failure in utility.