SAP Knowledge Base Article - Preview

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

Symptom

  • 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 ".


Read more...

Environment

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

Product

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

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.