alter.log:

Sat Jun  4 08:08:47 2005

Errors in file /oracle/admin/history/bdump/history_j000_11157.trc:

ORA-12012: error on auto execute of job 98

ORA-01410: invalid ROWID

ORA-02063: preceding line from TOPCCWIP

ORA-06512: at "MES_ADMINHIS.PRO_REPLICATION_MANUAL", line 53

ORA-06512: at "MES_ADMINHIS.PRO_JOBS_TENTHLY", line 23

ORA-06512: at line 1

trc文件﹕

/oracle/admin/history/bdump/history_j000_11157.trc

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

ORACLE_HOME = /oracle/product/9.2.0

System name:    Linux

Node name:      IALDBhistory

Release:        2.4.9-e.57enterprise

Version:        #1 SMP Thu Dec 2 20:45:51 EST 2004

Machine:        i686

Instance name: history

Redo thread mounted by this instance: 1

Oracle process number: 11

Unix process pid: 11157, image: oracle@IALDBhistory (J000)

*** SESSION ID

32.3670) 2005-06-04 08:08:47.735

*** 2005-06-04 08:08:47.735

ORA-12012: error on auto execute of job 98

ORA-01410: invalid ROWID

ORA-02063: preceding line from TOPCCWIP

ORA-06512: at "MES_ADMINHIS.PRO_REPLICATION_MANUAL", line 53

ORA-06512: at "MES_ADMINHIS.PRO_JOBS_TENTHLY", line 23

ORA-06512: at line 1

Job內容﹕

create or replace procedure PRO_REPLICATION_MANUAL

(I_DATE1 in VARCHAR2 DEFAULT NULL, I_DATE2 in VARCHAR2 DEFAULT NULL)

is

V_BEG_DATE   VARCHAR2(30);

V_END_DATE   VARCHAR2(30);

V_EXEC_DATE  VARCHAR2(30);

V_ENTITY_NO  VARCHAR2(30);

rsSLTS        SLTS_R%ROWTYPE;

CURSOR CUR_SLTS IS

SELECT * FROM SLTS@TOPCCWIP.US.ORACLE.COM S

WHERE S.FAC_ID =2

AND S.TRANS_DATE BETWEEN V_BEG_DATE AND V_END_DATE;

CURSOR CUR_SLTS_R IS

SELECT ENTITY_NO FROM SLTS_R R

WHERE R.FAC_ID =rsSLTS.Fac_Id

AND R.ENTITY_NO = rsSLTS.Entity_No

AND R.TRANS_NBR = rsSLTS.Trans_Nbr;

CURSOR CUR_TIME IS

SELECT LAST_EXEC_TIME

FROM EIS_PROCEDURE_EXEC

WHERE FAC_ID = 2

AND PROC_NAME = 'PRO_REPLICATION_MANUAL' ;

begin

IF NVL(I_DATE1,' ') =' ' THEN

OPEN CUR_TIME;

FETCH CUR_TIME INTO V_EXEC_DATE;

IF CUR_TIME%ROWCOUNT=0 THEN

INSERT INTO EIS_PROCEDURE_EXEC(FAC_ID,PROC_NAME,LAST_EXEC_TIME,COMPLETE_TIME)

VALUES(2,'PRO_REPLICATION_MANUAL',null,NULL);

V_BEG_DATE := TO_CHAR(SYSDATE -1,'YYYY/MM/DD') || SUBSTR(TO_char(SYSTIMESTAMP ,'YYYY/MM/DD HH24:MI:SSXFF6'),11);

ELSE

IF NVL(V_EXEC_DATE,' ') =' ' THEN

V_BEG_DATE := TO_CHAR(SYSDATE -1,'YYYY/MM/DD') || SUBSTR(TO_char(SYSTIMESTAMP ,'YYYY/MM/DD HH24:MI:SSXFF6'),11);

ELSE

V_BEG_DATE := TO_CHAR(TO_DATE(SUBSTR(V_EXEC_DATE,1,19),'YYYY/MM/DD HH24:MI:SS') - 30/1440,'YYYY/MM/DD HH24:MI:SS') || SUBSTR(V_EXEC_DATE,19);

END IF;

END IF;

CLOSE CUR_TIME;

ELSE

V_BEG_DATE := I_DATE1;

END IF;

IF NVL(I_DATE1,' ') =' ' THEN

V_END_DATE := TO_char(SYSTIMESTAMP ,'YYYY/MM/DD HH24:MI:SSXFF6');

ELSE

V_END_DATE := I_DATE1;

END IF;

OPEN CUR_SLTS;

LOOP

FETCH CUR_SLTS INTO rsSLTS;

EXIT WHEN CUR_SLTS%NOTFOUND;

OPEN CUR_SLTS_R;

FETCH CUR_SLTS_R INTO V_ENTITY_NO;

IF CUR_SLTS_R%ROWCOUNT =0 THEN

INSERT INTO SLTS_R(FAC_ID,ENTITY_NO,TRANS_NBR,TRANS_DATE,MACH_ID,OPERATOR,PROD_NBR,VER,WORK_CTR,WO_NBR,QAT_SMP_FG,SHIFT_ID,STIMES,STIMES_TTL,FG_TYPE,TRANS_TYPE,TO_WC,MAIN_WC,OUTPUT_FG,COMMENTS,LOT_NBR,LOT_TYPE,GRADE,RANK,CODE1,FR_TYPE,TO_OP_STS,LCM_OWNER,TO_WO_NBR,FR_ERP_OPER,FR_ERP_STAT,TO_ERP_OPER,TO_ERP_STAT,CUR_ERP_OPER,ERP_TRANS_NBR,POST_FLAG,ERP_TRANS_TYPE,FG_STORE_ACCT,TO_LCM_OWNER,TO_PROD_NBR,TO_VER,MEMO01,MEMO02,MEMO03,MEMO04,MEMO05)

VALUES(rsSLTS.FAC_ID, rsSLTS.ENTITY_NO, rsSLTS.TRANS_NBR, rsSLTS.TRANS_DATE, rsSLTS.MACH_ID, rsSLTS.OPERATOR, rsSLTS.PROD_NBR, rsSLTS.VER, rsSLTS.WORK_CTR, rsSLTS.WO_NBR, rsSLTS.QAT_SMP_FG, rsSLTS.SHIFT_ID, rsSLTS.STIMES, rsSLTS.STIMES_TTL, rsSLTS.FG_TYPE, rsSLTS.TRANS_TYPE, rsSLTS.TO_WC, rsSLTS.MAIN_WC, rsSLTS.OUTPUT_FG, rsSLTS.COMMENTS, rsSLTS.LOT_NBR, rsSLTS.LOT_TYPE, rsSLTS.GRADE, rsSLTS.RANK, rsSLTS.CODE1, rsSLTS.FR_TYPE, rsSLTS.TO_OP_STS, rsSLTS.LCM_OWNER, rsSLTS.TO_WO_NBR, rsSLTS.FR_ERP_OPER, rsSLTS.FR_ERP_STAT, rsSLTS.TO_ERP_OPER, rsSLTS.TO_ERP_STAT, rsSLTS.CUR_ERP_OPER, rsSLTS.ERP_TRANS_NBR, rsSLTS.POST_FLAG, rsSLTS.ERP_TRANS_TYPE, rsSLTS.FG_STORE_ACCT, rsSLTS.TO_LCM_OWNER, rsSLTS.TO_PROD_NBR, rsSLTS.TO_VER, rsSLTS.MEMO01, rsSLTS.MEMO02, rsSLTS.MEMO03, rsSLTS.MEMO04, rsSLTS.MEMO05);

COMMIT;

END IF;

CLOSE CUR_SLTS_R;

END LOOP;

CLOSE CUR_SLTS;

update EIS_PROCEDURE_EXEC set LAST_EXEC_TIME = V_END_DATE,COMPLETE_TIME = TO_char(SYSTIMESTAMP ,'YYYY/MM/DD HH24:MI:SSXFF6')

where FAC_ID =2

and PROC_NAME ='PRO_REPLICATION_MANUAL';

commit;

end PRO_REPLICATION_MANUAL;