on 08-14-2014 9:26 PM
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
Updating..
Configtool is connecting now. In connection pools tab, the old port value was set.
But JAVA do not start until now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Really Divyanshu.
Now is up!
Thank you all for the help.
Best Regards.
Marcos.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please, note that the instance was OK before the installation of another system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]#
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.