Work process restarted; session terminated in Client Copy

[Former Member]

Hello everyone!

I'm trying to do the "Client Copy" but when it is in, I get the following error "Work process restarted; session terminated"

The configuration of the facility is:

"ECC 6" in "Windows 2003 Enterprise" with Oracle.

I've tried to back at least some 5 times, always remain the same result.

Someone could help me with this?

thanks

[Former Member]

so it is set to default.

You can increase this parameter from RZ11 and try to execute the copy.

This is a dynamic parameter.

You dont need to really shutdown the system.

Thanks

Amit

[Former Member]

1 .I believe you are doing client copy in the background.

2.Check your rdisp/max_wprun_time parameter value.

3.Do you get some errror in sm21 or st22 related with point 2.

can you paste your scc3 log as well as sm21 ?

hope it help.

Regards

amit

[Former Member]

Amit,

The "Client Copy" took place both in "Background" and "Dialog Mode" in both cases the error is present. The time elapsed before the error is approximately 10 minutes for the first case and 30 minutes for the second case.

The parameter that you mention, in which one of the profiles should exist because I have checked the default, instance and start, and I find it in no one of them.

thanks

[Former Member]

Hi Manuel

May i know how long did the client copy run before it got terminate?

If you are not able to se the parameter value from RZ10

then check it from RZ11.

If the value is less, then you can change it dynamically.

No Restart required.

if it resolve the purpose fine otherwise

Please post related system logs.

Regards

[Former Member]

TCode SM21

-

---

Details Page 2 Line 8 System Log: Local Analysis of mts-qua 1

Time Type Nr Clt User TCode Grp N Text

08:18:07 DIA 003 BY 2 Database error 1033 at CON

Database error 1033 at CON

Details

Recording at local and central time........................ 18.08.2008 08:18:07

Task...... Process User...... Terminal Session TCode Program Cl Problem cl Package

02804 Dialog work process No. 003 K SAP Web AS Problem SBAC

Further details for this message type

Module nam Line SQL functi Table Name

dblink 431 CON

Documentation for system log message BY 2 :

After the attempt to call a database operation, the database system has

returned the error code specified in the message, which indicates that

the operation concerned could not be executed successfully.

Technical details

File Offset RecFm System log type Grp N variable message data

6 145620 g Database SQL Error BY 2 1033 CON dblink 431

-

---

Details Page 2 Line 9 System Log: Local Analysis of mts-qua 1

Time Type Nr Clt User TCode Grp N Text

08:25:38 BTC 010 R1 9 Initialization DB-Connect Failed, Return Code 000256

Initialization DB-Connect Failed, Return Code 000256

Details

Recording at local and central time........................ 18.08.2008 08:25:38

Task...... Process User...... Terminal Session TCode Program Cl Problem cl Package

03224 Background Processor No. 010 K SAP Web AS Problem STSK

Further details for this message type

Module nam Line Error text.......... Caller.... Reason/cal

thxxhead 1426 DB-Connect 000256 ThInit db_conn

Documentation for system log message R1 9 :

Initialization of the SAP environment has failed. Analyze the

preceding system log entries.

Technical details

File Offset RecFm System log type Grp N variable message data

5 365760 m Error (Function,Module,Row) R1 9 DB-Connect 000256 ThInit db_connthxxhead1426

-

---

Details Page 2 Line 10 System Log: Local Analysis of mts-qua 1

Time Type Nr Clt User TCode Grp N Text

08:25:38 BTC 010 Q0 2 Stop Workproc10, PID 3224

Stop Workproc10, PID 3224

Details

Recording at local and central time........................ 18.08.2008 08:25:38

Task...... Process User...... Terminal Session TCode Program Cl Problem cl Package

03224 Background Processor No. 010 S Operation Trace STSK

Further details for this message type

Module nam Line Error text Caller.... Reason/cal

dpnttool 327# Workproc10 3224 wp_halt WPStop

Documentation for system log message Q0 2 :

The specified process has been stopped

Technical details

File Offset RecFm System log type Grp N variable message data

5 365940 m Error (Function,Module,Row) Q0 2 Workproc10 3224 wp_haltWPStop dpnttool32

-

---

Details Page 2 Line 11 System Log: Local Analysis of mts-qua 1

Time Type Nr Clt User TCode Grp N Text

08:25:38 BTC 009 BV 3 SQL error 1033 occurred (possible network problems?). Work process is stopped

SQL error 1033 occurred (possible network problems?). Work process is stopped

Details

Recording at local and central time........................ 18.08.2008 08:25:38

Task...... Process User...... Terminal Session TCode Program Cl Problem cl Package

03276 Background Processor No. 009 S Operation Trace SBAC

Further details for this message type

Module nam Line Table Name Field Name

dbsh 1199 1033

Documentation for system log message BV 3 :

A database operation has returned an error code which indicates that

the work process concerned is no longer connected to the database or

that the connection has been interrupted. This situation may occur,

for example, when the database but not the SAP System was closed down.

The error may also result from network problems that cause the

connection between the application server and the database to be

interrupted. You may find information about the cause for the error in

the database error text.

The work process is stopped. The dispatcher tries to restart the work

process.

echnical details

File Offset RecFm System log type Grp N variable message data

5 366120 h Database Error (Non-SQL) BV 3 1033 dbsh 1199

[Former Member]

TCode SCC3 log

Target Client 300

Source Client 000

Copy Type Local Copy

Profile SAP_CUSV

- Restart X

Status Restart Cancelled

User SAP*

Start on 17.08.2008 / 15:45:01

Last Entry on 17.08.2008 / 16:06:42

Last Action: Copy/Delete Tables

- Table Being Edited: DSYS_PHHYPE_ECD2

Statistics for this Run

- No. of Tables (Total) 8988 of 52833

- In This Run 3975 of 47820

- Previously Copied Tables 5013

- Deleted Lines 1138398

- Copied Lines 1138301

Check System Log (SM21)

arnings and Errors

arnings from Current Run are Marked

Table Name Component Package

EABLARCHIVE IS-U-TO-ARC DDIC Error (See SE14)

ECVFIELD IS-U-CS DDIC Error (See SE14)

EEWA_PROP_H IS-U-WA DDIC Error (See SE14)

EKBE MM-PUR DDIC Error (See SE14)

Job Steps for the Same Run:

Date Time Status Status Text Phase

17.08.2008 15:45:01 Y Restart Cancelled CC

17.08.2008 13:13:41 X Cancelled CC

[Former Member]

Check the dump in ST22, you have some issues either at OS level ( paging space is not enough , add more paging space )

Oracle oracle table spaces are full.

Check the tcode : ST22

Give us the dump