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.

Connecting to remote Sybase ASE 15 server causes arithmetic overflow during login trigger

8 posts in General Discussion Last posting was on 2013-02-20 23:29:52.0Z
timwoj Posted on 2013-02-19 15:56:27.0Z
Sender: 70fb.5123a07b.1804289383@sybase.com
From: timwoj
Newsgroups: sybase.public.ase.general
Subject: Connecting to remote Sybase ASE 15 server causes arithmetic overflow during login trigger
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5123a0aa.7107.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 19 Feb 2013 07:56:27 -0800
X-Trace: forums-1-dub 1361289387 172.20.134.41 (19 Feb 2013 07:56:27 -0800)
X-Original-Trace: 19 Feb 2013 07:56:27 -0800, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31704
Article PK: 1307764

I have a SYBASE ASE 15 server that I'm attempting to connect
to remotely. The user I'm attempting to login as has a
login trigger configured that sets a couple of the sso and
sa roles. I can login locally with the user and everything
works fine. I'm able to do everything I need to as the
user.

Logging in remotely is another story. I get the same errors
as above, but any query after logging in results in the
following error:

Execution of login script '' failed with last error = 3606.
See server errorlog for details.

If I look at the error log on the server, it does have that
error, which is an arithmetic overflow. Does anyone have
any ideas why a login would throw an arithmetic overflow?
I'm fairly convinced it doesn't have anything to do with the
login script at this point, but I'm still not entirely sure.


Rob V Posted on 2013-02-19 23:05:56.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130107 Thunderbird/17.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Connecting to remote Sybase ASE 15 server causes arithmetic overflow during login trigger
References: <5123a0aa.7107.1681692777@sybase.com>
In-Reply-To: <5123a0aa.7107.1681692777@sybase.com>
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: <51240554@forums-1-dub>
Date: 19 Feb 2013 15:05:56 -0800
X-Trace: forums-1-dub 1361315156 172.20.134.152 (19 Feb 2013 15:05:56 -0800)
X-Original-Trace: 19 Feb 2013 15:05:56 -0800, vip152.sybase.com
Lines: 47
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31705
Article PK: 1307790


On 19-Feb-2013 16:56, timwoj wrote:
> I have a SYBASE ASE 15 server that I'm attempting to connect
> to remotely. The user I'm attempting to login as has a
> login trigger configured that sets a couple of the sso and
> sa roles. I can login locally with the user and everything
> works fine. I'm able to do everything I need to as the
> user.
>
> Logging in remotely is another story. I get the same errors
> as above, but any query after logging in results in the
> following error:
>
> Execution of login script '' failed with last error = 3606.
> See server errorlog for details.
>
> If I look at the error log on the server, it does have that
> error, which is an arithmetic overflow. Does anyone have
> any ideas why a login would throw an arithmetic overflow?
> I'm fairly convinced it doesn't have anything to do with the
> login script at this point, but I'm still not entirely sure.
>

You need to get the code of the login trigger to look at. Precisely what
does the errorlog say?

You can try to debug this by adding "print" statements in the login
trigger, the output will go to the errorlog.


--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


timwoj Posted on 2013-02-20 15:05:22.0Z
Sender: 77f5.5124e1d2.1804289383@sybase.com
From: timwoj
Newsgroups: sybase.public.ase.general
Subject: Re: Connecting to remote Sybase ASE 15 server causes arithmetic overflow during login trigger
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5124e632.7a29.1681692777@sybase.com>
References: <51240554@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Feb 2013 07:05:22 -0800
X-Trace: forums-1-dub 1361372722 172.20.134.41 (20 Feb 2013 07:05:22 -0800)
X-Original-Trace: 20 Feb 2013 07:05:22 -0800, 172.20.134.41
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31707
Article PK: 1307809


> On 19-Feb-2013 16:56, timwoj wrote:
> > I have a SYBASE ASE 15 server that I'm attempting to
> > connect to remotely. The user I'm attempting to login
> > as has a login trigger configured that sets a couple of
> > the sso and sa roles. I can login locally with the user
> > and everything works fine. I'm able to do everything I
> > need to as the user.
> >
> > Logging in remotely is another story. I get the same
> > errors as above, but any query after logging in results
> > in the following error:
> >
> > Execution of login script '' failed with last error =
> > 3606. See server errorlog for details.
> >
> > If I look at the error log on the server, it does have
> > that error, which is an arithmetic overflow. Does
> > anyone have any ideas why a login would throw an
> > arithmetic overflow? I'm fairly convinced it doesn't
> > have anything to do with the login script at this point,
> but I'm still not entirely sure. >
>
> You need to get the code of the login trigger to look at.
> Precisely what does the errorlog say?
>
> You can try to debug this by adding "print" statements in
> the login trigger, the output will go to the errorlog.
>

I removed the login trigger from that account, and tried the
sa account as well, and both still failed. I'll get the
full text of the error from the log when I go out to that
lab later today.


Rob V Posted on 2013-02-20 20:56:39.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Connecting to remote Sybase ASE 15 server causes arithmetic overflow during login trigger
References: <51240554@forums-1-dub> <5124e632.7a29.1681692777@sybase.com>
In-Reply-To: <5124e632.7a29.1681692777@sybase.com>
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: <51253887@forums-1-dub>
Date: 20 Feb 2013 12:56:39 -0800
X-Trace: forums-1-dub 1361393799 172.20.134.152 (20 Feb 2013 12:56:39 -0800)
X-Original-Trace: 20 Feb 2013 12:56:39 -0800, vip152.sybase.com
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31709
Article PK: 1307820

Keep in mind there can potentially be two login triggers active: a
login-specific one and a global login trigger.

Rob V.

On 20-Feb-2013 16:05, timwoj wrote:
> I removed the login trigger from that account, and tried the
> sa account as well, and both still failed. I'll get the
> full text of the error from the log when I go out to that
> lab later today.
>


Bret Halford Posted on 2013-02-20 21:35:31.0Z
From: Bret Halford <bret.halford@sap.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Connecting to remote Sybase ASE 15 server causes arithmetic overflowduring login trigger
References: <51240554@forums-1-dub> <5124e632.7a29.1681692777@sybase.com> <51253887@forums-1-dub>
In-Reply-To: <51253887@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: <512541a3$1@forums-1-dub>
Date: 20 Feb 2013 13:35:31 -0800
X-Trace: forums-1-dub 1361396131 172.20.134.152 (20 Feb 2013 13:35:31 -0800)
X-Original-Trace: 20 Feb 2013 13:35:31 -0800, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31710
Article PK: 1307822

As of 15.7 GA, there can now be three.
login-specific, global login trigger, and a third one
from the new login profile feature.

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01672.1570/html/sec_admin/CIHGFHGC.htm?

-bret

On 2/20/2013 1:56 PM, Rob V wrote:
> Keep in mind there can potentially be two login triggers active: a
> login-specific one and a global login trigger.
>
> Rob V.
>
> On 20-Feb-2013 16:05, timwoj wrote:
>> I removed the login trigger from that account, and tried the
>> sa account as well, and both still failed. I'll get the
>> full text of the error from the log when I go out to that
>> lab later today.
>>
>
>

--
Bret Halford
Support Architect, AGS Primary Support
Sybase, Inc., an SAP Company
385 Interlocken Crescent, Suite 300, Broomfield, Colorado, 80021


Rob V Posted on 2013-02-20 23:29:52.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Connecting to remote Sybase ASE 15 server causes arithmetic overflowduringlogin trigger
References: <51240554@forums-1-dub> <5124e632.7a29.1681692777@sybase.com> <51253887@forums-1-dub> <512541a3$1@forums-1-dub>
In-Reply-To: <512541a3$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: <51255c70$1@forums-1-dub>
Date: 20 Feb 2013 15:29:52 -0800
X-Trace: forums-1-dub 1361402992 172.20.134.152 (20 Feb 2013 15:29:52 -0800)
X-Original-Trace: 20 Feb 2013 15:29:52 -0800, vip152.sybase.com
Lines: 61
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31711
Article PK: 1307826

Actually there can still only be at most 2 active login triggers for a
login in 15.7. When you define a login trigger via a profile (the 15.7
syntax in the manual is obviously invalid BTW), it cannot be modified
with sp_modifylogin to set a different login-specific login trigger --
there is no error message but the setting is ignored. When you have set
a login-specific login trigger with sp_modifylogin and then you change
the login profile, the profile's login trigger is used and the original
login trigger is discarded. Bottom line, there can still be one
login-specific login trigger and one global login trigger.
It should be said that the different ways to define the login-specific
login trigger are not a great example of clarity though...

Rob V.

On 20-Feb-2013 22:35, Bret Halford wrote:
> As of 15.7 GA, there can now be three.
> login-specific, global login trigger, and a third one
> from the new login profile feature.
>
> http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01672.1570/html/sec_admin/CIHGFHGC.htm?
>
>
> -bret
>
> On 2/20/2013 1:56 PM, Rob V wrote:
>> Keep in mind there can potentially be two login triggers active: a
>> login-specific one and a global login trigger.
>>
>> Rob V.
>>
>> On 20-Feb-2013 16:05, timwoj wrote:
>>> I removed the login trigger from that account, and tried the
>>> sa account as well, and both still failed. I'll get the
>>> full text of the error from the log when I go out to that
>>> lab later today.
>>>
>>
>>
>
>

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


timwoj Posted on 2013-02-20 14:47:53.0Z
Sender: 77f5.5124e1d2.1804289383@sybase.com
From: timwoj
Newsgroups: sybase.public.ase.general
Subject: Re: Connecting to remote Sybase ASE 15 server causes arithmetic overflow during login trigger
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5124e219.7823.1681692777@sybase.com>
References: <5123a0aa.7107.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Feb 2013 06:47:53 -0800
X-Trace: forums-1-dub 1361371673 172.20.134.41 (20 Feb 2013 06:47:53 -0800)
X-Original-Trace: 20 Feb 2013 06:47:53 -0800, 172.20.134.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31706
Article PK: 1307803

Yesterday I removed the login script from the user and
unlocked the roles so they don't have passwords anymore. I
still can't login remotely as that user. It throws the same
error. I also tried the sa user, and it did the same.


Michael Peppler (Team Sybase) Posted on 2013-02-20 20:29:15.0Z
From: Michael Peppler (Team Sybase) <mpeppler@peppler.org>
Newsgroups: sybase.public.ase.general
Message-ID: <5125321a@forums-1-dub>
References: <5123a0aa.7107.1681692777@sybase.com> <5124e219.7823.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: Connecting to remote Sybase ASE 15 server causes arithmetic overflow during login trigger
User-Agent: Unison/2.1.10
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 20 Feb 2013 12:29:15 -0800
X-Trace: forums-1-dub 1361392155 172.20.134.152 (20 Feb 2013 12:29:15 -0800)
X-Original-Trace: 20 Feb 2013 12:29:15 -0800, vip152.sybase.com
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31708
Article PK: 1307819

On 2013-02-20 14:47:53 +0000, timwoj said:

> Yesterday I removed the login script from the user and
> unlocked the roles so they don't have passwords anymore. I
> still can't login remotely as that user. It throws the same
> error. I also tried the sa user, and it did the same.

Can you define "login remotely" please?

Sybase doesn't have any "local" connection (? la Oracle), so everything
is in fact a remote (i.e. TCP/IP) connection. If you are coming in
through a firewall then that could have an effect if it blocks
packets/ports.

Michael