急急!
我在用PowerCenter抽取文本数据文件到数据库的时候,在对应的source的配置中中用的都是参数,而在参数文件中都对相应的参数给了值,但是当我把参数文件引用到session运行的时候,老是提示我的参数没有初始化,可是明明我的参数文件里面对他们定义了的,而且我引用的路径也是对的,很奇怪,求好心人帮忙,分我全给了。谢谢!提醒一下,可是我在数据库里卸载数据到文本文件的时候也用参数文件是没有错的。
下面我把workflow的错误的日志贴出来:
Severity Timestamp Node Thread Message Code Message
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36435 Starting execution of workflow [wf_load_Invest_INVEST_TBPRODUCT] in folder [ODM_LAY] last saved by user [Administrator].
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_44206 Workflow wf_load_Invest_INVEST_TBPRODUCT started with run id [242], run instance name [], run type [Concurrent Run Disabled].
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_44195 Workflow [wf_load_Invest_INVEST_TBPRODUCT] service level [SLPriority:5,SLDispatchWaitTime:1800].
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_44253 Workflow started. Clients will be notified
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36330 Start task instance [Start]: Execution started.
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36318 Start task instance [Start]: Execution succeeded.
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36505 Link [Start --> s_m_load_Invest_INVEST_TBPRODUCT]: empty expression string, evaluated to TRUE.
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36388 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] is waiting to be started.
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36682 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT]: started a process with pid [1695992] on node [node01_aix2].
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36330 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT]: Execution started.
INFO 2010/7/30 17:33:35 node01_aix2 8226 VAR_27085 Parameter file [/home/crm/LFcrm/run/cfg/informatica/profile.cfg] is opened for [session [wf_load_Invest_INVEST_TBPRODUCT.s_m_load_Invest_INVEST_TBPRODUCT]].
INFO 2010/7/30 17:33:35 node01_aix2 8226 VAR_27062 Warning! Cannot find section for workflow [wf_load_Invest_INVEST_TBPRODUCT] and folder [ODM_LAY] in parameter file [/home/crm/LFcrm/run/cfg/informatica/profile.cfg].
INFO 2010/7/30 17:33:35 node01_aix2 8226 VAR_27016 Warning! Cannot find section for session [s_m_load_Invest_INVEST_TBPRODUCT] and folder [ODM_LAY] in parameter file [/home/crm/LFcrm/run/cfg/informatica/profile.cfg].
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6793 Fetching initialization properties from the Integration Service. : (Fri Jul 30 17:33:33 2010)]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [DISP_20305 The [Preparer] DTM with process id [1695992] is running on node [node01_aix2].
: (Fri Jul 30 17:33:33 2010)]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [PETL_24036 Beginning the prepare phase for the session.]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6721 Started [Connect to Repository].]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6722 Finished [Connect to Repository]. It took [1.10531] seconds.]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6794 Connected to repository [rep_lfpcrm] in domain [Domain_aix2] as user [Administrator] in security domain [Native].]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6721 Started [Fetch Session from Repository].]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6722 Finished [Fetch Session from Repository]. It took [0.143105] seconds.]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6793 Fetching initialization properties from the Integration Service. : (Fri Jul 30 17:33:35 2010)]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [CMN_1761 Timestamp Event: [Fri Jul 30 17:33:35 2010]]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [VAR_27026 Error: Missing initial value for session parameter:[$InputFileName].]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [CMN_1761 Timestamp Event: [Fri Jul 30 17:33:35 2010]]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6270 Error: Variable parameter expansion error.]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [CMN_1761 Timestamp Event: [Fri Jul 30 17:33:35 2010]]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6163 An error occurred initializing variables and parameters for the partition.]
ERROR 2010/7/30 17:33:37 node01_aix2 7455 LM_36320 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT]: Execution failed.
INFO 2010/7/30 17:33:37 node01_aix2 7455 LM_36318 Workflow [wf_load_Invest_INVEST_TBPRODUCT]: Execution succeeded.
我在用PowerCenter抽取文本数据文件到数据库的时候,在对应的source的配置中中用的都是参数,而在参数文件中都对相应的参数给了值,但是当我把参数文件引用到session运行的时候,老是提示我的参数没有初始化,可是明明我的参数文件里面对他们定义了的,而且我引用的路径也是对的,很奇怪,求好心人帮忙,分我全给了。谢谢!提醒一下,可是我在数据库里卸载数据到文本文件的时候也用参数文件是没有错的。
下面我把workflow的错误的日志贴出来:
Severity Timestamp Node Thread Message Code Message
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36435 Starting execution of workflow [wf_load_Invest_INVEST_TBPRODUCT] in folder [ODM_LAY] last saved by user [Administrator].
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_44206 Workflow wf_load_Invest_INVEST_TBPRODUCT started with run id [242], run instance name [], run type [Concurrent Run Disabled].
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_44195 Workflow [wf_load_Invest_INVEST_TBPRODUCT] service level [SLPriority:5,SLDispatchWaitTime:1800].
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_44253 Workflow started. Clients will be notified
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36330 Start task instance [Start]: Execution started.
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36318 Start task instance [Start]: Execution succeeded.
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36505 Link [Start --> s_m_load_Invest_INVEST_TBPRODUCT]: empty expression string, evaluated to TRUE.
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36388 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] is waiting to be started.
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36682 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT]: started a process with pid [1695992] on node [node01_aix2].
INFO 2010/7/30 17:33:33 node01_aix2 7455 LM_36330 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT]: Execution started.
INFO 2010/7/30 17:33:35 node01_aix2 8226 VAR_27085 Parameter file [/home/crm/LFcrm/run/cfg/informatica/profile.cfg] is opened for [session [wf_load_Invest_INVEST_TBPRODUCT.s_m_load_Invest_INVEST_TBPRODUCT]].
INFO 2010/7/30 17:33:35 node01_aix2 8226 VAR_27062 Warning! Cannot find section for workflow [wf_load_Invest_INVEST_TBPRODUCT] and folder [ODM_LAY] in parameter file [/home/crm/LFcrm/run/cfg/informatica/profile.cfg].
INFO 2010/7/30 17:33:35 node01_aix2 8226 VAR_27016 Warning! Cannot find section for session [s_m_load_Invest_INVEST_TBPRODUCT] and folder [ODM_LAY] in parameter file [/home/crm/LFcrm/run/cfg/informatica/profile.cfg].
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6793 Fetching initialization properties from the Integration Service. : (Fri Jul 30 17:33:33 2010)]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [DISP_20305 The [Preparer] DTM with process id [1695992] is running on node [node01_aix2].
: (Fri Jul 30 17:33:33 2010)]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [PETL_24036 Beginning the prepare phase for the session.]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6721 Started [Connect to Repository].]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6722 Finished [Connect to Repository]. It took [1.10531] seconds.]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6794 Connected to repository [rep_lfpcrm] in domain [Domain_aix2] as user [Administrator] in security domain [Native].]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6721 Started [Fetch Session from Repository].]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6722 Finished [Fetch Session from Repository]. It took [0.143105] seconds.]
INFO 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6793 Fetching initialization properties from the Integration Service. : (Fri Jul 30 17:33:35 2010)]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [CMN_1761 Timestamp Event: [Fri Jul 30 17:33:35 2010]]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [VAR_27026 Error: Missing initial value for session parameter:[$InputFileName].]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [CMN_1761 Timestamp Event: [Fri Jul 30 17:33:35 2010]]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6270 Error: Variable parameter expansion error.]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [CMN_1761 Timestamp Event: [Fri Jul 30 17:33:35 2010]]
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [TM_6163 An error occurred initializing variables and parameters for the partition.]
ERROR 2010/7/30 17:33:37 node01_aix2 7455 LM_36320 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT]: Execution failed.
INFO 2010/7/30 17:33:37 node01_aix2 7455 LM_36318 Workflow [wf_load_Invest_INVEST_TBPRODUCT]: Execution succeeded.
解决方案 »
- 问几个ORACLE 的小问题
- 急求一个sql语句,表信息在正文中
- 求rhell linux下 oracle rman恢复的完整实例,谢谢了!
- 那位有oracle的错误编码列表和相应的中文描述
- 怎样把.gz文件复制到磁带机
- 关于database link 连接的问题
- oracle数据备份和恢复问题
- 新手请教:如何进行数据库的连接???/
- beckhambobo(beckham)请回答我的问题谢谢!!
- plsql右击表—>查询数据 查不到数据 但是运行查询语句可以查到 这是怎么回事
- linux下启动oracle报Connected to an idle instance.
- solaris下使用dbca创建数据库报错:ora-12560
ERROR 2010/7/30 17:33:35 node01_aix2 7712 LM_36488 Session task instance [s_m_load_Invest_INVEST_TBPRODUCT] : [VAR_27026 Error: Missing initial value for session parameter:[$InputFileName].]