Question:
I made a job of rollup in my process chain. But job auto cancled when it was excuting. I find the log like this.
DROP TABLE "/BI0/0400015030I"
SQL-END: 2006.01.19 09:45:10 00:00:01
SQL: 2006.01.19 09:45:10 BWREMOTE
DROP TABLE "/BI0/0400015030R"
SQL-END: 2006.01.19 09:45:10 00:00:00
SQL: 2006.01.19 09:45:10 BWREMOTE
DROP TABLE "/BI0/0400015030F"
SQL-END: 2006.01.19 09:45:10 00:00:00
SQL: 2006.01.19 09:45:10 BWREMOTE
DROP TABLE "/BI0/0100000850"
SQL-END: 2006.01.19 09:45:10 00:00:00
SQL-ERROR: 942 ORA-00942: table or view does not exist
SQL: 2006.01.19 09:45:10 BWREMOTE
DROP TABLE "/BI0/0400015030I"
SQL-END: 2006.01.19 09:45:10 00:00:00
SQL-ERROR: 942 ORA-00942: table or view does not exist
SQL: 2006.01.19 09:45:10 BWREMOTE
DROP TABLE "/BI0/0400015030R"
SQL-END: 2006.01.19 09:45:10 00:00:00
SQL-ERROR: 942 ORA-00942: table or view does not exist
SQL: 2006.01.19 09:45:10 BWREMOTE
DROP TABLE "/BI0/0400015030F"
SQL-END: 2006.01.19 09:45:10 00:00:00
SQL-ERROR: 942 ORA-00942: table or view does not exist
ABAP/4 processor:
Job cancelled
I don't know how to fix the error. Anybody can help me!
thanks a lot.
Answer:
Hi,
I think your problem is described and solved in OSS 449891.
Check it and see if SAP_DROP_TMPTABLES and the other recommendations can help you.
Kind regards
/martin
Answer:
i check in st22, describe like this:
Database error text........: "ORA-01578: ORACLE data block corrupted (file #
15, block # 22721)#ORA-01110: data file 15:
'D:\ORACLE\BWD\SAPDATA2\BWD640_6\BWD640.DATA6'"
Triggering SQL statement...: "GP35S1K2L9T6M3IXY42FTUYP4XJ "
Internal call code.........: "[REPO/*/STIN/LREF/GP35S1K2L9T6M3IXY42FTUYP4XJ ]"
Please check the entries in the system log (Transaction SM21).
sm21 like this:
Q0I Operating system call getservbyname failed (error no. 0 )
Q0I Operating system call gethostbyaddr failed (error no. 0 )
Q0I Operating system call gethostbyaddr failed (error no. 0 )
BYL Database error 1578 requires intervention by the database administrator
BY4 Database error 1578 at CLC access to table D010INC
BY0 > ORA-01578: ORACLE data block corrupted (file # 15, block #
BY0 > 22721)#ORA-01110: data file 15:
BY0 > 'D:\ORACLE\BWD\SAPDATA2\BWD640_6\BWD640.DATA6'
R68 Perform rollback
AB0 Run-time error "DBIF_REPO_SQL_ERROR" occurred
AB1 > Short dump "060119 230952 slofbw BWREMOTE " generated
D01 Transaction Canceled 00 671 ( )
R68 Perform rollback