One of my script was trying to load data into GPRS table ,
When the no. of rows exceeded 3500 , it got locked inturn hanging the script .
Iam attaching the log from /var/opt/sybase/sybase/log
Could any one help me in this seeing the logs what's the problem .

Thanking you ,
Regards ,
Sree

Pasting the contents of Logs
##############################################


00:00000:00187:2003/07/24 04:11:44.92 kernel
************************************
00:00000:00187:2003/07/24 04:11:44.92 kernel SQL causing error :

if exists (select 1 from OSS_INSTALLATIONS where ossType = "CNOS" and
Status = 1)
begin

insert into csddb..GPRS select
*
from
asddb..GPRS
00:00000:00187:2003/07/24 04:11:44.92 kernel
************************************
00:00000:00187:2003/07/24 04:11:44.92 server SQL Text:

if exists (select 1 from OSS_INSTALLATIONS where ossType = "CNOS" and
Status = 1)
begin

insert into csddb..GPRS select
*
from
asddb..GPRS_FOR_CSD

delete bufferdb..BCP_INPUT5 from
bufferdb..BCP_INPUT5 a, csddb..GPRS b
where a.NE=b.NE and a.TIME=b.TIME and a.CNT_NAME=b.CNT_NAME
and a.CNT_NAME not in (select COUNTER from GSN_COLLECTIONS where
COLLECTION="GGSN_WPP_APN")

end

00:00000:00187:2003/07/24 04:11:44.92 kernel curdb = 20 pstat = 0x10100
lasterror = 6902
00:00000:00187:2003/07/24 04:11:44.92 kernel preverror = 0 transtate = 0
00:00000:00187:2003/07/24 04:11:44.92 kernel curcmd = 195 program = isql
................................
................................
................................

00:00000:00187:2003/07/24 04:11:45.90 kernel end of stack trace, spid
187, kpid 1169162703, suid 21
00:00000:00187:2003/07/24 04:11:45.90 server Error: 21, Severity: 21,
State: 1
00:00000:00187:2003/07/24 04:11:45.90 server WARNING - Fatal Error 6902
occurred at Jul 24 2003 4:11AM. Please note the error and time, and
contact a user
with System Administrator (SA) authorization.
00:00000:00187:2003/07/24 04:11:45.90 server Error: 6902, Severity: 21,
State: 0
00:00000:00187:2003/07/24 04:11:45.90 server Page timestamp value falls
between the old and new timestamps from log. Page #=582, object id =
80000285, page
timestamp=0000 0000ceb4. Log: old timestamp=0000 0000ceb3, new
timestamp=0000 0000cf00.
00:00000:00187:2003/07/24 04:11:45.90 server Error while undoing log
row in database 'bufferdb'. Rid pageid = 0xd472; row num = 0x5.
00:00000:00187:2003/07/24 04:11:45.90 server WARNING: Pss found with
open sdes. pspid 16, psuid 95745624, pcurdb 187, range entry 21, sdesp
0x00000000000000
000000, objid 16
00:00000:00187:2003/07/24 04:11:45.90 server WARNING: Pss found with
open sdes. pspid 16, psuid 95745624, pcurdb 187, range entry 21, sdesp
0x00000000000000
000032, objid 16
00:00000:00187:2003/07/24 04:11:45.90 server WARNING: Pss found with
open sdes. pspid 16, psuid 95745624, pcurdb 187, system table entry 21,
sdesp 0x0000000
0000000000000, objid 16