Wiki¶

green plum profile timeout log

[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