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.

Assertion while adding Proxy table

6 posts in General Discussion Last posting was on 2007-05-30 13:31:07.0Z
Dave Westphal Posted on 2007-05-14 18:41:20.0Z
From: "Dave Westphal" <Dave_Westphal@aal.org>
Newsgroups: ianywhere.public.general
Subject: Assertion while adding Proxy table
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: xbonat.thrivent.com
X-Original-NNTP-Posting-Host: xbonat.thrivent.com
Message-ID: <4648ad50$1@forums-1-dub>
Date: 14 May 2007 11:41:20 -0700
X-Trace: forums-1-dub 1179168080 64.214.85.60 (14 May 2007 11:41:20 -0700)
X-Original-Trace: 14 May 2007 11:41:20 -0700, xbonat.thrivent.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6002
Article PK: 2462

When I attempt to add a new proxy table using SQL Central I receive the
following Assertion message:

The table could not be created in the database.
Internal database error *** ERROR *** Assertion failed: 102800 (9.0.2.3486)
Unable to delete row from SYSINDEX -- transaction rolled back

If I try to add the Proxy table with selected columns ( selecting all
columns manually ) I am able to add the Proxy table, but if I leave the "all
columns" selected it crashes.

Any ideas on what I can do?

The table I am referencing as a proxy table is in an Oracle database.


Thanks in advance,
Dave


Rob Waywell Posted on 2007-05-15 13:16:49.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4648ad50$1@forums-1-dub>
Subject: Re: Assertion while adding Proxy table
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <4649b2c1$1@forums-1-dub>
Date: 15 May 2007 06:16:49 -0700
X-Trace: forums-1-dub 1179235009 10.25.98.235 (15 May 2007 06:16:49 -0700)
X-Original-Trace: 15 May 2007 06:16:49 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6003
Article PK: 2461

This tech doc provides a good starting point:

Handling an Assertion Failure
http://www.ianywhere.com/developer/technotes/sa_how_to_handle_assertion_error.html

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Dave Westphal" <Dave_Westphal@aal.org> wrote in message
news:4648ad50$1@forums-1-dub...
> When I attempt to add a new proxy table using SQL Central I receive the
> following Assertion message:
>
> The table could not be created in the database.
> Internal database error *** ERROR *** Assertion failed: 102800
> (9.0.2.3486)
> Unable to delete row from SYSINDEX -- transaction rolled back
>
> If I try to add the Proxy table with selected columns ( selecting all
> columns manually ) I am able to add the Proxy table, but if I leave the
> "all columns" selected it crashes.
>
> Any ideas on what I can do?
>
> The table I am referencing as a proxy table is in an Oracle database.
>
>
> Thanks in advance,
> Dave
>


jbrauer Posted on 2007-05-24 18:01:51.0Z
Sender: 9fe.4655bb40.1804289383@sybase.com
From: jbrauer
Newsgroups: ianywhere.public.general
Subject: Re: Assertion while adding Proxy table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4655d30f.da6.1681692777@sybase.com>
References: <4648ad50$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 May 2007 11:01:51 -0700
X-Trace: forums-1-dub 1180029711 10.22.241.41 (24 May 2007 11:01:51 -0700)
X-Original-Trace: 24 May 2007 11:01:51 -0700, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6026
Article PK: 2487

Hi Dave - I've experienced the exact same problem (except on
a slightly older build of ASA9). I am using a script to
create a bunch of proxy tables; it failed on 1 of those
tables (all the others created without any problem).
Have you found any solutions to your issue yet?
Thanks, John


Rob Waywell Posted on 2007-05-25 13:40:32.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4648ad50$1@forums-1-dub> <4655d30f.da6.1681692777@sybase.com>
Subject: Re: Assertion while adding Proxy table
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <4656e750$1@forums-1-dub>
Date: 25 May 2007 06:40:32 -0700
X-Trace: forums-1-dub 1180100432 10.25.98.235 (25 May 2007 06:40:32 -0700)
X-Original-Trace: 25 May 2007 06:40:32 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6028
Article PK: 2485

Are you also seeing an assertion error or is there a different error message
that your script is generating?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

<jbrauer> wrote in message news:4655d30f.da6.1681692777@sybase.com...
> Hi Dave - I've experienced the exact same problem (except on
> a slightly older build of ASA9). I am using a script to
> create a bunch of proxy tables; it failed on 1 of those
> tables (all the others created without any problem).
> Have you found any solutions to your issue yet?
> Thanks, John


jbrauer Posted on 2007-05-29 14:48:52.0Z
Sender: 29bf.465c3bbe.1804289383@sybase.com
From: jbrauer
Newsgroups: ianywhere.public.general
Subject: Re: Assertion while adding Proxy table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <465c3d54.29fb.1681692777@sybase.com>
References: <4656e750$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 May 2007 07:48:52 -0700
X-Trace: forums-1-dub 1180450132 10.22.241.41 (29 May 2007 07:48:52 -0700)
X-Original-Trace: 29 May 2007 07:48:52 -0700, 10.22.241.41
Lines: 46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6036
Article PK: 2494

I tried posting a response to your question a few days but
it looks like it never made it, so here goes again ...
Yes, I was getting an assertion error just like Dave
described earlier. My script was creating proxy tables for
a batch of tables (roughly 50-100) in the Oracle database;
Sybase returned the assertion error when the script hit one
particular table, and it was reproducible; I could not
detect anything unusual about this table that would explain
why the script would have trouble creating the proxy table.
After manually creating the proxy table for this particular
table, the script was able to create the remaining proxy
tables without any trouble. - John

> Are you also seeing an assertion error or is there a
> different error message that your script is generating?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> <jbrauer> wrote in message
> > news:4655d30f.da6.1681692777@sybase.com... Hi Dave -
> > I've experienced the exact same problem (except on a
> > slightly older build of ASA9). I am using a script to
> > create a bunch of proxy tables; it failed on 1 of those
> > tables (all the others created without any problem).
> > Have you found any solutions to your issue yet? Thanks,
> John
>
>


Stephen Rice Posted on 2007-05-30 13:31:07.0Z
From: "Stephen Rice" <sriceATianywhereDOTcom>
Newsgroups: ianywhere.public.general
References: <4656e750$1@forums-1-dub> <465c3d54.29fb.1681692777@sybase.com>
Subject: Re: Assertion while adding Proxy table
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vpn-concord-094.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-094.sybase.com
Message-ID: <465d7c9b$1@forums-1-dub>
Date: 30 May 2007 06:31:07 -0700
X-Trace: forums-1-dub 1180531867 158.159.8.94 (30 May 2007 06:31:07 -0700)
X-Original-Trace: 30 May 2007 06:31:07 -0700, vpn-concord-094.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6043
Article PK: 2502

Did the table have a computed index on it? We just recently fixed a bug in
this area

--
/steve
Stephen Rice
Sybase iAnywhere

<jbrauer> wrote in message news:465c3d54.29fb.1681692777@sybase.com...
>I tried posting a response to your question a few days but
> it looks like it never made it, so here goes again ...
> Yes, I was getting an assertion error just like Dave
> described earlier. My script was creating proxy tables for
> a batch of tables (roughly 50-100) in the Oracle database;
> Sybase returned the assertion error when the script hit one
> particular table, and it was reproducible; I could not
> detect anything unusual about this table that would explain
> why the script would have trouble creating the proxy table.
> After manually creating the proxy table for this particular
> table, the script was able to create the remaining proxy
> tables without any trouble. - John
>
>> Are you also seeing an assertion error or is there a
>> different error message that your script is generating?
>>
>> --
>> -----------------------------------------------
>> Robert Waywell
>> Sybase Adaptive Server Anywhere Developer - Version 8
>> Sybase Certified Professional
>>
>> Sybase's iAnywhere Solutions
>>
>> Please respond ONLY to newsgroup
>>
>> EBF's and Patches: http://downloads.sybase.com
>> choose SQL Anywhere Studio >> change 'time frame' to all
>>
>> To Submit Bug Reports:
>>
> http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>>
>> SQL Anywhere Studio Supported Platforms and Support Status
>> http://my.sybase.com/detail?id=1002288
>>
>> <jbrauer> wrote in message
>> > news:4655d30f.da6.1681692777@sybase.com... Hi Dave -
>> > I've experienced the exact same problem (except on a
>> > slightly older build of ASA9). I am using a script to
>> > create a bunch of proxy tables; it failed on 1 of those
>> > tables (all the others created without any problem).
>> > Have you found any solutions to your issue yet? Thanks,
>> John
>>
>>