改了数据库字段后,cognos报表运行出错

0
RQP-DEF-0177

执行操作“sqlOpenResult”(状态为“-28”)时出错。




UDA-SQL-0114 为操作“sqlOpenResult”提供的游标无效。UDA-SQL-0283 描述“成品销售计划.业务伙伴名称”的元数据与数据库返回的结果不匹配。RSV-SRV-0042 回溯:RSReportService.cpp(826): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(259): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_RequestRSASyncExecutionThread.cpp(789): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(250): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(842): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(616): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(289): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(356): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(356): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSPageAssembly.cpp(303): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(306): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(175): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(306): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(137): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(356): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSResultSetIterator.cpp(1422): QFException: CCL_RETHROW: RSResultSetIterator::retrieveDataQFSPartialDataset.cpp(80): QFException: CCL_RETHROW: QFSPartialDataset::GetEdgeIteratorSource/QEDmResultSet.cpp(75): QFException: CCL_THROW: QE
已邀请:
2

茳桦 - BI售前支持,cognos工程师 2013-11-02 回答

明显的就是数据库的字段名改了,造成了所用字段无效所致,给你一个最佳的解决方法。你在模型的物理层select出来这个字段的时候,将该字段 as 一下你原先的字段名,这样的话,你的业务层,展现层,还有你的报表都不必更改了,只要将包重新发布一下,就OK了。
1

hupingzhi - 大数据架构师 2013-10-29 回答

更新fm模型中对应query对象,检查所有引用了修改的字段的地方
1

zhengyi1943 - Don't be afraid, just be brave to meet the destiny! 2013-10-30 回答

修改了数据库字段,需要重新验证和发布包。
因为旧的包包含的是弃用的数据库元数据信息,所以会爆元数据不匹配的错误。
0

Cindy_水 - Cognos讲师、Cognos独立顾问 2013-10-30 回答

如果是表中字段的增加或者减少,直接更新模型中对应表和对象,如果是字段的类型发生改变,只能重新拖该表到fm中,暂时字段类型的改变没办法更新

要回复问题请先登录注册