SAP Knowledge Base Article - Preview

3220765 - Dump DBSQL_CONVERSION_ERROR when executing the report RC_COLLECT_ANALYSIS_DATA

Symptom

Job RC_COLLECT_ANALYSIS_DATA cancels due to the following error:

Start to collect SLT replications data
Internal session terminated with a runtime error DBSQL_CONVERSION_ERROR (see ST22)

In the meanwhile, the following short dump appears when executing the report RC_COLLECT_ANALYSIS_DATA for Readiness Check,

Category ABAP programming error
Runtime Errors DBSQL_CONVERSION_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program RC_COLLECT_ANALYSIS_DATA
Application Component SV-SMG-CM

Short Text
Conversion not possible.

Error analysis   
......
Either the conversion is not supported for the target field type, the target field is too small to take the value, or the data does not have the required format for the target field. The value to be converted is "4646186579 ". Field "???" in the select list was just being edited. The table field has ABAP type 8 length 8 with 0 decimal places. The ABAP field has type "I" length 4 with 0 decimal places.

Source Code Extract

| 2559| if sy-subrc = 0. |
| 2560| <ls_result>-counter = <ls_triggers_counter>-counter. |
| 2561| else. |
| 2562| clear lv_counter. |
| 2563| |
|>>>>>| select count(*) |
| 2565| into lv_counter |
| 2566| from (<lv_value>).

Contents of system fields

|SY-TITLE|SAP Readiness Check for SAP S/4HANA - Collect Analysis Data |
|SY-MSGTY|I |
|SY-MSGID|00 |
|SY-MSGNO|001 |
|SY-MSGV1|Start to collect SLT replications data


Read more...

Environment

SAP Netweaver ABAP

Product

SAP S/4HANA 1909

Keywords

 DBSQL_CONVERSION_ERROR; CX_SY_OPEN_SQL_DB; RC_COLLECT_ANALYSIS_DATA; , KBA , SV-SCS-S4R , SAP Readiness Check , 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.