on 10-22-2008 5:40 AM
Hi all,
I have installed ECC6.0 SR3 with Oracle 10.2.0.2.0 on Window Server 2003 64bit R2 with SP2 as a Development Server and now i am trying to make client copy of client 000 with SAP_CUST on DEV server and this client copy is running from last 17 hours. i am facing same status of SCC3 from yesterday:
Status : running
Start on : 21.10.2008 / 17:35
Last Entry On: 21:10:2008 / 19:15
Current Action : Post Processing component
- last Exit Program: RGBCFL01 FI-SL-SL
Statistics for this Run:
- No. of Tables: 54524 of 54524
while i have add parameter (abap/fieldexit) in rz10. May this parameter is effecting that happend or not?
regards,
majamil
Hi Majamil,
Have you updated Update database statistics?
Thanks,
Bhanu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi and thanks for all.
i have run following command.
1. SQL> STARTUP UPGRADE
2. SQL> SPOOL patch.log
3. SQL> @E:\oracle\DEV\102\RDBMS\ADMIN\catupgrd.sql
4. SQL> SPOOL OFF
5. Restart the database:
SQL> SHUTDOWN
SQL> STARTUP
6. SQL> @E:\oracle\DEV\102\RDBMS\ADMIN\utlrp.sql
after this client copy is not taking too much time.
regards,
majamil
Hello Markus,
I get the following error while client copy and the client copy cancelled. pls suggest any...
Warnings and Errors
Table Name Component Package
GRACSODREPDATA GRC-AC Program Cancel (See SM21)
13:41:04 DIA 005 540 SAP* BX F Table logging in program SAPMSSY1 disabled by user SAP*
13:41:04 DIA 005 540 SAP* B6 B Syn. MC maintenance deactivated fully from SAPMSSY1 by user SAP*
13:41:04 DIA 005 540 SAP* BB 1 Buffer TABL reset
13:41:04 DIA 005 540 SAP* BB 1 Buffer TABLP reset
13:45:12 BTC 027 540 SAP* Q0 E Signal 11 received by operating system
13:45:12 BTC 027 540 SAP* BY 4 Database error 24909 with UPD access to table TST01
13:45:12 BTC 027 540 SAP* BY 0 > ORA-24909: call in progress. Current operation cancelled
13:45:12 BTC 027 540 SAP* F6 H Database error: TemSe->XRTAB(3)->1 for table TST01 key [540]JOBLGX13405700X44770,1
13:45:12 BTC 027 540 SAP* BY M SQL error 3114 occurred; work process in reconnect status
13:45:12 BTC 027 540 SAP* AB 2 > Include ??? line 0000.
13:45:12 BTC 027 540 SAP* AB 0 Runtime error "DBIF_REPO_SQL_ERROR" occurred.
13:45:13 BTC 027 540 SAP* AB 2 > Include ??? line 0000.
13:45:13 BTC 027 540 SAP* AB 0 Runtime error "DBIF_REPO_SQL_ERROR" occurred.
3:45:26 BTC 027 540 SAP* | F6 F TemSe object JOBLGX13405700X44770 was closed remotely |
3:45:26 BTC 027 540 SAP* | R4 7 Delete session 001 after error 023 |
3:48:49 DIA 005 540 SAP* | Q0 E Signal 11 received by operating system |
3:48:49 DIA 005 540 SAP* | BY 4 Database error 1013 with SEL access to table REPOLOAD |
3:48:49 DIA 005 540 SAP* | BY 0 > ORA-01403: no data found |
3:48:49 DIA 005 540 SAP* | AB 2 > Include ??? line 0000. |
3:48:49 DIA 005 540 SAP* | AB 0 Runtime error "DBIF_REPO_SQL_ERROR" occurred. |
3:48:49 DIA 005 540 SAP* | BY 2 Database error 1013 at OPC |
3:48:49 DIA 005 540 SAP* | BY 0 > ORA-01403: no data found |
3:48:49 DIA 005 540 SAP* | BY 2 Database error 1013 at OPC |
3:48:49 DIA 005 540 SAP* | BY 0 > ORA-01403: no data found |
3:48:49 DIA 005 540 SAP* | BY 2 Database error 1013 at OPC |
3:48:49 DIA 005 540 SAP* | BY 0 > ORA-01403: no data found |
3:48:49 DIA 016 540 SAP* | BX F Table logging in program SAPMSSY1 disabled by user SAP* |
3:48:49 DIA 016 540 SAP* | B6 B Syn. MC maintenance deactivated fully from SAPMSSY1 by user SAP* |
3:48:49 DIA 016 540 SAP* | BB 1 Buffer TABL reset |
3:48:49 DIA 016 540 SAP* | BB 1 Buffer TABLP reset |
3:48:50 DIA 005 540 SAP* | BY 4 Database error 1013 with SEL access to table REPOLOAD |
3:48:50 DIA 005 540 SAP* | BY 0 > ORA-01403: no data found |
3:48:50 DIA 005 540 SAP* | AB 2 > Include ??? line 0000. |
3:48:50 DIA 005 540 SAP* | AB 0 Runtime error "DBIF_REPO_SQL_ERROR" occurred. |
3:48:50 DIA 005 540 SAP* | BY 4 Database error 1013 with SEL access to table REPOLOAD |
Analysis:
TemSe is fine with consistent and no extra jobs or oldest spool job exists and all cleaned up.
Hi,
I faced the same issue. Stop your client copy and start it again. If its not working for you in next 20 mins stop the cleint copy and run Update statistics.
And than start you client copy where it stopped. It will resolve your issue.
brtools
7 - Database statistics than
1 = Update database statistics
Thanks,
Bhanu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You see any copy process running in SM66? If yes, what is it doing?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi markus,
status in SM66.
Sort: Server
Server Name:devsap_DEV_00
No: 12
Type: BTC
PID:2964
Status: Running
Time: 74800
User: SAP*
Report: RGUGFIS0
Action: Sequential Read
Table: D010INC
the client copy consumed (74800 sec) 20 hours... may i restart the SAP System or close this client copy becoz there are lot of pending tasks or still wait..
waiting ur good respons.
regards,
majamil
Hi Eric & Markus,
FYI,
i have installed Oracle software and SAP installation and then install Oracle Patch.
should we need to upgrade the oracle with
upgrade and catupgrd.sql command
or not???
search in directory x:\usr\sap for file brconnect, change to this directory using a command prompt and execute again.
i searched the brconnect file and ... why we need to change the directory mean if i change its directory then may i face problem during execution of brconnect.exe.. and i have to tried to run brconnect.exe file while it exists in F drive and result is
C:\>F:\usr\sap\IDS\DVEBMGS00\EXE\brconnect.exe
BR0801I BRCONNECT 7.00 (18)
BR0155E No value found for option '-f'
BR0280I BRCONNECT time stamp: 2008-10-30 15.41.52
BR0804I BRCONNECT terminated with errors
regards,
majamil
execute brcoonnect with following options.
F:\usr\sap\IDS\DVEBMGS00\EXE\brconnect -c -u / -f stats -t D010INC -f collect
you have to execute catupgrd.sql scripts once you upgraded your oracle patches
follow Note 819830 - Oracle Database 10g: Additional Information on upgrade:UNIX
Note 839187 - Oracle Database 10g: Patch set installation
cheers,
-Sunil
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.