软件开发商业智能

关于cognos的Transformer中cube刷新,categories有限制吗

最近遇到个问题,cube刷新失败,log在下面:
PowerPlay Transformer(7.3.908.0 )  Wed Mar 23 01:49:26 2011
LogFileDirectory=D:EDWAppbuildbldlogs
ModelSaveDirectory=D:EDWAppBuildmodels
DataSourceDirectory=D:EDWAppBuildds
CubeSaveDirectory=D:EDWAppBuildcubes
DataWorkDirectory=E:TEMP
ModelWorkDirectory=E:TEMP
MaxTransactionNum=500000
ReadCacheSize=65536
WriteCacheSize=65536
Temporary UDA directory=E:TEMP
Wed 23 Mar 2011 01:49:46 AM 4 000D94D5 Start cube update.
Wed 23 Mar 2011 01:49:46 AM 4 000D94D5 Initializing categories.
Wed 23 Mar 2011 01:49:46 AM 4 000D94D5 Timing, INITIALIZING CATEGORIES,00:00:00
Wed 23 Mar 2011 01:49:46 AM 4 000D94D5 Start processing data source '.OPER_NCON_TIME_PERIOD.iqd'.
Wed 23 Mar 2011 01:49:46 AM 4 000D94D5 Reading source data.
Wed 23 Mar 2011 01:49:49 AM 4 000D94D5 Timing, OPEN DATA SOURCE,00:00:03
Wed 23 Mar 2011 01:49:49 AM 4 000D94D5 End processing 1 records from data source '.OPER_NCON_TIME_PERIOD.iqd'.
Wed 23 Mar 2011 01:49:49 AM 4 000D94D5 Timing, READ DATA SOURCE,00:00:03
Wed 23 Mar 2011 01:49:49 AM 4 000D94D5 Marking categories used.
Wed 23 Mar 2011 01:49:49 AM 4 000D94D5 Timing, MARKING CATEGORIES USED,00:00:00
Wed 23 Mar 2011 01:49:49 AM 4 000D94D5 Initializing categories.
Wed 23 Mar 2011 01:49:49 AM 4 000D94D5 Timing, INITIALIZING CATEGORIES,00:00:00
Wed 23 Mar 2011 01:49:49 AM 4 000D94D5 Start processing data source '.OPER_CUSTOMER_HIER.iqd'.
Wed 23 Mar 2011 01:49:49 AM 4 000D94D5 Reading source data.
Wed 23 Mar 2011 01:49:54 AM 4 000D94D5 Timing, OPEN DATA SOURCE,00:00:05
Wed 23 Mar 2011 01:49:56 AM 4 000D94D5 End processing 8324 records from data source '.OPER_CUSTOMER_HIER.iqd'.
Wed 23 Mar 2011 01:49:56 AM 4 000D94D5 Timing, READ DATA SOURCE,00:00:07
Wed 23 Mar 2011 01:49:56 AM 4 000D94D5 Marking categories used.
Wed 23 Mar 2011 01:49:56 AM 4 000D94D5 Timing, MARKING CATEGORIES USED,00:00:00
Wed 23 Mar 2011 01:49:56 AM 4 000D94D5 Initializing categories.
Wed 23 Mar 2011 01:49:56 AM 4 000D94D5 Timing, INITIALIZING CATEGORIES,00:00:00
Wed 23 Mar 2011 01:49:56 AM 4 000D94D5 Start processing data source '.BUDGETED_FLAT_COST_CTR_HIER.iqd'.
Wed 23 Mar 2011 01:49:56 AM 4 000D94D5 Reading source data.
Wed 23 Mar 2011 01:50:00 AM 4 000D94D5 Timing, OPEN DATA SOURCE,00:00:04
Wed 23 Mar 2011 01:50:31 AM 4 000D94D5 End processing 111473 records from data source '.BUDGETED_FLAT_COST_CTR_HIER.iqd'.
Wed 23 Mar 2011 01:50:31 AM 4 000D94D5 Timing, READ DATA SOURCE,00:00:35
Wed 23 Mar 2011 01:50:31 AM 4 000D94D5 Marking categories used.
Wed 23 Mar 2011 01:50:32 AM 4 000D94D5 Timing, MARKING CATEGORIES USED,00:00:01
Wed 23 Mar 2011 01:50:32 AM 4 000D94D5 Initializing categories.
Wed 23 Mar 2011 01:50:32 AM 4 000D94D5 Timing, INITIALIZING CATEGORIES,00:00:00
Wed 23 Mar 2011 01:50:32 AM 4 000D94D5 Start processing data source '.BUDGETED_FLAT_PROFIT_CTR_HIER.iqd'.
Wed 23 Mar 2011 01:50:32 AM 4 000D94D5 Reading source data.
Wed 23 Mar 2011 01:50:34 AM 4 000D94D5 Timing, OPEN DATA SOURCE,00:00:02
Wed 23 Mar 2011 01:50:35 AM 4 000D94D5 End processing 2893 records from data source '.BUDGETED_FLAT_PROFIT_CTR_HIER.iqd'.
Wed 23 Mar 2011 01:50:35 AM 4 000D94D5 Timing, READ DATA SOURCE,00:00:03
Wed 23 Mar 2011 01:50:35 AM 4 000D94D5 Marking categories used.
Wed 23 Mar 2011 01:50:35 AM 4 000D94D5 Timing, MARKING CATEGORIES USED,00:00:00
Wed 23 Mar 2011 01:50:35 AM 4 000D94D5 Initializing categories.
Wed 23 Mar 2011 01:50:35 AM 4 000D94D5 Timing, INITIALIZING CATEGORIES,00:00:00
Wed 23 Mar 2011 01:50:35 AM 4 000D94D5 Start processing data source '.SP_DL_METRICS_FACT.iqd'.
Wed 23 Mar 2011 01:50:35 AM 4 000D94D5 Reading source data.
Wed 23 Mar 2011 02:00:51 AM 4 000D94D5 Timing, OPEN DATA SOURCE,00:10:16
Wed 23 Mar 2011 02:00:51 AM 4 000D94D5 1 records have been read; 148486 categories have been created.
Wed 23 Mar 2011 02:10:51 AM 4 000D94D5 1648000 records have been read; 613296 categories have been created.
Wed 23 Mar 2011 02:21:25 AM 4 000D94D5 3277000 records have been read; 972304 categories have been created.
Wed 23 Mar 2011 02:32:39 AM 4 000D94D5 4218000 records have been read; 1157118 categories have been created.
Wed 23 Mar 2011 02:42:39 AM 4 000D94D5 5656000 records have been read; 1410380 categories have been created.
Wed 23 Mar 2011 02:53:04 AM 4 000D94D5 6879000 records have been read; 1600380 categories have been created.
Wed 23 Mar 2011 03:03:04 AM 4 000D94D5 7792000 records have been read; 1718213 categories have been created.
Wed 23 Mar 2011 03:13:37 AM 4 000D94D5 8106000 records have been read; 1754744 categories have been created.
Wed 23 Mar 2011 03:23:37 AM 4 000D94D5 9496000 records have been read; 1903036 categories have been created.
Wed 23 Mar 2011 03:33:37 AM 4 000D94D5 10855000 records have been read; 2039236 categories have been created.
Wed 23 Mar 2011 03:43:37 AM 4 000D94D5 12247000 records have been read; 2175416 categories have been created.
Wed 23 Mar 2011 03:53:37 AM 4 000D94D5 13613000 records have been read; 2304487 categories have been created.
Wed 23 Mar 2011 04:01:44 AM 4 000D94D5 End processing 14636433 records from data source '.SP_DL_METRICS_FACT.iqd'.
Wed 23 Mar 2011 04:01:44 AM 4 000D94D5 Timing, READ DATA SOURCE,02:11:09
Wed 23 Mar 2011 04:02:37 AM 4 000D94D5 Marking categories used.
Wed 23 Mar 2011 04:02:45 AM 4 000D94D5 Timing, MARKING CATEGORIES USED,00:00:08
Wed 23 Mar 2011 04:03:21 AM 4 000D94D5 Updating category status.
Wed 23 Mar 2011 04:03:22 AM 4 000D94D5 Processing the work file.
Wed 23 Mar 2011 04:04:37 AM 4 000001CF Processing cube 'SP_DL_METRIC_CUBE' at location D:EDWAppBuildcubes.SP_DL_METRIC_CUBE.mdc
Wed 23 Mar 2011 04:04:37 AM 4 000D94D5 Timing, UPDATE CATEGORY AND PROCESS WORK FILE,00:01:16
Wed 23 Mar 2011 04:04:37 AM 4 000001CF Start metadata update of cube 'SP_DL_METRIC_CUBE'.
Wed 23 Mar 2011 04:04:37 AM 4 000D94D5 Marking categories needed.
Wed 23 Mar 2011 04:04:40 AM 4 000D94D5 Updating the PowerCube metadata.
Wed 23 Mar 2011 04:15:04 AM 4 000D94D5 298000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 04:25:14 AM 4 000D94D5 396000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 04:36:00 AM 4 000D94D5 463000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 04:46:39 AM 4 000D94D5 561000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 04:57:13 AM 4 000D94D5 633000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 05:07:26 AM 4 000D94D5 699000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 05:17:58 AM 4 000D94D5 768000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 05:28:19 AM 4 000D94D5 832000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 05:38:48 AM 4 000D94D5 901000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 05:49:25 AM 4 000D94D5 966000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 05:59:28 AM 4 000D94D5 1028000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 06:09:38 AM 4 000D94D5 1091000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 06:19:50 AM 4 000D94D5 1153000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 06:30:16 AM 4 000D94D5 1216000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 06:40:23 AM 4 000D94D5 1278000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 06:51:01 AM 4 000D94D5 1342000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 07:01:22 AM 4 000D94D5 1401000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 07:11:55 AM 4 000D94D5 1461000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 07:22:32 AM 4 000D94D5 1523000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 07:33:00 AM 4 000D94D5 1582000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 07:43:26 AM 4 000D94D5 1640000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 07:53:49 AM 4 000D94D5 1698000 categories (of 2400782) have been processed.
Wed 23 Mar 2011 08:03:21 AM 4 000D94D5 Updating the PowerCube with currency data.
Wed 23 Mar 2011 08:06:50 AM 4 000001CF End metadata update of cube 'SP_DL_METRIC_CUBE'.  1744595 categories were added to the cube.
Wed 23 Mar 2011 08:06:50 AM 4 000D94D5 Timing, METADATA,04:02:13
Wed 23 Mar 2011 08:06:50 AM 4 000001CF Start update of cube 'SP_DL_METRIC_CUBE'.
Wed 23 Mar 2011 08:08:03 AM 4 000D94D5 End cube update.
Wed 23 Mar 2011 08:08:03 AM 4 000D94D5 Timing, TOTAL TIME (CREATE CUBE),06:18:17
PowerPlay Transformer  Wed Mar 23 08:08:07 2011

==================================================
之前categories在2309354 的时候成功了,但是2400782 失败了,错误描述是Error Description: trModel(CreateMDCFiles) : (TR0112) There isn't enough memory available.
谁有没有什么好的解决办法啊,先谢谢了?

参与7

6同行回答

dy2216dy2216软件开发工程师上海新致
最好层次不要太多显示全部
最好层次不要太多收起
互联网服务 · 2012-01-29
浏览961
xiaobaicanxiaobaican软件开发工程师南方航空公司
回复 1# jim6745     我也遇到了这样的问题,请问楼主解决了吗?显示全部
回复 1# jim6745


    我也遇到了这样的问题,请问楼主解决了吗?收起
轨道交通 · 2011-04-02
浏览932
hubeiliubinhubeiliubin软件开发工程师惠州市惠城区环城西路柏子树下66号
不知二楼增加虚拟内存的方法能否解决楼主的问题,之前碰到过此类问题,楼主可试下增加一个层次。显示全部
不知二楼增加虚拟内存的方法能否解决楼主的问题,之前碰到过此类问题,楼主可试下增加一个层次。收起
政府机关 · 2011-03-30
浏览920
五老星2011五老星2011数据仓库开发工程师安邦保险
楼主内存多大?显示全部
楼主内存多大?收起
金融其它 · 2011-03-30
浏览915
hbjlwhlhbjlwhl软件开发工程师好地方
这东西确实比较耗内存啊!!显示全部
这东西确实比较耗内存啊!!收起
互联网服务 · 2011-03-29
浏览995
stilltherestillthere软件开发工程师HP
Did you have a chance to take a look at:https://www-304.ibm.com/support/docview.wss?uid=swg21371565Let us know how it goes.显示全部
Did you have a chance to take a look at:

https://www-304.ibm.com/support/docview.wss?uid=swg21371565

Let us know how it goes.收起
互联网服务 · 2011-03-29
浏览947

提问者

jim6745
软件开发工程师hpe
擅长领域: 大数据商业智能

相关问题

相关资料

问题状态

  • 发布时间:2011-03-24
  • 关注会员:1 人
  • 问题浏览:4846
  • 最近回答:2012-01-29
  • X社区推广