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 failed: 106105 (10.0.0.2465)

5 posts in QAnywhere Last posting was on 2007-05-16 10:34:57.0Z
Frank Lamers Posted on 2007-05-14 08:08:47.0Z
Sender: 5b97.464817ad.1804289383@sybase.com
From: Frank Lamers
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Assertion failed: 106105 (10.0.0.2465)
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4648190e.5bb5.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub4648190e"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 May 2007 01:08:47 -0700
X-Trace: forums-1-dub 1179130127 10.22.241.41 (14 May 2007 01:08:47 -0700)
X-Original-Trace: 14 May 2007 01:08:47 -0700, 10.22.241.41
Lines: 5355
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:243
Article PK: 18802

Hello,

i'm getting a assertion error.
The first SQL statement works fine:
select distinct(RE102.RE102_ID), RE102.NAAM, * from RE102
left outer join RE103 on (RE102.RE102_ID = RE103.RE102_ID)

The second statement works fine also:
select RE103_ID from RE07 where RLE_ID = '006329'

The combination throws an error:
select distinct(RE102.RE102_ID), RE102.NAAM, * from RE102
left outer join RE103 on (RE102.RE102_ID = RE103.RE102_ID)
where RE103_ID not in (select RE103_ID from RE07 where
RLE_ID = '006329')

The above statement works fine on a version 8 database.

Can anyone please help me?

ScreenShot064.bmp

Rob Waywell Posted on 2007-05-14 13:50:24.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
References: <4648190e.5bb5.1681692777@sybase.com>
Subject: Re: Assertion failed: 106105 (10.0.0.2465)
Lines: 48
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: <46486920@forums-1-dub>
Date: 14 May 2007 06:50:24 -0700
X-Trace: forums-1-dub 1179150624 10.25.98.235 (14 May 2007 06:50:24 -0700)
X-Original-Trace: 14 May 2007 06:50:24 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:244
Article PK: 10476

Start by reviewing this tech doc:

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

<Frank Lamers> wrote in message news:4648190e.5bb5.1681692777@sybase.com...
> Hello,
>
> i'm getting a assertion error.
> The first SQL statement works fine:
> select distinct(RE102.RE102_ID), RE102.NAAM, * from RE102
> left outer join RE103 on (RE102.RE102_ID = RE103.RE102_ID)
>
> The second statement works fine also:
> select RE103_ID from RE07 where RLE_ID = '006329'
>
> The combination throws an error:
> select distinct(RE102.RE102_ID), RE102.NAAM, * from RE102
> left outer join RE103 on (RE102.RE102_ID = RE103.RE102_ID)
> where RE103_ID not in (select RE103_ID from RE07 where
> RLE_ID = '006329')
>
> The above statement works fine on a version 8 database.
>
> Can anyone please help me?
>


Chris Keating (Sybase iAnywhere) Posted on 2007-05-14 17:50:49.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: Assertion failed: 106105 (10.0.0.2465)
References: <4648190e.5bb5.1681692777@sybase.com>
In-Reply-To: <4648190e.5bb5.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <4648a179@forums-1-dub>
Date: 14 May 2007 10:50:49 -0700
X-Trace: forums-1-dub 1179165049 10.25.99.119 (14 May 2007 10:50:49 -0700)
X-Original-Trace: 14 May 2007 10:50:49 -0700, keating-dm20.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:245
Article PK: 10478

I think you may need to submit this to technical support or via the
report a bug server. You can work with technical support to narrow this
down if you are unable to provide a repro. This does not seem to be a
data corruption issue.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Chris Keating (Sybase iAnywhere) Posted on 2007-05-15 15:18:16.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: Assertion failed: 106105 (10.0.0.2465)
References: <4648190e.5bb5.1681692777@sybase.com> <4648a179@forums-1-dub>
In-Reply-To: <4648a179@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <4649cf38$1@forums-1-dub>
Date: 15 May 2007 08:18:16 -0700
X-Trace: forums-1-dub 1179242296 10.25.99.119 (15 May 2007 08:18:16 -0700)
X-Original-Trace: 15 May 2007 08:18:16 -0700, keating-dm20.sybase.com
Lines: 27
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:246
Article PK: 18778

This looks to have been fixed in 10.0.0.2766 as part of Engineering
Case#407390

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************