If STMS import queue is locked

Import queue is locked without manual intervention and remains locked.

Below are reasons:

A STOPMARK can be called in a number of ways :

(a) Manually via STMS by choosing Queue -> Close.
(b) Manually via the OS level with command tp setstopmark <SID>.
(c) If you have not set the STOPMARK before starting an import then tp will automatically execute this command and place a STOPMARK at the end of the existing import queue right after the import command has been issued.

You can solve using below

To remove the STOPMARK (manually) then you chose via STMS, Queue -> Open. The OS equivalent is the command tp delstopmark <SID>. This command is normally not needed as tp will automatically remove the marker after an import process has been successfully completed.

If one remains then it means the import process has not completed successfully. Please check for running tp processes and any running imports in the import monitor.

Alternatively a STOPMARK can remain in the import queue if you previously performed an import all with the option "Select All Requests for Later Import".
 In this case all transport requests are marked with umode I, and the STOPMARK is not removed so that you can import the same set of transport requests into another client.

SET_CODEPAGE_FAILED

While configuration STMS if you see below error


Tms alert views


SET_CODEPAGE_FAILED

could not start transport control program tp

following are could be causes:

TP is not registered in the gateway  OR

Lack of authorization when checking secinfo file

Checking CALLTP_* in SM59 (TCP/IP Connections)  and Check the radio button "Registered Server Program" in the destination CALLTP_*

ORA-00019: maximum number of session licenses exceeded

While execute R3trans -d if you get this error "ORA-00019: maximum number of session licenses exceeded"

Need to be increased max sessions using below command.

alter system set sessions=500 scope=spfile; alter system set sessions=500 scope=both


and license max session = 0 means, it allows  "n" number of sessions.