Power

post updating rpm package from 4.15.1.1011 to 4.15.1.1013 we are getting issues running gpg commands in app user whereas it is working fine as root.

gpg --list-keys

//.gnupg/pubring.gpg
-------------------

error while running same command from App user ID:

gpg --list-keys

Could not load program gpg_64:
Symbol resolution failed for gpg_64 because:
        Symbol _GLOBAL__AIXI_libsqlite3_so (number 334) is not exported from dependent
          module /usr/lib/libsqlite3.a[libsqlite3.so.0].
        Symbol _GLOBAL__AIXD_libsqlite3_so (number 335) is not exported from dependent
          module /usr/lib/libsqlite3.a[libsqlite3.so.0].
Examine .loader section symbols with the 'dump -Tv' command.

Normally, RPMs installed on AIX are installed under /opt/freeware/bin (executables) or /opt/freeware/lib (libraries).

If you installed an RPM package for gpg, libsqlite3 or other, most likely the libraries are installed in the above directories above.

If root is able to run the gpg command without any issues, it is likely because it has an update LIBPATH (or LD_LIBRARY_PATH) variable which contains the lib directory mentioned above, but the regular user does not. If that is the case, then update the .profile (or .kshrc or .bashrc) and update the LIBPATH or LD_LIBRARY_PATH to include /opt/freeware/lib (or whatever directory you installed the RPM under, if not the default).

Also, please note that the /usr/lib/libsqlite3.a or /usr/lib/libsqlite3.so files are files included in the rpm.rte fileset (not necessarily related to the RPM version of those files)

# rpm -qa | grep sql
sqlite-3.41.2-1.ppc

# lslpp -f rpm.rte | grep sql
                        /usr/opt/rpm/lib/libsqlite3.a
                        /usr/opt/rpm/old_rpmdb/lib/libsqlite3.so

# ls -l /usr/lib/libsq* /opt/free*/lib/libsq*
-rwxr-xr-x    1 root     system     13921375 Mar 31 2023  /opt/freeware/lib/libsqlite3.a                                       # these files are from the sqlite3 RPM 
-rwxr-xr-x    1 root     system      6506788 Mar 31 2023  /opt/freeware/lib/libsqlite3.so                                      # these files are from the sqlite3 RPM

lrwxrwxrwx    1 root     system           29 Jun 28 00:40 /usr/lib/libsqlite3.a -> /usr/opt/rpm/lib/libsqlite3.a         # these files are from the rpm.rte fileset
lrwxrwxrwx    1 root     system           30 Nov 21 2023  /usr/lib/libsqlite3.so -> /usr/opt/rpm/lib/libsqlite3.so    # these files are from the rpm.rte fileset

Based in the error that you are getting, it is likely that the gpg command is picking up the libsqlite3.a file from the rpm.rte fileset location instead of the one for sqllite3 RPM