cancel
Showing results for 
Search instead for 
Did you mean: 

Applying Support Packages and S-Notes never end

Former Member
0 Kudos

Hello,

Since we have switched to Windows Server 2008 R2 (64) no Support Package or S-Snote can be applied to the system correctly.

In detail, the import phase IMPORT_PROPER does not end. The Batch Job OCS_QUEUE_IMPORT runs constantly without any errors.

On Windows the tp.exe process runs, it has nothing to do. After killing the tp process the Batch Job OCS_QUEUE_IMPORT ends successfully. Afterwards I delete the files in /tmp in TRANS_DIR. If I restart the queue import again then it works.

Technical details:

SAP ECC 6.0

SAP BASIS 700 PL 23

Oracle 11.2

Windows Server 2008 R2 (64)

Any idea what the problem is?

Thanks.

Accepted Solutions (0)

Answers (3)

Answers (3)

markus_doehr2
Active Contributor
0 Kudos

Sort the logs in /usr/sap/trans/log and check the latest ones.

Is this a local or a network drive?

Markus

tomas-krojzl
Active Contributor
0 Kudos

Hello,

also try to review Windows event log - you might find there some related errors...

Tomas

nicholas_chang
Active Contributor
0 Kudos

in addition to above, please check oracle alert log as well.

Former Member
0 Kudos

I have applied an Add-On yesterday. The same problem occured.

In SM50 I could not see the table DO10INC in SM50. The database statistics are up to date.

By the way the transport directory is a network drive.

I have checked the latest logs in /usr/sap/trans/log too. But I see no errors.

IMODPROT.P01 (german)

1 ETN080X*************************************************************************
1 E0U532 "Report RSUMOD20_SP" "(Sonderbehandlung IS-Tabellen)"
1 ETN252     Start date: "10.01.2012"
1 ETN253     Start time: "17:23:14"
1 ETN080 *************************************************************************
1 ETN080X*************************************************************************
1 E0U532 "Report RSUMOD20_SP" "(Sonderbehandlung IS-Tabellen)"
1 ETN252     Start date: "10.01.2012"
1 ETN253     Start time: "17:33:39"
1 ETN080 *************************************************************************

SAPRUPGM.P01 (german)

4 E  531 Unknown message with "Alle DB-Puffer des Applikationsservers sapsys wurd" " " " " " "
4 E  531 Unknown message with "Es wurde keine Hinweiskorrektur mit unbestimmtem A" "Bitte prüfen Sie die Filtereinstellungen." " " " "
4 E  531 Unknown message with "Es wurde keine Modifikation mit unbestimmtem Abgle" "Bitte prüfen Sie die Filtereinstellungen." " " " "
4 E  531 Unknown message with "Wählen Sie im Selektionsbild der Transaktionen SE9" " " " " " "
4 E  531 Unknown message with "Das Ankreuzfeld 'Gelöschte Objekte' finden Sie auf" " " " " " "
4 E  531 Unknown message with "In der SPAU werden die 'Gelöschten Objekte' mit ei" " " " " " "
4 E  531 Unknown message with "Beim Klick auf die rote Ampel erhalten Sie weitere" " " " " " "
4 E  531 Unknown message with "Verwenden Sie ggf. die Funktion 'Modifkationsproto" " " " " " "
4 E  531 Unknown message with "LIMU" "DYNP" "/SAPDMC/SAPLLSMW_OBJ_080                0700" "Lösch-Kennzeichen gesetzt."
4 E  531 Unknown message with "LIMU" "DYNP" "/SAPDMC/SAPLLSMW_OBJ_080                0800" "Lösch-Kennzeichen gesetzt."
...

SAPIITLRD5.P01

4 ETW000 R3trans.exe version 6.14 (release 700 - 03.06.11 - 17:57:00).
4 ETW000 ===============================================
4 ETW000 
4 ETW000 date&time   : 10.01.2012 - 17:13:17
4 ETW000 control file: \sapsyssapmnt	rans	mpSAPKKITLRD5.P01
4 ETW000 > #pid 4452 on sapsys (APServiceP01)
4 ETW000 > import
4 ETW000 > buffersync=yes
4 ETW000 > file='\sapsyssapmnt	ransdataRITLRD5.SAP'
4 ETW000 > continuation='\sapsyssapmnt	ransdataRITLRD5_#.SAP'
4 ETW000 > client cascade yes
4 ETW000 > recclient = "050"
4 ETW000 > watchparallelprocesses yes
4 ETW000 > 
4 ETW000 > excluding 'R3TRDDDD','R3TRDOMA','R3TRDTEL','R3TRENQU','R3TRMACO','R3TRMCID','R3TRMCOB','R3TRSHLP','R3TRSQLT','R3TRTABL','R3TRTTYP','R3TRUENO','R3TRVIEW'
4 ETW000 R3trans was called as follows: R3trans.exe -w \sapsyssapmnt	rans	mpSAPIITLRD5.P01 \sapsyssapmnt	rans	mpSAPKKITLRD5.P01
4 ETW000 table logging turned on '050'
4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'P01' --- SYSTEM = 'P01'.
4 ETW690 COMMIT "0" "0"
4 ETW000  trace at level 1 opened for a given file pointer
4 ETW000 
4 ETW000 ================== STEP 1 =====================
4 ETW000 date&time        : 10.01.2012 - 17:13:17
4 ETW000 function         : IMPORT
4 ETW000 data file        : \sapsyssapmnt	ransdataRITLRD5.SAP
4 ETW000 Continuation     : \sapsyssapmnt	ransdataRITLRD5_#.SAP
4 ETW000 buffersync       : YES
4 ETW000 clients          : cascade
4 ETW000 repeatimport     : NO
4 ETW000 repeatclimport   : NO
4 ETW000 c.s.i.           : NO
4 ETW000 watchparallelprocesses: YES
4 ETW000 autorepeat       : -1 (automatic)
4 ETW000 recclient        : 050
4 ETW000 l.s.m.           : VECTOR
4 ETW000 charsetadapt     : YES
4 ETW000 def. charset     : WEUROPEAN
4 ETW000 commit           : 100000
4 ETW000 table cache      : dynamic
4 ETW000 EXCLUDING        : 'R3TRVIEW','R3TRUENO','R3TRTTYP','R3TRTABL','R3TRSQLT','R3TRSHLP','R3TRMCOB','R3TRMCID','R3TRMACO','R3TRENQU','R3TRDTEL','R3TRDOMA','R3TRDDDD'
4 ETW000 
4 ETW000 clients which are protected against client cascade: 066
4 ETW000 
4 ETW000 client cascade to: 000, 001, 050, 100
4 ETW000 Character set on this machine : ASCII (ISO 8859-1).
4 ETW000 Character set on the data file: 2 byte unicode little endian.
4 ETW000 Data file is compressed with algorithm 'L'.
4 ETW000 Export was executed on 13.10.2011 at 15:21:58 by k71adm      
3 ETW709 "702 "
4 ETW000   with R3trans version: 24.08.10 - 14:38:42
4 ETW000 Source System = AMD/Intel x86_64 with Linux on DBMS = ADABAS D --- DBNAME = 'K71' --- SYSTEM = 'K71'.

On Windows side I have application errors to the related time. The error was taken from the Event Viewer.

SAP Basis System: Operating system call           recv failed (error no. 10054)

On Oracle side I could not find any abnormality.

Former Member
0 Kudos

Hi,

The problem could be because it is a network drive.

I had a similar problem once, after changing the directory to a local drive, the problem did not occur.

Regards,

Vishnu

Former Member
0 Kudos

Hi,

I have a similar problem on Win2K8 R2 but with the 7.20_EXT kernel on a solution manager with Oracle DB (11.2.0.2).

I've tried all the available kernel versions : 100, 105 and even the latest Disp+work, R3trans and DBsl libs.

When importing big patch (over 200 Mb) R3trans keeps running without doing anything. No activity on Oracle side (GV$SESSION), no updates in the transport logs.

When I kill the R3trans process (after hours of processing) in the log of the SP beeing import it notify an interruption few minutes after the latest update of the log... but in fact 6 hours before I kill the process. This shows that R3trans was really stuck.

I think this is something specific to windows because I did not get that problem when importing the same SP stack on a Linux SLES system.

I'll have to open an OSS message but I'm afraid it will be a very long process before having some usefull answer ...

It's a pain to handle this kind of problem with SAP support !

Former Member
0 Kudos

I did get an answer from SAP support on that problem of imports running forever.

There is an Oracle 11g bug that did affect mass insert on LOB segements (and SAP sources are in lob segments)

[_1635605 - CLIENT HANGS ON INSERT INTO TABLE WITH SECUREFILE LOB_|https://service.sap.com/sap/support/notes/1635605]

Oracle client programs like SAP disp+work.exe or R3trans.exe can hang on insert into tables with SecureFile LOB columns if Oracle server is running on MS Windows.

Set the Oracle initialization parameter

usezero_copy_io=false

Former Member
0 Kudos

Yes. That was it. SAP Note 1635605 solves the Bug. Thank you.

tomas-krojzl
Active Contributor
0 Kudos

Hello,

On Windows the tp.exe process runs, it has nothing to do. After killing the tp process the Batch Job OCS_QUEUE_IMPORT ends successfully. Afterwards I delete the files in /tmp in TRANS_DIR. If I restart the queue import again then it works.

Once I got very similar problem on AIX. After SAP startup I was able to import one transport successfully and then second transport get frozen until next SAP restart. (I was not trying to kill tp at that time.)

After really long time wasted on this issue I was able to identify the root cause - I got dboraslib.so two times on system and I was unlucky to have very old version in directory that was mentioned in LD_LIBRARY_PATH before my kernel. So wrong version of SAP DBMS library was loaded into memory.

Interesting fact was that this incompatibility did not cause any error - just froze-ups. Since that time I encountered similar issue multiple times and it was always problem related to DBMS library or database client.

I would suggest to ensure that you have proper version of client installed and proper SAP DBMS library as well as that these files are not anywhere in path before your kernel and that these files are not in windows/system32 directory.

Tomas

former_member188883
Active Contributor
0 Kudos

Hi,

Could you apply the latest SAP kernel on your system supported on Window 2008 R2. This should help you in getting out of these problems.

Regards,

Deepak Kori

Former Member
0 Kudos

Thank you for your response. The system is already up to date with the latest Kernel version 310.

Former Member
0 Kudos

Hi,

In SM50 are you seeing a table DO10INC being constantly accessed?

If you are using oracle database, ensure that your database statistics are upto date, if not run it using brtools.

Regards,

SBK