[12/06/25 10:38:14] [NR_INFO_DIC_TB] - ===========================================================
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - NRInfoManager Dicinfo Table Init - PMP.CMS_SVC_NEWS
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - -----------------------------------------------------------
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - [DIC_KEY_BACKUP] Dictionary Info 구성 Start
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - 복제대상 테이블이 등록된 svr_seq, dbms_seq 정보 추출
[12/06/25 10:38:14] [NR_INFO_DIC_TB][ORACLE] - SELECT DISTINCT T3.SVR_SEQ, T3.DBMS_SEQ, T3.GRP_CODE, T4.POL_CODE FROM NR_SVR T1, NR_DBMS T2, NR_GROUP T3, NR_CLONETB T4 WHERE T1.SVR_SEQ = T2.SVR_SEQ AND T2.SVR_SEQ = T3.SVR_SEQ AND T2.DBMS_SEQ = T3.DBMS_SEQ AND T3.GRP_CODE = T4.GRP_CODE AND T1.SVR_HOSTNAME = 'pmndb03'AND T3.GRP_TYPE = 'S' AND T4.TB_OWNER = 'PMP' AND T4.TB_NAME = 'CMS_SVC_NEWS'ORDER BY T3.GRP_CODE, T4.POL_CODE
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - -----------------------------------------------------------
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - [STEP1][G01-P101] [PMP.CMS_SVC_NEWS] := 기본 Dictionary 정보구성 Start !!!
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - -----------------------------------------------------------
[12/06/25 10:38:14] [NR_INFO_DIC_TB][ORACLE] - SELECT DISTINCT T5.POL_CODE, T1.SVR_IPADDR, T2.DBMS_SID, T2.DBMS_PORT, T2.DBMS_USERID, T2.DBMS_PASSWD, T4.TB_OWNER, T4.TB_NAME FROM NR_SVR T1, NR_DBMS T2, NR_GROUP T3, NR_CLONETB T4, NR_POL T5 WHERE T1.SVR_SEQ = T2.SVR_SEQ AND T2.SVR_SEQ = T3.SVR_SEQ AND T2.DBMS_SEQ = T3.DBMS_SEQ AND T3.GRP_CODE = T4.GRP_CODE AND T4.GRP_CODE = T5.GRP_CODE AND T3.GRP_CODE = T5.GRP_CODE AND T4.POL_CODE = T5.POL_CODE AND T3.GRP_CODE = 'G01'AND T3.GRP_TYPE = 'S' AND T4.TB_OWNER = 'PMP' AND T4.TB_NAME = 'CMS_SVC_NEWS' AND T5.POL_CODE = 'P101' AND T3.GRP_ACTNODE_YN = 'Y' AND T4.TB_DROP_YN= 'N' ORDER BY POL_CODE
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - Object_id 추출을 위한 DBMS Connection
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - -----------------------------------------------------------
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - [STEP1-1][G01-P101] Dictionary 정보 추출 statement 생성
[12/06/25 10:38:14] [NR_INFO_DIC_TB] - -----------------------------------------------------------
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - PMP.CMS_SVC_NEWS 테이블 Object_ID 정보 수집 중!!
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - SELECT T1.OBJECT_ID, SUBSTR(T2.PARTITIONED,0,1) AS PART_YN FROM ALL_OBJECTS T1, ALL_TABLES T2 WHERE T1.OWNER = T2.OWNER AND T1.OBJECT_NAME = T2.TABLE_NAME AND T2.TABLE_NAME = 'CMS_SVC_NEWS' AND T2.OWNER = 'PMP' AND T1.OBJECT_TYPE IN ('TABLE', 'TABLE PARTITION')
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - PMP.CMS_SVC_NEWS 테이블 Object_ID := 102991
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - UPDATE NR_CLONETB SET TB_OBJID = '102991', TB_PART_YN = 'N' WHERE GRP_CODE = 'G01' AND POL_CODE = 'P101' AND TB_OWNER = 'PMP' AND TB_NAME = 'CMS_SVC_NEWS'
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - SELECT * FROM NR_CLONETB WHERE TB_OWNER = 'PMP' AND TB_NAME = 'CMS_SVC_NEWS' AND POL_CODE = 'P101'
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - PMP.CMS_SVC_NEWS 테이블 Column 정보 수집완료
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - SELECT * FROM NR_DICINFO WHERE GRP_CODE = 'G01' AND POL_CODE = 'P101' AND DIC_OWNER = 'PMP' AND DIC_TNAME = 'CMS_SVC_NEWS'
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - SELECT * FROM NR_DICINFO_PK WHERE GRP_CODE = 'G01' AND POL_CODE = 'P101' AND DIC_OWNER = 'PMP' AND DIC_TNAME = 'CMS_SVC_NEWS'
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - PMP.CMS_SVC_NEWS 테이블 1 건의 Dictionary-PK 컬럼을 삭제합니다.
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - DELETE FROM NR_DICINFO_PK WHERE GRP_CODE = 'G01' AND POL_CODE = 'P101' AND DIC_OWNER = 'PMP' AND DIC_TNAME = 'CMS_SVC_NEWS'
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - SELECT DISTINCT T1.* FROM ( SELECT * FROM NR_DICINFO WHERE GRP_CODE = 'G01' AND DIC_LOGMNR_YN = 'Y' AND POL_CODE = 'P101' AND DIC_OWNER = 'PMP' AND DIC_TNAME = 'CMS_SVC_NEWS' UNION ALL SELECT * FROM NR_DICINFO WHERE GRP_CODE = 'G01' AND DIC_CRYP_YN = 'Y' AND POL_CODE = 'P101' AND DIC_OWNER = 'PMP' AND DIC_TNAME = 'CMS_SVC_NEWS' ) T1
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - PMP.CMS_SVC_NEWS 테이블 1 건의 Dictionary-PK 컬럼을 새로 백업 받습니다
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - INSERT INTO NR_DICINFO_PK(GRP_CODE, POL_CODE, DIC_OBJID, DIC_TNAME, DIC_OWNER, DIC_COLNAME, DIC_LOGMNR_YN, DIC_CRYP_YN, DIC_COLNAME_MAP, DIC_CLONE_YN, DIC_REGDATE)VALUES('G01','P101','102991','CMS_SVC_NEWS','PMP','NEWS_ID','Y','','NEWS_ID','Y','20120625103815')
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - DELETE FROM NR_DICINFO WHERE GRP_CODE = 'G01' AND DIC_OWNER = 'PMP' AND DIC_TNAME = 'CMS_SVC_NEWS' AND POL_CODE = 'P101'
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - 기존 Dictionary Info DELETE 완료
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - 대용량 데이터 타입 := PMP.CMS_SVC_NEWS 테이블 Column Info := ARTICLE_CTXT(CLOB)
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - java.lang.NullPointerException
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - Dictionary Info Insert 성공 := 24
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - SELECT COUNT(*) AS PK_COUNT FROM NR_DICINFO WHERE DIC_TNAME = 'CMS_SVC_NEWS' AND DIC_OWNER = 'PMP' AND DIC_LOGMNR_YN = 'Y'
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - -----------------------------------------------------------
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - [STEP2][G01-P101] [PMP.CMS_SVC_NEWS] := 백업받은 컬럼 재적용 Start !!!
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - -----------------------------------------------------------
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - SELECT * FROM NR_DICINFO_PK WHERE GRP_CODE = 'G01' AND POL_CODE = 'P101' AND DIC_OWNER = 'PMP' AND DIC_TNAME = 'CMS_SVC_NEWS'
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - PMP.CMS_SVC_NEWS 테이블에 1 건의 PK 컬럼을 Dictionary 에 재적용 합니다
[12/06/25 10:38:15] [NR_INFO_DIC_TB][ORACLE] - UPDATE NR_DICINFO SET DIC_LOGMNR_YN = 'Y', DIC_CRYP_YN = '', DIC_COLNAME_MAP = 'NEWS_ID', DIC_CLONE_YN = 'Y' WHERE GRP_CODE = 'G01' AND POL_CODE = 'P101' AND DIC_TNAME = 'CMS_SVC_NEWS' AND DIC_OWNER = 'PMP' AND DIC_COLNAME = 'NEWS_ID'
[12/06/25 10:38:15] [NR_INFO_DIC_TB] - Dictionary Info 구성완료!!!
에러 메세지 (아래)
[pmndb03:/home/nradmin/NRManager/bin] ./nrinfomgrd -dt PMP.CMS_SVC_NEWS
NR_DIR := /home/nradmin/NRManager
NR_CONFIG := /home/nradmin/NRManager/conf/nr.conf
NR_LOG := /home/nradmin/NRManager/log/nrinfo.log
[DEBUG] dbClassName : oracle.jdbc.driver.OracleDriver
[DEBUG] dbURL : jdbc:oracle:thin:@172.18.179.41:1648:BIS1
[DEBUG] dbUSER : nradmin
[DEBUG] dbPASSWD : "A_D_M_I_N_123"
[DEBUG] dbClassName : oracle.jdbc.driver.OracleDriver
[DEBUG] dbURL : jdbc:oracle:thin:@172.18.179.15:1648:PMP3
[DEBUG] dbUSER : nradmin
[DEBUG] dbPASSWD : "A_D_M_I_N_123"
java.sql.SQLException: 부적합한 SQL 유형입니다
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:67)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1623)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
at nrlib.common.NRQuery.confirm(NRQuery.java:110)
at nr.info.dictionary.NRDictionary.dicInfoInsert(NRDictionary.java:974)
at nr.info.dictionary.NRDictionary.setDicinfoAdd(NRDictionary.java:574)
at nr.info.dictionary.NRDictionary.setDicinfoTotalInit(NRDictionary.java:316)
at nr.info.dictionary.NRDictionary.setDictionaryTable(NRDictionary.java:228)
at nr.info.NRInfoManager.main(NRInfoManager.java:119)
SUCCESS
[pmndb03:/home/nradmin/NRManager/bin]