由于cognos会把cognos相关配置及运行时信息全部存入内容库,所以了解内容库的元信息很有必要。
CMSYSPROPS This table has the Content Store Version.
CMOBJNAMES This table has the names of all the objects in the content store.
CMOBJPROPS1 Users, Roles Group Distribution list and contact information such as Email, phone number, Fax Given name etc are stored in this table
CMOBJPROPS2 Report scheduling information is stored. This table has fields like hour, day week etc
CMOBJPROPS3 Stores Screen Tip and Object description provided while creating the objects are stored here
CMOBJPROPS4 Stores the printer paper setting details like height and width of A3 , A4 , letter and 11X17 paper orientations
CMOBJPROPS6 Has the details of the all packages which were published using the FM.
CMOBJPROPS7 This table stores the XML of all reports and models. This is basically to maintain the metadata about the structure of the reports and models.
CMOBJPROPS10 Contact information is stored in this table. This table has columns like Contact Email and Contact.
CMOBJPROPS11 This table stores the data sources configuration details like connect string, the cube location etc.
CMOBJPROPS13 It stores the names of parameter passed to the range prompts
CMOBJPROPS14 Has details regarding the versions, creation time etc of the objects in the content store.
CMOBJPROPS16 This table provides the status of the multiple services of Cognos like LogService, MonitorService, ReportService, SystemService, JobService
CMOBJPROPS17 Stores performance details of each component like “query Studio, Analysis Studio, Event Studio” etc
CMOBJPROPS18 This table stores the drill path from the source to the final target report.
CMOBJPROPS20 Stores details regarding which are all the reports for which prompting has been enabled. And also has the details of which are the reports which has the default report options overridden.
CMOBJPROPS24 Stores the printer configuration details
CMOBJPROPS25 Stores the data regarding the objects deployed, like the deployed folder, the reports, the number of folders present in the deployment archive, etc
CMOBJPROPS26 This table stores the data about all the packages imported / exported in C8, with the properties selected during the process.
CMOBJPROPS27 Has the details regarding the data source created in the content store using Cubes.
CMOBJPROPS30 Stores the registration , service description etc details about portlets in this table
CMOBJPROPS31 Has the custom logging level for each of the Cognos services, CMID can be be linked to CMOBJNAMES for the names of each of the services
CMOBJPROPS32 Has the details of the stored procedures used as the query items in the FM model.
CMOBJPROPS33 Detail related to users, user groups user roles.
CMOBJPROPS34 Has the details regarding the drill through parameters of the drill through reports. The parameter assign values are present in coded format
CMOBJPROPS36 Has the list of all the Models published using framework manager
CMOBJPROPS37 This table has the details of the routing sets configured for server / load balancing for each package published in the content store
CMOBJPROPS38 Configuration details about number of items to retrieve in studios, for a package are saved under this table.
CMOBJPROPS39 Has values for properties of reports and views. PROPID can be linked to CMPROPERTIES for property names
CMOBJPROPS52 Contains the properties for the connections
CMOBJPROPS55 Has the URI for icons for each entry in Cognos Connection
CMLOCALES Has the locale ids associated with each language supported by Cognos 8
表:CMCAPACITY 这张表保存的是内容库的容量信息,就是做集群的时候配置的server group的负载均衡。表里面的数据有所有在cognos configuration里配置供failover的内容库链接,以及他们的负载比例。其中有条记录是当前活动内容库的链接。
之前有个朋友找我帮忙说:他们的cognos服务器切换到新的oracle内容库以后平稳运行23天以后突然不工作了,内容库测试通过,但是cognos服务启动的时候报错,报错详细是:
[Start Service]
1. 15:19:18, 'LogService',
'StartService', 'Success'.
2. 15:19:24, CM-CFG-5063 A
Content Manager configuration error was detected while connecting to the
content store.
CM-CFG-5114 An error occurred
while locking the content store database.
CM-CFG-5114 An error occurred
while locking the content store database.
3. 15:19:24, 'ContentManager',
'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to
determine the active Content Manager. Will retry periodically.
4. 15:19:24,
'com.cognos.pogo.contentmanager.coordinator.ActiveCMControl', 'pogo',
'Failure'.
DPR-DPR-1035 Dispatcher
detected an error.
我就让他把内容库的CMCAPACITY这张表的记录发给我,发现里面有CMPATH字段为空值的记录。我建议他先备份内容库,然后删除里面为空的记录,后面就正常起来了。
添加新评论7 条评论
2013-11-25 22:45
2013-01-15 11:28
2013-01-09 16:12
我是用的笨方法:1.备份内容库2.重装cognos,选上derby3.重新配置4.导入内容库
2013-01-09 11:59
我是用的笨方法:1.备份内容库2.重装cognos,选上derby3.重新配置4.导入内容库
我是在自己测试机上弄着玩的,所以敢这样,如果你是生产机上,就得再问问高手这样弄行不行了
2013-01-09 10:58
2013-01-09 10:56
2013-01-06 09:22