errors in system copy

[Former Member]

Hi All,

Am doing homogenous system copy by using export/impoort method.We are using table split technique too.

The database size is 780gb and out of 162 packages 144 packages are done successfully .18 are failing .Below are the logs

Sytem details:Oracle 11.2.0.2/SunOS 5.10/ECC6 EHP5

ERROR: 2013-03-29 10:45:14 com.sap.inst.migmon.LoadTask run
Unloading of 'SAPAPPL0_3' export package is interrupted with R3load error.
Process '/usr/sap/XXX/DVEBMGS00/exe/R3load -e SAPAPPL0_3.cmd -datacodepage 4102 -l SAPAPPL0_3.log -stop_on_error' exited with return code 2.
For mode details see 'SAPAPPL0_3.log' file.
Standard error output:
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

In the export_monitor.java.log

DbSl Trace: Error 3106 in stmt_fetch() from oci_execute_stmt(), orpc=13

DbSl Trace: ORA-03106 occurred at SQL stmt (parse error offset=5308416)

(EXP) ERROR: DbSlExeRead failed
  rc = 99, table "CAT_DP_TAB"
  (SQL error 3106)
  error message returned by DbSl:
ORA-03106: fatal two-task communication protocol error
(DB) INFO: disconnected from DB

/usr/sap/XXX/DVEBMGS00/exe/R3load: job finished with 1 error(s)
/usr/sap/XXX/DVEBMGS00/exe/R3load: END OF LOG: 20130329104514

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

ERROR: 2013-03-29 11:56:04 com.sap.inst.migmon.LoadTask run
Unloading of 'SAPPOOL' export package is interrupted with R3load error.
Process '/usr/sap/XXX/DVEBMGS00/exe/R3load -e SAPPOOL.cmd -datacodepage 4102 -l SAPPOOL.log -stop_on_error' exited with return code 2.
For mode details see 'SAPPOOL.log' file.
Standard error output:
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

In the export_monitor.java.log

DbSl Trace: Error 3106 in stmt_fetch() from oci_fetch_stmt(), orpc=491

DbSl Trace: ORA-03106 occurred at SQL stmt (parse error offset=3473408)

(EXP) ERROR: DbSlExeRead failed
  rc = 99, table "ATAB"
  (SQL error 3106)
  error message returned by DbSl:
ORA-03106: fatal two-task communication protocol error
(DB) INFO: disconnected from DB

/usr/sap/XXX/DVEBMGS00/exe/R3load: job finished with 1 error(s)
/usr/sap/XXX/DVEBMGS00/exe/R3load: END OF LOG: 20130329115604

#################################################################################

SAPSPROT.log

DbSl Trace: ORA-03106 occurred at SQL stmt (parse error offset=0)

(EXP) ERROR: DbSlExeRead failed
  rc = 99, table "DBTABLOG"
  (SQL error 3106)
  error message returned by DbSl:
ORA-03106: fatal two-task communication protocol error
(DB) INFO: disconnected from DB

/usr/sap/XXX/DVEBMGS00/exe/R3load: job finished with 1 error(s)
/usr/sap/XXX/DVEBMGS00/exe/R3load: END OF LOG: 20130329115821

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

The size of the table SWWCNTP0 IS 26626.56mb(25gb) ,We are using the table split technique for this too .Below are the 14 packages and we don’t have logs for these 14 packages in any log files

Unloading of 'SWWCNTP0-1' export package: ERROR
Unloading of 'SWWCNTP0-11' export package: ERROR
Unloading of 'SWWCNTP0-10' export package: ERROR
Unloading of 'SWWCNTP0-12' export package: ERROR
Unloading of 'SWWCNTP0-13' export package: ERROR
Unloading of 'SWWCNTP0-14' export package: ERROR
Unloading of 'SWWCNTP0-15' export package: ERROR
Unloading of 'SWWCNTP0-2' export package: ERROR
Unloading of 'SWWCNTP0-3' export package: ERROR
Unloading of 'SWWCNTP0-4' export package: ERROR
Unloading of 'SWWCNTP0-5' export package: ERROR
Unloading of 'SWWCNTP0-7' export package: ERROR
Unloading of 'SWWCNTP0-6' export package: ERROR
Unloading of 'SWWCNTP0-8' export package: ERROR
Unloading of 'SWWCNTP0-9' export package: ERROR

==================================================

SAPAPPL0_3.log
SAPSPROT.log
SAPPOOL.log

SWWCNTP0-1=-
SWWCNTP0-10=-
SWWCNTP0-11=-
SWWCNTP0-12=-
SWWCNTP0-13=-
SWWCNTP0-14=-
SWWCNTP0-15=-
SWWCNTP0-2=-
SWWCNTP0-3=-
SWWCNTP0-4=-
SWWCNTP0-5=-
SWWCNTP0-6=-
SWWCNTP0-7=-
SWWCNTP0-8=-
SWWCNTP0-9=-

Kernel versions

nfsphy0301:oraXXX 6% disp+work

--------------------
disp+work information
--------------------

kernel release                720

kernel make variant           720_EXT_REL

compiled on                   SunOS 5.10 Generic_141444-09 sun4us for sun_64

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  Jun 16 2012 00:42:07

update level                  0

patch number                  223

source id                     0.223

---------------------
supported environment
---------------------

database (SAP, table SVERS)   700
                              710
                              701
                              702
                              703
                              711
                              720
                              730
                              731
                              732

operating system
SunOS 5.10
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$######################$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$#####################################################$$$$$$$$$$$$$$$$$$$$$

R3load version ::

nfsphy0301:oraXXX 7% R3load -v
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

--------------------
R3load information
--------------------

kernel release                720

kernel make variant           720_EXT_REL

DBMS client library           OCI_102,

DBSL shared library version   720.00

compiled on                   SunOS 5.10 Generic_141444-09 sun4us for sun_64

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  Jun  1 2012 19:27:13

update level                  0

patch number                  221

source id                     0.221

---------------------
supported environment
---------------------

database (SAP, table SVERS)   700
                              710
                              701
                              702
                              703
                              711
                              720
                              730
                              731
                              732

DBMS server
   ORACLE 10.1.0.*.*
   ORACLE 10.2.0.*.*
   ORACLE 11.2.*.*.*

operating system
SunOS 5.10
SunOS 5.11

Regards
Bharat

[Former Member · Accepted solution]

Hi Bharat,

     After installation of oracle  , did you applied the oracle patches ?

It is due to inconsistent bugs in the oracle.  Please see the links for more information.

http://scn.sap.com/thread/435544

Note 1005758 - ORA 3106 in Oracle 10.2.0.2

If your oracle is 11G, you have to apply the SBP in order to fix this issue.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Try to re-continue also and check ..

[Former Member · Accepted solution]

Hi Maria,

Thanks for your prompt solution.

Let me know if you can help in this issue while running SBP .

I have Executed the SAP Bundle pack(SAP_112029_201302_SOL64.zip)  in the documentation mode in the  system by updating the OPatch to 11.2.0.3.1  and MOPatch  to 2.1.13.

I have attached the logs for further reference .

There are 33 patches skipped  as they are online. Let me know whether  these patches will have any impact  if approaching  for  original run?

Regards

Bharatram Ramakrishnan

mopatch log1.txt.zip

mopatch log.txt.zip

[Former Member · Accepted solution]

Hi Bharat,

    Yes. You are correct.

There are some patches that will be skipped ..

There won't be any impact ... It is normal only.

Please proceed further.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Maria,

We have done the SAP bundle pack,opatch and mopatch upgrade

You have given the exact solution to us and now the export for 3 tables(ATAB",DBTABLOG,CAT_DP_TAB) are successfull and for one table SWWCNTP0(26gb) is failing

Regards

Ram

[Former Member · Accepted solution]

Hi ,

Below are the logs for the table SWWCNP0 and we have used tablepslit for this table too

The error we got in the export montiorlog  for table SWWCNTP0

ERROR: 2013-03-29 12:13:04 com.sap.inst.migmon.LoadTask run

Unloading of 'SWWCNTP0-12' export package is interrupted with exception.

1. java.io.FileNotFoundException: DATA/SWWCNTP0.STR

        at com.sap.inst.migmon.LoadTask.buildTaskFileCommand(LoadTask.java:463)

        at com.sap.inst.migmon.LoadTask.processPackage(LoadTask.java:267)

        at com.sap.inst.migmon.LoadTask.run(LoadTask.java:195)

        at java.lang.Thread.run(Thread.java:722)

        at com.sap.inst.lib.util.ThreadDispatcher$ThreadWrapper.run(ThreadDispatcher.java:113)

ERROR: 2013-03-29 12:13:04 com.sap.inst.migmon.LoadTask run

Unloading of 'SWWCNTP0-13' export package is interrupted with exception.

1. java.io.FileNotFoundException: DATA/SWWCNTP0.STR

        at com.sap.inst.migmon.LoadTask.buildTaskFileCommand(LoadTask.java:463)

        at com.sap.inst.migmon.LoadTask.processPackage(LoadTask.java:267)

        at com.sap.inst.migmon.LoadTask.run(LoadTask.java:195)

        at java.lang.Thread.run(Thread.java:722)

        at com.sap.inst.lib.util.ThreadDispatcher$ThreadWrapper.run(ThreadDispatcher.java:113)

TRACE: 2013-03-29 12:13:34 com.sap.inst.migmon.LoadTask run

Unloading of 'SWWCNTP0-14' export package is started.

TRACE: 2013-03-29 12:13:34 com.sap.inst.migmon.LoadTask run

Unloading of 'SWWCNTP0-15' export package is started.

ERROR: 2013-03-29 12:13:34 com.sap.inst.migmon.LoadTask run

Unloading of 'SWWCNTP0-14' export package is interrupted with exception.

1. java.io.FileNotFoundException: DATA/SWWCNTP0.STR

        at com.sap.inst.migmon.LoadTask.buildTaskFileCommand(LoadTask.java:463)

        at com.sap.inst.migmon.LoadTask.processPackage(LoadTask.java:267)

        at com.sap.inst.migmon.LoadTask.run(LoadTask.java:195)

        at java.lang.Thread.run(Thread.java:722)

        at com.sap.inst.lib.util.ThreadDispatcher$ThreadWrapper.run(ThreadDispatcher.java:113)

Let me know if anyone can give any solutions to the issue

Regards

Ram

[Former Member · Accepted solution]

Hi  Maria

Export is finished successfully .

I could not get any solutions from any link so i did my workaround

i just did a small trick .As per the log it is not recognizing SWWCNTP0.STR so the structure of SWWCNTP0~2.STR should be in sync to SWWCNTP0.STR   .This I got it by comparing EDI40 and CDCLS tables.Then resumed the export and all the 14 packages were successfull .

Many thanks

Regards

Bharatram Ramakrishnan

[Former Member · Accepted solution]

Hi Maria,

Do you  have any idea in modifying  not  to export  the  table  DBTABLOG,SWWLOGHIST ?

Let me know if there  is any modification to be done to avoid export for these tables during the process of system copy

Regards

Ram