1. 服务器环境拓扑:
2. 现状分析:由于公司需求,需要在MOSS中显示一个汇总报表 ,但数据都存储在其他业务系统中,所以需要先从业务数据库中提取数据到SQL server2005中,然后把需要手工输入的数据也读取到SQL中,由Reporting Service自动生成报表,通过Reporting Service的外接程序显示在MOSS中。
3. 故障现象:在SQL server 2005服务器中使用Microsoft Office SharePoint server SP1安装好WEB前端后,安装基于MOSS的Reporting Service外接程序报错。如下图:
通过Google搜索到得解决方案为:
Problem:
Event Type: Error Event Source: Windows Sharepoint Services 3 Event Category: Topology EventID: 5617 Date: 03.25.2008 Time: 20:45:34 User: N/A Computer: MOSS Server Description: The schema version (3.0.149.0) of the database SharePoint_AdminContent_0015a5e2-8907-416d-8672-940a68c2c431 on Database Server is not consistent with the expected database schema version (3.1.3.0) on MOSS Server. Connections to this database from this server have been blocked to avoid data loss. Upgrade the web front end or the content database to ensure that these versions match Solution: "stsadm -o upgrade -inplace -url http://{central_admin_url}/"
example., stsadm –o upgrade –inplace –url
[url]http://mossserver:17492/[/url]
|
经过尝试,提示【未将对象引用设置到对象的实例】,看来此药不对此证。
仔细琢磨错误描述,又Google N次后,无意来到这个页面:
[url]http://www.mindsharpblogs.com/penny/articles/481.aspx[/url]
Using
SharePoint Central Administration Web site SharePoint HTML Site Settings admin pages or IIS Manager, on the web sites properties
HTTP Headers tab, virtual servers once extended will show the following version numbers:
MOSS 20071 or WSS 3.0 Cumulative update (KB956056 & KB956057) 12.0.0.6327 MOSS 20071 or WSS 3.0 Infrastructure Update ( KB951695 & KB951297) 12.0.0.6318 MOSS 20071 or WSS 3.0 post-SP1 hotfix ( KB948945) 12.0.0.6303 MOSS 20071 or WSS 3.0 post-SP1 hotfix ( KB941274) 12.0.0.6301 MOSS 20071 or WSS 3.0 post-SP1 hotfix ( KB941422) 12.0.0.6300 MOSS 20071 or WSS 3.0 SP1 12.0.0.6219 MOSS 20071 or WSS 3.0 October public update 12.0.0.6039 MOSS 20071 or WSS 3.0 August 24, 2007 hotfix package 12.0.0.6036 MOSS 20071 or WSS 3.0 RTM 12.0.0.4518 MOSS 20071 or WSS 3.0 Beta 2 TR: 12.0.0.4407 MOSS 20071 or WSS 3.0 Beta 2: 12.0.0.4017 Office 12 (PDC p_w_picpath - pre-beta): 12.0.0.3111 (This version of Office does not have a support link in the Add/Remove programs dialog box).
1To confirm that a particular service pack is install on SharePoint Server you must either check the version numbers of specific dlls as specified in the related Microsoft Knowledge Based article or select the
Show Updates check box in
Add and Remove Programs.
|
突然灵感闪现,想到是不是SQL服务器安装好web前端没打补丁导致的版本不一致。
于是立刻打开【SharePoint 管理中心】—【操作】—【服务器场中的服务器】,果然发现了问题所在。
OK,知道问题了,现在的要做的就是安装【KB956056 & KB956057】这两个KB了,赶紧down下来安装好。
注意:两个补丁都安装好之后再执行【产品和技术配置向导】,并且两台服务器都要进行向导。
补丁安装完后,再次查看服务器版本。
注:外接程序需要安装在MOSS服务器上,SQL server服务器虽然可以安装,并且Reporting Service服务也可以正常配置,但在MOSS管理中心中没有Reporting Service相关选项。
5. 总结
在多服务器部署MOSS的时候,特别是需要把MOSS的不同角色部署到不同服务器上时,要保证多台服务器上MOSS版本的一致性,不然就会出现相关问题。
转载于:https://blog.51cto.com/struggle/143632