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:
- On the new application server, the password of SAP<SID> user is identical with the one maintained on Primary application server.
- 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
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.