SAP solman on sybase 16.0 installation

[Former Member]

Dear Experts,

We are installation solution manager 7.1 on windows 2012 R2 and sybase 16.0 and we are getting error at import abap phase as

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

D:\usr\sap\GSD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20151002125851

D:\usr\sap\GSD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

D:\usr\sap\GSD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.6 [UNICODE]

Compiled Apr 29 2015 03:46:11

patchinfo (patches.h): (0.419) DB2 z/OS: SWPM: SQLCODE -913: ALTER TABLE SVERS ADD PRIM (note 2138220)

process id 3836

D:\usr\sap\GSD\SYS\exe\uc\NTAMD64\R3load.exe -testconnect

(PRC) INFO: working directory "C:\Program Files\sapinst_instdir\SOLMAN71\SYSTEM\SYB\CENTRAL\AS"

(DB) ERROR: db_connect rc = 256

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\GSD\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\GSD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20151002125853

We checked by changing the id to sidadm but still the same error r3trans -d gives error as below

This is r3trans version 6.24 (release 721 - 01.04.15 - 20:15:04).

unicode enabled version

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

2EETW169 no connect possible: "DBMS = SYBASE --- "

r3trans finished (0012).

And the trans log gives as below

4 ETW000 r3trans version 6.24 (release 721 - 01.04.15 - 20:15:04).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 02.10.2015 - 15:37:29

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

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

4 ETW000  [     dev trc,00000]  Fri Oct 02 15:37:29 2015                                                 162  0.000162

4 ETW000  [     dev trc,00000]  Loading DB library 'dbsybslib.dll' ...                                    31  0.000193

4 ETW000  [     dev trc,00000]  Library 'dbsybslib.dll' loaded                                           651  0.000844

4 ETW000  [     dev trc,00000]  Version of 'dbsybslib.dll' is "721.02", patchlevel (0.419)               391  0.001235

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

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

4 ETW000  [     dev trc,00000]  Fri Oct 02 15:37:31 2015                                             1449339  1.450643

4 ETW000  [     dev trc,00000]  database is local: connect_timeout: 3                                     32  1.450675

4 ETW000  [     dev trc,00000]  Thread ID:3672                                                            18  1.450693

4 ETW000  [     dev trc,00000]  lib_dbsl 721 03/12/2015 12:56:00                                          17  1.450710

4 ETW000  [     dev trc,00000]  connection unquiesced                                                     27  1.450737

4 ETW000  [     dev trc,00000]  721_EXT build                                                             15  1.450752

4 ETW000  [     dev trc,00000]  Using dynamic link library 'D:\usr\sap\GSD\SYS\exe\uc\NTAMD64\dbsybslib.dll'

4 ETW000                                                                                                  33  1.450785

4 ETW000  [     dev trc,00000]  dbsybslib.dll patch info                                                  67  1.450852

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                       16  1.450868

4 ETW000  [     dev trc,00000]    SAP patchno  500                                                        15  1.450883

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchlevel 0                                           15  1.450898

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchno         419                                    17  1.450915

4 ETW000  [     dev trc,00000]    Last SYBASE DBSL patchcomment Option to verify secure storage (2129883)

4 ETW000                                                                                                  39  1.450954

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4552]

4 ETW000                                                                                              546953  1.997907

4 ETW000  [     dev trc,00000]  (4002) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Login failed.

4 ETW000                                                                                                  32  1.997939

4 ETW000  [     dev trc,00000]  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 4552]

4 ETW000                                                                                                  38  1.997977

4 ETW000  [     dev trc,00000]  (30131) [08S01] [SAP][ASE ODBC Driver]Connection to the server has been lost, connection to the

4 ETW000                                                                                                  28  1.998005

4 ETW000  [     dev trc,00000]  next available HA server also failed. All active transactions have been rolled b

4 ETW000                                                                                                  26  1.998031

4 ETW000  [     dev trc,00000]  ack                                                                       14  1.998045

4 ETW000  [     dev trc,00000]  Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=HRMS-DEVSM;port=4901;uid=SAPSR3;db=GSD;pwd=xxxxxxxxx;TextSize=2147483647;FetchArraySize=1000;ReleaseLocksOnCursorClose=1;DynamicPrepare=1;UseCursor=2;homogeneousbatch=1;charset=utf8;EncryptPassword=1;EnableLOBLocator=0;app=R3 000 00 comm rd ODBC;logintimeout=3;ProtocolCapture=cap_p3836_comm_rd;supresstdscontroltokens=1;SuppressRowFormat=1;SuppressParamFormat=1;

4 ETW000                                                                                                 128  1.998173

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 30131  performing CON                              581  1.998754

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>[ASE Error SQL4002][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Login failed.

4 ETW000                        [ASE Error SQL30131:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost, connection to the next available HA server also failed. All active transactions have been rolled back

4 ETW000                                                                                                  64  1.998818

2EETW169 no connect possible: "DBMS = SYBASE --- "

We tried to login with isql with below command it success

D:\sybase\GSD\OCS-16_0\bin>isql -U sa -S GSD

Password:

1> sp_displaylogin sapsa

2> go

Suid: 4

Loginame: sapsa

Fullname:

Default Database: saptools

Default Language: us_english

Auto Login Script:

Configured Authorization:

        sybase_ts_role (default ON)

        sap_adm (default ON)

Locked: NO

Date of Last Password Change: Oct  1 2015  2:35PM

Password expiration interval: 0

Password expired: NO

Minimum password length: 6

Maximum failed logins: 0

Current failed login attempts: 0

Authenticate with: AUTH_DEFAULT

Login Password Encryption: SHA-256

Last login date:

Exempt inactive lock: 0

(return status = 0)

But when we try login with any other id it gives below error

D:\sybase\GSD\OCS-16_0\bin>isql -U sapsa -S GSD

Password:

Msg 4002, Level 14, State 1:

Server 'GSD':

Login failed.

CT-LIBRARY error:

        ct_connect(): protocol specific layer: external error: The attempt to co

nnect to the server failed.

D:\sybase\GSD\OCS-16_0\bin>isql -U sapsso -S GSD

Password:

Msg 4002, Level 14, State 1:

Server 'GSD':

Login failed.

CT-LIBRARY error:

        ct_connect(): protocol specific layer: external error: The attempt to co

nnect to the server failed.

We also tried as mentioned in note 2181942. Also tried manually upgrading kernel and restarting installation still the same error. Also when we try to open D:\sybase\GSD\ASE-16_0\install\GSD   log file it says access denied

Kindly advice  to resolve the issue

Thanks and Regards

[former_member3043]

Hello,

agree with Cris, you should upload these two files, although I don't think this is related to the -X "password encryption", cause the isql with the sa was working and I would expect also a Msg 1640 before your Msg 4002 that says "Apdative Server requires encryption of the login password on the network". Except you have configured an ISQL part in your ocs.cfg (/sybase/<SID>/OCS-16_0/config).

Did you specified just one password for all logins (sapsa, sapsso and SAPSR3) ? Or are they different ? It might be an idea to 'overwrite' the sapsa password with your sa login:

alter login sapsa with password <sa password> modify password <sapsa password>

go

Then retry to login wiht sapsa, if this works, the password stored in the database are not the correct. You can redo this for sapsso, SAPSR3 and so on also.

You can do this also with sybctrl (see sap note 1796540), but I prefer the old way . So you will use the alter login command and update the secure store also with rsecssfx.

See SAP Note 1706410 for details on how to do it.

Hope this will help.

Kind regards

Stefan

[crisnormand]

Hello,

FYI, I'm moving this post to space.

Running ASE in a Business Suite environment has specific considerations that should be taken in account, ie, in a BS environment, password encryption is activated by default, so you must use option -X when login into ASE, for example:

isql -Usapsa -S<SID> -X

To know what exact error you have during installation, we need to check:

1) sapinst_dev.log , it should provide you a more detailed explanation about the error occurring during SOLMAN installation.

2) ASE errorlog (\sybase\<SID>\install\<SID>.log)

Thanks

Regards,

Cris

[Former Member]

Hello Comp,

Please check following SAP note for some help.

1942379 - Setup password encryption to encrypt login passwords on the network between ASE and isql

Regards

Anand

[Former Member]

Hi HP Comp,

Have you checked the note which anand has mentioned and Also do a DBSL library and kernel upgrade in your system as the default shipment DVD does not have the SSFS support.

Regards,

Ram

[Former Member]

With the sa account can you reset the password?

[Former Member]

Thanks

As per  r3trans -d log the user trying to login is SAPSR3 and our installation is in import abap phase

Can you please advice if its fine to reset password of SAPSR3 also advice the commands to reset password