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.

RAISERROR - unable to recompile view

2 posts in General Discussion Last posting was on 2009-05-07 21:08:39.0Z
<Ingmar> Posted on 2009-05-05 12:13:32.0Z
From: <Ingmar>
Newsgroups: ianywhere.public.general
Subject: RAISERROR - unable to recompile view
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a002d6c@forums-1-dub>
Date: 5 May 2009 05:13:32 -0700
X-Trace: forums-1-dub 1241525612 10.22.241.152 (5 May 2009 05:13:32 -0700)
X-Original-Trace: 5 May 2009 05:13:32 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7538
Article PK: 5946

Hi,

when I try to unload a database in a new one, i get the following error
("SQL-Fehler: RAISERROR ausgeführt: Unable to recompile view ...").
The view seems to be ok... it can be executed.

I'm using 9.0.2 - build 3804

Regards


Kory Hodgson [Sybase iAnywhere] Posted on 2009-05-07 21:08:39.0Z
From: "Kory Hodgson [Sybase iAnywhere]" <khodgson_nospam@sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: RAISERROR - unable to recompile view
References: <4a002d6c@forums-1-dub>
In-Reply-To: <4a002d6c@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a034dd7$1@forums-1-dub>
Date: 7 May 2009 14:08:39 -0700
X-Trace: forums-1-dub 1241730519 10.22.241.152 (7 May 2009 14:08:39 -0700)
X-Original-Trace: 7 May 2009 14:08:39 -0700, vip152.sybase.com
Lines: 23
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7542
Article PK: 5951

This seems like something that might be worth opening a technical
support case for us to look at.

As a workaround have you tried:

1. drop the view
2. unload/reload the database
3. recreate the view

Ingmar wrote:
> Hi,
>
> when I try to unload a database in a new one, i get the following error
> ("SQL-Fehler: RAISERROR ausgeführt: Unable to recompile view ...").
> The view seems to be ok... it can be executed.
>
> I'm using 9.0.2 - build 3804
>
> Regards
>
>