Cognos 8 Troubleshooting Guide

preview
试读
118页
Cognos
需积分: 0 8 下载量 154 浏览量 更新于2009-07-16 收藏 1.19MB PDF 举报
### Cognos 8 Troubleshooting Guide：关键知识点解析 #### 一、文档概述与适用范围 本指南旨在为用户提供一套全面的Cognos 8 Business Intelligence系统的故障排除方法。适用于Cognos 8 Version 8.1.2 MR2版本，并可能同样适用于后续版本。用户可以通过访问Cognos全球客户服务网站（http://support.cognos.com）来获取文档的最新版本。 #### 二、版权与商标声明 - **版权**：文档版权归Cognos Incorporated所有，受多项美国专利保护。 - **商标**：Cognos及Cognos标志是Cognos Incorporated在美国和其他国家/地区的注册商标；其他名称均为各自公司所拥有的商标或注册商标。 #### 三、文档结构与内容概览 ##### 1. 故障排除信息定位 - **日志文件**：系统日志文件对于识别和解决Cognos运行过程中出现的问题至关重要。了解如何查看、分析这些文件对于故障排除非常有帮助。 - **在线资源**：Cognos提供了丰富的在线支持资源，包括官方文档和知识库，这些都是查找解决方案的重要途径。 ##### 2. 特定问题的识别与排除 - **性能问题**：当遇到Cognos运行速度慢或者响应时间过长等问题时，可以通过调整系统配置、优化查询语句等方式进行改进。 - **安装与配置错误**：如果在安装过程中出现错误提示或者配置不当导致无法正常使用，可以参考官方文档中的常见问题解答部分。 - **安全性问题**：对于权限设置不合理、数据泄露等安全问题，应确保按照最佳实践来进行权限管理，并定期检查系统的安全性。 #### 四、技术支持与文档更新 - **官方支持**：鼓励用户咨询管理员获取更多帮助，或通过电子邮件联系技术支持部门（support.americacognos.com）。 - **文档更新**：任何对产品或文档的改进或变更都将在后续版本中记录下来。 #### 五、政府受限权利 - **使用限制**：对于政府用户，使用、复制或披露该软件及相关材料的权利受到限制。 - **合同信息**：合同方为Cognos Corporation。 #### 六、故障排除技巧详解 ##### 1. 日志文件分析 - **位置与格式**：了解日志文件的位置及其格式对于快速定位问题至关重要。通常情况下，Cognos的日志文件会存储在特定的目录下，并且每个服务或组件都有自己的日志文件。 - **常见错误代码**：熟悉常见的错误代码有助于快速诊断问题。例如，“Error 404”可能表示找不到指定的资源，“Error 500”则可能意味着内部服务器错误。 ##### 2. 性能调优 - **查询优化**：通过分析SQL查询语句并对其进行优化，可以显著提升Cognos的查询性能。 - **缓存策略**：合理设置缓存策略可以减少不必要的数据加载，从而提高整体效率。 - **硬件升级**：在某些情况下，升级硬件（如增加内存、使用更快的磁盘驱动器等）也是提升性能的有效手段。 ##### 3. 安全性加强 - **权限管理**：确保只有授权用户才能访问敏感数据，定期审查用户的权限分配。 - **加密技术**：采用加密技术保护数据的安全传输，避免数据泄露风险。 - **审计跟踪**：启用审计功能记录用户的操作历史，以便于追踪潜在的安全威胁。 #### 七、总结 Cognos 8 Troubleshooting Guide为用户提供了一套全面而实用的故障排除方法。通过深入理解日志文件、性能调优技术和加强安全性等方面的知识点，可以帮助用户更高效地解决问题，确保Cognos系统的稳定运行。同时，建议用户充分利用官方提供的在线资源和支持服务，以获得最新的技术支持和解决方案。
COGNOS
(R)
8 Business Intelligence
TROUBLESHOOTING GUIDE
THE NEXT LEVEL OF PERFORMANCE
TM
Cognos(R) 8 Business Intelligence Readme
Cognos(R) 8 Business Intelligence Troubleshooting
Guide
TROUBLESHOOTING GUIDE
Product Information
This document applies to Cognos
(R)
8 Version 8.1.2 MR2 and may also apply to subsequent releases. To check for newer versions of this
document, visit the Cognos Global Customer Services Web site (http://support.cognos.com).
Copyright
Copyright (C) 2006 Cognos Incorporated.
Portions of Cognos(R) software products are protected by one or more of the following U.S. Patents: 6,609,123 B1; 6,611,838 B1; 6,662,188
B1; 6,728,697 B2; 6,741,982 B2; 6,763,520 B1; 6,768,995 B2; 6,782,378 B2; 6,847,973 B2; 6,907,428 B2; 6,853,375 B2; 6,986,135 B2;
6,995,768 B2.
Cognos and the Cognos logo are trademarks of Cognos Incorporated in the United States and/or other countries. All other names are
trademarks or registered trademarks of their respective companies.
While every attempt has been made to ensure that the information in this document is accurate and complete, some typographical errors or
technical inaccuracies may exist. Cognos does not accept responsibility for any kind of loss resulting from the use of information contained in
this document.
This document shows the publication date. The information contained in this document is subject to change without notice. Any
improvements or changes to either the product or the document will be documented in subsequent editions.
U.S. Government Restricted Rights. The software and accompanying materials are provided with Restricted Rights. Use, duplication, or
disclosure by the Government is subject to the restrictions in subparagraph (C)(1)(ii) of the Rights in Technical Data and Computer Software
clause at DFARS 252.227-7013, or subparagraphs (C) (1) and (2) of the Commercial Computer Software - Restricted Rights at
48CFR52.227-19, as applicable. The Contractor is Cognos Corporation, 15 Wayside Road, Burlington, MA 01803.
This software/documentation contains proprietary information of Cognos Incorporated. All rights are reserved. Reverse engineering of this
software is prohibited. No part of this software/documentation may be copied, photocopied, reproduced, stored in a retrieval system,
transmitted in any form or by any means, or translated into another language without the prior written consent of Cognos Incorporated.
Troubleshooting Guide 3
Introduction
11
Chapter 1: Troubleshooting Resources
13
Error Messages 13
Log Files 13
Windows Event Viewer 15
Samples 15
Example - Testing Report Studio 15
Use Knowledge Base 15
View the Report Definition in Query Studio 16
Call Cognos Support 16
Chapter 2: Problems Using Documentation
19
Problems When Printing a PDF Manual 19
Unable to Launch a Web Browser When Accessing Help 19
Chapter 3: Installation and Configuration Problems
21
Problems Starting Cognos 8 21
CFG-ERR-0106 Error When Starting the Cognos 8 Service in Cognos Configuration 21
Unable to Start the Cognos 8 Service Because the Port is Used by Another Process 22
Cognos BI Server Not Available When Starting Cognos 8 23
Cannot Log On to a Namespace When Using Cognos Connection (PRS-CSE-1255
Error) 26
Cognos 8 Services Fail to Restart After a Network Outage 26
No Warning That Installing a Later Version of Cognos 8 Will Automatically Update the
Earlier Version of the Content Store 26
Download of Resource Fails 26
DB2 Returns SQL1224N Error When Connecting from AIX 27
Content Manager Error When Starting Cognos 8 27
Cannot Open an MS Cube or PowerCube 27
Cannot Open an OLAP Data Source 27
The Page Cannot Be Found When Starting Cognos 8 in Windows 2003 27
The Page Is Not Shown When Opening a Portal After Installing Cognos 8 28
DPR-ERR-2058 Error Appears in Web Browser When Starting Cognos 8 28
Report Studio Does Not Start 29
DPR-ERR-2022 Error Appears in Web Browser When Starting Cognos 8 29
Unable to Download the cognos.xts File 30
Application Server Startup Script Fails 30
Microsoft Excel 2000 Multipage Report Type Does Not Work 30
Unable to Deserialize Context Attribute Error When Deploying the p2pd.war File to
WebLogic 31
Error Appears After Upgrading Cognos 8 on a WebLogic Application Server 31
The Upgrade Message in Cognos Configuration 31
Unable to Uninstall ReportNet
(R)
Service on Windows 31
Chinese, Japanese, or Korean Characters Are Different After Upgrade 32
Problems Configuring Cognos 8 32
Run Database Cleanup Scripts 32
Improve Metric Store Database Performance 34
Error Trying to Encrypt Information When Saving Your Configuration 34
CAM-CRP-1315 Error When Saving Configuration 35
Configuration Data is Locked by Another Instance of Cognos Configuration 35
Table of Contents
4
Unable to Exit a Tab Sequence When Using Keyboard-only Navigation in Cognos
Configuration 35
Unable to Save Your Configuration 35
Java Error When Starting Cognos Configuration 36
Cryptographic Error When Starting Cognos Configuration 36
Current Configuration Settings Are Not Applied to Your Computer 36
CM-CFG-029 Error When Trying to Save a Configuration That Specifies a SQL Server
Data Source 37
Font on UNIX Not Found When Starting Cognos Configuration 37
Page Cannot be Found Error Running Reports using Cognos Office Connection 37
Some Users Are Prompted to Log On When Using Active Directory Server 37
Error Initializing Oracle Content Store After Upgrade from ReportNet 38
HTTP 500 Server Error for Oracle Application Server 38
CGI Timeout Error While Connected to Cognos 8 Components Through a Web
Browser 38
Servlet Class Fails to Load in WebLogic 39
Desktop Icons or Cognos Configuration Window Flicker on Windows 39
Chapter 4: Security Problems
41
Problems Setting Up Security 41
Access to Entries is Denied During Deployment 41
Prompt to Change Passwords When Logging On to an Active Directory Security
Source 41
Unable to Log On 41
Entries Do Not Appear in Cognos Connection for a Member of a Newly Created
Group 42
Problems Logging On to Cognos Portlets 42
Authentication Problems Using Third-party Providers 43
CAM-AAA-0096 Unable to Authenticate User When Using a Cognos Series 7
Namespace 43
Expired Password Error Appears When Using Active Directory Server 43
Single Signon Is Not Working When Using Active Directory Server 43
Unable to Authenticate User for Cognos Portlets 44
Unable to Identify SAP Permissions Required 44
Chapter 5: Report and Server Administration Problems
45
Database Connection Problems 45
Unable to Select ODBC as the Type of Data Source Connection 45
Cannot Connect to a SQL Server Database Using an OLE DB Connection 45
Intermittent Problems Connecting to a SQL Server Database 46
Cannot Access Cognos Series 7 Reports from Cognos Connection 46
Series 7 Namespaces Do Not Initialize When Services are Started 47
Content Manager Connection Problem in Oracle (Error CM-CFG-5036) 47
Cannot Connect to an OLAP Data Source 47
Other Administration Problems 47
An Update or Delete Request Fails 48
BI Bus Server Processes Remain in Memory After a Shutdown 48
Higher Logging Levels Negatively Affect Performance 48
Problems Accessing Cognos Portlets 49
Unable to Edit Object Properties in a Plumtree 5.0 Portal 50
iViews on Different Pages Show the Same Content 50
Only the Administrator Can See Cognos Portlets 50
Locale Mismatch in Cognos Navigator Portlet 51
Not Yet Optimized Cognos PowerCubes May Open Slowly in Cognos 8 51
Unable to Identify SAP BW Version and Corrections 52
Links to Referenced Content Objects are Broken Following Deployment 52
Troubleshooting Guide 5
Chapter 6: Problems Creating Models and Publishing Packages
53
Problems Creating a Model 53
Cannot import a Microsoft Access Data Source into Framework Manager 53
Measures Not Added After Initial Import in an Upgraded Model 53
Unable to View the Result Set of a Stored Procedure 54
Unable to Run Stored Procedures Imported from an ERWin Metadata Source 54
Cannot Test a Query Subject Imported from a Third-party Data Source 54
An Out of Memory Error with ERWin Imported Metadata 54
Changes in the Model Are Not Reflected in the Report If Model Versioning Is Used 55
Data Query Stored Procedure Updates the Data Source 55
The Hierarchy Node Prompt Does Not Highlight Default Values 55
Framework Manager Cannot Access the Gateway URI 55
The SOAP Server Cannot Be Connected 56
Security Error Messages in Windows 2003 Server 56
Required Currency Is Not Shown in Framework Manager 56
Object Names Appear in the Wrong Language 56
Full Outer Joins in Oracle 56
Columns With the BIT Datatype Are Summarized in Query Studio Reports 57
Error When Testing Query Subjects in a Model Imported from Teradata 57
Function Name Not Recognized 57
Errors Creating Expressions Containing Vendor Specific Functions 57
Relationships Involving Table Views Are Not Imported from an Oracle Designer File 57
SQL View Definitions Are Not Imported from a Power Designer File 57
Undoing Repairs Does Not Reset Prompt Values 58
Unable to Use an IQD Created in Framework Manager That Contains an Oracle Stored
Procedure 58
Some Expressions Imported from Third-Party Metadata Sources Are Not Valid 58
QE-DEF-0259 Error 59
Properties Appear with Cryptic Names 59
Number of Rows Retrieved Exceeds the Data Retrieval Limit 59
Externalized Key Figures Dimension Retains Old Prompt Value 59
Older Cognos 8 Models Display Level Object Security 60
Informix Stored Procedures and Functions Are Not Imported Properly 60
Additional Data Source Created When Re-importing Objects From SAP 60
Problems Publishing a Package 60
Unable to Access Service at URL Error When Publishing a Model 60
Unable to Find the Functions List for a Vendor 61
Running Scripts That Publish Packages May Result in Broken Reports 61
Chapter 7: Problems Authoring Reports
63
Problems Creating Reports 63
Intermittent Problems Occur When Trying to Insert Data in a Report 63
Cannot Insert Data Into Table Cells 63
The Conditional Style Is Not Applied When Drilling-through 63
Cannot Collapse the Report in Query Studio 64
A Web Server Error When Trying to Browse Images 64
Negative Amounts Appear in Different Formats 64
An Error Message Appears When Changing the Language in a Reporting Application 65
Chart Labels Overwrite One Another 65
Chart Shows Only Every Second Label 65
Chart Gradient Backgrounds Appear Gray 65
Tooltips for Charts Appear Slowly in Japanese Operating System 65
A Chart Has Incorrect Height and Width Settings in HTML 66
The Point Layer or Region Layer is Missing From the CSV or XML Output for a
Map 66
The java.lang.OutOfMemory Error Message Appears in Cognos Connection or Report
Studio 66

剩余117页未读，继续阅读

资源推荐
资源评论
insurance_qian
  • 粉丝: 0
  • 资源: 10
上传资源 快速赚钱
voice
center-task 前往需求广场，查看用户热搜

最新资源