Solved: Ehp7 implemnt error in phase PREP_EXTRACT/PREIMP

Dear Team,

When I am implemnting Ehp7 During extraction Phase , It stuck in below screen

Please find the attach log of R710VPE.QAS

Regards

SAP Managed Tags:
Software Logistics

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi,

Could you upgrade kernel 720 with 720_EXT and recheck SSFS connection again.

Regards,

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Answers (4)

Hi Pooja,

As i replied earlier first you need to configure SSFS database connection properly for the source kernel as well,for that you could refer earlier mentioned SCN doc and can refer SAP Notes 1622837 - Secure connection of AS ABAP to Oracle via SSFS

2097613 - Database is running with inconsistent Secure Storage File System (SSFS)

1905775 - SSFS connection is not working

Hope this will help you.

Regards,

Gaurav Rana

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Supply the output of these commands.

su - qasadm

/usr/sap/trans/ehp7/SUM/abap/exe/tp -v

/usr/sap/trans/ehp7/SUM/abap/exe/R3trans -v

/oracle/client/11x_64/instantclient/genezi -v

R3trans -d

cat trans.log

4 ETW000  [dbcon.c     ,00000]  *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read


sapqas:qasadm 61> cd data
sapqas:qasadm 62> ll
total 32
-rwxrwxrwx   1 qasadm     sapsys          29 Dec 27 20:39 JUpgrade.key
-rwxrwxrwx   1 qasadm     sapsys         195 Dec 27 20:39 JUpgrade.properties

The file /usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT is not present at that location then there is no point in providing the full permission.

Thanks

Message was edited by: Reagan Benjamin

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear Reagan,

I have check all below log.

sapqas:qasadm 21>

sapqas:qasadm 21> cd /usr/sap/trans/ehp7/SUM/abap/exe/

sapqas:qasadm 22> tp -v

This is tp version 380.10.20 (release 720, unicode enabled)

--------------------

tp information

--------------------

kernel release 720

kernel make variant 720_REL

DBMS client library OCI_102,

DBSL shared library version 720.00

compiled on HP-UX B.11.23 U ia64 for hpia64

compiled for 64 BIT

compilation mode UNICODE

compile time Mar 9 2014 21:13:22

update level 0

patch number 526

source id 0.600

sapqas:qasadm 23> R3trans -v

This is R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).

unicode enabled version

--------------------

R3trans information

--------------------

kernel release 720

kernel make variant 720_REL

DBMS client library OCI_102,

DBSL shared library version 720.00

compiled on HP-UX B.11.23 U ia64 for hpia64

compiled for 64 BIT

compilation mode UNICODE

compile time Mar 9 2014 21:13:22

update level 0

patch number 525

sapqas:qasadm 24> cd /oracle/client/11x*

sapqas:qasadm 28> genezi -v

Client Shared Library 64-bit - 11.2.0.3.0

System name: HP-UX

Release: B.11.31

Version: U

Machine: ia64

Operating in Instant Client mode.

Small timezone file = timezone_14.dat

Large timezone file = timezlrg_14.dat

sapqas:qasadm 29>

sapqas:qasadm 38> pwd

/sapmnt/QAS/global/security/data

sapqas:qasadm 39> ll

total 64

-rwxrwxrwx 1 qasadm sapsys 29 Dec 27 20:39 JUpgrade.key

-rwxrwxrwx 1 qasadm sapsys 195 Dec 27 20:39 JUpgrade.properties

-rw-rw-rw- 1 qasadm sapsys 8854 Dec 29 16:01 trans.log

sapqas:qasadm 40>

But in this SSFS_QAS.DAT file does not exist in /sapmnt/QAS/global/security/data

and i have give full permission on /sapmnt/QAS/global/security/data.

Regards

Hi Pooja,

You need to run the below command

rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD *****

With Regards

Ashutosh Chaturvedi

Dear Pooja,

as already said by Gaurav Kumar Pandey you need the kernel version 740/741/742 in the upgrade directory if you would like to go to EHP7.

Please check which kernel is valid according to note #1969546 (Release Roadmap Kernel 740) and switch the kernel. Afterwards please repeat the upgrade.

Cheers,
Andreas

Your commands are wrong and they are not executed in the way I suggested you.

There is a difference in the way I asked you and the way you are executing it.

Andreas - The commands are not run in the way it should be executed so it is not confirming the kernel used by the shadow system is based on 740/741 release or not.

If the file SSFS_QAS.DAT is missing then the SSFS is not set correctly. First set the SSFS correctly.

Hello Pooja,

You used commands :

sapqas:qasadm 21> cd /usr/sap/trans/ehp7/SUM/abap/exe/

sapqas:qasadm 22> tp -v

#### if the path is not set properly them it might still pick the tp from main instance directory only.

Can you use :

sapqas:qasadm 21> /usr/sap/trans/ehp7/SUM/abap/exe/tp -v

sapqas:qasadm 21> cd /usr/sap/trans/ehp7/SUM/abap/exe/tp -v

sapqas:qasadm 22> ./tp -v

Regards,
Gaurav

you are right. missed it.

Dear gaurav,

Its tp version

sapqas:qasadm 24> cd /usr/sap/trans/ehp7/SUM/abap/exe/

sapqas:qasadm 25> tp -v

This is tp version 380.10.20 (release 720, unicode enabled)

--------------------

tp information

--------------------

kernel release 720

kernel make variant 720_REL

DBMS client library OCI_102,

DBSL shared library version 720.00

compiled on HP-UX B.11.23 U ia64 for hpia64

compiled for 64 BIT

Regards

Dear Adreas,

I done below activity for Secure Storage File System

Create new directories with qasadm

cd /usr/sap/SID/SYS/global

mkdir /usr/sap/SID/SYS/global/security

mkdir /usr/sap/SID/SYS/global/security/rsecssfs

mkdir /usr/sap/SID/SYS/global/security/rsecssfs/data

mkdir /usr/sap/SID/SYS/global/security/rsecssfs/key

Set authorizations on directories with qasadm

cd /usr/sap/SID/SYS/global

chmod 700 security

chmod 700 security/rsecssfs

chmod 700 security/rsecssfs/data

chmod 700 security/rsecssfs/key

Set Default profile parameters via OS Level RZ10

In the default profile, add following parameter:

rsec/ssfs_datapath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)data

rsec/ssfs_keypath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)key

rsdb/ssfs_connect = 1

Set environment Variables in these two file /home/qasadm>

.sapenv.sh and .sapenv.csh

vi .sapenv.sh

At the end of the file add lines :

export RSEC_SSFS_DATAPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data

export RSEC_SSFS_KEYPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key

rsdb_ssfs_connect=1

vi .sapenv.csh

At the end of the file add lines :

setenv RSEC_SSFS_DATAPATH /usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data

setenv RSEC_SSFS_KEYPATH /usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key

setenv rsdb_ssfs_connect 1

sapqas:qasadm 65> rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain

SAP-Profile is not used; in this case, all three environment parameters SAPSYSTEMNAME, RSEC_SSFS_DATAPATH and RSEC_SSFS_KEYPATH must exist and have non-initial values

sapqas:qasadm 66> ll

sapqas:qasadm 71> pwd

/home/qasadm

sapqas:qasadm 72> rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD abcdefg

SAP-Profile is not used; in this case, all three environment parameters SAPSYSTEMNAME, RSEC_SSFS_DATAPATH and RSEC_SSFS_KEYPATH must exist and have non-initial values

sapqas:qasadm 73>

But my SAP is not starting . Plz find last few lines of trans log

4 ETW000 [ dev trc,00000] New connection 0 created 26 0.445108

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = N

O , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 8186 0.453294

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 7283 0.460577

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

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 33 0.460637

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 24 0.460661

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO

, frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 53 0.460714

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 25 0.460739

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0

4 ETW000 849 0.461588

4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 52 0.461640

4 ETW000 ==> connect info for default DB will be read from ssfs

4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 69 0.461709

4 ETW000 ==> Using default key set to get connect info from ssfs

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 41 0.461750

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872] 29115 0.490865

4 ETW000 [ dev trc,00000] Mon Dec 29 14:41:45 2014 71566 0.562431

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4353]

4 ETW000 37 0.562468

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read

[rsecssfs.c 2535]

4 ETW000 5923 0.568391

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/QAS/SYS/glob

al/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read) [rsecssfs.c 936]

4 ETW000 105 0.568496

4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/S

YS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read

4 ETW000 6506 0.575002

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 26 0.575028

4 ETW000 [dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS

4 ETW000 46 0.575074

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 8199 0.583273

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 94 0.583367

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 366 0.583733

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 71 0.583804

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 775 0.584579

4 ETW000 [ dev trc,00000] -> 'OCI_102, ' 353 0.584932

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"

sapqas:qasadm 23>

Regards

Dear Andreas,

Should I download these new kernel 7.41 as given below path and copy /usr/sap/trans/ehp7/

SAP KERNEL 7.41 64-BIT UNICODE -> HP-UX on IA64 64bit -> #Database independent

HP-UX on IA64 64bit

Database independent

SAPEXE_100-10012461.SAR Kernel Part I 100 Info 580086

SAP KERNEL 7.41 64-BIT UNICODE -> HP-UX on IA64 64bit -> ORACLE

SAPEXEDB_100-10012462.SAR Kernel Part 100 Info 26417

Then Our SAP Can Start.

Regards

Hi Pooja,

this depends on the support package level of the basis release of your target system.

Would you please tell us the target basis release level?

Many thanks,
Andreas

Dear Pooja,

"/usr/sap/trans/ehp7/SUM/abap/exe/" represents the target release kernel. If you switch to that directory and run "tp - v" then you will see the tp version of that tp which is maintained in your path variable first.

If you would like to have the output of a specific directory then you have to switch to it (cd /usr/sap/trans/ehp7/SUM/abap/exe/) and run the statement with a "./" before the TP call.

So it should not be "sapqas:qasadm 25> tp -v", but "sapqas:qasadm 25> ./tp -v".

Best regards,
Andreas

Dear Andreas,

Currentyly our SP Level is as given belwo

SAP_BASIS	700	0027	SAPKB70027
SAP_ABA	700	0027	SAPKA70027
PI_BASIS	2006_1_700	0017	SAPKIPYM17
ST-PI	2008_1_700	0007	SAPKITLRD7
SAP_BW	700	0029	SAPKW70029
SAP_AP	700	0028	SAPKNA7028
SAP_APPL	600	0016	SAPKH60016
SAP_HR	600	0096	SAPKE60096

Kernal Release 720 patch level 401

Regards

Hi,

happy new year.

What's the target release?

Hi Pooja,


*** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS

SSFS is fine here,now you just need to check with the permissions on the directories as well as on the SSFS files,as connection is failing on retrieve of user password from the SSFS .Kindly follow SCN doc and check your SSFS steps again.

After that retry with R3trans -d to get output 0000.

Regards,

Gaurav

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Pooja,

Error shows database connection is not successful,if possible share output for R3trans -d with trans.log file.Also try to configure SSFS database connection methods for the further processes.

Regards,

Gaurav

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear Gaurav,

When I check

sapqas:qasadm 21> R3trans -d

This is R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"

R3trans finished (0012).

sapqas:qasadm 22> pwd

sapqas:qasadm 24> more trans.log

a57y0C4 ETW000 R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 29.12.2014 - 14:41:44

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [ dev trc,00000] Mon Dec 29 14:41:44 2014 44035 0.044035

4 ETW000 [ dev trc,00000] db_con_init called 8006 0.052041

4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000 15032 0.067073

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 6029 0.073102

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

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' ... 13148 0.086274

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/QAS/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 299458 0.385732

4 ETW000 [ dev trc,00000] Library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' loaded 37 0.385769

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 84 0.385853

4 ETW000 [ dev trc,00000] Version of '/usr/sap/QAS/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.522)

4 ETW000 56555 0.442408

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 368 0.442776

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 763 0.443539

4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 936 0.444475

4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 49 0.444524

4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 49 0.444573

4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 61 0.444634

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

4 ETW000 385 0.445019

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 32 0.445051

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 31 0.445082

4 ETW000 [ dev trc,00000] New connection 0 created 26 0.445108

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = N

O , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 8186 0.453294

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 7283 0.460577

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

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 33 0.460637

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 24 0.460661

4 ETW000 [ dev trc,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO

, frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 53 0.460714

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 25 0.460739

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0

4 ETW000 849 0.461588

4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 52 0.461640

4 ETW000 ==> connect info for default DB will be read from ssfs

4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 69 0.461709

a57y0CdBtrans.log (66%)d@a57y0Ca57y0C4 ETW000 ==> Using default key set to get connect info from ssfs

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 41 0.461750

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872] 29115 0.490865

4 ETW000 [ dev trc,00000] Mon Dec 29 14:41:45 2014 71566 0.562431

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4353]

4 ETW000 37 0.562468

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read

[rsecssfs.c 2535]

4 ETW000 5923 0.568391

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/QAS/SYS/glob

al/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read) [rsecssfs.c 936]

4 ETW000 105 0.568496

4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/S

YS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read

4 ETW000 6506 0.575002

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 26 0.575028

4 ETW000 [dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS

4 ETW000 46 0.575074

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 8199 0.583273

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 94 0.583367

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 366 0.583733

4 ETW000 [ dev trc,00000] --DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 71 0.583804

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 775 0.584579

4 ETW000 [ dev trc,00000] -> 'OCI_102, ' 353 0.584932

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"

a57y0CdBtrans.log: ENDd@

Regards

Hello,

What is the version of the tp and R3trans in ../abap/exe/ directory ?

tp -v
R3trans -v

Regards,
Gaurav

Dear Gaurav,

sapqas:qasadm 30> tp -v

This is tp version 380.10.20 (release 720, unicode enabled)

--------------------

tp information

--------------------

kernel release 720

kernel make variant 720_REL

DBMS client library OCI_102,

DBSL shared library version 720.00

compiled on HP-UX B.11.23 U ia64 for hpia64

compiled for 64 BIT

compilation mode UNICODE

compile time Mar 9 2014 21:13:22

update level 0

patch number 526

source id 0.600

sapqas:qasadm 31> R3trans -v

This is R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).

unicode enabled version

--------------------

R3trans information

--------------------

kernel release 720

kernel make variant 720_REL

DBMS client library OCI_102,

DBSL shared library version 720.00

compiled on HP-UX B.11.23 U ia64 for hpia64

compiled for 64 BIT

compilation mode UNICODE

compile time Mar 9 2014 21:13:22

update level 0

patch number 525

source id 0.600

Regards

Hi Pooja,

Provide the permission on the file SSFS_QAS.DAT

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read

[rsecssfs.c 2535]

4 ETW000 5923 0.568391

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/QAS/SYS/glob

al/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read) [rsecssfs.c 936]

4 ETW000 105 0.568496

4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/S

YS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read

Then check the same with R3trans -d option again.

With Regards

Ashutosh Chaturvedi

Hello Pooja,

I would recommend to update the kernel in the ../abap/exe/ directory with latest one available on SMP. You said that you are upgrading the system to EHP7 so i believe the target kernel should be
740 or 741 or 742 based on your target SPS level.

1969546 - Release Roadmap Kernel 740

Regards,
Gaurav

Dear Ashutosh,

I have given full permission on below link

usr/sap/QAS/SYS/global/security/rsecssfs/

sapqas:qasadm 57> chmod -R 777 security

sapqas:qasadm 58> ll

total 7808

drwxrwx--- 2 qasadm sapsys 73728 Dec 29 15:33 000JOBLG

drwxrwx--- 2 qasadm sapsys 8192 Aug 7 00:30 500BDCLG

drwxrwx--- 2 qasadm sapsys 368640 Dec 29 15:55 500JOBLG

drwxrwx--- 2 qasadm sapsys 96 Dec 28 00:01 500TEST0

-rw-r--r-- 1 qasadm sapsys 0 May 11 2014 ABAPPROT

-rw-r--r-- 1 qasadm sapsys 1522848 May 17 2014 SLOGJ

-rw-r--r-- 1 qasadm sapsys 1999840 May 15 2014 SLOGJO

-rw-r--r-- 1 qasadm sapsys 272 May 11 2014 ms_acl_info

drwxr-xr-x 2 qasadm sapsys 96 Dec 23 14:56 sapcontrol

drwxrwxrwx 5 qasadm sapsys 96 Dec 23 12:31 security

sapqas:qasadm 59> cd security

sapqas:qasadm 60> ll

total 0

drwxrwxrwx 2 qasadm sapsys 96 Dec 27 20:39 data

drwxrwxrwx 3 qasadm sapsys 96 May 11 2014 lib

drwxrwxrwx 4 qasadm sapsys 96 Dec 23 12:32 rsecssfs

sapqas:qasadm 61> cd data

sapqas:qasadm 62> ll

total 32

-rwxrwxrwx 1 qasadm sapsys 29 Dec 27 20:39 JUpgrade.key

-rwxrwxrwx 1 qasadm sapsys 195 Dec 27 20:39 JUpgrade.properties

sapqas:qasadm 63> R3trans -d

This is R3trans version 6.24 (release 720 - 04.02.14 - 20:14:02 ).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"

R3trans finished (0012).

sapqas:qasadm 64>

But same error code comes.

Regards

Jagdish Kumar

Hi Jagdish,

Paste the trans.log file.

Kindly check the profile parameter

Set Profile parameters

Administrator / RZ10

****Take backup of DEFAULT.PFL****

In the default profile, add following parameter :

rsec/ssfs_datapath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)data

rsec/ssfs_keypath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)key

rsdb/ssfs_connect = 1

Environment varaible

export RSEC_SSFS_DATAPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data

export RSEC_SSFS_KEYPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key

rsdb_ssfs_connect=1

If all the above parameters are sets then rerun the below two commands

rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD *****

Also do follow the steps suggested by Former Member

With Regards

Ashutosh Chaturvedi

Dear Ashutosh,

Please find the trans log

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [ dev trc,00000] Mon Dec 29 14:41:44 2014 44035 0.044035

4 ETW000 [ dev trc,00000] db_con_init called 8006 0.052041

4 ETW000 [ dev trc,00000] set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000 15032 0.067073

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 6029 0.073102

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

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' ... 13148 0.086274

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/QAS/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 299458 0.385732

4 ETW000 [ dev trc,00000] Library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' loaded 37 0.385769

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 84 0.385853

4 ETW000 [ dev trc,00000] Version of '/usr/sap/QAS/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.522)

4 ETW000 56555 0.442408

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 368 0.442776

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 763 0.443539

4 ETW000 [ dev trc,00000] function sapic_get_instant_client_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 936 0.444475

4 ETW000 [ dev trc,00000] function sapic_get_instant_client_flavor loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 49 0.444524

4 ETW000 [ dev trc,00000] function sapic_get_patchset_version loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 49 0.444573

4 ETW000 [ dev trc,00000] function sapic_get_ls_inventory loaded from library /usr/sap/QAS/SYS/exe/run/dboraslib.so

4 ETW000 61 0.444634

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

4 ETW000 385 0.445019

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK) 32 0.445051

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 31 0.445082

4 ETW000 [ dev trc,00000] New connection 0 created 26 0.445108

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

4 ETW000 8186 0.453294

43y0CBtrans.log (48%)@43y0C43y0C4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET) 7283 0.460577

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

4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 33 0.460637

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection: 24 0.460661

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

4 ETW000 53 0.460714

4 ETW000 [ dev trc,00000] read_con_info_ssfs(): reading connect info for connection R/3 25 0.460739

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=74=DBSL_CMD_CON_INFO_EXT_SUPPORT) -> rc=0=DBSL_ERR_OK, con_vers=0

4 ETW000 849 0.461588

4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol 52 0.461640

4 ETW000 ==> connect info for default DB will be read from ssfs

4 ETW000 [ dev trc,00000] con_info_ext_support(): auth/shadow_upgrade = undefined 69 0.461709

4 ETW000 ==> Using default key set to get connect info from ssfs

4 ETW000 [ dev trc,00000] read_ssfs_record(): register callback ssfs_dbi_trace and max level 2

4 ETW000 41 0.461750

4 ETW000 [ dev trc,00000] RSecSSFs: Entering function "RSecSSFsGetRecord" [rsecssfs.c 872] 29115 0.490865

4 ETW000 [ dev trc,00000] Mon Dec 29 14:41:45 2014 71566 0.562431

4 ETW000 [ dev trc,00000] RSecSSFs: Configuration data read from environment parameters [rsecssfs.c 4353]

4 ETW000 37 0.562468

4 ETW000 [ dev trc,00000] RSecSSFs: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read [rsecssfs.c 2535]

4 ETW000 5923 0.568391

4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read) [rsecssfs.c 936]

4 ETW000 105 0.568496

4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=1 : Data file "/usr/sap/QAS/SYS/global/security/rsecssfs/data/SSFS_QAS.DAT" cannot be opened for read

4 ETW000 6506 0.575002

4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 26 0.575028

4 ETW000 [dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS

4 ETW000 46 0.575074

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET) 8199 0.583273

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET) 94 0.583367

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO) 366 0.583733

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET) 71 0.583804

4 ETW000 [ dev trc,00000] -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION) 775 0.584579

4 ETW000 [ dev trc,00000] -> 'OCI_102, ' 353 0.584932EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'"

43y0CBtrans.log: END@43y0C43y0C@sapqas:qasadm 23>

I was not able to set below parameter in Default Profile . Right now my SAP Instance is not running.

Default Profile:=

rsec/ssfs_datapath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)data

rsec/ssfs_keypath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)key

rsdb/ssfs_connect = 1

I have set below environment in .sapenv.sh

Please find last seven line of .sapenv.sh

Environment varaible in /home/qasadm>tail -7 .sapenv.sh

done

export SEC_SSFS_DATAPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data

export RSEC_SSFS_KEYPATH=/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key

rsdb_ssfs_connect=1

end SAP R/3 Environment

sapqas:qasadm>

Please suggest

Hi Pooja,

Follow the suggestion of

With Regards

Ashutosh Chaturvedi

Ask a Question

Top Q&A Solution Author

User

Count

Ehp7 implemnt error in phase PREP_EXTRACT/PREIMP

Accepted Solutions (1)

Accepted Solutions (1)

Answers (4)

Answers (4)

SAP KERNEL 7.41 64-BIT UNICODE -> HP-UX on IA64 64bit -> ORACLE

Re: SAC Header Image Insert trouble

Re: SAP CRYSTAL REPORT 2020 support ODBC DRIVER 18...

Re: Customer Engagement apps / roles within SAP S/...

SAP Analytics Cloud Optimize Story - How to reset ...

Re: Analysis for excel not showing values in maste...