Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Stack Trace

3 views
Skip to first unread message

PI

unread,
Aug 7, 2006, 8:26:59 AM8/7/06
to
Hi there

We are running Sybase ASE 11.5.1 on a NCR system and the Sybase Open
Client 12.5 is running on our Windows XP Clients.

When we run the following UPDATE

UPDATE
GAAS_V_GF
SET
VGF_TimeStamp = '2006/08/07 10:10:35:885',
VGF_HIS_Ref = 7174,
VGF_VKN_Ref = 20124,
VGF_RGF_Ref = 238,
VGF_SachbMa_Ref = 103,
VGF_VerantMa_Ref = 103,
VGF_Team_Ref = 1,
VGF_Aktenort = ' ',
VGF_Nummer = '99.99.99',
VGF_Typ = 'Separate Leistungserfassung',
VGF_Bezeichnung = 'ABC',
VGF_Bereich = 'LEO',
VGF_Group = 'Sonstige',
VGF_Kategorie = 'Sonstige',
VGF_KK = 'L06-000089',
VGF_BlCLSID = ' ',
VGF_BlIID = ' ',
VGF_BlIIDEvents = ' ',
VGF_Bemerkung =
'123456789A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789o123456789P123456789Q123456789R',

VGF_Beginn = '2006/08/04 00:00:00:000',
VGF_BeginnFachlich = '2006/08/04 00:00:00:000',
VGF_Ende = '9999/12/31 00:00:00:000',
VGF_EndeFachlich = '9999/12/31 00:00:00:000',
VGF_Weiter = '9999/12/31 00:00:00:000',
VGF_AbhaengigGF_Ref = 0,
VGF_EmbedStatus = 'In Bearbeitung',
VGF_Statistik_AnzSp = 1,
VGF_Statistik_AnzHbb = 0,
VGF_Statistik_AnzLb = 0,
VGF_Statistik_Kommentar = ' ',
VGF_OhneLeistungGrund = ' ',
VGF_Mandant = 39
WHERE
VGF_ID = 1333

then we are getting the following stack trace:

00:00000:00001:2006/08/07 10:11:00.18 kernel
************************************
00:00000:00001:2006/08/07 10:11:00.18 kernel SQL causing error : er =
@c23, VGF_AbhaengigGF_Ref = @c24, VGF_EmbedStatus = @c25,
VGF_Statistik_AnzSp = @c26, VGF_Statistik_AnzHbb = @c27,
VGF_Statistik_AnzLb = @c28, VG
00:00000:00001:2006/08/07 10:11:00.18 kernel curdb = 7 pstat = 0x10000
lasterror = 0
00:00000:00001:2006/08/07 10:11:00.18 kernel preverror = 0 transtate =
0
00:00000:00001:2006/08/07 10:11:00.18 kernel curcmd = 197 program =

00:00000:00001:2006/08/07 10:11:00.18 kernel pc 0x806c3de
ucbacktrace+0x4e(0x0,0xffffffff,0x9c2d528,0x0,0x925d940)
00:00000:00001:2006/08/07 10:11:00.19 kernel pc 0x824f9b4
hdl_default+0x38(0x4,0x0,0x19,0x1,0x8a76cc8)
00:00000:00001:2006/08/07 10:11:00.19 kernel pc 0x81e0628
ex_raise+0x15c(0x4d,0x26,0x19,0x1,0xaf)
00:00000:00001:2006/08/07 10:11:00.19 kernel pc 0x8385954
tdsrecv__onepfmt+0x15c(0x8a76da9,0x1,0x9c32760,0x9c32761,0x9c32764)
00:00000:00001:2006/08/07 10:11:00.19 kernel pc 0x8385acd
tdsrecv_paramfmt+0x171(0x925ab80,0x0,0x1,0x925ab80,0x0)
00:00000:00001:2006/08/07 10:11:00.19 kernel pc 0x80715c4
tdsrecv_language+0x294(0x1,0x1,0x8a76e1c,0x5,0x0)
00:00000:00001:2006/08/07 10:11:00.20 kernel pc 0x81ee023
conn_hdlr+0x6ac(0x3,0x8a76f1c,0x6a006a,0x0,0x5374616b)
00:00000:00001:2006/08/07 10:11:00.20 kernel Handler hdl_backout
(0x805adb4) installed by the following function:
00:00000:00001:2006/08/07 10:11:00.20 kernel pc 0x80f9160
_ex_cleanup(0x0,0x5374616b,0x0,0x0,0x0)
00:00000:00001:2006/08/07 10:11:00.20 kernel pc 0x6a006a
(0x0,0x0,0x0,0x0,0x0)
00:00000:00001:2006/08/07 10:11:00.20 kernel end of stack trace, spid
1, kpid 4784201, suid 1

Now, when the Input for the VGF_Bemerkung field is shorter (e.g. just
40 varchar's) then it is running just fine! It seems it is OK up to a
length of 170. It will fail with a length of 171, 252, and 254. Haven't
tried more! But it will work again with a length of 255.

- PI

0 new messages