-
恩智浦凯文 初学数据Lv2
发表于2021-2-9 14:26
悬赏100
已解决
2021-02-09 14:17:29 开始迁移到目标表:dbo.Leaded_CQC
2021-02-09 14:17:29 创建临时表:dbo.T_EMSUQZ,表结构为:ALOT_NUMBER(C|15),DEVC_NUMBER(C|16),OUT_QUANTITY(N|9),PKGCODE(C|4),TRACECODE(C|16),DATECODE(C|4),PROCESS_START_TIME(P|23),PROCESS_END_TIME(P|23),STEP_NAME(C|16),MACH_ID(C|16),END_USER_ID(C|32),USER_CREW(C|10),REJECT_QUANTITY(N|9),ATTR_NAME(C|32),ATTR_VALUE(C|2000),DTYP_NAME(C|8),QUANTITY(N|9),DEVICE1(C|16),PLOT_NUMBER(C|15)
2021-02-09 14:17:29 数据查询耗时:1毫秒结果集结构:
ALOT_NUMBER(C|15),DEVC_NUMBER(C|16),OUT_QUANTITY(N|9),PKGCODE(C|4),TRACECODE(C|16),DATECODE(C|4),PROCESS_START_TIME(P|0),PROCESS_END_TIME(P|0),STEP_NAME(C|16),MACH_ID(C|16),END_USER_ID(C|32),USER_CREW(C|10),REJECT_QUANTITY(N|9),ATTR_NAME(C|32),ATTR_VALUE(C|2000),DTYP_NAME(C|8),QUANTITY(N|9),DEVICE1(C|16),PLOT_NUMBER(C|15)
2021-02-09 14:17:29 数据迁移插入SQL:
insert into dbo.T_EMSUQZ([ALOT_NUMBER],[DEVC_NUMBER],[OUT_QUANTITY],[PKGCODE],[TRACECODE],[DATECODE],[PROCESS_START_TIME],[PROCESS_END_TIME],[STEP_NAME],[MACH_ID],[END_USER_ID],[USER_CREW],[REJECT_QUANTITY],[ATTR_NAME],[ATTR_VALUE],[DTYP_NAME],[QUANTITY],[DEVICE1],[PLOT_NUMBER]) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2021-02-09 14:17:30 已经完成表:dbo.T_EMSUQZ迁移数据条数:0耗时:401毫秒
2021-02-09 14:17:30 将临时表dbo.T_EMSUQZ数据写入目的表dbo.Leaded_CQC:
2021-02-09 14:17:30 insert into dbo.Leaded_CQC ( ALOT_NUMBER,DEVC_NUMBER,OUT_QUANTITY,PKGCODE,TRACECODE,DATECODE,PROCESS_START_TIME,PROCESS_END_TIME,STEP_NAME,MACH_ID,END_USER_ID,USER_CREW,REJECT_QUANTITY,ATTR_NAME,ATTR_VALUE,DTYP_NAME,QUANTITY,DEVICE1,PLOT_NUMBER)
select b.ALOT_NUMBER,b.DEVC_NUMBER,b.OUT_QUANTITY,b.PKGCODE,b.TRACECODE,b.DATECODE,b.PROCESS_START_TIME,b.PROCESS_END_TIME,b.STEP_NAME,b.MACH_ID,b.END_USER_ID,b.USER_CREW,b.REJECT_QUANTITY,b.ATTR_NAME,b.ATTR_VALUE,b.DTYP_NAME,b.QUANTITY,b.DEVICE1,b.PLOT_NUMBER from dbo.T_EMSUQZ b
2021-02-09 14:17:30 执行sql耗时:5毫秒
2021-02-09 14:17:30 完成数据提交到表:dbo.Leaded_CQC
2021-02-09 14:17:30 执行更新总耗时429毫秒
2021-02-09 14:17:30 完成将数据插入到目标表:Leaded_CQC
2021-02-09 14:17:30 结束执行组件:Leaded_CQC
2021-02-09 14:17:30 结束执行ETL过程:[Leaded_CQC]
以上应该表示执行成功,ETL过程没有问题。表输出设定如下:
点击“查看”,结果如下,没有数据
查看相应数据集,数据也为空
这个ETL和数据集,之前我运行过,得到过数据。今天对相应数据集做了数据分析,运行后就得不到数据了。
请大神帮忙看看这种问题一般出在哪里,需要检查什么地方。
谢谢!
18个回答
-
1505121235 数据老手Lv5
恩智浦凯文 发表于 2021-2-9 14:53
你说的源表是指什么,是指数据库吗?
我是用其他软件运行了一下,是有数据的。
...
方便远程看下不,或者你导出ETL和数据库源表,我本地看下
SELECT T0.alot_number AS alot_number,
T0.devc_number AS devc_number,
T0.out_quantity AS out_quantity,
T0.pkgcode AS pkgcode,
T0.tracecode AS tracecode,
T0.datecode AS datecode,
T0.process_start_time AS process_start_time,
T0.process_end_time AS process_end_time,
T0.step_name AS step_name,
T0.mach_id AS mach_id,
T0.end_user_id AS end_user_id,
T0.user_crew AS user_crew,
T0.reject_quantity AS reject_quantity,
T0.attr_name AS attr_name,
T0.attr_value AS attr_value,
T0.dtyp_name AS dtyp_name,
T0.quantity AS quantity,
T0.device1 AS device1,
T0.plot_number AS plot_number
FROM(SELECT al3.alot_number,
al3.devc_number,
al3.out_quantity,
al1.pkgcode,
al1.tracecode,
al1.datecode,
al3.process_start_time,
al3.process_end_time,
al3.step_name,
al2.mach_id,
al3.end_user_id,
al4.user_crew,
al3.reject_quantity,
al5.attr_name,
al5.attr_value,
al6.dtyp_name,
al6.quantity,
al8.devc_number AS device1,
al7.plot_number
FROM genstaging.mview$_stage_ao_lots al1,
genstaging.mview$_stage_alot_mach_hists al2,
genstaging.mview$_stage_aolot_hists al3,
cmrpt.mview$_users al4,
genstaging.mview$_stage_lhst_attr_values al5,
genstaging.mview$_stage_defcts al6,
cmrpt.mview$_stage_aolot_pp_assign al7,
cmrpt.mview$_stage_piece_part_lots al8
WHERE (al3.alot_number = al2.alot_number (+)
AND al6.alot_number (+) = al3.alot_number
AND al6.step_name (+) = al3.step_name
AND al3.step_name = al2.step_name (+)
AND al2.alot_number = al5.alot_number (+)
AND al2.step_name = al5.step_name (+)
AND al7.alot_number (+) = al3.alot_number
AND al7.step_name (+) = al3.step_name
AND al7.plot_number = al8.plot_number (+)
AND al3.alot_number = al1.alot_number
AND al4.user_id = al3.end_user_id)
AND ((al3.step_name IN ('BE TO KESBI',
'BE TO KESFT',
'BE TO NON-A WHSE',
'BE TO TEST1',
'BE TO TEST2',
'BE TO TTJBI',
'DEFLASH',
'DEJUNK',
'DIE_BOND',
'ENG MOLD',
'FORM',
'FVI',
'FVI_GATE',
'MARK',
'MOLD',
'PASS_WINDOW',
'PLATE',
'PMC',
'PPB',
'PRE-MOLD PLASMA',
'REFLOW',
'TRIM_FORM',
'VM_CHECK',
'VM_INSPECT')
AND al3.alot_number = 'TJMEA21X2300'
AND (al5.attr_name (+) LIKE '%DAMBAR%'
OR al5.attr_name (+) LIKE '%FORM%'
OR al5.attr_name (+) LIKE '%MOLD%')))) T0
-
1505121235 数据老手Lv5
我导入看了一下,没有数据啊,是不是你表输入组件的那张表就没有数据呀,你检查一下