3310707 - DTP fails with error or dump "An exception with the type CX_SY_OPEN_SQL_DB"

• The DTP run ends with the following errors :

" An exception with the type CX_SY_OPEN_SQL_DB was raised, but was not handled locally or declared in a RAISING clause.
Message no. RS_EXCEPTION000

Database returned the SQL code 270. Error text: not enough values: :30: line 1 col 156 (at pos 155)
Message no. RS_EXCEPTION000

Exception CX_SY_NO_HANDLER logged
Message no. RSBK228 "

• The following dump occurs as well:

Category               ABAP programming error
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_BY_OPEN_SQL_DB
ABAP Program           CL_RSDTIS_OBJECT==============CP

• The below error occurs while activating the transformation:

" Rule (target field: XXXXX group: 01 Standard Group): Formula is empty ".

• SAP BW/4HANA 1.0
• SAP BW/4HANA 2.0
• SAP BW/4HANA 2021
• SAP BW/4HANA 2023

CX_BY_OPEN_SQL_DB , RSDTIS_CLEANUP , DTIS , SE11 , DBSQL_SQL_ERROR , Intermediate Storage Table , Transformation , CL_RSDTIS_OBJECT , Rule , RS_EXCEPTION000 , SQL code 270 , RSBK228 , Formula is empty , Standard Group , target field . , KBA , BW4-DM-DTP , ABAP Orchestration of Data Transfer Process , Problem