Parallel Export/Import processes ends with NiWrite=RC6 or RC8

[Former Member]

Hi All,

I would like to get some ideas on what could have gone wrong for this.

Trying to run parallel export/import from two boxes but the source seems to get disconnected after a successful socket connection to the target box.

Source - LDNPSMSA77

Target - LDNPSMSA0029

I am using the latest NW7.01 CD with the later MIGMON patch. R3load is 7.01 patch 69.

I have also tried patching up R3load to 7.01 patch 98, but still got the weird network problem.

Appreciate some help on this.

Thanks

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

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100721145325

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: version R7.01/V1.4 [UNICODE]

Compiled Jun 23 2010 23:59:52

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe -ctf E
ldnpsmsa0029\e$\EXPORT_SBX\ABAP\DATA\ARFCSDATA.STR
ldnpsmsa0029\e$\EXPORT_SBX\ABAP\DB\DDLORA_LRG.TPL ARFCSDATA-1.TSK ORA -where
ldnpsmsa0029\e$\EXPORT_SBX\ABAP\DATA\ARFCSDATA-1.WHR -l ARFCSDATA-1.log

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: job completed

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100721145325

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100721145326

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: version R7.01/V1.4 [UNICODE]

Compiled Jun 23 2010 23:59:52

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe -socket -e ARFCSDATA-1.cmd -datacodepage 4103 -l ARFCSDATA-1.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: Export without hintfile

(RFS) INFO: connection established to port 3005 on ldnpsmsa0029

(GSI) INFO: dbname = "SBX20100616040637 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "LDNPSMSA77 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "LDNPSMSA77"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 2"

(GSI) INFO: machine = "4x AMD64 Level 15 (Mod 37 Step 1)"

(GSI) INFO: instno = "INITIAL "

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(WTS) ERROR: NiWrite() failed, rc = -6

(WTS) ERROR: NiWrite() failed, rc = -8

(DB) INFO: disconnected from DB

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\SBX\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100721145330

[markus_doehr2]

> Trying to run parallel export/import from two boxes but the source seems to get disconnected after a successful socket connection to the target box.

Make sure all firewalls are deactivated, they tend to tear down TCP connections after some time when there's no active data transfer happening.

Markus

[Former Member]

Hi Markus,

Thanks for the reply.

The network team has confirmed that there are no firewall inbetween the boxes. I am able to do a telnet to the target box on the network sockets ports. NiPing tests was running fine.

Regards

[markus_doehr2]

> The network team has confirmed that there are no firewall inbetween the boxes. I am able to do a telnet to the target box on the network sockets ports. NiPing tests was running fine.

I was thinking more about the local firewalls on the machines itself. Even if they have been deactivated certain security patches enable them again.

Markus

[Former Member]

Hi Markus,

The Windows Firewall is not enabled on both Windows OS.

Regards

[Former Member]

Hi Ferris,

Sorry, not much of an SAP guy here but if it's an Oracle-related export you might try setting the SQLNET.EXPIRE_TIME parameter in the sqlnet.ora.

http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm

Regards,

Rich