|
상황을 잘 모르겠지만, 혹시, Connection Timeout 때문 아닌가요 ?
쓰신 내용글을 보면, 17:34 에는 정상이고, 19:49 는 에러인데, 2시간 15분 정도의 차이가 있어 보이네요....
민현호 님이 쓰신 글 :
: 안녕하세요..
:
: TQuery의 Edit/Post메소드로데이터를 변경하는 처리가
: 어떤때는 에러가 나고 어떤 때는 정상적으로 처리 되는
: 경우가 발생했습니다.
:
: SQL모니터로 확인한 로그입니다.
: 같은 처리인데 아래와 같이 정상일때가 있고 에러일때 가 있습니다..
: 무엇이 문제일까요??? 정말 모르겠습니다..
: 정상일 때는 9845 17:34:31 SQL Data In: ORACLE - Rows affected = 1
: 에러일때는 184422 19:49:36 SQL Data In: ORACLE - Rows affected = 0
:
:
: >>1. 정상일때는
: 9830 17:34:31 SQL Prepare: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL AND "ACCS_DATE" IS NULL AND "ACCS_TIME" IS NULL AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
: 9831 17:34:31 SQL Data In: ORACLE - Param = 1, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:34:25
: 9832 17:34:31 SQL Data In: ORACLE - Param = 2, Name = TEST_ID, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 11.000000
: 9833 17:34:31 SQL Data In: ORACLE - Param = 3, Name = TT_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = ABS-2004 m0 12
: 9834 17:34:31 SQL Data In: ORACLE - Param = 4, Name = PRN_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 079461-2007
: 9835 17:34:31 SQL Data In: ORACLE - Param = 5, Name = SCOMMENT, Type = fldZSTRING, Precision = 16, Scale = 0, Data = -CM-000525
: 9836 17:34:31 SQL Data In: ORACLE - Param = 6, Name = INDATE, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2013/10/15
: 9837 17:34:31 SQL Data In: ORACLE - Param = 7, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:32:31
: 9838 17:34:31 SQL Data In: ORACLE - Param = 8, Name = BLK_CNT, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 0.000000
: 9839 17:34:31 SQL Data In: ORACLE - Param = 9, Name = LOCK_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
: 9840 17:34:31 SQL Data In: ORACLE - Param = 10, Name = USER_ID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NLB-0042
: 9841 17:34:31 SQL Data In: ORACLE - Param = 11, Name = LIB_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
: 9842 17:34:31 SQL Data In: ORACLE - Param = 12, Name = TUNING_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 0.000000
: 9843 17:34:31 SQL Data In: ORACLE - Param = 13, Name = ROWID, Type = fldZSTRING, Precision = 18, Scale = 0, Data = AAAHefAAPAAABfaAAK
: 9844 17:34:31 SQL Execute: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL AND "ACCS_DATE" IS NULL AND "ACCS_TIME" IS NULL AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
: 9845 17:34:31 SQL Data In: ORACLE - Rows affected = 1
: 9846 17:34:31 SQL Stmt: ORACLE - Close
:
: >>>2.에러 일때는
:
: 184407 19:49:36 SQL Prepare: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL AND "ACCS_DATE" IS NULL AND "ACCS_TIME" IS NULL AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
: 184408 19:49:36 SQL Data In: ORACLE - Param = 1, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:49:36
: 184409 19:49:36 SQL Data In: ORACLE - Param = 2, Name = TEST_ID, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 11.000000
: 184410 19:49:36 SQL Data In: ORACLE - Param = 3, Name = TT_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = ABS-2004 m0 12
: 184411 19:49:36 SQL Data In: ORACLE - Param = 4, Name = PRN_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 079461-2007
: 184412 19:49:36 SQL Data In: ORACLE - Param = 5, Name = SCOMMENT, Type = fldZSTRING, Precision = 16, Scale = 0, Data = -CM-000525
: 184413 19:49:36 SQL Data In: ORACLE - Param = 6, Name = INDATE, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2013/10/15
: 184414 19:49:36 SQL Data In: ORACLE - Param = 7, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:49:30
: 184415 19:49:36 SQL Data In: ORACLE - Param = 8, Name = BLK_CNT, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 0.000000
: 184416 19:49:36 SQL Data In: ORACLE - Param = 9, Name = LOCK_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
: 184417 19:49:36 SQL Data In: ORACLE - Param = 10, Name = USER_ID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NLB-0042
: 184418 19:49:36 SQL Data In: ORACLE - Param = 11, Name = LIB_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
: 184419 19:49:36 SQL Data In: ORACLE - Param = 12, Name = TUNING_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 0.000000
: 184420 19:49:36 SQL Data In: ORACLE - Param = 13, Name = ROWID, Type = fldZSTRING, Precision = 18, Scale = 0, Data = AAAHefAAPAAABfaAAK
: 184421 19:49:36 SQL Execute: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL AND "ACCS_DATE" IS NULL AND "ACCS_TIME" IS NULL AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
: 184422 19:49:36 SQL Data In: ORACLE - Rows affected = 0
: 184423 19:49:36 SQL Stmt: ORACLE - Close
:
:
|