Chinaunix

标题: 重建存储过程问题 [打印本页]

作者: iloveyy1 时间: 2008-07-25 17:35
标题: 重建存储过程问题
小弟我目前维护一个sybase数据库,WIN平台

目前存储过程库sybsystemproc出了点问题,我按照网上的文档重建了sybprocs设备和sybsystemproc库,

最后需要执行重建系统存储过程的脚本,网上的文档UNIX上的重建脚本是$SYBASE/scripts/installmaster

想问一下WIN平台下对应的是不是\sybase\ASE-12_5\scripts\installmsgsvss

执行该文件isql -Usa -P -SServer -i"C:\sybase\ASE-12_5\scripts\installmsgsvss"报错

Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp_addexternlogin'. The stored procedure will
still be created.

sp_addexternlogin存储过程没有在脚本前面建立,问问大家是不是还有其它的脚本建立系统存储过程??

谢谢各位大侠..

作者: hobbylu 时间: 2008-07-25 18:15
这个报错可以忽略，没有关系，实在你感觉不放心，重新执行一下脚本就不会出这个问题了

作者: iloveyy1 时间: 2008-07-25 21:45
D:\Documents and Settings\zhangl>isql -Usa -P -STest_1 -n  -i"C:\sybase\ASE-12_5\scripts\installmsgsvss"
Parameter Name                Default    Memory Used Config Value
      Run Value Unit                Type
------------------------------ ----------- ----------- ------------
      ----------- -------------------- ----------
allow updates to system tables          0          0          1
               1 switch             dynamic

(1 row affected)
Configuration option changed. The SQL Server need not be rebooted since the
option is dynamic.
Changing the value of 'allow updates to system tables' does not increase the
amount of memory Adaptive Server uses.
(return status = 0)
Installing procedures from rtm_common ...
Installing procedures from rtm_help ...
Installing sp_rtm_help
Installing procedures from rtm_check_extra_args ...
Installing sp_rtm_check_extra_args
Installing procedures from rtm_check_required_arg ...
Installing sp_rtm_check_required_arg
Installing procedures from rtm_helpserver ...
Installing sp_rtm_helpserver
Installing procedures from rtm_helpexternlogin ...
Installing sp_rtm_helpexternlogin
Installing procedures from rtm_default ...
Installing sp_rtm_default
Msg 2007, Level 11, State 1:
Server 'Test_1', Procedure 'sp_rtm_default', Line 52:
Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp_addexternlogin'. The stored procedure will
still be created.
CT-LIBRARY error:
      ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

上面是第一次执行的信息,装不下去了..到Installing sp_rtm_default这个存储过程,我查看了installmsgsvss的脚本,里面用到的'sp_addexternlogin'存储过程之前没有安装....再执行也是这样..下面是再执行的信息
D:\Documents and Settings\zhangl>isql -Usa -P -STest_1 -i"C:\sybase\ASE-12_5\scripts\installmsgsvss"
Parameter Name                Default    Memory Used Config Value
      Run Value Unit                Type
------------------------------ ----------- ----------- ------------
      ----------- -------------------- ----------
allow updates to system tables          0          0          1
               1 switch             dynamic

(1 row affected)
Configuration option changed. The SQL Server need not be rebooted since the
option is dynamic.
Changing the value of 'allow updates to system tables' to '1' increases the
amount of memory ASE uses by 14 K.
(return status = 0)
Installing procedures from rtm_common ...
Installing procedures from rtm_help ...
Re-installing sp_rtm_help
Installing procedures from rtm_check_extra_args ...
Re-installing sp_rtm_check_extra_args
Installing procedures from rtm_check_required_arg ...
Re-installing sp_rtm_check_required_arg
Installing procedures from rtm_helpserver ...
Re-installing sp_rtm_helpserver
Installing procedures from rtm_helpexternlogin ...
Re-installing sp_rtm_helpexternlogin
Installing procedures from rtm_default ...
Re-installing sp_rtm_default
Msg 2007, Level 11, State 1:
Server 'Test_1', Procedure 'sp_rtm_default', Line 52:
Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp_addexternlogin'. The stored procedure will
still be created.
CT-LIBRARY error:
      ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

还是过不去..

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)