急，恢復后，執(zhí)行到存儲過程，應用程序就非法操作

chujian

各位，怎么解決呢？

chenfeng825

什么信息?前臺應用和sybase errorlog，單獨運行這個procedure也會出錯嗎?

chujian

00:00000:00009:2004/04/11 03:29:04.51 kernel  SQL causing error : INSERT INTO import(s_billno,     i_rowno,     s_suppid,     s_deptid,s_typist,     c_status ,   s_validdt,s_goodsid,    f_imptpri,   f_imptqty,    f_i
00:00000:00009:2004/04/11 03:29:04.51 kernel  Failed to log the current message in the Windows NT event log
00:00000:00009:2004/04/11 03:29:04.51 kernel  ************************************
00:00000:00009:2004/04/11 03:29:04.51 kernel  Failed to log the current message in the Windows NT event log
00:00000:00009:2004/04/11 03:29:04.51 server  SQL Text: INSERT INTO import(s_billno,     i_rowno,     s_suppid,     s_deptid,s_typist,     c_status ,   s_validdt,s_goodsid,    f_imptpri,   f_imptqty,    f_imptamt,s_billdt,     s_memo ,     f_tax,        f_taximptpri,f_taximptamt, f_taxamt,         s_note,                        c_paystate, f_favtpri)  VALUES('100102990',1,'0001','1001',   '6006','1','2004/04/11',  '00010006',1.8803,12.00,22.56,  '2004/04/11','000002990',0.17,2.20,  26.40,3.84,null,'0','一柜組' )
00:00000:00009:2004/04/11 03:29:04.51 kernel  Failed to log the current message in the Windows NT event log
00:00000:00009:2004/04/11 03:29:04.51 kernel  curdb = 5 pstat = 0x10108 lasterror = 0
00:00000:00009:2004/04/11 03:29:04.51 kernel  Failed to log the current message in the Windows NT event log
00:00000:00009:2004/04/11 03:29:04.51 kernel  preverror = 0 transtate = 0
00:00000:00009:2004/04/11 03:29:04.51 kernel  Failed to log the current message in the Windows NT event log
00:00000:00009:2004/04/11 03:29:04.51 kernel  curcmd = 195 program =                              
00:00000:00009:2004/04/11 03:29:04.51 kernel  Failed to log the current message in the Windows NT event log
00:00000:00009:2004/04/11 03:29:04.51 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x14eea74, 0x1a001a, 0x14eea74, 0x0)
00:00000:00009:2004/04/11 03:29:04.51 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x14eea74, 0x14eefc8, 0x270f, 0x2)
00:00000:00009:2004/04/11 03:29:04.51 kernel  pc: 0x883514 pcstkwalk+ 0x224 (0x1a001a, 0x2, 0x270f, 0x0)
00:00000:00009:2004/04/11 03:29:04.51 kernel  pc: 0x8830ae ucstkgentrace+ 0x1ce (0x1a001a, 0x1, 0xc0000005, 0x202cb260)
00:00000:00009:2004/04/11 03:29:04.51 kernel  pc: 0x862864 ucbacktrace+ 0x84 (0x1a001a, 0xffffffff, 0x1110, 0x0)
00:00000:00009:2004/04/11 03:29:04.51 kernel  pc: 0x405fe6 terminate_process+ 0x566 (0xc0000005, 0x77c03efb, 0x14ef3bc, 0x0)
00:00000:00009:2004/04/11 03:29:04.53 kernel  pc: 0x85b56e kiexception+ 0x1ee (0x20014940, 0x20013830, 0x160016, 0x20014940)
00:00000:00009:2004/04/11 03:29:04.53 kernel  pc: 0x89c23d kpntwrapper+ 0x10d (0x89c130, 0x20014940, 0x0, 0x0)
00:00000:00009:2004/04/11 03:29:04.53 kernel  pc: 0x77e5d33b kernel32.dll (0x20130400, 0x1, 0x20010040, 0x202cb260)
00:00000:00009:2004/04/11 03:29:04.53 kernel  pc: 0x77e546cf kernel32.dll (0x20838d94, 0x2081c2c8, 0x2081c3c1, 0x20816ab
00:00000:00009:2004/04/11 03:29:04.53 kernel  end of stack trace, spid 9, kpid 1703962, suid 1
00:00000:00009:2004/04/11 03:29:04.53 kernel  Failed to log the current message in the Windows NT event log
00:00000:00010:2004/04/11 03:31:04.44 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00010:2004/04/11 03:31:04.44 kernel  Failed to log the current message in the Windows NT event log
00:00000:00010:2004/04/11 03:31:04.44 kernel  pc: 0x0 (suspect virtual address)(0x0, 0x0, 0x0, 0x0)
00:00000:00010:2004/04/11 03:31:04.44 kernel  end of stack trace, spid 10, kpid 1835036, suid 1
00:00000:00010:2004/04/11 03:31:04.44 kernel  Failed to log the current message in the Windows NT event log
00:00000:00010:2004/04/11 03:31:04.44 kernel  ************************************
00:00000:00010:2004/04/11 03:31:04.44 kernel  Failed to log the current message in the Windows NT event log
00:00000:00010:2004/04/11 03:31:04.44 kernel  SQL causing error : execute usp_dayclose '2004/04/11'
00:00000:00010:2004/04/11 03:31:04.44 kernel  Failed to log the current message in the Windows NT event log
00:00000:00010:2004/04/11 03:31:04.44 kernel  ************************************
00:00000:00010:2004/04/11 03:31:04.44 kernel  Failed to log the current message in the Windows NT event log
00:00000:00010:2004/04/11 03:31:04.44 server  SQL Text: execute usp_dayclose '2004/04/11'
00:00000:00010:2004/04/11 03:31:04.44 kernel  Failed to log the current message in the Windows NT event log
00:00000:00010:2004/04/11 03:31:04.44 kernel  curdb = 5 pstat = 0x10000 lasterror = 0
00:00000:00010:2004/04/11 03:31:04.44 kernel  Failed to log the current message in the Windows NT event log

里面的SQL語句沒問題的.

chujian

知道了,是角色so_role權限問題,因為我沒倒master庫,我只是倒了一個生產(chǎn)庫,所以權限要重新設定的.