大家好,请教各位一个关于cognos cube的问题,多谢了。
我有一个cube,其中的数据很多,是每日增量更新的,现在的大小有4.35GB,之前一直正常,突然从上周开始就报这个“系统内存不足”的错误了,
我google了一下,找到了下面两个解决方案
1.官方的
http://www-01.ibm.com/support/docview.wss?uid=swg213433452.论坛的
http://www.cognoschina.net/club/thread-24586-1-1.html就是下面的方法:
一个方法是增加读取cube的缓存大小,一个是清空cognos的临时文件。
具体:
1,打开cognos administration-->配置--->数据源连接--->单击选择你需要的数据源--->设置属性--->连接--->编辑连接字符串(铅笔符号)--->读取高速缓存大小(填写一个足够大的值,这个因为服务器不一所以不一)-->确定
2,删除cognos bin目录下的dmp临时文件
重启。
我按照上面的方法照做了,并且将readCacheSize调整为8096M,并重启cognos,但是依然报同样的错误。我的服务器相关信息cognos版本:8.4.1
内存:16G
操作系统:64位windows2008r2
服务器内存使用情况:
详细错误日志:172.19.118.7:9300 1980 2015-05-19 16:35:34.989+8 Thread-77 caf 60121
Audit.dispatcher.caf
Request
Failure
SecureErrorId: 2015-05-19-16:35:34.988-#526 Original Error: PDS-PPE-0083 系统内存不足。 (安全) RSV-SRV-0042 回溯: RSReportService.cpp(779): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(265): QFException:
CCL_RETHROW: RSReportServiceMethod::process(): reportEditAnalysis_Request RSASyncExecutionThread.cpp(788): QFException:
RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run():
reportEditAnalysis_Request RSASyncExecutionThread.cpp(838): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand():
reportEditAnalysis_Request PPSAnalysis.cpp(177): QFException: CCL_RETHROW: PPSAnalysis::executeAnalysis PPSAnalysis.cpp(169): QFException: CCL_CAUGHT:
PPSAnalysis::executeAnalysis core/RequestContext.cpp(536): QFException: CCL_RETHROW: RequestContext::handleRequest core/RequestContext.cpp(529):
QFException: CCL_CAUGHT: RequestContext::handleRequest core/RequestContext.cpp(587): QFException: CCL_RETHROW: RequestContext::establishContext
core/RequestContext.cpp(582): QFException: CCL_CAUGHT: RequestContext::establishContext scmd/QuerySessionProxy.cpp(57): QFException: CCL_RETHROW:
CFaultSavvyProxy::DoRequest scmd/QuerySessionProxy.cpp(55): QFException: CCL_CAUGHT: CFaultSavvyProxy::DoRequest RSQFSession.cpp(305): QFException:
CCL_RETHROW: RSQFSession::DoRequest QFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(717): QFException:
CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(662): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(637):
QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(751): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(213):
QFException: CCL_RETHROW: QFSQuery::Execute v2 BmtRtmBuilderImp.cpp(641): QFException: CCL_RETHROW: BmtRtmBuilderImp::CreateConversionScript
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction BmtActionsHelper.cpp(488): QFException: CCL_RETHROW:
BmtActionsHelper::DoAction QFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(717): QFException: CCL_CAUGHT:
QFSSession::ProcessDoRequest() QFSSession.cpp(662): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(637): QFException:
CCL_RETHROW: QFSSession::ProcessDoRequest() MPCAPPDS.cpp(159): QFException: CCL_RETHROW: MPCAPPDS::ProviderConnect MPCAPPDS.cpp(426): QFException:
CCL_RETHROW: MPCAPPDSCube.cpp(569): QFException: CCL_THROW: MPCAPPDSCube::SetCubeSecurity
收起