Имею странную проблему на ASE 12
запускаю хранимую процедуру артизаном, получаю в ответ The SQL Server is terminating this process.
и в еррорлоге следующее

00:00000:00027:2006/07/15 14:33:34.46 kernel SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00027:2006/07/15 14:33:34.46 kernel pc: 0x00478AB6 collocate+ 0x116 (0x632A5250, 0x28E00300, 0x00000005, 0x00000008)
00:00000:00027:2006/07/15 14:33:34.46 kernel pc: 0x00478AB6 collocate+ 0x116 (0x83661CEC, 0x632A5250, 0x00000005, 0x041DCA0C)
00:00000:00027:2006/07/15 14:33:34.46 kernel pc: 0x005F8041 setkeys+ 0x8a (0x83661CEC, 0x632A5250, 0x00000005, 0x041DCA0C)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x005F7F32 setkeys_indordatarow+ 0x22 (0x83A67898, 0x632A5250, 0x00000001, 0x00005757)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x007A739E stat_collect+ 0x33 (0x041DCFF4, 0x041DCFBC, 0x0058516F, 0x82FDB6DC)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x005950AC sobld_processrow+ 0xb4 (0x8361EB7C, 0x0058516F, 0x82FDB6DC, 0x83622800)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x00591FDD indbuild+ 0xc2d (0x8361EB7C, 0x00000001, 0x03F7BFA0, 0x564BD700)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x0058C9A5 sort_ind_heap_bld+ 0xfa (0x8361EB7C, 0x00000001, 0x00000001, 0x041DD5D8)
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x0058BD51 so_handle installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x0058AE7A startsort+ 0x17ae (0x8361EB7C, 0x00000001, 0x00000001, 0x03F7BFA0)
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x0058BD51 so_handle installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x0058925C sort+ 0x120c (0x8362ECA4, 0x836618AC, 0x8361AD08, 0x00000008)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x0079CBC6 run+ 0x177c6 (0x8362ECA4, 0x836618AC, 0x041DF688, 0x8361AD08)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x0076F40A exec_eop+ 0x797 (0x8362ECA4, 0x83661800, 0x041DF688, 0x041DF13C)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x0076F4AD exec_eop+ 0x83a (0x83623F3C, 0x8362ECA4, 0x000000C3, 0x041DF688)
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x00774879 execerr installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x008E63B5 jcsExHandler installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x0075B3E1 sortmerr installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x00774879 execerr installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x00774879 execerr installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x006EC66E aritherr installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x0076E623 execute+ 0xac3 (0x041DF748, 0x005A1C4F, 0x222257B0, 0x005378D6)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x006C6706 s_execute+ 0x29e6 (0x83602000, 0x20DB8370, 0xFFFFFFFF, 0x00710000)
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x006F17DF s_handle installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x006EE9AD sequencer+ 0x16ed (0x8361AC10, 0x8361AC90, 0x00000001, 0x00000000)
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x0045CFB4 hdl_backout installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x006CEDDF execproc+ 0x7b9 (0x000000E6, 0x20DB8370, 0x041DFF7C, 0x0040FE9F)
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x00707561 execrpc_handle installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x00706202 execrpc+ 0x12b2 (0x000000E6, 0x00AE04A0, 0x03F7BFA0, 0x00000000)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x004417D8 tdsrecv_rpc+ 0x15 (0x00000007, 0x00AE04A0, 0x03F7BFA0, 0x20034604)
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x0045CFB4 hdl_backout installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x0064C3B0 ut_handle installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel [Handler pc: 0x0064C3B0 ut_handle installed by the following function:-]
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x0040FE9F conn_hdlr+ 0x3148 (0x20034604, 0x00AE04A0, 0x03F7BFA0, 0x20034604)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x00999677 kpntwrapper+ 0x84 (0x009995F3, 0x20034604, 0x00000000, 0x00000000)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x7C4E987C KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00027:2006/07/15 14:33:34.48 kernel end of stack trace, spid 27, kpid 14155992, suid 1
00:00000:00027:2006/07/15 14:33:34.48 kernel ************************************
00:00000:00027:2006/07/15 14:33:34.48 kernel SQL causing error : o.rpt_rep
00:00000:00027:2006/07/15 14:33:34.48 kernel ************************************
00:00000:00027:2006/07/15 14:33:34.48 server SQL Text: o.rpt_rep
00:00000:00027:2006/07/15 14:33:34.48 kernel curdb = 6 pstat = 0x10100 lasterror = 0
00:00000:00027:2006/07/15 14:33:34.48 kernel preverror = 0 transtate = 0
00:00000:00027:2006/07/15 14:33:34.48 kernel curcmd = 195 program = DBArtisan
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x009F75E4 os_get_cur_stk_desc+ 0xf1 (0x041DC204, 0x7C4FF0B4, 0x7C4F17E8, 0xFFFFFFFF)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x009F75E4 os_get_cur_stk_desc+ 0xf1 (0x041DC204, 0x041DBFBC, 0x0000270F, 0x00000002)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x009CFB6F pcstkwalk+ 0x204 (0x00D800D8, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x009CF7F9 ucstkgentrace+ 0x1f9 (0x00D800D8, 0x00000001, 0x00AE04A0, 0x041DC574)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x0099FA78 ucbacktrace+ 0x88 (0x00D800D8, 0xFFFFFFFF, 0xC0000005, 0x20DB8370)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x00406013 terminate_process+ 0xb11 (0xC0000005, 0x7800BDB5, 0x041DC57C, 0x00000000)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x00998BE7 kiexception+ 0x2da (0x20034604, 0x00AE04A0, 0x03F7BFA0, 0x20034604)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x009996D3 kpntwrapper+ 0xe0 (0x009995F3, 0x20034604, 0x00000000, 0x00000000)
00:00000:00027:2006/07/15 14:33:34.48 kernel pc: 0x7C4E987C KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00027:2006/07/15 14:33:34.48 kernel end of stack trace, spid 27, kpid 14155992, suid 1
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 0, sdesp 0x83661000, objid -1769522
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 16, sdesp 0x221E4750, objid 1749581271
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 17, sdesp 0x221E4AF0, objid 1621580815
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 18, sdesp 0x221F7090, objid 1618104805
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 19, sdesp 0x221CDCD0, objid 1301579675
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 20, sdesp 0x221E4750, objid 1749581271
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 21, sdesp 0x221F7090, objid 1618104805
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 22, sdesp 0x221B92F0, objid 1730105204
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 23, sdesp 0x221CAA10, objid 1378103950
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 24, sdesp 0x221CDCD0, objid 1301579675
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 25, sdesp 0x221D9210, objid 1543676547
00:00000:00027:2006/07/15 14:33:34.59 server WARNING: Pss found with open sdes. pspid 27, psuid 1, pcurdb 6, range entry 26, sdesp 0x22214090, objid 1280655472
00:00000:00027:2006/07/15 14:33:34.60 server Error: 6103, Severity: 17, State: 1
00:00000:00027:2006/07/15 14:33:34.60 server Unable to do cleanup for the killed process; received Msg 1143.

но если рестартануть сервер, то первый раз выдается результат... также выдается результат, когда маленький объем данных возвратиться должен, например дня за два инфа выводиться, а больше опять ошибка, но после рестарта за полгода строит без проблем... При этом на этом же сервере есть база с точно такой же структурой, но другими данными, но ошибка та же...
так понимаю, дело в сервере и его настройке.... На другом сервере есть эти базы которые являются реплицируемыми копиями, так на них все нормально отрабатывает, настройки серверов одинаковые, за исключением total memory... на глючащем - 1200000 (т.к. физически 4 гига которые заюзаны виндой ключем /3GB /PAE в boot.ini) на нормальном - 750000 т.к. физически 2 гига

Что предпринять...?

Разобрался... вероятно ошибка из-за железа...
ибо, подняв дамп на сервере с третими пеньками, все заработало, однако на ксенонах 3,2 такой косяк... переписал радикально процедуру - все заработало...