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.

sqsh and ASE 15

3 posts in General Discussion Last posting was on 2010-03-09 19:25:18.0Z
cm Posted on 2010-03-04 20:10:17.0Z
Sender: b3c.4b9011b1.1804289383@sybase.com
From: CM
Newsgroups: sybase.public.ase.general
Subject: sqsh and ASE 15
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b9013a9.b8d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Mar 2010 12:10:17 -0800
X-Trace: forums-1-dub 1267733417 10.22.241.41 (4 Mar 2010 12:10:17 -0800)
X-Original-Trace: 4 Mar 2010 12:10:17 -0800, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29026
Article PK: 78263

I installed sqsh on ASE 15.0.3, however, when I tried
calling the utiltiy I get the following error
sybase@jupiter:/home/sybase>$ sqsh -Usa -SJupiter
sqsh-2.1.6 Copyright (C) 1995-2001 Scott C. Gray
Portions Copyright (C) 2004-2008 Michael Peppler
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
Password:
Msg 5704, Level 543450471, State 10
, Procedure '', Line 6655960
nt character set setting to 'utf8'.
Msg 5701, Level 543450471, State 10
, Procedure '', Line 6655960
base context to 'master'.
Msg 5703, Level 543450471, State 10
, Procedure '', Line 6655960
uage setting to 'us_english'.
[1] Jupiter..1>

The character set is utf8. Can anyone assist me with
troubleshooting this?


cm Posted on 2010-03-04 20:13:36.0Z
Sender: b3c.4b9011b1.1804289383@sybase.com
From: CM
Newsgroups: sybase.public.ase.general
Subject: Re: sqsh and ASE 15
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b901470.bd2.1681692777@sybase.com>
References: <4b9013a9.b8d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Mar 2010 12:13:36 -0800
X-Trace: forums-1-dub 1267733616 10.22.241.41 (4 Mar 2010 12:13:36 -0800)
X-Original-Trace: 4 Mar 2010 12:13:36 -0800, 10.22.241.41
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29027
Article PK: 78265

some more information

1] Jupiter..1> select @@servername
[1] Jupiter..2> go
Open Client Message
Layer 114, Origin 95, Severity 116, Number 99
OS Error:
ts(): user api layer: external error: This routine cannot be
called until all fetchable results have been completely
processed.
Jupiter: Aborting on severity 116
Open Client Message
Layer 99, Origin 95, Severity 115, Number 99
OS Error:
rop: cslib user api layer: external error: The context
structure cannot be dropped because the application has not
exited from ct.

> I installed sqsh on ASE 15.0.3, however, when I tried
> calling the utiltiy I get the following error
> sybase@jupiter:/home/sybase>$ sqsh -Usa -SJupiter
> sqsh-2.1.6 Copyright (C) 1995-2001 Scott C. Gray
> Portions Copyright (C) 2004-2008 Michael Peppler
> This is free software with ABSOLUTELY NO WARRANTY
> For more information type '\warranty'
> Password:
> Msg 5704, Level 543450471, State 10
> , Procedure '', Line 6655960
> nt character set setting to 'utf8'.
> Msg 5701, Level 543450471, State 10
> , Procedure '', Line 6655960
> base context to 'master'.
> Msg 5703, Level 543450471, State 10
> , Procedure '', Line 6655960
> uage setting to 'us_english'.
> [1] Jupiter..1>
>
> The character set is utf8. Can anyone assist me with
> troubleshooting this?


Michael Peppler [Team Sybase] Posted on 2010-03-09 19:25:18.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: sqsh and ASE 15
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2010.03.09.19.25.14.154713@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4b9013a9.b8d.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 9 Mar 2010 11:25:18 -0800
X-Trace: forums-1-dub 1268162718 10.22.241.152 (9 Mar 2010 11:25:18 -0800)
X-Original-Trace: 9 Mar 2010 11:25:18 -0800, vip152.sybase.com
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29040
Article PK: 78277

The weird "level" values are a clue. You've built sqsh in 64 bit mode, but
sqsh is unfortunately not smart enough to figure out that it needs to add
a -DSYB_LP64 to the CFLAGS macro when you do this.

To fix - edit the src/Makefile file and add -DSYB_LP64 to the CFLAGS
macro, then rebuild.

Michael

On Thu, 04 Mar 2010 12:10:17 -0800, CM wrote:

> I installed sqsh on ASE 15.0.3, however, when I tried
> calling the utiltiy I get the following error
> sybase@jupiter:/home/sybase>$ sqsh -Usa -SJupiter
> sqsh-2.1.6 Copyright (C) 1995-2001 Scott C. Gray
> Portions Copyright (C) 2004-2008 Michael Peppler
> This is free software with ABSOLUTELY NO WARRANTY
> For more information type '\warranty'
> Password:
> Msg 5704, Level 543450471, State 10
> , Procedure '', Line 6655960
> nt character set setting to 'utf8'.
> Msg 5701, Level 543450471, State 10
> , Procedure '', Line 6655960
> base context to 'master'.
> Msg 5703, Level 543450471, State 10
> , Procedure '', Line 6655960
> uage setting to 'us_english'.
> [1] Jupiter..1>
>
> The character set is utf8. Can anyone assist me with
> troubleshooting this?