My Client Copy/Export keeps failing!

[Former Member]

Guys,

I have tried almost everything but any attempt to perform a local client copy keeps failing. I have tried a client export but that too didn’t succeed.

Configuration:

- R/3 Enterprise 4.7 1.10

- AIX 5.2

- DB2 with FixPak10

Error log of the export.

Main export

Transport request___: N02KT00205

System______________: N02

tp path : tp

Version and Release: 340.16.03 640

SQL error -902 accessing AGR_HIERT: SQL0902C A system error (reason code =

SQL error -902 accessing LKSML: SQL0902C A system error (reason code =

SQL error -902 accessing T074: SQL0902C A system error (reason code =

Incorrect export. Request is not imported.

Main export

End date and time : 20060508121828

Ended with return code: ===> 12 <===

[Former Member]

Hi,

Look at note 756526. Its not completely related but might give you a hint.

[Former Member]

Hi Hassan,

have you solved the problem?

I'm encountering the same error message during my copy...

Best regards

Ivan Schnyder

[Former Member]

Hi Hassen

can u provide me the local client copy error log.

regards,

kaushal

[Former Member]

Target Client 220

Source Client (incl. Auth.) 201

Source Client User Master 201

Copy Type Local Copy

Profile SAP_ALL

Status Ended with Errors

User SAP*

Start on 03.05.2006 / 17:36:34

Last Entry on 03.05.2006 / 19:25:53

Statistics for this Run

- No. of Tables 29.582 of 29.584

- Deleted Lines 10.395

- Copied Lines 4.436.310

Warnings and Errors

Table/Object Component Error

AGR_HIERT BC-SEC-USR-PFC Read Error(See System Log)

DSYS_PHCONT_E_CD PY-XX Read Error (See System Log)

[Former Member]

Do you need additional logs?

[Former Member]

Hi Hassen

the error indicates there is problem reading two tables.

AGR_HIERT--- Role menu texts

DSYS_PHCONT_E_CD --Table for Document Contents

CHCEK THIS TABLE In 201 CLIENT. AND ACTIVE IT.

also check the system log using SM21.

make sure there are no user login into system during client copy

regards,

kaushal

[Former Member]

Hi Haseen

if possible provide the system log . (sm21)

regards,

kaushal

[Former Member]

I have sm21 logs

-

---

20:37:52 BTC 11 220 DDIC BXF Table logging in program RSCLXCOP disabled by user DDIC

20:38:50 BTC 11 220 DDIC BB1 Buffer TABL reset

20:38:50 BTC 11 220 DDIC BB1 Buffer TABLP reset

20:38:51 BTC 11 220 DDIC F77 Spool: Invalid Output Device

20:38:51 BTC 11 220 DDIC F77 Spool: Invalid Output Device

20:38:51 BTC 11 220 DDIC FBJ DB_RTAB_ERROR at Table TSP0A, Error 64 rspogdio 2

20:38:58 DIA 03 000 SAPSYS D01 Transaction Canceled BT 513 ( )

20:38:58 DIA 03 000 SAPSYS R68 Perform rollback

20:44:58 SPO 15 000 SAPSYS Q0I Operating system call gethostbyname failed (error no. 0 )

20:46:52 BTC 11 220 DDIC BYM SQL error -902 . Work processes in reconnect status

20:47:23 DIA 00 200 Z714G41 DB13 BYM SQL error -902 . Work processes in reconnect status

20:49:18 BTC 12 220 DDIC BYM SQL error -902 . Work processes in reconnect status

20:49:18 BTC 12 220 DDIC R68 Perform rollback

20:49:18 BTC 12 220 DDIC BYY Work process has left reconnect status

20:49:18 BTC 12 220 DDIC AB0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

20:49:18 BTC 12 220 DDIC AB1 > Short dump "060503 204918 rn0434 DDIC " generated

20:49:18 BTC 12 220 DDIC D01 Transaction Canceled 00 671 ( DBIF_RSQL_SQL_ERROR 20060503204918rn0434 DDIC 2201 )

20:49:19 BTC 12 220 DDIC R68 Perform rollback

20:51:48 BTC 11 220 DDIC BYM SQL error -902 . Work processes in reconnect status

21:04:45 BTC 11 220 DDIC BYM SQL error -902 . Work processes in reconnect status

21:12:14 BTC 11 220 DDIC BYM SQL error -902 . Work processes in reconnect status

21:13:34 BTC 11 220 DDIC BYM SQL error -902 . Work processes in reconnect status

21:42:13 BTC 11 220 DDIC BYM SQL error -902 . Work processes in reconnect status

22:01:37 BTC 11 220 DDIC BYM SQL error -902 . Work processes in reconnect status

22:36:14 BTC 11 220 DDIC R68 Perform rollback

[Former Member]

Hi,

The above mentioned table are already active.