cancel
Showing results for 
Search instead for 
Did you mean: 

Two sap systems in one host. ABAP ok, JAVA not start anymore.

Former Member
0 Kudos

    Hi experts.

We have a Netweaver PI 7.4 (JAVA) installed on Linux and Sybase ASE, and we did a new installation of an ABAP system on the same host.

But after the second installation,  PI does not start more.

The ports of sybase were changed, and there is directories for each system.

Any idea?

R3trans -d log:

R3trans -d

This is R3trans version 6.24 (release 740 - 23.05.13 - 20:13:04 ).

unicode enabled version

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function:   db_ntab

2EETW000 fcode:      NT_RDTDESCR

2EETW000 tabname:    TADIR

2EETW000 len (char): 5

2EETW000 key:        TADIR

2EETW000 retcode:    2

R3trans finished (0012).

.....


4 ETW000 R3trans version 6.24 (release 740 - 23.05.13 - 20:13:04 ).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 14.08.2014 - 17:19:16

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 Aug 14 17:19:16 2014                                                  94  0.000094

4 ETW000  [     dev trc,00000]  db_con_init called                                                        30  0.000124

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

4 ETW000                                                                                                  38  0.000162

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

4 ETW000                                                                                                  28  0.000190

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

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/PID/SYS/exe/run/dbsybslib.so' ...            59  0.000270

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/PID/SYS/exe/run/dbsybslib.so"), hdl 0, count 1, addr 2d93a      b0

4 ETW000                                                                                                 555  0.000825

4 ETW000  [     dev trc,00000]  Library '/usr/sap/PID/SYS/exe/run/dbsybslib.so' loaded                    24  0.000849

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

4 ETW000                                                                                                  35  0.000884

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/PID/SYS/exe/run/dbsybslib.so' is "740.10", patchlevel (0.22)

4 ETW000                                                                                                 173  0.001057

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

4 ETW000                                                                                                  28  0.001085

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

4 ETW000                                                                                                  25  0.001110

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  33  0.001143

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 , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000                                                                                                  47  0.001190

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

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

4 ETW000                                                                                                  24  0.001241

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          15  0.001256

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 , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000                                                                                                  36  0.001292

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

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): DBSL supports extended connect protocol             25  0.001339

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

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): profile parameter auth/shadow_upgrade is not set ==> connect info for shad      ow upgrade will not be read with an extra upgrade key set

4 ETW000                                                                                                  87  0.001426

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

4 ETW000                                                                                                  45  0.001471

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [/bas/740_REL/src/krn/rsec/rsecssfs.c 874]

4 ETW000                                                                                                  79  0.001550

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [/bas/740_REL/src/krn/rsec/rsecssf      s.c 4448]

4 ETW000                                                                                               28349  0.029899

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "/usr/sap/PID/SYS/global/security/rsecssfs/data/SSFS_PID.DAT" opened for rea      d [/bas/740_REL/src/krn/rsec/rsecssfs.c 2563]

4 ETW000                                                                                                  92  0.029991

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "/usr/sap/PID/SYS/global/security/rsecssfs/key/SSFS_PID.KEY" not found, using       default key [/bas/740_REL/src/krn/rsec/rsecssfs.c 1426]

4 ETW000                                                                                                  46  0.030037

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message availabl      e>) [/bas/740_REL/src/krn/rsec/rsecssfs.c 942]

4 ETW000                                                                                                 351  0.030388

4 ETW000  [     dev trc,00000]  read_ssfs_record(): DB_CONNECT/DEFAULT_DB_USER read successfully from ssfs

4 ETW000                                                                                                  29  0.030417

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): deregister callback ssfs_dbi_trace                  17  0.030434

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

4 ETW000                                                                                                  22  0.030456

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [/bas/740_REL/src/krn/rsec/rsecssfs.c 874]

4 ETW000                                                                                                  29  0.030485

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [/bas/740_REL/src/krn/rsec/rsecssf      s.c 4448]

4 ETW000                                                                                                  63  0.030548

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "/usr/sap/PID/SYS/global/security/rsecssfs/data/SSFS_PID.DAT" opened for rea      d [/bas/740_REL/src/krn/rsec/rsecssfs.c 2563]

4 ETW000                                                                                                  70  0.030618

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "/usr/sap/PID/SYS/global/security/rsecssfs/key/SSFS_PID.KEY" not found, using       default key [/bas/740_REL/src/krn/rsec/rsecssfs.c 1426]

4 ETW000                                                                                                  40  0.030658

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 0 (message: <No message availabl      e>) [/bas/740_REL/src/krn/rsec/rsecssfs.c 942]

4 ETW000                                                                                                 275  0.030933

4 ETW000  [     dev trc,00000]  read_ssfs_record(): DB_CONNECT/DEFAULT_DB_PASSWORD read successfully from ssfs

4 ETW000                                                                                                  24  0.030957

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): deregister callback ssfs_dbi_trace                  61  0.031018

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

4 ETW000                                                                                                  22  0.031040

4 ETW000  [     dev trc,00000]  RSecSSFs: Entering function "RSecSSFsGetRecord" [/bas/740_REL/src/krn/rsec/rsecssfs.c 874]

4 ETW000                                                                                                  29  0.031069

4 ETW000  [     dev trc,00000]  RSecSSFs: Configuration data read from environment parameters [/bas/740_REL/src/krn/rsec/rsecssf      s.c 4448]

4 ETW000                                                                                                  62  0.031131

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "/usr/sap/PID/SYS/global/security/rsecssfs/data/SSFS_PID.DAT" opened for rea      d [/bas/740_REL/src/krn/rsec/rsecssfs.c 2563]

4 ETW000                                                                                                  69  0.031200

4 ETW000  [     dev trc,00000]  RSecSSFs: Key file "/usr/sap/PID/SYS/global/security/rsecssfs/key/SSFS_PID.KEY" not found, using       default key [/bas/740_REL/src/krn/rsec/rsecssfs.c 1426]

4 ETW000                                                                                                  52  0.031252

4 ETW000  [     dev trc,00000]  RSecSSFs: Data file "/usr/sap/PID/SYS/global/security/rsecssfs/data/SSFS_PID.DAT" exists, but do      es not contain the requested entry [/bas/740_REL/src/krn/rsec/rsecssfs.c 2587]

4 ETW000                                                                                                  59  0.031311

4 ETW000  [     dev trc,00000]  RSecSSFs: Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage [/bas/740_      REL/src/krn/rsec/rsecssfs.c 2590]

4 ETW000                                                                                                  38  0.031349

4 ETW000  [     dev trc,00000]  RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code 1 (message: Record with key "DB_      CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage <-- Data file "/usr/sap/PID/SYS/global/security/rsecssfs/data/SSFS_PID.D      AT" exists, but does not contain the requested entry) [/bas/740_REL/src/krn/rsec/rsecssfs.c 942]

4 ETW000                                                                                                  68  0.031417

4 ETW000  [     dev trc,00000]  read_ssfs_record(): not found is accepted, RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_CON_ENV)=1 :       Record with key "DB_CONNECT/DEFAULT_DB_CON_ENV" not found in secure storage <-- Data file "/usr/sap/PID/SYS/global/security/rsec      ssfs/data/SSFS_PID.DAT" exists, but does not contain the requested entry

4 ETW000                                                                                                  31  0.031448

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): deregister callback ssfs_dbi_trace                  15  0.031463

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("libsybdrvodb8.so"), hdl 1, count 1, addr 2dc9c80

4 ETW000                                                                                                7128  0.038591

4 ETW000  [     dev trc,00000]  load of SQLLEN8 SYB library libsybdrvodb8.so successful.                  50  0.038641

4 ETW000  [     dev trc,00000]  database is local: connect_timeout: 3                                   1369  0.040010

4 ETW000  [     dev trc,00000]  lib_dbsl 740 03/06/2013 11:37:00                                          34  0.040044

4 ETW000  [     dev trc,00000]  connection unquiesced                                                     23  0.040067

4 ETW000  [     dev trc,00000]  dbsybslib.dll patch info                                                  24  0.040091

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                       20  0.040111

4 ETW000  [     dev trc,00000]    SAP patchno  22                                                         37  0.040148

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchlevel 0                                           20  0.040168

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchno         22                                     23  0.040191

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchcomment Smaller corrections in release 7.40 (th, dp, vmc, dpmon) (182140      4)

4 ETW000                                                                                                  33  0.040224

4 ETW000  [     dev trc,00000]  spid 1 comm rd ODBC                                                   104150  0.144374

4 ETW000  [     dev trc,00000]  spid 23 unc rd ODBC                                                      532  0.144906

4 ETW000  [     dev trc,00000]  Driver: Adaptive Server Enterprise (ANSI) Driver release: 15.7.0.1102

4 ETW000                                                                                                1152  0.146058

4 ETW000  [     dev trc,00000]  Driver full version: Sybase ASE ODBC Driver/15.7/SP110 N-Off/P/x86_64/Linux/mango157sp110x/Build       1102/64-bit/Normal/Tue Nov 19 UTC 16:49:55 2013/SQLLEN8

4 ETW000                                                                                                  56  0.146114

4 ETW000  [     dev trc,00000]  Driver uses SQLLEN8                                                       23  0.146137

4 ETW000  [     dev trc,00000]  GetServerInfo version: Adaptive Server Enterprise/15.7/EBF 21708 SMP SP110 /P/x86_64/Enterprise       Linux/ase157sp11x/3546/64-bit/FBO/Fri Nov  8 05:39:38 2013

4 ETW000                                                                                                 514  0.146651

4 ETW000  [     dev trc,00000]  GetServerInfo release: 15.7.0.110                                        557  0.147208

4 ETW000  [     dev trc,00000]  GetServerInfo architecture: x86_64                                        61  0.147269

4 ETW000  [     dev trc,00000]  GetServerInfo edition: P                                                  26  0.147295

4 ETW000  [     dev trc,00000]  GetServerInfo byte width: 64 bit                                          20  0.147315

4 ETW000  [     dev trc,00000]  ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 31787]

4 ETW000                                                                                                1171  0.148486

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DBPROPERTIES not found. Specify

4 ETW000                                                                                                  35  0.148521

4 ETW000  [     dev trc,00000]   owner.objectname or use sp_help to check whether the object exists (sp_help may

4 ETW000                                                                                                  28  0.148549

4 ETW000  [     dev trc,00000]   produce lots of output).                                                 20  0.148569

4 ETW000  [     dev trc,00000]  DbSlConnect hdl: 0                                                      1050  0.149619

4 ETW000  [     dev trc,00000]  trace file set                                                            33  0.149652

4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)                                       25  0.149677

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 21701]                2244  0.151921

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]SVERS not found. Specify owner.

4 ETW000                                                                                                  49  0.151970

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  29  0.151999

4 ETW000  [     dev trc,00000]  e lots of output).                                                        20  0.152019

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT VERSION FROM SVERS                           101  0.152120

4 ETW000                        /* R3::0 T:SVERS */

4 ETW000  [    dblink  ,00000]  ***LOG BZA=>table SVERS      does not exist on database                   80  0.152200

4 ETW000  [     dev trc,00000]  db_con_test_and_open: 1 open cursors (delta=1)                           162  0.152362

4 ETW000  [     dev trc,00000]  db_con_check_dirty: 1 open cursors, tx = NO , bc = NO                     26  0.152388

4 ETW000  [     dev trc,00000]  db_con_check_dirty: db_con_dirty = YES                                    15  0.152403

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 21701]                1225  0.153628

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.

4 ETW000                                                                                                  52  0.153680

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  30  0.153710

4 ETW000  [     dev trc,00000]  e lots of output).                                                        21  0.153731

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT COMPCNT, UNICODELG FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:DDNTT                                                          45  0.153776

4 ETW000  [     dev trc,00000]   */                                                                       21  0.153797

4 ETW000  [     dev trc,00000]  NTAB: SELECT COMPCNT, UNICODELG FROM DDNTT WHERE TABNAME = 'SVERS' FAILED

4 ETW000                                                                                                  31  0.153828

4 ETW000  [     dev trc,00000]  db_con_test_and_open: 2 open cursors (delta=1)                            41  0.153869

4 ETW000  [     dev trc,00000]  db_con_check_dirty: 2 open cursors, tx = NO , bc = NO                     20  0.153889

4 ETW000  [     dev trc,00000]  db_con_check_dirty: db_con_dirty = YES                                    15  0.153904

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 21701]                1136  0.155040

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.

4 ETW000                                                                                                  45  0.155085

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  30  0.155115

4 ETW000  [     dev trc,00000]  e lots of output).                                                        19  0.155134

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT VERSION FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:DDNTT */                                                       42  0.155176

4 ETW000  [     dev trc,00000]   */                                                                       19  0.155195

4 ETW000  [     dev trc,00000]  NTAB: SELECT VERSION FROM DDNTT WHERE TABNAME = 'SVERS' FAILED            23  0.155218

4 ETW000  [     dev trc,00000]  db_con_test_and_open: 3 open cursors (delta=1)                            43  0.155261

4 ETW000  [     dev trc,00000]  db_con_check_dirty: 3 open cursors, tx = NO , bc = NO                     19  0.155280

4 ETW000  [     dev trc,00000]  db_con_check_dirty: db_con_dirty = YES                                    15  0.155295

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 21701]                1235  0.156530

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]DDNTT not found. Specify owner.

4 ETW000                                                                                                  69  0.156599

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  30  0.156629

4 ETW000  [     dev trc,00000]  e lots of output).                                                        20  0.156649

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT DBASE FROM "DDNTT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:DDNTT */                                                       42  0.156691

4 ETW000  [     dev trc,00000]   */                                                                       19  0.156710

4 ETW000  [    dbntab.c,00000]  *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT WHERE TABNAME = 'SVERS' FAILED

4 ETW000                                                                                                  44  0.156754

4 ETW000  [    dbntab  ,00000]  ***LOG BZY=>unexpected return code 103        calling NTAB                39  0.156793

4 ETW000  [     dev trc,00000]  NTAB: db_ntab(): init_ntab failed, returning 2                            53  0.156846

4 ETW000  [     dev trc,00000]  db_con_test_and_open: 4 open cursors (delta=1)                            49  0.156895

4 ETW000  [     dev trc,00000]  db_con_check_dirty: 4 open cursors, tx = NO , bc = NO                     19  0.156914

4 ETW000  [     dev trc,00000]  db_con_check_dirty: db_con_dirty = YES                                    15  0.156929

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 21701]                6337  0.163266

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.

4 ETW000                                                                                                  45  0.163311

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  28  0.163339

4 ETW000  [     dev trc,00000]  e lots of output).                                                        19  0.163358

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:XXXXT                                                          40  0.163398

4 ETW000  [     dev trc,00000]   */                                                                       26  0.163424

4 ETW000  [     dev trc,00000]  NTAB: SELECT COMPCNT, UNICODELG FROM XXXXT WHERE TABNAME = 'SVERS' FAILED

4 ETW000                                                                                                  31  0.163455

4 ETW000  [     dev trc,00000]  db_con_test_and_open: 5 open cursors (delta=1)                            38  0.163493

4 ETW000  [     dev trc,00000]  db_con_check_dirty: 5 open cursors, tx = NO , bc = NO                     18  0.163511

4 ETW000  [     dev trc,00000]  db_con_check_dirty: db_con_dirty = YES                                    14  0.163525

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 21701]                1272  0.164797

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.

4 ETW000                                                                                                  46  0.164843

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  29  0.164872

4 ETW000  [     dev trc,00000]  e lots of output).                                                        27  0.164899

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:XXXXT */                                                       61  0.164960

4 ETW000  [     dev trc,00000]   */                                                                       21  0.164981

4 ETW000  [     dev trc,00000]  NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' FAILED            25  0.165006

4 ETW000  [     dev trc,00000]  db_con_test_and_open: 6 open cursors (delta=1)                            39  0.165045

4 ETW000  [     dev trc,00000]  db_con_check_dirty: 6 open cursors, tx = NO , bc = NO                     18  0.165063

4 ETW000  [     dev trc,00000]  db_con_check_dirty: db_con_dirty = YES                                    15  0.165078

4 ETW000  [     dev trc,00000]  ERROR: -1 in function StartSelect (execute) [line 21701]                1171  0.166249

4 ETW000  [     dev trc,00000]  (208) [42000] [Sybase][ODBC Driver][Adaptive Server Enterprise]XXXXT not found. Specify owner.

4 ETW000                                                                                                  45  0.166294

4 ETW000  [     dev trc,00000]  objectname or use sp_help to check whether the object exists (sp_help may produc

4 ETW000                                                                                                  28  0.166322

4 ETW000  [     dev trc,00000]  e lots of output).                                                        18  0.166340

4 ETW000  [     dev trc,00000]  sql statement is ==> SELECT DBASE FROM "XXXXT" WHERE TABNAME = 'SVERS'

4 ETW000                        /* R3::0 T:XXXXT */                                                       40  0.166380

4 ETW000  [     dev trc,00000]   */                                                                       19  0.166399

4 ETW000  [    dbntab.c,00000]  *** ERROR => NTAB: SELECT VERSION/DBASE FROM XXXXT WHERE TABNAME = 'SVERS' FAILED

4 ETW000                                                                                                  42  0.166441

4 ETW000  [    dbntab  ,00000]  ***LOG BZY=>unexpected return code 103        calling NTAB                32  0.166473

4 ETW000  [     dev trc,00000]  NTAB: db_ntab(): init_ntab failed, returning 2                            32  0.166505

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function:   db_ntab

2EETW000 fcode:      NT_RDTDESCR

2EETW000 tabname:    TADIR

2EETW000 len (char): 5

2EETW000 key:        TADIR

2EETW000 retcode:    2

4 ETW000  [     dev trc,00000]  db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)                    215  0.166720

4 ETW000  [     dev trc,00000]  db_con_check_dirty: db_con_dirty = NO         

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Updating..

Configtool is connecting now. In connection pools tab, the old port value was set.

But JAVA do not start until now.

divyanshu_srivastava3
Active Contributor
0 Kudos

So, now check your java profile too. As told you before it's port or some network issue.

Former Member
0 Kudos

The parameters of profile had been changed before, as well the interfaces file located in /sybase/SID.

Anymore place to be changed?

divyanshu_srivastava3
Active Contributor
0 Kudos

If every thing correct, then startsap with pidadm.

Also in configtool, check secure store jdbc/pool/<sid>/Url parameter.

Answers (9)

Answers (9)

Former Member
0 Kudos

Really Divyanshu.

Now is up!

Thank you all for the help.

Best Regards.

Marcos.

divyanshu_srivastava3
Active Contributor
0 Kudos

Great News.. !!

Former Member
0 Kudos

Yes Reagan, you´re right.

The drivers are present in that paths, with correct permissions...

Here is the environment variables to pidadm user:

TERM=xterm

HOME=/home/pidadm

SHELL=/bin/csh

USER=pidadm

LOGNAME=pidadm

PATH=/sybase/PID/ASE-15_0/jobscheduler/bin:/sybase/PID/ASE-15_0/bin:/sybase/PID/ASE-15_0/install:/sybase/PID/SCC-3_2/bin:/sybase/PID/DBISQL/bin:/sybase/PID/OCS-15_0/bin:/home/pidadm/bin:/usr/local/bin:/bin:/usr/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/usr/sap/PID/SYS/exe/uc/linuxx86_64:/usr/sap/PID/SYS/exe/run:/home/pidadm:.

HOSTTYPE=x86_64

VENDOR=suse

OSTYPE=linux

MACHTYPE=x86_64-suse-linux

SHLVL=1

PWD=/usr/sap/PID/J00/exe/sybjdbc

GROUP=sapsys

HOST=mlmvs0007l

CSHEDIT=emacs

MAIL=/var/spool/mail/pidadm

CPU=x86_64

HOSTNAME=mlmvs0007l

INPUTRC=/etc/inputrc

LESS=-M -I

LESSOPEN=lessopen.sh %s

LESSCLOSE=lessclose.sh %s %s

LESS_ADVANCED_PREPROCESSOR=no

LESSKEY=/etc/lesskey.bin

PAGER=less

MORE=-sl

MINICOM=-c on

MANPATH=/usr/local/man:/usr/share/man

INFODIR=/usr/local/info:/usr/share/info:/usr/info

INFOPATH=/usr/local/info:/usr/share/info:/usr/info

XKEYSYMDB=/usr/share/X11/XKeysymDB

XNLSPATH=/usr/share/X11/nls

COLORTERM=1

CVS_RSH=ssh

XCURSOR_THEME=DMZ

QT_HOME_DIR=/usr/share/desktop-data

LANG=en_US.UTF-8

FROM_HEADER=

NNTPSERVER=news

WINDOWMANAGER=/usr/bin/gnome

PYTHONSTARTUP=/etc/pythonstart

XDG_DATA_DIRS=/usr/local/share:/usr/share:/etc/opt/kde3/share:/opt/kde3/share:/usr/share/gnome/help

XDG_CONFIG_DIRS=/etc/xdg

G_BROKEN_FILENAMES=1

G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-1,CP1252

ENV=/etc/bash.bashrc

CSHRCREAD=true

LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:

LS_OPTIONS=-N --color=tty -T 0

SAPSYSTEMNAME=PID

DIR_LIBRARY=/usr/sap/PID/SYS/exe/run

RSEC_SSFS_DATAPATH=/usr/sap/PID/SYS/global/security/rsecssfs/data

RSEC_SSFS_KEYPATH=/usr/sap/PID/SYS/global/security/rsecssfs/key

rsdb_ssfs_connect=1

LD_LIBRARY_PATH=/usr/sap/PID/SYS/global/syb/linuxx86_64/sybodbc:/sybase/PID/ASE-15_0/lib:/sybase/PID/DataAccess64/ODBC/lib:/sybase/PID/DataAccess/ODBC/lib:/sybase/PID/OCS-15_0/lib:/sybase/PID/OCS-15_0/lib3p64:/sybase/PID/OCS-15_0/lib3p:/usr/sap/PID/SYS/exe/run:/usr/sap/PID/SYS/exe/uc/linuxx86_64

INCLUDE=/sybase/PID/OCS-15_0/include:

LIB=/sybase/PID/OCS-15_0/lib:

SYBASE_JRE7_32=/sybase/PID/shared/JRE-7_0_21_32BIT

SYBASE_JRE7=/sybase/PID/shared/JRE-7_0_21_64BIT

SYBASE_JRE7_64=/sybase/PID/shared/JRE-7_0_21_64BIT

SYBASE_OCS=OCS-15_0

SCC_JAVA_HOME=/sybase/PID/shared/JRE-7_0_21_64BIT

SYBASE=/sybase/PID

SYBASE_ASE=ASE-15_0

SYBROOT=/sybase/PID

SYBASE_JRE_RTDS=/sybase/PID/shared/JRE-7_0_21_64BIT

SYBASE_WS=WS-15_0

dbms_type=syb

dbs_syb_schema=SAPSR3

dbs_syb_server=mlmvs0007l

dbs_syb_dbname=PID

dbs_syb_port=4905

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


And here is to grdadm user:


TERM=xterm

HOME=/home/grdadm

SHELL=/bin/csh

USER=grdadm

LOGNAME=grdadm

PATH=/sybase/GRD/ASE-15_0/jobscheduler/bin:/sybase/GRD/ASE-15_0/bin:/sybase/GRD/ASE-15_0/install:/sybase/GRD/OCS-15_0/bin:/home/grdadm/bin:/usr/local/bin:/bin:/usr/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/usr/sap/GRD/SYS/exe/uc/linuxx86_64:/usr/sap/GRD/SYS/exe/run:/home/grdadm:.

HOSTTYPE=x86_64

VENDOR=suse

OSTYPE=linux

MACHTYPE=x86_64-suse-linux

SHLVL=1

PWD=/home/grdadm

GROUP=sapsys

HOST=mlmvs0007l

CSHEDIT=emacs

MAIL=/var/spool/mail/grdadm

CPU=x86_64

HOSTNAME=mlmvs0007l

INPUTRC=/etc/inputrc

LESS=-M -I

LESSOPEN=lessopen.sh %s

LESSCLOSE=lessclose.sh %s %s

LESS_ADVANCED_PREPROCESSOR=no

LESSKEY=/etc/lesskey.bin

PAGER=less

MORE=-sl

MINICOM=-c on

MANPATH=/usr/local/man:/usr/share/man

INFODIR=/usr/local/info:/usr/share/info:/usr/info

INFOPATH=/usr/local/info:/usr/share/info:/usr/info

XKEYSYMDB=/usr/share/X11/XKeysymDB

XNLSPATH=/usr/share/X11/nls

COLORTERM=1

CVS_RSH=ssh

XCURSOR_THEME=DMZ

QT_HOME_DIR=/usr/share/desktop-data

LANG=en_US.UTF-8

FROM_HEADER=

NNTPSERVER=news

WINDOWMANAGER=/usr/bin/gnome

PYTHONSTARTUP=/etc/pythonstart

XDG_DATA_DIRS=/usr/local/share:/usr/share:/etc/opt/kde3/share:/opt/kde3/share:/usr/share/gnome/help

XDG_CONFIG_DIRS=/etc/xdg

G_BROKEN_FILENAMES=1

G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-1,CP1252

ENV=/etc/bash.bashrc

CSHRCREAD=true

LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:

LS_OPTIONS=-N --color=tty -T 0

SAPSYSTEMNAME=GRD

DIR_LIBRARY=/usr/sap/GRD/SYS/exe/run

RSEC_SSFS_DATAPATH=/usr/sap/GRD/SYS/global/security/rsecssfs/data

RSEC_SSFS_KEYPATH=/usr/sap/GRD/SYS/global/security/rsecssfs/key

rsdb_ssfs_connect=1

LD_LIBRARY_PATH=/usr/sap/GRD/SYS/global/syb/linuxx86_64/sybodbc:/sybase/GRD/ASE-15_0/lib:/sybase/GRD/OCS-15_0/lib:/sybase/GRD/OCS-15_0/lib3p64:/sybase/GRD/OCS-15_0/lib3p:/usr/sap/GRD/SYS/exe/run:/usr/sap/GRD/SYS/exe/uc/linuxx86_64

SAP_JRE7_32=/sybase/GRD/shared/SAPJRE-7_1_011_32BIT

SAP_JRE7=/sybase/GRD/shared/SAPJRE-7_1_011_64BIT

SAP_JRE7_64=/sybase/GRD/shared/SAPJRE-7_1_011_64BIT

SYBASE_OCS=OCS-15_0

INCLUDE=/sybase/GRD/OCS-15_0/include:

LIB=/sybase/GRD/OCS-15_0/lib:

SYBASE=/sybase/GRD

SYBASE_ASE=ASE-15_0

SYBROOT=/sybase/GRD

SYBASE_JRE_RTDS=/sybase/GRD/shared/SAPJRE-7_1_011_64BIT

SYBASE_WS=WS-15_0

dbms_type=syb

dbs_syb_schema=SAPSR3

dbs_syb_server=mlmvs0007l

dbs_syb_dbname=GRD

dbs_syb_port=4901

Former Member
0 Kudos

Please, note that the instance was OK before the installation of another system.

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Marcos

So you have installed a new ABAP stack on the same host where PI Java PID is running.

They both have different databases and are not connected in any way. Correct me if I am wrong.

Is it possible to provide the environment variables of the sidadm users for both the systems ?

Are the drivers present at the below location ?

/usr/sap/PID/J00/exe/sybjdbc/jconn4.jar

/usr/sap/PID/J00/exe/sybjdbc/EccpressoFIPS.jar

/usr/sap/PID/J00/exe/sybjdbc/EccpressoFIPSJca.jar

Regards

RB

Former Member
0 Kudos

Hi Reagan.

The parameter has value

j2ee/dbdriver = $(DIR_EXECUTABLE)/sybjdbc/jconn4.jar:$(DIR_EXECUTABLE)/sybjdbc/EccpressoFIPS.jar:$(DIR_EXECUTABLE)/sybjdbc/EccpressoFIPSJca.jar

The permissions of the files, is 755, to sidadm:sapsys

Former Member
0 Kudos

Divyanshu,

Properties files revised, as per mentioned note.

No, configtool do not work, can not connect to DB.

configtool trace:

#2.#2014 08 15 11:35:40:777#0-300#Error#configtool#

com.sap.ASJ.cft.000205#BC-JAS-ADM-ADM-CFT#sap.com~tc~je~configtool#C0000A640F0700000000000160482805###configtool########Thread[main,5,main]#Plain##

Error occurred while scanning DB.

com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.

        at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPoolImpl.createConnection(DBConnectionPoolImpl.java:496)

        at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPoolImpl.<init>(DBConnectionPoolImpl.java:197)

        at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandlerImpl.<init>(PersistenceHandlerImpl.java:50)

        at com.sap.engine.core.configuration.impl.cache.ConfigurationController.<init>(ConfigurationController.java:139)

        at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:309)

        at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:59)

        at com.sap.engine.configtool.visual.ConfigTool.loadClusterData(ConfigTool.java:167)

        at com.sap.engine.configtool.visual.ConfigTool.initScan(ConfigTool.java:148)

        at com.sap.engine.configtool.visual.ConfigTool.<init>(ConfigTool.java:143)

        at com.sap.engine.configtool.visual.ConfigTool.main(ConfigTool.java:1203)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:162)

Caused by: com.sap.sql.log.OpenSQLException: Exception of type java.sql.SQLException caught: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s)..

        at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:104)

        at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:143)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.get(DBDataSourceImpl.java:284)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.getPooledConnection(DBDataSourceImpl.java:179)

        at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:213)

        at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPoolImpl.createConnection(DBConnectionPoolImpl.java:482)

        ... 14 more

Caused by: java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).

        at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:766)

        at com.sybase.jdbc4.tds.Tds.processLoginAckToken(Tds.java:5287)

        at com.sybase.jdbc4.tds.Tds.doLogin(Tds.java:724)

        at com.sybase.jdbc4.tds.Tds.login(Tds.java:578)

        at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(SybConnection.java:418)

        at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(SybConnection.java:3285)

        at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:344)

        at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:249)

        at com.sybase.jdbc4.jdbc.SybDriver.connect(SybDriver.java:233)

        at com.sap.sql.connect.factory.DriverPooledConnectionFactory.createVendorConnection(DriverPooledConnectionFactory.java:50)

        at com.sap.sql.connect.factory.DriverPooledConnectionFactory.getPooledConnection(DriverPooledConnectionFactory.java:37)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:651)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.create(DBDataSourceImpl.java:995)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.create(DBDataSourceImpl.java:43)

        at com.sap.sql.connect.pool.CreatedObjectsPool.create(CreatedObjectsPool.java:95)

        at com.sap.sql.connect.pool.Pool.get(Pool.java:707)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.get(DBDataSourceImpl.java:261)

        ... 17 more

[Log ID = C0000A640F0700000000000060482805]#

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

What is the value for the parameter j2ee/dbdriver in the instance profile ?

And they set with the correct permissions ?

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Marcos,

Have a look at this thread. The issue seems to be with port or network, which has occurred after your have made changes to the infra.

BTW, is you Database up and running ?

Regards,

Divyanshu

Former Member
0 Kudos

Yes, the DB is up, i can connect with isql.

The ports is adjusted, as per note 1729176.

I check this thread, and have a question.. where to configure the parameters?

JDBCDriver: com.sybase.jdbc4.jdbc.SybDriver

ServerURL : jdbc:sybase:Tds:<db_ip>:<db_port>/<db_name>

UserName: <user_name>

Password: <password>

Validate Query: SELECT count(*) FROM dbo.sysobjects

Thanks.

Former Member
0 Kudos

And log_bootstrap.0.log

[Aug 15, 2014 9:16:42 AM ] Starting to configure the bootstrap

[Aug 15, 2014 9:16:42 AM ]       Bootstrap properties file [/usr/sap/PID/J00/j2ee/cluster/bootstrap/bootstrap.properties] found

[Aug 15, 2014 9:16:42 AM ] Bootstrap configured for [67] ms

[Aug 15, 2014 9:16:42 AM ]

[Aug 15, 2014 9:16:42 AM ] Memory available to the bootstrap JVM: [2 GiB / 2863333376 bytes]

[Aug 15, 2014 9:16:42 AM ]

-----[Bootstrap Module started]--------[Fri Aug 15 09:16:42 BRT 2014]-------

[Aug 15, 2014 9:16:42 AM ]

+------------[Bootstrap synchronization activities information]-----------+

| Runtime Binaries: [X]        Native files: [X] Instance Properties: [X] |

|  Nodes Structure: [X] Cluster File System: [X]    Online bootstrap: [ ] |

+-------------------------------------------------------------------------+

[Aug 15, 2014 9:16:42 AM ] Properties used for initialization: [element.resynch=detect, Logging properties = {log[defaultTrace]=FileLog, log[defaultTrace].pattern=../../work/log_bootstrap.log, log[consoleLog].formatter=formatter[ConsoleFormatter], com.sap.engine.bootstrap.severity=Info, formatter[ConsoleFormatter]=TraceFormatter, log[consoleLog]=com.sap.engine.bootstrap.logging.BootstrapConsoleLog, com.sap.engine.bootstrap.logs=log[defaultTrace],log[consoleLog], log[defaultTrace].cnt=3, formatter[BootstrapFormatter]=TraceFormatter, log[defaultTrace].formatter=formatter[BootstrapFormatter], formatter[ConsoleFormatter].pattern=%m, log[defaultTrace].limit=5242880, formatter[BootstrapFormatter].pattern=[%24d] %m}, debug=no, Watchdog properties = {watchdog.timeout=90000, watchdog.check_interval=2000}]

[Aug 15, 2014 9:16:42 AM ] Bootstrap initialized for [112] ms

[Aug 15, 2014 9:16:42 AM ] Watchdog [90000] ms checking every [2000] ms started

[Aug 15, 2014 9:16:42 AM ] Starting to initialize database connection

[Aug 15, 2014 9:16:43 AM ] Exception occurred for component [internal/unkown] of type [unkown]

com.sap.engine.bootstrap.SynchronizationException: Storage access initialization failed due to OpenSQL error.Check if your db driver file is available on the file system or if the user has correct permissions for that file

        at com.sap.engine.bootstrap.StorageAccess.<init>(StorageAccess.java:146)

        at com.sap.engine.bootstrap.Bootstrap.initializeSynchronizer(Bootstrap.java:79)

        at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:273)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:162)

----------==[ Caused by: ]==----------

com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.

        at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPoolImpl.createConnection(DBConnectionPoolImpl.java:496)

        at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPoolImpl.<init>(DBConnectionPoolImpl.java:197)

        at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandlerImpl.<init>(PersistenceHandlerImpl.java:50)

        at com.sap.engine.core.configuration.impl.cache.ConfigurationController.<init>(ConfigurationController.java:139)

        at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:309)

        at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:59)

        at com.sap.engine.bootstrap.StorageAccess.<init>(StorageAccess.java:138)

        at com.sap.engine.bootstrap.Bootstrap.initializeSynchronizer(Bootstrap.java:79)

        at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:273)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:162)

Caused by: com.sap.sql.log.OpenSQLException: Exception of type java.sql.SQLException caught: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s)..

        at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:104)

        at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:143)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.get(DBDataSourceImpl.java:284)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.getPooledConnection(DBDataSourceImpl.java:179)

        at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:213)

        at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPoolImpl.createConnection(DBConnectionPoolImpl.java:482)

        ... 13 more

Caused by: java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).

        at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:765)

        at com.sybase.jdbc4.tds.Tds.processLoginAckToken(Tds.java:5275)

        at com.sybase.jdbc4.tds.Tds.doLogin(Tds.java:723)

        at com.sybase.jdbc4.tds.Tds.login(Tds.java:577)

        at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(SybConnection.java:419)

        at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(SybConnection.java:3325)

        at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:345)

        at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:250)

        at com.sybase.jdbc4.jdbc.SybDriver.connect(SybDriver.java:232)

        at com.sap.sql.connect.factory.DriverPooledConnectionFactory.createVendorConnection(DriverPooledConnectionFactory.java:50)

        at com.sap.sql.connect.factory.DriverPooledConnectionFactory.getPooledConnection(DriverPooledConnectionFactory.java:37)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:651)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.create(DBDataSourceImpl.java:995)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.create(DBDataSourceImpl.java:43)

        at com.sap.sql.connect.pool.CreatedObjectsPool.create(CreatedObjectsPool.java:95)

        at com.sap.sql.connect.pool.Pool.get(Pool.java:707)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.get(DBDataSourceImpl.java:261)

        ... 16 more

[Aug 15, 2014 9:16:43 AM ] [Bootstrap]> Error during synchronization. More details: the previous log entries

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Marcos,

Have a look at below note:

1885295 - J2EE System fails with "exitcode 558"

and

JZ00L: Login failed

for user/password.

Are you able to logon to configtool ?

Have a look at database related parameter and properties for PI system in all these locations.

Regards,

Divyanshu

Former Member
0 Kudos

Hello Divyanshu.

I´m not using the same database, there is two installations of sybase, with their own binaries.

There is the dev_bootstrap file.

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

trc file: "dev_bootstrap", trc level: 1, release: "740"

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

sysno      00

sid        PID

systemid   390 (AMD/Intel x86_64 with Linux)

relno      7400

patchlevel 0

patchno    0

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

profile    /usr/sap/PID/SYS/profile/PID_J00_mlmvs0007l

pid        18534

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      All, egi

*

Fri Aug 15 09:16:41 2014

*

*  trace logging activated, max size = 52428800 bytes, 2 versions

*

arguments :

  arg[ 0] : /usr/sap/PID/J00/exe/jstart

  arg[ 1] : -appTrc

  arg[ 2] : -nodeId=0

  arg[ 3] : pf=/usr/sap/PID/SYS/profile/PID_J00_mlmvs0007l

  arg[ 4] : -hostvm

  arg[ 5] : -nodeName=bootstrap

  arg[ 6] : -file=/usr/sap/PID/J00/exe/startup.properties

  arg[ 7] : -jvmFile=/usr/sap/PID/J00/work/jstart.jvm

  arg[ 8] : -traceFile=/usr/sap/PID/J00/work/dev_bootstrap

  arg[ 9] : -javaOutFile=/usr/sap/PID/J00/work/jvm_bootstrap.out

F

F Fri Aug 15 09:16:41 2014

F  ********************************************************************************

F  Java environment properties

F    root directory    : /usr/sap/PID/J00/exe/sapjvm_6

F    vendor            : SAP AG

F    version           : 1.6.0_51

F    cpu               : amd64

F    java vm type      : server

F    java vm version   : 6.1.057 23.5-b02

F    jvm library name  : libjvm.so

F    library path      : /usr/sap/PID/J00/exe/sapjvm_6/jre/lib/amd64/server:/usr/sap/PID/J00/exe/sapjvm_6/jre/lib/amd64

F    executable path   : /usr/sap/PID/J00/exe/sapjvm_6/bin

F    SAP extensions    : available

F  ********************************************************************************

I  [Thr 140737353885536] MtxInit: 10000 0 2

M  [Thr 140737353885536] NiInit3: NI already initialized; param 'maxHandles' ignored (init=2;par=65536;cur=2048)

M  [Thr 140737353885536] CCMS: Initialized monitoring segment of size 60000000.

M  [Thr 140737353885536] CCMS: Initialized CCMS Headers in the shared monitoring segment.

M  [Thr 140737353885536] CCMS: Checking Downtime Configuration of Monitoring Segment.

M  [Thr 140737353885536] CCMS: AlMsUpload called by wp 1004.

M  [Thr 140737353885536] CCMS: AlMsUpload successful for /usr/sap/PID/J00/log/ALMTTREE (602 MTEs).

M  [Thr 140737353885536] CCMS: CCMS Monitoring Initialization finished, rc=0.

F

F Fri Aug 15 09:16:41 2014

F  ********************************************************************************

F  SAP Java VM arguments:

F    arg[ 0] = vfprintf

F    arg[ 1] = abort

F    arg[ 2] = exit

F    arg[ 3] = -XmonGcCallback

F    arg[ 4] = -XdebugStateChangeCallback

F    arg[ 5] = -DSAPJStartVersion=740, patch 22, changelist 1421308, linuxx86_64, optU (Jun 17 2013, 19:02:49)

F    arg[ 6] = -verbose:gc

F    arg[ 7] = -XX:+HeapDumpOnOutOfMemoryError

F    arg[ 8] = -DSAPSTARTUP=1

F    arg[ 9] = -DSAPSYSTEM=00

F    arg[10] = -DSAPSYSTEMNAME=PID

F    arg[11] = -DSAPMYNAME=mlmvs0007l_PID_00

F    arg[12] = -DSAPDBHOST=mlmvs0007l

F    arg[13] = -DSAPINFO=PID_00_bootstrap

F    arg[14] = -Dj2ee.dbhost=mlmvs0007l

F    arg[15] = -Dsun.java.launcher=jstart

F    arg[16] = -Dsun.java.command=com.sap.engine.offline.OfflineToolStart com.sap.engine.bootstrap.Bootstrap ./bootstrap

F    arg[17] = -Djstartup.mode=JSTART

F    arg[18] = -Djstartup.whoami=bootstrap

F    arg[19] = -Djstartup.ownProcessId=18534

F    arg[20] = -Djstartup.ownHardwareId=J0363113045

F    arg[21] = -Djstartup.debuggable=no

F    arg[22] = -DLoadBalanceRestricted=no

F    arg[23] = -Denv.class.path=

F    arg[24] = -Dsys.global.dir=/usr/sap/PID/SYS/global

F    arg[25] = -Dapplication.home=/usr/sap/PID/J00/exe

F    arg[26] = -Djava.class.path=/usr/sap/PID/J00/exe/jstart71.jar:/usr/sap/PID/J00/exe/sapjvm_6/lib/jvmx.jar:/usr/sap/PID/J00/exe/sapjvm_6/lib/jvmx_tools.jar:/usr/sap/PID/J00/exe/jre/lib/iqlib.jar:/usr/sap/PID/J00/exe/sapjvm_6/lib/tools.jar:./bootstrap/sap.com~tc~bl~offline_launcher~impl.jar

F    arg[27] = -Djava.library.path=/usr/sap/PID/J00/exe/sapjvm_6/jre/lib/amd64/server:/usr/sap/PID/J00/exe/sapjvm_6/jre/lib/amd64:/usr/sap/PID/J00/j2ee/os_libs:/usr/sap/PID/J00/exe:/usr/sap/PID/SYS/global/syb/linuxx86_64/sybodbc:/sybase/PID/ASE-15_0/lib:/sybase/PID/DataAccess64/ODBC/lib:/sybase/PID/DataAccess/ODBC/lib:/sybase/PID/OCS-15_0/lib:/sybase/PID/OCS-15_0/lib3p64:/sybase/PID/OCS-15_0/lib3p:/usr/sap/PID/SYS/exe/run:/usr/sap/PID/SYS/exe/uc/linuxx86_64

F    arg[28] = -Xmx3072m

F    arg[29] = -Xss1048576

F  ignore unrecognized options : no

F  ********************************************************************************

F  [Thr 140737114334976] *** LOG => SfCJavaVm: Java VM started.

F  ********************************************************************************

F  Main method call:

F  com/sap/engine/offline/OfflineToolStart.main()

F    arg[ 0] = com.sap.engine.bootstrap.Bootstrap

F    arg[ 1] = ./bootstrap

F  ********************************************************************************

J

J Fri Aug 15 09:16:41 2014

J  [GC 4032K->1268K(9984K), 0.0046730 secs]

J  [GC 5255K->3682K(14016K), 0.0030220 secs]

J  [Full GC 3682K->3508K(20672K), 0.0145340 secs]

J

J Fri Aug 15 09:16:42 2014

J  [GC 11572K->7682K(20672K), 0.0018770 secs]

F

F [Thr 140737114334976] Fri Aug 15 09:16:42 2014

F  [Thr 140737114334976] *** LOG => State changed from 0 (Initial) to 2 (Starting framework).

F  [Thr 140737114334976] *** LOG    state real time: 0.862 CPU time: 0.610 sys, 2.130 usr

F  [Thr 140737114334976] *** LOG    total real time: 0.862 CPU time: 0.610 sys, 2.130 usr

F  [Thr 140737114334976]

J  [GC 15699K->9601K(24960K), 0.0029340 secs]

J  [Full GC 9601K->6458K(32320K), 0.0240920 secs]

J  [GC 18810K->7539K(32704K), 0.0022480 secs]

J  [GC 20275K->8307K(40960K), 0.0030020 secs]

J  [GC 25203K->9179K(40832K), 0.0044460 secs]

J  [GC 26075K->10112K(46272K), 0.0083480 secs]

F

F [Thr 140737114334976] Fri Aug 15 09:16:43 2014

F  [Thr 140737114334976] *** LOG => State changed from 2 (Starting framework) to 5 (Stopping).

F  [Thr 140737114334976] *** LOG    state real time: 0.933 CPU time: 0.050 sys, 2.640 usr

F  [Thr 140737114334976] *** LOG    total real time: 1.796 CPU time: 0.660 sys, 4.770 usr

F  [Thr 140737114334976]

F

F [Thr 140736544548608] Fri Aug 15 09:16:43 2014

F  [Thr 140736544548608] *** LOG => SfCJavaVm: exit hook is called. (rc = 558)

F

F  ********************************************************************************

F  *** ERROR => Java node 'Instance_bootstrap' terminated with exit code 558.

F  ***

F  *** Please see section 'Java program exit codes'

F  *** in SAP Note 1316652 for additional information and trouble shooting advice.

F  ********************************************************************************

F

F  [Thr 140736544548608] *** LOG => exiting (exitcode 558, retcode 1).

M  [Thr 140736544548608] CCMS: CCMS Monitoring Cleanup finished successfully.

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Marcos,

1st thing, R3trans should not be used for JAVA system. As far as I know, it won't work for a JAVA database.

2nd thing, Are you trying to use the same database for JAVA and ABAP ? Did you use Virtual hostname ?

3rd thing, Share logs from work directory of PI.

Regards,

Divyanshu

Former Member
0 Kudos

In file JdbcCon.log, found the entry:

OK: disconnected

com.sap.sql.log.OpenSQLException: Exception of type java.sql.SQLException caught: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s)..

        at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:104)

        at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:143)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.get(DBDataSourceImpl.java:284)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.getConnection(DBDataSourceImpl.java:139)

        at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:204)

        at com.sap.inst.jdbc.connect.JdbcCon.connectViaSecureStore(JdbcCon.java:217)

        at com.sap.inst.jdbc.connect.JdbcCon.connect(JdbcCon.java:353)

        at com.sap.inst.jdbc.connect.TestConnect.mainIntern(TestConnect.java:78)

        at com.sap.inst.jdbc.connect.JdbcCon.main(JdbcCon.java:553)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:162)

Caused by: java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).

        at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:765)

        at com.sybase.jdbc4.tds.Tds.processLoginAckToken(Tds.java:5275)

        at com.sybase.jdbc4.tds.Tds.doLogin(Tds.java:723)

        at com.sybase.jdbc4.tds.Tds.login(Tds.java:577)

        at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(SybConnection.java:419)

        at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(SybConnection.java:3325)

        at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:345)

        at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:250)

        at com.sybase.jdbc4.jdbc.SybDriver.connect(SybDriver.java:232)

        at com.sap.sql.connect.factory.DriverPooledConnectionFactory.createVendorConnection(DriverPooledConnectionFactory.java:50)

        at com.sap.sql.connect.factory.DriverPooledConnectionFactory.getPooledConnection(DriverPooledConnectionFactory.java:37)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:651)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.create(DBDataSourceImpl.java:995)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.create(DBDataSourceImpl.java:43)

        at com.sap.sql.connect.pool.CreatedObjectsPool.create(CreatedObjectsPool.java:95)

        at com.sap.sql.connect.pool.Pool.get(Pool.java:707)

        at com.sap.sql.connect.datasource.DBDataSourceImpl.get(DBDataSourceImpl.java:261)

        ... 11 more

Error: Couldn't connect to DB

com.sap.sql.log.OpenSQLException: Exception of type java.sql.SQLException caught: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s)..