视图显示错误 Exceeded configured maximum number of allowed output prompts,
注意:记得提前把要添加的xml 做好备份再进行修改,否则,一旦出错会导致重新安装biee 酿成悲剧啊
BIEE检索数据时提示如下错误:
'Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.'
解决办法:
原文地址:https://cn.forums.oracle.com/forums/thread.jspa?threadID=2263447
在D:\BIEE\instances\instance2\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml文件中添加如下代码:
View Code
<ServerInstance>
...........
<Views>
<Pivot>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DisableAutoPreview>false</DisableAutoPreview>
<!--++++++++add start++++++++++++++++++++++++++++++++++++-->
<MaxVisibleColumns>3000</MaxVisibleColumns>
<MaxVisibleRows>1500</MaxVisibleRows>
<MaxVisibleSections>50</MaxVisibleSections>
<MaxVisiblePages>1000</MaxVisiblePages>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Pivot>
<Cube>
<CubeMaxRecords>35000</CubeMaxRecords>
<CubeMaxPopulatedCells>65000</CubeMaxPopulatedCells>
</Cube>
<Charts>
<MaxVisibleColumns>2000</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>2000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<JavaHostReadLimitInKB>6144</JavaHostReadLimitInKB>
</Charts>
<!--++++++add end++++++++++++++++++++++++++++++++++++++-->
<Table>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--++++++++add start++++++++++++++++++++++++++++++++++++-->
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>1500</MaxVisibleRows>
<MaxVisibleSections>50</MaxVisibleSections>
<MaxCells>65000</MaxCells>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
<!--++++++add end++++++++++++++++++++++++++++++++++++++-->
</Table>
</Views>
...........
</ServerInstance>
分享到:
相关推荐
整个unity里面的shader的#pragma multi xxxxx_ON 关键字不能超过256个,给系统添加负担...所以会报错:maximum number (256) of shader keywords exceeded unity。 做法是减少关键字的使用。 下面提供一个优化工具。
The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
解决常见的破解不完全问题:The maximum number of licenses has been exceeded for the following servers 弹窗! 将此文件替换安装目录C:\Program Files\Design Explorer 99 SE,如当初安装protel99时自定义了安装...
主要介绍了详解 Java Maximum redirects (100) exceeded的相关资料,需要的朋友可以参考下
The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook is a wrong excepiton 将抛异常的方法去掉,是程序继续执行,生成excel 。本来想免费,但是苦于没积分所以...
Maximum最大值
最近做的程序中涉及到的循环比较多且处理的情况较复杂,在运行程序时出现执行超时提示如下:Fatal error: Maximum execution time of 30 seconds exceeded in D:phpAppServwwwsum3test.php on line 3通过在网上搜索...
解决 Maximum number of format records exceeded 问题
每在页面中上传较大的文件时遇到FastCgi的错误:“The FastCGI process exceeded configured request timeout”,几经试验,明白了需要修改FastCgi的配置文件“fcgiext.ini”,位于目录“C:/WINDOWS/system32/...
利用struts2上传文件 环境配置JDK1.8 Eclipse 版本 Version: Mars Release (4.5.0) tomcat版本7.0.40 注意的问题是文件上传的时候的enctype="multipart/form-data" 如果设置错误会报错 今天初次使用Struts 2做文件...
本篇文章是对解决PHP mysql_query执行超时(Fatal error: Maximum execution time of 300 seconds exceeded in…)的问题进行了详细的分析介绍,需要的朋友参考下
hive报hdfs exceeded directory item limit错误,是由于每次任务失败或者异常退出会造成存在HDFS上的临时目录不自动删除,HDFS目录文件数达到上限,可以脚本清理旧的无用目录解决
Kudu :Service unavailable: Soft memory limit exceeded at xxx% of capacity 3.原因 内存限制问题(Memory Limits): Kudu都有一个硬性和软性的内存限制。 硬存储器限制是Kudu进程允许使用的最大数量,由--...
超出最大会话数和Ora-00020超出最大进程数错误的解决方法 Ora-00018 Maximum number of sessions exceeded超出最大会话数
导入导出、合并单元格处理代码示例 jar包解决导出Excel 出现的问题:Warning: Maximum number of format records exceeded. Using default format.
presto提供多数据源,可以通过该语句从其他数据源导入数据到presto,作为ETL的手段。
小程序开发 crypto-js 报错 加密 解密 maximum call stack size exceeded
☆ 资料说明: ☆ Telerik RadControls for Windows 8 XAML 2013 Q3 2013.3.1015 此版本为开发版(零售版),无需序列号、无需破解;
Paging is represented by a number of counters including page faults/sec, page input/sec and page output/sec. Page faults/sec include soft and hard page faults where as the page input/output counters ...