after configuring SSFS on ABAP server, our JAVA server wont start

[Former Member]

Hi everyone, we are curently going through the 74 upgrade process.

We started with one dual stack server TBW running NW 7.21.

We ran the split stack tool and now have 2 servers - TBW (ABAP) and TBJ

(JAVA).

Using SUM we upgraded TBJ to NW 7.4 and it everything was OK with this JAVA server after the upgrade.

We then moved on to ABAP server TBW.

During the upgrade SUM told us we had to use SSFS.

We configured this on TBW and the ABAP server is now using SSFS and

running NW 7.21.   So all is currently OK with the ABAP server.

But this seems to have an effect on our JAVA server - it is no longer

working, or starting.

R3trans shows :

This is R3trans version 6.25 (release 742 - 11.02.15 - 14:06:42).

unicode enabled version

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

R3trans finished (0012).

How does SSFS on our ABAP server effect our JAVA server and how can I

get JAVA to start again

Thanks so much

[former_member182657]

Hi Terry,

after configuring SSFS on ABAP server, our JAVA server wont start

As per trans.log you supplied i don't think your ABAP instance is using SSFS database connection method.You could find as

4 ETW000  [

dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used

28  0.001538

And as per me still ABAP instance is using OPS$ mechanism .So i suggest try to recheck with SSFS configuration & the parameter

rsdb ssfs_connect=1

If still persists issue re-share the trans.log .

Hope this will help you.

Regards,

[former_member204080]

HI,

R3trans -d will not work for Java Instance .It will always give RC12

Could you please share server0/1 logs for java instance

Have you changed SAPSR3DB user password ,if yes please update same in config tool

Regards,

Murali

[former_member185954]

Also,

Have you setup SSFS correctly as per

https://service.sap.com/sap/support/notes/1639578

Your R3trans -d shouldn't fail, it it is failing that would mean that the environment variables for the <sid>adm users aren't pointing to the correct location of the secure key.

Regards,

Siddhesh

[Former Member]

Hi

SSFS is only configured on the ABAP server - and it is working. There are no issues on the ABAP server.

I did not change any configuration on the JAVA server  - i agree with earlier post that SSFS isnt used for JAVA servers. I will look in config tool

[Former Member]

Terry,

4 ETW000  [dbsloci.c   ,00000]  *** ERROR => Connect via SAPUSER not supported for kernel >= 740.

4196  0.056983

The above is a information/warning even though the text contains the word "ERROR". In any case, as has been pointed out, the J2EE doesn't use that mechanism.

The R3trans -d on the J2EE is always going to fail with a RC=12.

Look in the traces/logs of your log and work to see why the J2EE isn't coming up.

/usr/sap/TBJ/Jxx/work/std_server0.out

/usr/sap/TBJ/Jxx/j2ee/cluster/server0/log/defaultTrace_00.0.trc (or whatever the current file is)

Also check J2EE_ADMIN/SAPJSF on your ABAP stack as I assume your UME is still pointing there.

Cheers,

Amerjit

[former_member185954]

Hello Terry,

SSFS was meant to replace OPS$ mechanism on oracle, AS Java doesn't use this mechanism to login, its credentials are already stored in secure storage.

Use the configtool to check if JAVA can connect to secure storage.

Check the following link:

http://help.sap.com/saphelp_nw73/helpdata/en/47/af5753fa711503e10000000a42189c/content.htm

I suspect that the kernel upgrade that you performed knocked off some directory permissions for /global/security/data etc.

Regards,

Siddhesh

[Former Member]

Hi Terry,

Please provide the entire trans.log to analyze.

Regards,

Raja. G

[Former Member]

Thanks Raja for getting back. Please find below trans.log :

4 ETW000 R3trans version 6.25 (release 742 - 11.02.15 - 14:06:42).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 02.04.2015 - 13:41:45

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]  Thu Apr  2 13:41:45 2015                                                1487  0.001487

4 ETW000  [     dev trc,00000]  db_con_init called                                                        23  0.001510

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        28  0.001538

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

4 ETW000                                                                                                  17  0.001555

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

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/TBJ/SYS/exe/run/dboraslib.so' ...            38  0.001603

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

4 ETW000                                                                                               23221  0.024824

4 ETW000  [     dev trc,00000]  Library '/usr/sap/TBJ/SYS/exe/run/dboraslib.so' loaded                    17  0.024841

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

4 ETW000                                                                                                  19  0.024860

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

4 ETW000                                                                                                 214  0.025074

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

4 ETW000                                                                                                  17  0.025091

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

4 ETW000                                                                                                  60  0.025151

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

4 ETW000                                                                                                  17  0.025168

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

4 ETW000                                                                                                  29  0.025197

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

4 ETW000                                                                                                  18  0.025215

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

4 ETW000                                                                                                  17  0.025232

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

4 ETW000                                                                                                 146  0.025378

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

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

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  11  0.025442

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = NO , info = NO , timeout = 000, con_max = 25

5, con_opt = 255, occ = NO , prog =

4 ETW000                                                                                                1609  0.027051

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

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

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

4 ETW000                                                                                                  17  0.027464

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          39  0.027503

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

, con_opt = 255, occ = NO , prog =

4 ETW000                                                                                                  21  0.027524

4 ETW000  [     dev trc,00000]  -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='742')

4 ETW000                                                                                                  78  0.027602

4 ETW000  [     dev trc,00000]  Substitution of aliases T_mn (m,n=0...9) in SQL hints enabled.          4554  0.032156

4 ETW000  [     dev trc,00000]  Register application info.                                              4443  0.036599

4 ETW000  [     dev trc,00000]  Oracle client version: 11.2.0.3.0, V2, default build, (dbsl 742 150115, UNICODE[2])

4 ETW000                                                                                               15862  0.052461

4 ETW000  [     dev trc,00000]  Installed Oracle client patches:                                         102  0.052563

4 ETW000  [     dev trc,00000]  # Patch  14489591     : Created on 19 Jan 2013, 19:47:47 hrs PST8PDT

4 ETW000                                                                                                  21  0.052584

4 ETW000  [     dev trc,00000]  # Patch  14042380     : Created on  3 Jan 2014, 11:08:00 hrs PST8PDT

4 ETW000                                                                                                  22  0.052606

4 ETW000  [     dev trc,00000]  # Patch description: Created on  7 Jan 2014, 04:32:31 hrs PST8PDT         21  0.052627

4 ETW000  [     dev trc,00000]  # Patch  13508485     : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT

4 ETW000                                                                                                 144  0.052771

4 ETW000  [     dev trc,00000]  # Patch  11742262     : Created on  7 Mar 2012, 12:22:41 hrs CET          16  0.052787

4 ETW000  [dbsloci.c   ,00000]  *** ERROR => Connect via SAPUSER not supported for kernel >= 740.       4196  0.056983

4 ETW000  [     dev trc,00000]     Only Secure Connect method possible.                                   32  0.057015

4 ETW000  [     dev trc,00000]     DbSlConnect(con=-1) -> orc=0, rc=15=DBSL_ERR_UNSUPPORTED               33  0.057048

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

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

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

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

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

4 ETW000  [     dev trc,00000]                 -> 'OCI_112, 11.2.0.3.0, V2, default build'                19  0.059323

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

[former_member207186]

Hi,

Regarding this "ERROR=>Connect via SAPUSER not supported...", you can check below SAP Notes:

1904826 - "Upgrade error "Connect via SAPUSER not supported for kernel >= 740"

1860519 - "SAP fails to connect to the database"

Regards,

Bíborka