SAP Knowledge Base Article - Preview

3324134 - DB6: SQL30082N reason "24" on newly installed additional application server

Symptom

You have successfully installed a new application server using in addition to Primary application server instance.
R3trans works on primary server, but it still fails with SQL30082N reason code "24" on new application server.

You have confirmed the follows: 

  1. On the new application server, the password of SAP<SID> user is identical with the one maintained on Primary application server.
  2. On database server, command "db2 connect to <SID> user sap<sid> using <password of sap<sid>>" finishes without issue.

trans.log

4 ETW000 date&time   : 06.04.2023 - 06:06:05
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]  Thu Apr   6 06:06:05 2023
4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/ABC/SYS/exe/run/dbdb6slib.so' ...
4 ETW000  [     dev trc,00000]  Library '/usr/sap/ABC/SYS/exe/run/dbdb6slib.so' loaded
4 ETW000  [     dev trc,00000]  Version of '/usr/sap/ABC/SYS/exe/run/dbdb6slib.so' is "753.02", patchlevel (0.900)
4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): DBSL supports extended connect protocol
4 ETW000                         ==> connect info for default DB will be read from ssfs      <<<<<<
4 ETW000  [     dev trc,00000]  DB6 (DB2 UDB) UNICODE database interface 753.02 [opt]

...

4 ETW000  [     dev trc,00000]  DB2 library has been loaded.
4 ETW000  [     dev trc,00000]  Info: successfully loaded DB2 library '/usr/sap/ABC/SYS/global/db6/AIX_64/db6_clidriver/lib/libdb2.a(shr_64.o)' 
4 ETW000  [     dev trc,00000]  Running with UTF-8 Unicode
4 ETW000  [     dev trc,00000]  DB2 client driver version '11.05.0501'
4 ETW000  [     dev trc,00000]  Running with CLI driver.
4 ETW000  [     dev trc,00000]  Thu Apr   6 06:06:06 2023
4 ETW000  [     dev trc,00000]  *** ERROR in DB6Connect[/bas/753_REL/src/dbs/db6/dbdb6.c, 1961] CON = 0 CACHEID = -1 (BEGIN)
4 ETW000  [     dev trc,00000]  &+     DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL30082N  Security processing failed with reason "24" ("USERNAME 
4 ETW000  [     dev trc,00000]  &+     AND/OR PASSWORD INVALID").  SQLSTATE=08001                                                                        
                                                                                                                      
4 ETW000  [     dev trc,00000]  *** ERROR in DB6Connect[/bas/753_REL/src/dbs/db6/dbdb6.c, 1961] (END)
4 ETW000  [dbdb6.c     ,00000]  *** ERROR => DbSlConnect to 'ABC' as 'sapabc' failed


Read more...

Environment

  • IBM Db2 on Linux, Unix and Windows 
  • SWPM 1.0 SP36 or higher
  • SAP NetWeaver 7.5 or higher
  • SAP Kernel is 7.49 or higher

Product

SAP NetWeaver 7.5

Keywords

secure storage, read_con_info_ssfs, rsdb/ssfs_connect, SQL30082N, 24, profile , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.