SAP Knowledge Base Article - Preview

3578054 - Dump SAPSQL_DATA_LOSS in SAP Queries with LANGU / SPRAS.

Symptom

After and upgrade or implementing SAP Note 3001691, dumps with the error SAPSQL_DATA_LOSS are being observed in SAP Queries related reports. The section 'Source Code Extract' contains a SELECT statement using LANGU / SPRAS with a 2 char language key, like:

|>>>>>|    select single MAKTG , MATNR , SPRAS   |
|  131|                  from MAKT                                |
|  132|            where MATNR = @MARA-MATNR       |
|  133|             and SPRAS = 'EN'                           |  

Or

|>>>>>|    select single MAKTG , MATNR , SPRAS   |
|  131|                  from MAKT                                |
|  132|            where MATNR = @MARA-MATNR       |
|  133|             and LANGU = 'EN'                           |   


Read more...

Environment

SAP NetWeaver

Product

SAP ERP all versions ; SAP NetWeaver all versions

Keywords

SAP Query, upgrade, language selection, SAPSQL_DATA_LOSS, Basis 7.41/28, Basis 7.50/29, SQL check, CDS views, note 3001691, Table T002, language key. , KBA , BC-SRV-QUE , SAP Query , 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.