on 12-20-2011 11:07 AM
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.
Sort the logs in /usr/sap/trans/log and check the latest ones.
Is this a local or a network drive?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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 !
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.