Client Copy Still Running

[former_member182034]

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

[Former Member]

Hi Majamil,

Have you updated Update database statistics?

Thanks,

Bhanu

[former_member182034]

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

[markus_doehr2]

Those two scripts create/update the Oracle dictionary, they are not performance related at all. If you see a speed increase it´s more likely that the restart of the database did help.

Markus

[former_member197668]

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.

[Former Member]

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

[markus_doehr2]

You see any copy process running in SM66? If yes, what is it doing?

Markus

[former_member182034]

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

[Former Member]

check in tcode scc3 and check for log details. here you can findout when the last entry was and how many lines copied.

cheers,

-Sunil

[former_member182034]

Hi Sunil,

plz check first message in this post and you can c all tables which is completed and Post Processing is running from last 21 hours.

while

No of Tables: 54524 of 54524

Deleted Line: 3

copied lines: 5046248

regards,

[Former Member]

can you please check the active job status in SM37 --> select client copy job --> job check status.

also check whether you sufficient space at OS level (usr\sap\trans\).

cheers,

-Sunil

[former_member204746]

run this command at OS level:

brconnect -c -u / -f stats -t D010INC -f collect

[former_member182034]

Hi Eric,

the client copy still running mean it has consumed the 40 hours until..

and would you explain the effects and outcome of this command.

brconnect -c -u / -f stats -t D010INC -f collect

regards,

[former_member204746]

this will recalculates DB stats. it might help improve speed of queries made to this table.

[former_member182034]

Hi ERIK,

brconnect -c -u / -f stats -t D010INC -f collect

sorry for delay... dear when i run this command on OS level then it shows .. this is not internal or external command.....

cheers

[markus_doehr2]

Are you running that command as ora<SID>?

Markus

[former_member204746]

Markus,

He's on Windows!

Manu Jain,

search in directory x:\usr\sap for file brconnect, change to this directory using a command prompt and execute again.

a long-term solution is to add this directory in your PATH (Environment variables)

[lakshminarayanan_m]

Hi,

Did you check your tablespace in your system

Regards

MLN

[former_member182034]

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

[Former Member]

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