Error 14378 updating _Connect-CachingType VST with SELF service connections

Why error does 14378 with Self service connections and not client/server?
Why is error 14378 not reflected in ERROR-STATUS?
Why does NO-ERROR fail to suppress error 14378?
Why is the  _Connect-CachingType not updated?

The 14378 message is not an error as far as the ABL is concerned. It's an informational message from the database layer which goes to standard output, which for the ABL client is the screen and for the database server (when connected client/server) is the database log file. This has been like this forever for this specific message.

The code provided has the NO-ERROR on the field assignment but the message is shown when the record is written to the database, at the end of the record scope. So you would have to have a RELEASE statement with the NO-ERROR to avoid seeing the message altogether. Since the code has a FOR EACH, the record will be written at the end of the record scope, which is the end of the FOR EACH iteration, in which case the message cannot be supressed.

The field is not updated (and the reason why the message is displayed) because the code is trying to set the statement cache for the BROKER, which is not allowed - you can only set it for clients and the server processes: "SELF,REMC,SERV,SQSV".

When setting _Connect-CachingType, connections other than SELF,REMC,SERV,SQSV (eg "BROK","WDOG","MON") are not supported by Client Database-Request Statement Cache.

Ensure that the ABL code will select only users of these types to update the _Connect-CachingType:

Example:

DEFINE VARIABLE i          AS INTEGER   NO-UNDO.
DEFINE VARIABLE j          AS INTEGER   NO-UNDO INITIAL 1.
DEFINE VARIABLE vInputList AS CHARACTER NO-UNDO
    INITIAL "SELF,REMC,SERV,SQSV":U.

DO j = 1 TO NUM-ENTRIES(vInputList):
    FOR EACH _connect WHERE _connect._Connect-type = ENTRY(j, vInputList):
        DISP ENTRY(j, vInputList) _Connect-Name (_Connect-Id - 1) _Connect._Connect-CachingType.
    END.
END.