SAP transport request release at database level

[Former Member]

Hi,

Is there any way to release transport request from database (oracle10g) level? if so please let me know how to release.

Thanks,

Suraj

[JPReyes]

Why would you do that?...

Regards

Juan

[Former Member]

Hi,

Thanks for the reply.

We are not to login to SAP and we dont have latest backup availble. We have some impartant data which are in the form of change requests and these requests are not released in the system. We are looking to copy the data in the request to other similar SAP system.

We are trying to release request from database level not for OS.

Please suggest any solution for this scenario.

Thanks,

Suraj

[Former Member]

Hello,

If I understand correctly the database is not up? Please correct me if wrong. If not so why are we talking about back ups ?

Anyways this is not possible as far as I know. A transport release can be done using SE01/SE09/SE10 only. On release it would create data files and co files at OS level (provided it has a target system).

Anyways still try this out:

tp export <Transport Number> clientxxx pf=<Transport profile full path>

For this use <sid>adm.

Regards.

Ruchit.

[Former Member]

Of course "tp export" is an OS level function and not database level.

Regards.

Ruchit.

[Former Member]

Hi Ruchit,

The database is up and running. the only problem is unable to login to SAP(ECC6 EHP3). I am getting RC0 with r3trans -d command.

We have tried with suggested option but no luck.

Thanks,

Suraj

[Former Member]

Hello Suraj,

Then you must try to get that fixed first. Do a r3trans -x and post the contents of trans.log.

Regards.

Ruchit.

[JPReyes]

Any particular reason to not been able to logon to the system???... seems like you have a consistent DB. If your filesystem is corrupted... simply do a DB offline backup, reinstall SAP and restore the DB. (If viable)

Regards

Juan

[Former Member]

Hi Juan,

I am getting "Syntax error in program SAPLSFES" message while connection SAP. We are not applying any patches in the system.

4 ETW000 r3trans version 6.14 (release 700 - 28.07.08 - 15:52:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 21.12.2009 - 19:04:30

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Dec 21 19:04:34 2009 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 8319 0.008319

4 ETW000 [dev trc ,00000] using "F:\usr\sap\EHT\SYS\exe\uc\NTAMD64\dboraslib.dll"

4 ETW000 29 0.008348

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 11 0.008359

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 23 0.008382

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.167)

4 ETW000 192 0.008574

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 20 0.008594

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 31 0.008625

4 ETW000 [dev trc ,00000] New connection 0 created 21 0.008646

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 33 0.008679

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 21 0.008700

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 19 0.008719

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 25 0.008744

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 284 0.009028

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 8187 0.017215

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 25 0.017240

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 3295 0.020535

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPEHT's password 21 0.020556

4 ETW000 [dev trc ,00000] Connecting as /@EHT on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 27 0.020583

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 25 0.020608

4 ETW000 [dev trc ,00000] 0 UTF8 1 00000000095FF090 00000000003137D0 0000000000318F98

4 ETW000 79 0.020687

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 23 0.020710

4 ETW000 [dev trc ,00000] Allocating server context handle 17 0.020727

4 ETW000 [dev trc ,00000] Attaching to DB Server EHT (con_hdl=0,svchp=0000000000318E58,srvhp=000000000961E0E8)

4 ETW000 47 0.020774

4 ETW000 [dev trc ,00000] Assigning server context 000000000961E0E8 to service context 0000000000318E58

4 ETW000 129270 0.150044

4 ETW000 [dev trc ,00000] Allocating user session handle 38 0.150082

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000000318E58,srvhp=000000000961E0E8,usrhp=0000000000313FE8)

4 ETW000 34 0.150116

4 ETW000 [dev trc ,00000] Assigning user session 0000000000313FE8 to service context 0000000000318E58

4 ETW000 58027 0.208143

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0000000009627A28)

4 ETW000 42 0.208185

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 24 0.208209

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0000000009628A80)

4 ETW000 87 0.208296

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 22 0.208318

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0000000009628A80)

4 ETW000 510 0.208828

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 23 0.208851

4 ETW000 [dev trc ,00000] Connected to session 57. 350 0.209201

4 ETW000 [dev trc ,00000] Now '/@EHT' is connected: con_hdl=0, nls_hdl=0, session_id=57.

4 ETW000 23 0.209224

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0000000009628A80)

4 ETW000 24 0.209248

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 23 0.209271

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0000000009628A80)

4 ETW000 385 0.209656

4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 23 0.209679

4 ETW000 [dev trc ,00000] Got SAPEHT's password from OPS$-user 502 0.210181

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 18 0.210199

4 ETW000 [dev trc ,00000] Rolling back transaction ... 75 0.210274

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0000000000318E58,usrhp=0000000000313FE8)

4 ETW000 191 0.210465

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 341 0.210806

4 ETW000 [dev trc ,00000] Connecting as SAPEHT/<pwd>@EHT on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 24 0.210830

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 23 0.210853

4 ETW000 [dev trc ,00000] 0 UTF8 1 00000000095FF090 00000000003137D0 0000000000318F98

Thanks,

Suraj

[Former Member]

4 ETW000 26 0.210879

4 ETW000 [dev trc ,00000] Assigning username to user session 0000000000313FE8

4 ETW000 18 0.210897

4 ETW000 [dev trc ,00000] Assigning password to user session 0000000000313FE8

4 ETW000 28 0.210925

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000000318E58,srvhp=000000000961E0E8,usrhp=0000000000313FE8)

4 ETW000 27 0.210952

4 ETW000 [dev trc ,00000] Assigning user session 0000000000313FE8 to service context 0000000000318E58

4 ETW000 5086 0.216038

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0000000009627308)

4 ETW000 30 0.216068

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 24 0.216092

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0000000009627A28)

4 ETW000 42 0.216134

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 23 0.216157

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0000000009627A28)

4 ETW000 399 0.216556

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 24 0.216580

4 ETW000 [dev trc ,00000] Connected to session 57. 294 0.216874

4 ETW000 [dev trc ,00000] Now 'SAPEHT/<pwd>@EHT' is connected: con_hdl=0, nls_hdl=0, session_id=57.

4 ETW000 23 0.216897

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0000000009627A28)

4 ETW000 25 0.216922

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 22 0.216944

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0000000009627A28)

4 ETW000 376 0.217320

4 ETW000 [dev trc ,00000] SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET') ORDER BY PARAM

4 ETW000 23 0.217343

4 ETW000 [dev trc ,00000] ETER

4 ETW000 22 0.217365

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.UTF8 298 0.217663

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0000000009627A28)

4 ETW000 208 0.217871

4 ETW000 [dev trc ,00000] SELECT UPPER(INSTANCE_NAME),HOST_NAME,VERSION,TO_CHAR(STARTUP_TIME,'MON DD, YYYY, HH24:MI:SS') FROM V$INSTANCE

4 ETW000 23 0.217894

4 ETW000 [dev trc ,00000] DB instance EHT is running on IGINSAP1 with ORACLE version 10.2.0.1.0 since DEC 17, 2009, 21:17:46

4 ETW000 372 0.218266

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0000000009627A28)

4 ETW000 26 0.218292

4 ETW000 [dev trc ,00000] SELECT SUBSTR(NAME,1,3), TO_CHAR(CREATED,'YYYYMMDDHHMMSS') FROM V$DATABASE

4 ETW000 22 0.218314

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 44798 0.263112

4 ETW000 [dev trc ,00000] build_stmt: reallocating stmt buffer: 256 -> 2000 characters

4 ETW000 5742 0.268854

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=26, stmth_p=0000000009627A28)

4 ETW000 45 0.268899

4 ETW000 [dev trc ,00000] SELECT VERSION FROM SVERS

4 ETW000 23 0.268922

4 ETW000 [dev trc ,00000] DbSlRead(): table='SVERS' 28 0.268950

4 ETW000 Connected to database.

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 366 0.269316

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 20 0.269336

4 ETW000 [dev trc ,00000] Rolling back transaction ... 19 0.269355

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0000000000318E58,usrhp=0000000000313FE8)

4 ETW000 172 0.269527

4 ETW000 [dev trc ,00000] Deallocating user session handle 364 0.269891

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=000000000961E0E8)

4 ETW000 28 0.269919

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0000000000318E58,srvhp=000000000961E0E8)

4 ETW000 22 0.269941

4 ETW000 [dev trc ,00000] Deallocating server context handle 000000000961E0E8

4 ETW000 343 0.270284

4 ETW000 [dev trc ,00000] Deallocating service context 0000000000318E58 77 0.270361

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 17 0.270378

4 ETW000 [dev trc ,00000] Disconnected from connection 0 12 0.270390

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

4 ETW000 19 0.270409

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

4 ETW000 19 0.270428

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 21.12.2009 - 19:04:34

[Former Member]

Hello Suraj,

Can also please post the last few lines of dev_disp,dev_ms and dev_w0 separately. Meanwhile we can analyze trans.log in detail.

Also was there any system copy done on this system. I don't think coz this sounds like your development box but still wanted to confirm.

Also has this problem occured randomly or occured after some major activity/change to the system?

Regards.

Ruchit.

[Former Member]

Better stil don't post dev_ms,dev_disp and dev_w0 straightaway. Try to start SAP and then send the startup logs in case it is not started.

Did not check your earlier comment than r3trans -d RC=0. I thought it was a non zero code.

Regards.

Ruchit.

[JPReyes]

"Syntax error in program SAPLSFES"

Did you check the logs.... there has been cases that modification to the registry settings can cause this issue... check for issues with the services file. I presume you have tried to logon from a different terminal...

Also open an OSS message for this issue to SAP.

Regards

Juan

[Former Member]

Hi Juan Reyes ,

Thanks for your quick responce appriciate if you can suggest us further.

We already raised message to SAP and waiting for their response. I checked work directory and event logs but did't find any clue.

Can you please suggest the procedure to repair the regestry settings.

Thanks ,

Suraj

[JPReyes]

Well... just put it this way... if its a problem with the registry on the end user PC then you will have no trouble login from another terminal. Is that the case?... Have you looked for issues on the event log of the PC (Not the server)?

Regards

Juan

[Former Member]

Hello Suraj,

Is it database level or operating system?

Regards.

Ruchit.

[Former Member]

For that matter I don't think it is possible to do any release at OS level either

Is this an interview trick question ?

Regards.

Ruchit.