FDM向HFM加载 Cell Text时报错

问题描述：

报错信息如下：

2016-01-20 10:03:40,539 INFO  [AIF]: ************************************************************************************

2016-01-20 10:03:40,539 INFO  [AIF]: *      HFM_LOAD.py Started for LoadID: 51

2016-01-20 10:03:40,539 INFO  [AIF]: ************************************************************************************

2016-01-20 10:03:40,663 INFO  [AIF]: Cluster name:  hfmprd

2016-01-20 10:03:40,819 INFO  [AIF]: Connected to: JEREHHFM

2016-01-20 10:03:44,863 INFO  [AIF]: Load data started: 2016/1/20 10:03:40.

2016-01-20 10:03:44,863 INFO  [AIF]: Load data completed: 2016/1/20 10:03:40.

2016-01-20 10:03:44,895 INFO  [AIF]: Records Loaded: 893

2016-01-20 10:03:44,895 INFO  [AIF]: blnDataAsJournal-->1: False

2016-01-20 10:03:45,318 ERROR [AIF]: ORA-01000: maximum open cursors exceeded

2016-01-20 10:03:45,318 ERROR [AIF]: Error during Cell Text Load

2016-01-20 10:03:45,318 ERROR [AIF]: 'NoneType' object has no attribute 'next'

2016-01-20 10:03:45,321 ERROR [AIF]: The script has failed to execute:

2016-01-20 10:03:45,325 FATAL [AIF]: Error in Comm.executeJythonScript

Traceback (most recent call last):

  File "<string>", line 564, in executeJythonScript

  File "/app/epm/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/HFM_LOAD.py", line 1072, in <module>

    raise Exception("Cell Text Failed.")

Exception: Cell Text Failed.

2016-01-20 10:03:45,326 FATAL [AIF]: Error in HfmData.loadData

Traceback (most recent call last):

  File "<string>", line 42, in loadData

  File "<string>", line 587, in executeVBScript

  File "<string>", line 564, in executeJythonScript

  File "/app/epm/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/HFM_LOAD.py", line 1072, in <module>

    raise Exception("Cell Text Failed.")

Exception: Cell Text Failed.

解决方案：

DBA  登陆数据库

打开  Command Window  ，

--调高 open_cursors  的值

SQL> alter system set open_cursors=3000 scope=both;

--查看修改后的 open_cursors

SQL>show parameter open_cursors;