suse linux +cognos 10+ db2 9.7 【６４位】【安装布署记录】博客分类： BI cognos liunx 布署

程序员文章站 2024-03-23 23:38:10

...

--　export DISPLAY=10.1.12.159:0

gedit ~/.bashrc

JDK设置：通过编辑gedit ~/.bashrc来设置java_home
#set java envivonment
export JAVA_HOME=/root/jdk/jdk1.6.0_45
export CLASSPATH=.:$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH

export JAVA_HOME=/root/jdk/jdk1.6.0_45
export CLASSPATH=.:$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH

congos安装命令
linux-5lt4:~/cognos10install/linuxi38664h # ./issetup

3、将JDK下所有文件赋权限。则不会发生jdk拒绝访问
chmod -R 777 jdk

2.cognos打包前需要把，cognos的基本页面拷贝到打包目录下，以备打包时，或者运行时使用。
1）因为我们采用了DB２作为content store，因此需要将jconn2.jar拷贝到webapps/p2pd/WEB-INF/lib目录下；

3）将<COGNOS installed path>/c10_64/webcontent/ 下面的全部文件拷贝到 <COGNOS installed path>/c10_64/webapps/p2pd/下面。

5）将必备的jar放到classpath中
configuration打开后又出现一个问题，是由于java的classpath中缺少必要的jar造成的
我的环境中Copy the bcprov-jdk13-125.jar文件从cognos的库中复制到jre的ext目录下即可
另外，还要将db2java.zip、db2jcc、db2jcc_license_cu.jar从/opt/ibm/db2/V9.7/java复制到/opt/ibm/cognos/webapps/p2pd/WEB-INF/lib，并将db2java.zip重命名为db2java.jar
1.我想将home/wangshiming/Downloads里面的文件和文件夹等复制到home/wangshiming/tools目录怎么实现1
cp -rf /opt/ibm/cognos/c10_64/webcontent/* /opt/ibm/cognos/c10_64/webapps/p2pd/WEB-INF

//运行cognos configration
/opt/ibm/cognos/c10_64/bin64/cogconfig.sh
./cogconfig.sh

//db2cmd 输入DB2 了！

db2 "create db COG130 using codeset utf-8 territory cn"
db2 connect to COG130

(1)
db2 create bufferpool BF8 immediate size 250 pagesize 8k
db2 create bufferpool BF16 immediate size 250 pagesize 16k
db2 create bufferpool BF32 immediate size 250 pagesize 32k
db2 create system temporary tablespace STMP pagesize 32k managed by automatic storage extentsize 16 overhead 10.5 prefetchsize 16 transferrate 0.14 bufferpool BF32
db2 create user temporary tablespace UTMP pagesize 4k managed by automatic storage extentsize 16 overhead 10.5 prefetchsize 16 transferrate 0.14 bufferpool IBMDEFAULTBP
db2 create regular tablespace RUTS pagesize 4k managed by automatic storage extentsize 16 overhead 10.5 prefetchsize 16 transferrate 0.14 bufferpool IBMDEFAULTBP dropped table recovery on
db2 create regular tablespace RUTS8 pagesize 8k managed by automatic storage extentsize 16 overhead 10.5 prefetchsize 16 transferrate 0.14 bufferpool BF8 dropped table recovery on

(2)
db2 "create bufferpool bp4k pagesize 4k"
db2 "create bufferpool bp16k pagesize 16k"
db2 "create bufferpool bp32k pagesize 32k"
db2 "create system temporary tablespace temp16 pagesize 16k managed by automatic storage bufferpool bp16k"
db2 "create user temporary tablespace temp4 pagesize 4k managed by automatic storage bufferpool bp4k"
db2 "create tablespace tbs4k pagesize 4k managed by automatic storage bufferpool bp4k"

给内容库授权！！！
GRANT DBADM ON DATABASE TO USER db2admin
GRANT CONNECT ON DATABASE TO db2admin
GRANT CREATETAB ON DATABASE TO db2admin
GRANT IMPLICIT_SCHEMA ON DATABASE TO db2admin
GRANT BINDADD ON DATABASE TO db2admin
GRANT CREATE_NOT_FENCED_ROUTINE ON DATABASE TO db2admin
GRANT LOAD ON DATABASE TO db2admin

linux 设置JDK大小方法，修改配置文件catalina.sh
/opt/ibm/cognos/c10_64/tomcat/bin/catalina.sh

export JAVA_OPTS= -Xms128m -Xmx1024m 设置JAVA虚拟机的内存

export CATALINA_OPTS= -Xms256m -Xmx1024m    设置tomcat可以使用多少内存

-Xms128m   【初始化内存大小】 128M
-Xmx512m    【可以使用的最大内存】   512M

[Start Service]
[ ERROR ] CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured.
（１）
分析：这个错误是JVM申请内存时，不能满足要求。Cognos的服务分为大、中、小三类，他们的主要区别在于对内存大小的要求。Cognos安装后创建的服务类别为“小”，默认最大内存（Maximum Memory in MB）值为768。在32位环境下建议此值不要调整超过1.2G。
解决：调低对应服务的Maximum Memory in MB的值。
注意：该错误的编码为CFG-ERR-0106，但是不一定所有CFG-ERR-0106错误都是这个问题造成的，还是要具体问题具体分析。
（２）
错误原因有以下几种可能
参考方法1：
检查..\IBM\cognos\c10\configuration\cogconfig.prefs文件，确保其是UTF-8格式。

参考方法2：
在上面文件的后面添加如下两行
ServiceWaitInterval=1000
ServiceMaxTries=10

参考方法3：
检查系统环境变量中的JAVA_HOME是不是配置了java5或者更低版本，最好是删除JAVA_HOME，使得cognos使用自带的jre.

（7）
configuration文件夹下存在cogstartup.lock　解决：若能确认是非正常关闭点击Continue即可，若是由多用户同时操作造成，推荐先退出，待其他人退出后在使用，以免修改的配置被其他人误改。
/opt/ibm/cognos/c10_64/configuration/cogstartup.lock
所以进入/c10/configration删除cogstartup.lock文件即可

（8）启动COGNOS
cogbootstraoservice.exe –start
cogbootstrap

cd /opt/ibm/cognos/c10_64/bin64/
./cogbootstrapservice -start

（cognos新建数据源）｛确保继续做下去，要jdbc｝
jdbc:db2://ServerIP:50000/databasename

现在在FM中发布不了模型到COGNOS服务器上，

“QE-DEF-0368 无法解密来自内容库的用户名和密码凭证。检查并保存 Cognos Configuration 设置以配置您的报告环境。
”
将Server上的../configuration/csk目录拷贝到FM的../configuration目录中。

QE-DEF-0325 由于以下原因导致登录失败：RQP-DEF-0068 对 repdb2 中的 1 个数据库进行多项连接时，至少无法连接一个数据库。UDA-SQL-0569 无法载入驱动程序管理器库（libdb2.so）。UDA-SQL-0571 操作系统返回错误消息（libdb2.so: cannot open shared object file: No such file or directory）。

17/05/2013,10:30:04,Err,CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured.
Exception occurred during event dispatching:
java.lang.NullPointerException
        at com.cognos.i18n.ui.I18NWrappedPlainView.calculateBreakPosition(I18NWrappedPlainView.java:99)
        at javax.swing.text.WrappedPlainView$WrappedLine.breakLines(WrappedPlainView.java:769)
        at javax.swing.text.WrappedPlainView$WrappedLine.getPreferredSpan(WrappedPlainView.java:548)
        at javax.swing.text.View.getMinimumSpan(View.java:234)
        at javax.swing.text.BoxView.calculateMajorAxisRequirements(BoxView.java:854)
        at javax.swing.text.BoxView.checkRequests(BoxView.java:913)
        at javax.swing.text.BoxView.setSpanOnAxis(BoxView.java:312)
        at javax.swing.text.BoxView.layout(BoxView.java:692)
        at javax.swing.text.BoxView.setSize(BoxView.java:380)
        at javax.swing.text.WrappedPlainView.setSize(WrappedPlainView.java:375)
        at javax.swing.plaf.basic.BasicTextUI$RootView.setSize(BasicTextUI.java:1702)
        at javax.swing.plaf.basic.BasicTextUI.getPreferredSize(BasicTextUI.java:900)
        at javax.swing.plaf.basic.BasicTextAreaUI.getPreferredSize(BasicTextAreaUI.java:103)
        at javax.swing.JComponent.getPreferredSize(JComponent.java:1642)
        at javax.swing.JTextArea.getPreferredSize(JTextArea.java:617)
        at javax.swing.ScrollPaneLayout.layoutContainer(ScrollPaneLayout.java:769)
        at java.awt.Container.layout(Container.java:1419)
        at java.awt.Container.doLayout(Container.java:1408)
        at java.awt.Container.validateTree(Container.java:1505)
        at java.awt.Container.validateTree(Container.java:1511)
        at java.awt.Container.validateTree(Container.java:1511)
        at java.awt.Container.validateTree(Container.java:1511)
        at java.awt.Container.validateTree(Container.java:1511)
        at java.awt.Container.validate(Container.java:1478)
        at javax.swing.RepaintManager$2.run(RepaintManager.java:698)
        at javax.swing.RepaintManager$2.run(RepaintManager.java:696)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
        at javax.swing.RepaintManager.validateInvalidComponents(RepaintManager.java:695)
        at javax.swing.RepaintManager$ProcessingRunnable.run(RepaintManager.java:1667)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:672)
        at java.awt.EventQueue.access$400(EventQueue.java:81)
        at java.awt.EventQueue$2.run(EventQueue.java:633)
        at java.awt.EventQueue$2.run(EventQueue.java:631)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:642)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
        at java.awt.Dialog$1.run(Dialog.java:1052)
        at java.awt.Dialog$3.run(Dialog.java:1104)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1102)
        at com.cognos.crconfig.CnfgTaskDialog.show(CnfgTaskDialog.java:521)
        at com.cognos.crconfig.CnfgTaskDialog.begin(CnfgTaskDialog.java:597)
        at com.cognos.crconfig.data.CnfgActionEngine.run(CnfgActionEngine.java:139)
        at com.cognos.crconfig.CRConfigFrame.runAction(CRConfigFrame.java:2531)
        at com.cognos.crconfig.CRConfigFrame.runAction(CRConfigFrame.java:2535)
        at com.cognos.crconfig.CRConfigFrame.runServiceAction(CRConfigFrame.java:2381)
        at com.cognos.crconfig.CRConfigFrame.runAllServicesAction(CRConfigFrame.java:2301)
        at com.cognos.crconfig.CRConfigFrame.access$700(CRConfigFrame.java:111)
        at com.cognos.crconfig.CRConfigFrame$32.actionPerformed(CRConfigFrame.java:2656)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
        at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
        at java.awt.Component.processMouseEvent(Component.java:6297)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
        at java.awt.Component.processEvent(Component.java:6062)
        at java.awt.Container.processEvent(Container.java:2039)
        at java.awt.Component.dispatchEventImpl(Component.java:4660)
        at java.awt.Container.dispatchEventImpl(Container.java:2097)
        at java.awt.Component.dispatchEvent(Component.java:4488)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
        at java.awt.Container.dispatchEventImpl(Container.java:2083)
        at java.awt.Window.dispatchEventImpl(Window.java:2489)
        at java.awt.Component.dispatchEvent(Component.java:4488)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:674)
        at java.awt.EventQueue.access$400(EventQueue.java:81)
        at java.awt.EventQueue$2.run(EventQueue.java:633)
        at java.awt.EventQueue$2.run(EventQueue.java:631)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
        at java.awt.EventQueue$3.run(EventQueue.java:647)
        at java.awt.EventQueue$3.run(EventQueue.java:645)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:644)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)        at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
17/05/2013,10:33:02,Err,CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured.

[Start Service]
[ ERROR ] CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured.
11:15:16, 'LogService', 'StartService', 'Success'.
11:15:16, CAF input validation enabled.
11:15:16, CAF Third Party XSS checking disabled.
11:15:23, CM-SYS-2215 A Content Manager internal PRECACHEINITACTIONS task started.
11:15:23, CM-SYS-2216 A Content Manager internal PRECACHEINITACTIONS task is complete.
11:15:24, CM-SYS-2215 A Content Manager internal POSTINITACTIONS task started.
11:15:24, CM-SYS-2215 A Content Manager internal CMUPGRADESCRIPT task started.
11:15:25, 'ContentManagerService', 'StartService', 'Success'.
11:15:25, 'relationalMetadataService', 'StartService', 'Success'.
11:15:25, CM-SYS-5159 Content Manager is running in active mode.
11:15:24, CM-SYS-2216 A Content Manager internal POSTINITACTIONS task is complete.
11:15:26, DPR-DPR-1002 Successfully registered the dispatcher http://linux-5lt4:9300/p2pd in Content Manager.
11:16:00, 'camAsyncService', 'StartService', 'Success'.
11:16:38, 'IBM Cognos Enhanced Search Service', 'StartService', 'Success'.
11:16:38, 'ReportDataService', 'StartService', 'Success'.
11:16:38, 'BatchReportService', 'StartService', 'Success'.
11:16:39, Start a External Process because the start count 1 is larger than 0.
11:16:38, 'PresentationService', 'Upgrade', 'Success'.
11:16:39, 'PresentationService', 'StartService', 'Success'.
11:16:38, 'CacheService', 'StartService', 'Success'.
11:16:38, 'ContentManagerCacheService', 'StartService', 'Success'.
11:17:57, 'QueryService', 'StartService', 'Success'.
[ WARNING ] Please wait while the current task finishes. Any subsequent tasks will be canceled.

附参考文档：

Cognos10_for_linux安装配置指南.doc

Cognos+8.3+I386+FOR+Linux64Bit安装文档.docx

linux-cognos安装.doc

Cognos8.4_Linux安装_精选.docx

cognos_liunx_db2　安装　参考文档.rar (5.9 MB)
下载次数: 60

suse linux +cognos 10+ db2 9.7 【６４位】【安装布署记录】 博客分类： BI cognos liunx 布署