3204172 - ARCHIVED DBSQL_DUPLICATE_KEY_ERROR error when checking STMS Import history

• You get following error when you try to check the import queue or import history in STMS

RFC communications error with system/destination
TMSADM@XX.DOMAIN_YY
open SQL array insert produces duplicate records in the
database.

• In ST22, you can see following dump

Category ABAP Programming Error
Runtime Errors DBSQL_DUPLICATE_KEY_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program SAPLSTFI
Application Component BC-CTS
Date and Time 27.04.2022 09:03:15
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short Text |
| Open SQL array insert produces duplicate records in the database. |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What happened? |
| Error in the ABAP Application Program |
| |
| The current ABAP program "SAPLSTFI" had to be terminated because it has |
| come across a statement that unfortunately cannot be executed. |
---------------------------------------------------------------------------------------------------- 

STMS, IMPORT HISTORY, DBSQL_DUPLICATE_KEY_ERROR, TMS_TS_GET_TRLIST , KBA , BC-CTS-TMS , Transport Management System , Problem