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.

SQLAnywhere Monitor : problem with one monitored database

3 posts in General Discussion (old) Last posting was on 2009-09-09 07:52:38.0Z
ps <ps Posted on 2009-09-08 13:57:55.0Z
From: ps <ps@.>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: SQLAnywhere Monitor : problem with one monitored database
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4aa662e3$1@forums-1-dub>
Date: 8 Sep 2009 06:57:55 -0700
X-Trace: forums-1-dub 1252418275 10.22.241.152 (8 Sep 2009 06:57:55 -0700)
X-Original-Trace: 8 Sep 2009 06:57:55 -0700, vip152.sybase.com
Lines: 23
X-Authenticated-User: powerbuilder
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:293
Article PK: 841534

Hi,
We are testing SQLAnywhere Monitor . Everything is fine, except on ONE
database : when adding the ressource, everything is OK, but the status
keeps "UNKNOWN". We have tried to recreate the resource , checked the
sa_monitor objects, ...
We always receive the following email. Any idea about the problem ?

Alert: Monitoring support objects need repair

Server: sa11_YYYY
Database: XXXXXXX
Host:
Time: 2009-09-08 15:50 CEST

Problem:

When you monitor a database, the SQL Anywhere Monitor installs some
support objects into the database. Those objects are now missing.

Advice:

Contact an administrator to repair the configuration for the database.


Dan Petker [Sybase iAnywhere] Posted on 2009-09-08 17:24:22.0Z
From: "Dan Petker [Sybase iAnywhere]" <"dpetker[NO]"@[SPAM]sybase[PLEASE].com>
Reply-To: "dpetker[NO]"@[SPAM]sybase[PLEASE].com
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: SQLAnywhere Monitor : problem with one monitored database
References: <4aa662e3$1@forums-1-dub>
In-Reply-To: <4aa662e3$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4aa69346$1@forums-1-dub>
Date: 8 Sep 2009 10:24:22 -0700
X-Trace: forums-1-dub 1252430662 10.22.241.152 (8 Sep 2009 10:24:22 -0700)
X-Original-Trace: 8 Sep 2009 10:24:22 -0700, vip152.sybase.com
Lines: 41
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:294
Article PK: 866729

Hi,

I have a couple questions about your setup, which should hopefully help
us track down the cause of the problem you're seeing here.

What version of the SQL Anywhere Monitor are you using? What version of
SQL Anywhere is the database that's giving you this error?

Does the database you're trying to monitor have any password
verification functions, post-login procedures or login policies defined
on it?

Thanks,

Dan Petker
iAnywhere Tools Development

ps wrote:
> Hi,
> We are testing SQLAnywhere Monitor . Everything is fine, except on ONE
> database : when adding the ressource, everything is OK, but the status
> keeps "UNKNOWN". We have tried to recreate the resource , checked the
> sa_monitor objects, ...
> We always receive the following email. Any idea about the problem ?
>
> Alert: Monitoring support objects need repair
>
> Server: sa11_YYYY
> Database: XXXXXXX
> Host:
> Time: 2009-09-08 15:50 CEST
>
> Problem:
>
> When you monitor a database, the SQL Anywhere Monitor installs some
> support objects into the database. Those objects are now missing.
>
> Advice:
>
> Contact an administrator to repair the configuration for the database.
>


ps <ps Posted on 2009-09-09 07:52:38.0Z
From: ps <ps@.>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: SQLAnywhere Monitor : problem with one monitored database
References: <4aa662e3$1@forums-1-dub> <4aa69346$1@forums-1-dub>
In-Reply-To: <4aa69346$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4aa75ec6@forums-1-dub>
Date: 9 Sep 2009 00:52:38 -0700
X-Trace: forums-1-dub 1252482758 10.22.241.152 (9 Sep 2009 00:52:38 -0700)
X-Original-Trace: 9 Sep 2009 00:52:38 -0700, vip152.sybase.com
Lines: 51
X-Authenticated-User: powerbuilder
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:295
Article PK: 841535

We use 11.0.1.2250 for sqlanywhere server and monitor. All except one of
the databases of this server are correctly monitored.
I just found the solution. The DB had the following option set :
login_mode=integrated. I changed that to MIXED, and reattached the DB to
Monitor. Everything OK now :-)
Thanks for the help

Philip

Dan Petker [Sybase iAnywhere] wrote:
> Hi,
>
> I have a couple questions about your setup, which should hopefully help
> us track down the cause of the problem you're seeing here.
>
> What version of the SQL Anywhere Monitor are you using? What version of
> SQL Anywhere is the database that's giving you this error?
>
> Does the database you're trying to monitor have any password
> verification functions, post-login procedures or login policies defined
> on it?
>
> Thanks,
>
> Dan Petker
> iAnywhere Tools Development
>
> ps wrote:
>> Hi,
>> We are testing SQLAnywhere Monitor . Everything is fine, except on ONE
>> database : when adding the ressource, everything is OK, but the status
>> keeps "UNKNOWN". We have tried to recreate the resource , checked the
>> sa_monitor objects, ...
>> We always receive the following email. Any idea about the problem ?
>>
>> Alert: Monitoring support objects need repair
>>
>> Server: sa11_YYYY
>> Database: XXXXXXX
>> Host:
>> Time: 2009-09-08 15:50 CEST
>>
>> Problem:
>>
>> When you monitor a database, the SQL Anywhere Monitor installs some
>> support objects into the database. Those objects are now missing.
>>
>> Advice:
>>
>> Contact an administrator to repair the configuration for the database.
>>