버전 1 - 이력 - Wiki - opened - En·core Redmine

1

성태 류

h1. Wiki

2

3

green plum profile timeout log

4

<pre>

5

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

6

7

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

8

9

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

10

11

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

12

13

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

14

15

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

16

17

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

18

19

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

20

21

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

22

23

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

24

25

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

26

27

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

28

29

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

30

31

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

32

33

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

34

35

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

36

37

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

38

39

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

40

41

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

42

43

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

44

45

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

46

47

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

48

49

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

50

51

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

52

53

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

54

55

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

56

57

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

58

59

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

60

61

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

62

63

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

64

65

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

66

67

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

68

69

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

70

71

[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

72

CADORecordset Error

73

	Code = 80040e31

74

	Code meaning = IDispatch error #3121

75

	Source = Microsoft OLE DB Provider for ODBC Drivers

76

	Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired.

77

78

79

[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

80

CADORecordset Error

81

	Code = 80040e31

82

	Code meaning = IDispatch error #3121

83

	Source = Microsoft OLE DB Provider for ODBC Drivers

84

	Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired.

85

86

87

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

88

89

[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

90

CADORecordset Error

91

	Code = 80040e31

92

	Code meaning = IDispatch error #3121

93

	Source = Microsoft OLE DB Provider for ODBC Drivers

94

	Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired.

95

96

97

[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

98

CADORecordset Error

99

	Code = 80040e31

100

	Code meaning = IDispatch error #3121

101

	Source = Microsoft OLE DB Provider for ODBC Drivers

102

	Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired.

103

104

105

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

106

107

[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

108

CADORecordset Error

109

	Code = 80040e31

110

	Code meaning = IDispatch error #3121

111

	Source = Microsoft OLE DB Provider for ODBC Drivers

112

	Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired.

113

114

115

[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

116

CADORecordset Error

117

	Code = 80040e31

118

	Code meaning = IDispatch error #3121

119

	Source = Microsoft OLE DB Provider for ODBC Drivers

120

	Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired.

121

122

123

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

124

125

[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

126

CADORecordset Error

127

	Code = 80040e31

128

	Code meaning = IDispatch error #3121

129

	Source = Microsoft OLE DB Provider for ODBC Drivers

130

	Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired.

131

132

133

[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

134

CADORecordset Error

135

	Code = 80040e31

136

	Code meaning = IDispatch error #3121

137

	Source = Microsoft OLE DB Provider for ODBC Drivers

138

	Description = [DataDirect][ODBC Greenplum Wire Protocol driver]Timeout expired.

139

140

141

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

142

143

144

</pre>

프로젝트

일반

사용자정보

opened

Wiki » 이력 » 버전 1