cancel
Showing results for 
Search instead for 
Did you mean: 

"running DEPLOYMENT", CTS+ & non-Deployment

Former Member
0 Kudos

Hello @All:

Currently we are facing some major issues, trying to use CTS+. When we create a transport request, attach (whatever epa or sca) release it and then tying to import it tp starts and runs and runs and runs...

In the state "running DEPLOYMENT" the transport request is not completed completey.

We got the following system landscape:

DEV --> PROD

Both systems are dual stacks with SPS12.

I have already read 4! different documentations with different explanations how to configure the transport route.

Anyway we did it like this:

DEV -


SAP----


> /SAP/ -


> PROD


JAVA------\

-


ABAP----


> /CUST/ ---

Does anybody know this issue?

Thanks in advance & Best regards 😆

Accepted Solutions (0)

Answers (2)

Answers (2)

ulrich_auer
Employee
Employee
0 Kudos

Let me document the solution for the public.

The problem was caused by a FILE object which was attached to a transport request with application type == 'FS'. However, deployment of FILEs with application type 'FS' (File System deployment) is not supported in SPS12, but it will work as of SPS13.

Former Member
0 Kudos

Well this is just a second issue we're still working on. The problem, that the import was not triggered correctly was caused by invalid entries in TRBATS.

Best Regards

Paul Baade

ulrich_auer
Employee
Employee
0 Kudos

Hello Paul,

I doubt that your problem - deployment doesn't finish - is related with transport routes. A first hint to the caused is probably contained in the SLOG file ($transdir)/log/SLOGyymm.sid.

Best regards, Uli Auer

NW Software Logistics Development @ SAP

Former Member
0 Kudos

Hello Ulrich,

you're correct, the LOG says:

WARNING: (This warning is harmless if no further warnings follow.)

WARNING: System FE6. Warning. 20071209212619 :

WARNING: Background job RDDIMPDP could not be started or terminated abnormally.

Please check that the R/3 system is running.

Please check the system. Use transactions SM21, SM37, SM50.

I just mentioned the transport routes because I was not sure whether they are right.

The mentioned transactions do not help me. I cannot find the reason why it broke down.

ulrich_auer
Employee
Employee
0 Kudos

RDDIMPDP is an ABAP programm which is triggered by the transport control program tp ("import dispatcher"). Thsi probgram must be scheduled as backgrund job.

The mentioned transactions a useful to find out why RDDIMPDP is not running:

SM37 is the monitoring transaction for the ABAP background processing.

SM21 is the system log viewer

SM50 displays the system's work processes

Please have a look at <a href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bc_cts/~form/handler">OSS note 71353</a> , it contains some more details.

Former Member
0 Kudos

The program runs, but it finishes quite quickly. The following message appears in the log:

Datum Uhrzeit Nachrichtentext

03.12.2007 08:57:08 Job wurde gestartet

03.12.2007 08:57:08 Step 001 gestartet (Programm RDDIMPDP, Variante , Benutzername DDIC)

03.12.2007 08:57:08 Programm RDDIMPDP läuft im Mandanten 000

03.12.2007 08:57:08 Header T: Job 08570601 läuft noch laut TRBAT, Jobstatus wird geprüft ...

03.12.2007 08:57:08 Header T: Job 08570601 ist bereits beendet

03.12.2007 08:57:08 Header T: Jobkennung aus TRJOB gelöscht

03.12.2007 08:57:08 Header T: Return-Code auf Beendet gesetzt

03.12.2007 08:57:08 Header Q: Jobkennung 08570800 in TRJOB eingetragen

03.12.2007 08:57:08 Header Q: Job gestartet

03.12.2007 08:57:08 Job wurde beendet

ulrich_auer
Employee
Employee
0 Kudos

RDDIMPDP is only a dispatcher (anyway - your reply proves at least that RDDIMPDP is properly scheduled).

Please have a look at the batch jobs called RDDEPLOY. They are submited by RDDIMPDP, these are the jobs where the deploy service is triggered from. It seems that the RDDEPLOY jobs are correctly submitted, but for some reason they do not end regularly.

Former Member
0 Kudos

Thank you very much for your help! I'm really happy to get help here 😃

But the Log of RDDEPLOY looks quite normal:

Datum Uhrzeit Nachrichtentext

03.12.2007 08:57:01 Job wurde gestartet

03.12.2007 08:57:01 Step 001 gestartet (Programm RDDEPLOY, Variante &0000000035620, Benutzername DDIC)

03.12.2007 08:57:01 Alle DB-Puffer des Applikationsservers by-sap-FE6 wurden synchronisiert

03.12.2007 08:57:01 Transportstep T: Hintergrundjob RDDEPLOY wurde korrekt beendet

03.12.2007 08:57:01 Job wurde beendet

ulrich_auer
Employee
Employee
0 Kudos

Hello Paul,

can you please have a look into the deployment log? It is located in $(transportdirectory)/log or $(transportdirectory)/log/<tarsid>, and it's name is <srcsid>Tnnnnnn.<tarsid> where srcsid is the source system ID, tarsid is the target system id, and nnnnnn is the transport request number. Example:

/usr/sap/trans/log/DEV<b>T</b>900123.PRD

From what I understand so far, your problem is not that the import hangs, it is rather that the import finishes without performing the deployment. Right?

Best regards, Uli

Former Member
0 Kudos

Hello Ulrich,

thank you again. You're correct: Deployment does not take place and therefore the transport status is not set correctly:

The Log you described tells me:

1 ETP199X######################################

1 ETP184 CREATE VERSIONS BEFORE IMPORT

1 ETP101 transport order : "B5QK900758"

1 ETP102 system : "FE6"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.08" "700"

1 ETP198

3 ESB158XVersion management: Make backup versions before importing from "B5QK900758"

4 ESB176 "FILE" "4753B6D6B64701F5000000000ABE744E" No version made, object does not exist or no version can be made

3 ESB159XVersion management: Backup versions made

1 ETP184 CREATE VERSIONS BEFORE IMPORT

1 ETP110 end date and time : "20071203085702"

1 ETP111 exit code : "0"

Thanks in advance & Best Regards

Paul Baade

ulrich_auer
Employee
Employee
0 Kudos

Hello Paul,

this was the wrong file, it's the content of B5Q<b>W</b>900758.FE6. But I need the content of B5Q<b>T</b>900758.FE6.

Best regards, Uli

Former Member
0 Kudos

Hello Ulrich,

there is no file called B5QT900758.FE6. Instead i have the following files:

<b>B5QI900758.FE6:</b>

1 ETP199X######################################

1 ETP154 MAIN IMPORT

1 ETP101 transport order : "B5QK900758"

1 ETP102 system : "FE6"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.08" "700"

1 ETP198

4 ETW000 R3trans version 6.14 (release 700 - 17.10.07 - 17:33:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 03.12.2007 - 08:57:04

4 ETW000 control file: /usr/sap/FE6/trans/tmp/B5QKK900758.FE6

4 ETW000 > #pid 1265882 on ab3e (fe6adm)

4 ETW000 > import

4 ETW000 > buffersync=yes

4 ETW000 > file='/usr/sap/FE6/trans/data/R900758.B5Q'

4 ETW000 > continuation='/usr/sap/FE6/trans/data/R900758_#.B5Q'

4 ETW000 > client=400

4 ETW000 > recclient="ALL"

4 ETW000 > excluding 'R3TRDDDD','R3TRDOMA','R3TRDTEL','R3TRENQU','R3TRMACO','R3TRMCID','R3TRMCOB','R3TRSHLP','R3TRSQLT','R3TRTABL','R3TRTTYP','R3TRUENO','R3TRVIEW'

4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/FE6/trans/tmp/B5QI900758.FE6 /usr/sap/FE6/trans/tmp/B5QKK900758.FE6

4 ETW000 table logging turned on 'ALL'

4 ETW000 Connected to DBMS = ORACLE dbs_ora_tnsname = 'FE6' SYSTEM = 'FE6'.

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 : 03.12.2007 - 08:57:05

4 ETW000 function : IMPORT

4 ETW000 data file : /usr/sap/FE6/trans/data/R900758.B5Q

4 ETW000 Continuation : /usr/sap/FE6/trans/data/R900758_#.B5Q

4 ETW000 buffersync : YES

4 ETW000 client : 400

4 ETW000 repeatimport : NO

4 ETW000 repeatclimport : NO

4 ETW000 c.s.i. : NO

4 ETW000 recclient : ALL

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 Character set on this machine : 2 byte unicode big endian.

4 ETW000 Character set on the data file: ASCII (ISO 8859-1).

4 ETW000 Data file is compressed with algorithm 'L'.

4 ETW000 Export was executed on 03.12.2007 at 08:55:54 by b5qadm

3 ETW709 "700 "

4 ETW000 with R3trans version: 17.10.07 - 17:33:00

4 ETW000 Source System = IBM RS/6000 with AIX on DBMS = ORACLE dbs_ora_tnsname = 'B5Q' SYSTEM = 'B5Q'.

4 ETW000

4 ETW000 language vector during export: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz(),./:;&

4 ETW000 lsm during export: VECTOR

4 ETW000 texts in language i will be converted with codepage 1100

4 ETW000 texts in language c will be converted with codepage 1100

4 ETW000 texts in language b will be converted with codepage 1100

4 ETW000 texts in language a will be converted with codepage 1100

4 ETW000 texts in language 7 will be converted with codepage 1100

4 ETW000 texts in language V will be converted with codepage 1100

4 ETW000 texts in language U will be converted with codepage 1100

4 ETW000 texts in language S will be converted with codepage 1100

4 ETW000 texts in language P will be converted with codepage 1100

4 ETW000 texts in language O will be converted with codepage 1100

4 ETW000 texts in language N will be converted with codepage 1100

4 ETW000 texts in language K will be converted with codepage 1100

4 ETW000 texts in language I will be converted with codepage 1100

4 ETW000 texts in language F will be converted with codepage 1100

4 ETW000 texts in language E will be converted with codepage 1100

4 ETW000 texts in language D will be converted with codepage 1100

4 ETW000 trfunction = K (transport to consolidation system)

4 ETW000 Used Commandfile B5QK900758 (WDBAP/1)

4 ETW000 Target client in E070C updated (400)

4 ETW000 ... ignoring such differences.

4 ETW000 0 entries for E070 imported (B5QK900758).

4 ETW000 ... ignoring such differences.

4 ETW000 0 entries for E071 imported (B5QK900758 *).

4 ETW000 ... ignoring such differences.

4 ETW000 ... ignoring such differences.

4 ETW000 ... ignoring such differences.

4 ETW000 ... ignoring such differences.

3 ETW674Xstart import of "R3TRFILE4753B6D6B64701F5000000000ABE744E" ...

4 ETW690 COMMIT "52" "52"

4 ETW000 ... ignoring such differences.

4 ETW000 1 entry for SI_RQ_CONTENT inserted (4753B6D6B64701F5000000000ABE744E).

4 ETW000 option 'filedirectory' not specified => using directory '/usr/sap/FE6/trans/data/B5QK900758/'

4 ETW000 option 'filedirectory' not specified => using directory '/usr/sap/FE6/trans/data/B5QK900758/'

4 ETW000 file '/usr/sap/FE6/trans/data/B5QK900758/tchiboBOHNENFDI_Jacobs_C~20071015081246.sca' exists already - it's not necessary to extract it again

4 ETW000 different nametabs for table SI_RQ_FILECNTRL (field ATTRIBUTE_NAME).

4 ETW000 Existing Field Imported Field

4 ETW000 keypart: ' ' ' '

4 ETW000 format : 'C' 'C'

4 ETW000 len : 020 005 (chars)

4 ETW000 offset : 034 009 (chars)

4 ETW000 different nametabs for table SI_RQ_FILECNTRL (field ATTRIBUTE_VALUE).

4 ETW000 Existing Field Imported Field

4 ETW000 keypart: ' ' ' '

4 ETW000 format : 'C' 'C'

4 ETW000 len : 250 062 (chars)

4 ETW000 offset : 054 014 (chars)

4 ETW000 table SI_RQ_FILECNTRL: entry in DB is 300 bytes bigger than in file.

4 ETW000 ... ignoring such differences.

4 ETW000 0 d / 3 i / 0 u / 0 = 0% ucf SI_RQ_FILECNTRL

4 ETW000 3 entries for SI_RQ_FILECNTRL imported (4753B6D6B64701F5000000000ABE744E*).

4 ETW675 end import of "R3TRFILE4753B6D6B64701F5000000000ABE744E".

4 ETW000 E071-LOCKFLAGs 000001 - 000001 updated ('2', 1 entries).

4 ETW000 B5QK900758 touched.

4 ETW000 0 tables in P-buffer synchronized.

4 ETW000 0 tables in R-buffer synchronized.

4 ETW690 COMMIT "2772" "2824"

4 ETW000 18843 bytes read.

4 ETW000 Transport overhead 25.6 %.

4 ETW000 Data compressed to 65.2 %.

4 ETW000 Duration: 0 sec (18843 bytes/sec).

3 ETW710 "1" "0"

4 ETW000

4 ETW000 Summary:

4 ETW000

4 ETW000 Totally 4 tabentries imported.

4 ETW000 2824 bytes modified in database.

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 630699 0.630699

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 130 0.630829

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x110fbedd8,usrhp=0x110fbe1e0)

4 ETW000 1884 0.632713

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x110fbedd8,srvhp=0x110fd0b98)

4 ETW000 1813 0.634526

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 713 0.635239

4 ETW000 [dev trc ,00000] Disconnected from connection 0 57 0.635296

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=3, com_tx=3)

4 ETW000 75 0.635371

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 77 0.635448

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 03.12.2007 - 08:57:05

then I have a <b>B5QL900758.FE6</b> that looks just like the B5QI900758.FE6.

And a <b>B5QV900758.FE6</b> which I posted before.

Former Member
0 Kudos

Hi @All.

This problem is solved. In the table TRBATS was an obsolete entry. When no transport runs, the table should be empty.

After cleaning up TRBATS with se16 the import works.

Thanks again Ulrich you took me to the right track, but in the end a SAP OSS helped me.