免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1598 | 回复: 3

急,恢复后,执行到存储过程,应用程序就非法操作 [复制链接]

论坛徽章:
0
发表于 2004-04-11 09:45 |显示全部楼层
各位,怎么解决呢?

论坛徽章:
0
发表于 2004-04-12 10:28 |显示全部楼层

急,恢复后,执行到存储过程,应用程序就非法操作

什么信息?前台应用和sybase errorlog,单独运行这个procedure也会出错吗?

论坛徽章:
0
发表于 2004-04-13 22:52 |显示全部楼层

急,恢复后,执行到存储过程,应用程序就非法操作

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语句没问题的.

论坛徽章:
0
发表于 2004-04-14 01:04 |显示全部楼层

急,恢复后,执行到存储过程,应用程序就非法操作

知道了,是角色so_role权限问题,因为我没倒master库,我只是倒了一个生产库,所以权限要重新设定的.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP