opened

Wiki » 이력 » 개정판 2

개정판 1 (성태 류, 2022-10-31 02:11 오전) → 개정판 2/4 (성태 류, 2022-10-31 02:16 오전)

h1. Wiki 

 green plum profile timeout log 
 <pre> 



 
 [2022-10-31 10:57:34]    Analyze Profile Table[dmsm_ims_insp_dt] 

 [2022-10-31 10:57:34]    Column basic count - schyms, dmsm_ims_insp_dt, org_run_id 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, org_tray_cell_no 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, shop 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, line 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, plant 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, factory 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, run_id 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, cell_no 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, batch_id 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, lot_id 

 [2022-10-31 10:57:35]    Column basic count - schyms, dmsm_ims_insp_dt, tray_no 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, tray_id 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, tray_cell_no 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, org_tray_id 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, ff_run_id 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, ff_tray_id 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, ff_tray_cell_no 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, judge_gb 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, defect_soper_id 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, proc_no 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, cell_defect_code 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, ff_cell_defect_code 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, rank 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, insert_time 

 [2022-10-31 10:57:36]    Column basic count - schyms, dmsm_ims_insp_dt, update_time 

 [2022-10-31 10:57:37]    Column basic count - schyms, dmsm_ims_insp_dt, etl_load_date 

 [2022-10-31 10:57:37]    Column basic count - schyms, dmsm_ims_insp_dt, system_id 

 [2022-10-31 10:57:37]    Insert Profiling data to Local - TABLE:[dmsm_ims_insp_dt] 

 [2022-10-31 10:57:37]    Insert Profiling Pattern data to Local - TABLE:[dmsm_ims_insp_dt] 

 [2022-10-31 10:57:37]    Insert Profiling Distinct data to Local - TABLE:[dmsm_ims_insp_dt] 

 [2022-10-31 10:57:37]    Analyze Profile Table[dmsm_ims_insp_dtl_7201_02] 

 [2022-10-31 10:57:37]    Column basic count - schyms, dmsm_ims_insp_dtl_7201_02, org_run_id 

 [2022-10-31 10:59:37]    Query = SELECT SUM(FREQUENCY) AS "TOT_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NULL THEN FREQUENCY END), 0) AS "NULL_CNT"    , COALESCE(CASE WHEN SUM(FREQUENCY) IS NULL THEN NULL ELSE COUNT(1) END, 0) AS "DIST_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NOT NULL A 
 CADORecordset Error 
	 Code = 80040e31 
	 Code meaning = IDispatch error #3121 
	 Source = Microsoft OLE DB Provider for ODBC Drivers 
	 Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired. 


 [2022-10-31 10:59:37]    Query = SELECT SUM(FREQUENCY) AS "TOT_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NULL THEN FREQUENCY END), 0) AS "NULL_CNT"    , COALESCE(CASE WHEN SUM(FREQUENCY) IS NULL THEN NULL ELSE COUNT(1) END, 0) AS "DIST_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NOT NULL A 
 CADORecordset Error 
	 Code = 80040e31 
	 Code meaning = IDispatch error #3121 
	 Source = Microsoft OLE DB Provider for ODBC Drivers 
	 Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired. 


 [2022-10-31 10:59:37]    Column basic count - schyms, dmsm_ims_insp_dtl_7201_02, org_tray_cell_no 

 [2022-10-31 11:01:38]    Query = SELECT SUM(FREQUENCY) AS "TOT_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NULL THEN FREQUENCY END), 0) AS "NULL_CNT"    , COALESCE(CASE WHEN SUM(FREQUENCY) IS NULL THEN NULL ELSE COUNT(1) END, 0) AS "DIST_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NOT NULL A 
 CADORecordset Error 
	 Code = 80040e31 
	 Code meaning = IDispatch error #3121 
	 Source = Microsoft OLE DB Provider for ODBC Drivers 
	 Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired. 


 [2022-10-31 11:01:38]    Query = SELECT SUM(FREQUENCY) AS "TOT_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NULL THEN FREQUENCY END), 0) AS "NULL_CNT"    , COALESCE(CASE WHEN SUM(FREQUENCY) IS NULL THEN NULL ELSE COUNT(1) END, 0) AS "DIST_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NOT NULL A 
 CADORecordset Error 
	 Code = 80040e31 
	 Code meaning = IDispatch error #3121 
	 Source = Microsoft OLE DB Provider for ODBC Drivers 
	 Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired. 


 [2022-10-31 11:01:38]    Column basic count - schyms, dmsm_ims_insp_dtl_7201_02, param_code 

 [2022-10-31 11:03:39]    Query = SELECT SUM(FREQUENCY) AS "TOT_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NULL THEN FREQUENCY END), 0) AS "NULL_CNT"    , COALESCE(CASE WHEN SUM(FREQUENCY) IS NULL THEN NULL ELSE COUNT(1) END, 0) AS "DIST_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NOT NULL A 
 CADORecordset Error 
	 Code = 80040e31 
	 Code meaning = IDispatch error #3121 
	 Source = Microsoft OLE DB Provider for ODBC Drivers 
	 Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired. 


 [2022-10-31 11:03:39]    Query = SELECT SUM(FREQUENCY) AS "TOT_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NULL THEN FREQUENCY END), 0) AS "NULL_CNT"    , COALESCE(CASE WHEN SUM(FREQUENCY) IS NULL THEN NULL ELSE COUNT(1) END, 0) AS "DIST_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NOT NULL A 
 CADORecordset Error 
	 Code = 80040e31 
	 Code meaning = IDispatch error #3121 
	 Source = Microsoft OLE DB Provider for ODBC Drivers 
	 Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired. 


 [2022-10-31 11:03:39]    Column basic count - schyms, dmsm_ims_insp_dtl_7201_02, shop 

 [2022-10-31 11:05:40]    Query = SELECT SUM(FREQUENCY) AS "TOT_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NULL THEN FREQUENCY END), 0) AS "NULL_CNT"    , COALESCE(CASE WHEN SUM(FREQUENCY) IS NULL THEN NULL ELSE COUNT(1) END, 0) AS "DIST_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NOT NULL A 
 CADORecordset Error 
	 Code = 80040e31 
	 Code meaning = IDispatch error #3121 
	 Source = Microsoft OLE DB Provider for ODBC Drivers 
	 Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired. 


 [2022-10-31 11:05:40]    Query = SELECT SUM(FREQUENCY) AS "TOT_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NULL THEN FREQUENCY END), 0) AS "NULL_CNT"    , COALESCE(CASE WHEN SUM(FREQUENCY) IS NULL THEN NULL ELSE COUNT(1) END, 0) AS "DIST_CNT" , COALESCE(SUM(CASE WHEN COL_VALUE IS NOT NULL A 
 CADORecordset Error 
	 Code = 80040e31 
	 Code meaning = IDispatch error #3121 
	 Source = Microsoft OLE DB Provider for ODBC Drivers 
	 Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired. 


 [2022-10-31 11:05:40]    Column basic count - schyms, dmsm_ims_insp_dtl_7201_02, line 


 </pre>