STMS: ERROR: environment variable dbms

Your activity on STMS, transport import is failing due to below error,

This is tp version 381.21.46 (release 753, unicode enab
ERROR: No connect due to DbSl Load Lib Failure
ERROR: environment variable dbms_type is not set.
ERROR: Connect to SID failed (20210427062557).
INFO: no trace information stored

tp returncode summary:

TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0249
tp finished with return code: 249
meaning:
  connect failed due to DbSL load lib failure

standard output from tp and from tools called by tp:

Solution

Check the environment is maintain correctly. Use transaction code SE38 and report RSBDCOS0. Execute command “set” for Windows OS or “env” for unix OS.

Check the output list to confirm if “DBMS_TYPE” is correctly set.

If not, set the environment variable, dbms_type & profile parameter, dbms/type.

Some information taken from SAP Note 1966797 – Errors: connect failed due to DbSL load lib failure,

dbms_type is an environment variable at the OS level, not a profile parameter.
If you change the value of an environment variable, you should reboot the application server.
In some rare cases if this doesn’t work, you need also restart the OS server.
For Windows environments, the output of “set” command as per point 1 above will display the environment of the SAPService user.
If the database related environment variables (such as DBMS_TYPE) are missing from the SAPService environment, check note 128126 under “Setting the environment variables for the SAP service”.