使用参数文件的参数为session选项赋值报错WRT_8004

紫胸佛法僧 2017-11-09 07:05:18
本来是因为要配置的会话太多了,而且目标导出为文件格式,以后可能路径会经常变更,所以想使用参数文件进行配置,结果报出以下错误.希望有大神能解决一下,谢谢

报错信息:
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : VAR_27092 : Warning! Found an unused name and value pair [$$DATE_FORMAT = YYYY/MM/DD HH24:MI:SS].
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : VAR_27092 : Warning! Found an unused name and value pair [$$SOURCE_FILTER = EXT_Date_Time>= DATE_FORMAT(DATE_SUB(now(),INTERVAL 1 DAY),'%Y-%m-%d') and EXT_Date_Time < DATE_FORMAT(now(),'%Y-%m-%d')].
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : VAR_27092 : Warning! Found an unused name and value pair [$$FILESDIR = /Informatica/data/mcpspogg].
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6014 : Initializing session [s_mcpsp_D_IO_DET] at [Thu Nov 09 17:57:27 2017].
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6683 : Repository Name: [rep_tj]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6684 : Server Name: [int]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6686 : Folder: [mcpsp_ogg]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6685 : Workflow: [test_1] Run Instance Name: [] Run Id: [4369]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6101 : Mapping name: mcpsp_D_IO_DET.
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6964 : Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6348 : The maximum number of files that can be open at a time is 65536.
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6708 : Using configuration property [EnableDataEncryption,no]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6708 : Using configuration property [StoreHAPersistenceInDB,no]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6708 : Using configuration property [NLS_LANG,AMERICAN_AMERICA.ZHS16GBK]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6708 : Using configuration property [$FILESDIR,/Informatica/data/mcpspogg]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : TM_6703 : Session [s_mcpsp_D_IO_DET] is run by 64-bit Integration Service [node01_informatica1], version [9.6.1 HotFix3], build [0611].
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : PETL_24088 : Registering the session with the Integration Service
2017-11-09 17:57:27 : 信息 : (69637 | MANAGER) : (IS | int) : node01_informatica1 : PETL_24058 : Running Partition Group [1].
2017-11-09 17:57:27 : 信息 : (69637 | MANAGER) : (IS | int) : node01_informatica1 : PETL_24000 : Parallel Pipeline Engine initializing.
2017-11-09 17:57:27 : 信息 : (69637 | MANAGER) : (IS | int) : node01_informatica1 : PETL_24001 : Parallel Pipeline Engine running.
2017-11-09 17:57:27 : 信息 : (69637 | MANAGER) : (IS | int) : node01_informatica1 : PETL_24003 : Initializing session run.
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : CMN_1569 : Server Mode: [UNICODE]
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : CMN_1570 : Server Code page: [UTF-8 encoding of Unicode]
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : TM_6151 : The session sort order is [Binary].
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : TM_6155 : Using HIGH precision processing.
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : TM_6180 : Deadlock retry logic will not be implemented.
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : TM_6187 : Session target-based commit interval is [10000].
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : TM_6307 : DTM error log disabled.
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : TE_7022 : TShmWriter: Initialized
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : DBG_21245 : Initializing Pre and Post Stored Procedures...
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : DBG_21686 : Consumer [d_io_det] receives data from following Queues: [Queue [0] ]
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : TM_6007 : DTM initialized successfully for session [s_mcpsp_D_IO_DET]
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : PETL_24033 : All DTM Connection Info: [<NONE>].
2017-11-09 17:57:27 : 信息 : (69637 | MANAGER) : (IS | int) : node01_informatica1 : PETL_24004 : PETL_24004 Starting pre-session tasks. : (Thu Nov 09 17:57:27 2017)
2017-11-09 17:57:27 : 信息 : (69637 | MANAGER) : (IS | int) : node01_informatica1 : PETL_24027 : PETL_24027 Pre-session task completed successfully. : (Thu Nov 09 17:57:27 2017)
2017-11-09 17:57:27 : 信息 : (69637 | DIRECTOR) : (IS | int) : node01_informatica1 : PETL_24006 : Starting data movement.
2017-11-09 17:57:27 : 信息 : (69637 | MAPPING) : (IS | int) : node01_informatica1 : TM_6660 : Total Buffer Pool size is 18894368 bytes and Block size is 2097152 bytes.
2017-11-09 17:57:27 : 信息 : (69637 | READER_1_1_1) : (IS | int) : node01_informatica1 : DBG_21438 : Reader: Source is [mcpsp_ogg], user [infor]
2017-11-09 17:57:27 : 信息 : (69637 | READER_1_1_1) : (IS | int) : node01_informatica1 : BLKR_16051 : Source database connection [mcpsp_ogg] code page: [MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding]
2017-11-09 17:57:27 : 信息 : (69637 | READER_1_1_1) : (IS | int) : node01_informatica1 : ODL_26098 : Connecting to database [mcpsp_ogg]...
2017-11-09 17:57:27 : 信息 : (69637 | READER_1_1_1) : (IS | int) : node01_informatica1 : ODL_26099 : Connected to database [mcpsp_ogg].
2017-11-09 17:57:27 : 信息 : (69637 | READER_1_1_1) : (IS | int) : node01_informatica1 : CMN_1021 : Database driver event...
CMN_1021 [ODBC Event Using array fetches.
ODBC Event Using Array Inserts. connect string = [mcpsp_ogg]. userid = [infor]]
2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8397 : Appending output data to file [/Informatica/9.6.1/server/infa_shared/BadFiles/d_io_det11.bad] (initial size [68410715]).
2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : DBG_21579 : Writer: Opened bad (reject) file [/Informatica/9.6.1/server/infa_shared/BadFiles/d_io_det11.bad]
2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8124 : Target Table d_io_det :Writing output to: $$FILESDIR/d_io_det.tbl
2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8222 : Target file [$$FILESDIR/d_io_det.tbl] code page: [UTF-8 encoding of Unicode]
2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8270 : Target connection group #1 consists of target(s) [d_io_det]
2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8003 : Writer initialization complete.
2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8005 : Writer run started.
2017-11-09 17:57:27 : 信息 : (69637 | READER_1_1_1) : (IS | int) : node01_informatica1 : BLKR_16007 : Reader run started.
2017-11-09 17:57:27 : 调试 : (69637 | READER_1_1_1) : (IS | int) : node01_informatica1 : DBG_21439 : Reader will use maximum [7] buffer blocks at a time
2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8158 :

*****START LOAD SESSION*****

Load Start Time: Thu Nov 09 17:57:27 2017

Target tables:

d_io_det


2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : DBG_21324 : Load Started for Load Order Group [1] with [1] targets
2017-11-09 17:57:27 : 错误 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8004 : Writer initialization failed [Error opening session output file [$$FILESDIR/d_io_det.tbl] [error=No such file or directory]]. Writer terminating.
2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8035 : Load complete time: Thu Nov 09 17:57:27 2017

LOAD SUMMARY
============

WRT_8036 Target: d_io_det (Instance Name: [d_io_det1])
WRT_8044 No data loaded for this target



2017-11-09 17:57:27 : 信息 : (69637 | WRITER_1_*_1) : (IS | int) : node01_informatica1 : WRT_8043 : *****END LOAD SESSION*****
2017-11-09 17:57:27 : 信息 : (69637 | READER_1_1_1) : (IS | int) : node01_informatica1 : RR_4010 : SQ instance [SQ_d_io_det] SQL Query [SELECT d_io_det.IO_DET_ID, d_io_det.IO_WH_ID, d_io_det.DETECT_DEV_ID, d_io_det.EQUIP_CATEG, d_io_det.ARRIVE_BATCH_NO, d_io_det.EQUIP_ID, d_io_det.EQUIP_CODE, d_io_det.BAR_CODE, d_io_det.BOX_BAR_CODE, d_io_det.PILE_NO, d_io_det.DUE_RET_DATE, d_io_det.PALLET_BAR_CODE, d_io_det.MANUFACTURER, d_io_det.IS_DETECT, d_io_det.EXT_Date_Time, d_io_det.EXT_flag, d_io_det.EXT_Src_System, d_io_det.EXT_Valid_Flag, d_io_det.EXT_Provincial_Flag, d_io_det.EXT_Reserve1, d_io_det.EXT_Reserve2, d_io_det.EXT_Reserve3, d_io_det.ext_oper_count, d_io_det.EXT_rowid, d_io_det.EXT_Ogg_Seq FROM d_io_det WHERE EXT_Date_Time>= DATE_FORMAT(DATE_SUB(now(),INTERVAL 1 DAY),'%Y-%m-%d') and EXT_Date_Time < DATE_FORMAT(now(),'%Y-%m-%d')]
2017-11-09 17:57:27 : 信息 : (69637 | READER_1_1_1) : (IS | int) : node01_informatica1 : RR_4049 : RR_4049 SQL Query issued to database : (Thu Nov 09 17:57:27 2017)
...全文
1104 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
紫胸佛法僧 2017-12-21
  • 打赏
  • 举报
回复
解决了,需要在worklet或者workflow中设置一下变量,具体位置为编辑工作集或者工作流中变量页签,声明一下参数文件中的参数名.

246

社区成员

发帖
与我相关
我的任务
社区描述
讨论 Informatica 数据集成相关技术、数据隐私保护相关技术
社区管理员
  • 数据集成社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧