SAP Knowledge Base Article - Preview

2243643 - "Error 6.900" or "inconsistent datatype" error happens during a DTP load

Symptom

One of the following error messages happens during the load with the help of a DTP (the source and the target can be any InfoProvider):

  • Error 6.900 has occurred in the SAP HANA/BWA server
    Attribute engine failed;exception 6900:
    AttributeEngine/Parallel/Aggregation.cpp:419 engine failed;
    $function$=createAggregatorL
    Error 6.900 has occurred in the SAP HANA/BWA server
    Error reading the data of InfoProvider "xyz"
    Error while extracting from source "abc" (type InfoProvider)
    Data package processing terminated
    Data package 1 / 27.03.2015 09:42:49 / Status 'Processed with Errors'
  • RS_EXCEPTION000: inconsistent datatype: only numeric type is available for SUM/AVG/STDDEV/VAR function: line 1 col 2953 (at pos 2952)

 The work process trace of the failed DTP job contains the following information:

C *** ERROR => prepare() of C_0241, rc=1, rcSQL=266
[dbsdbsql.cpp 1443]
C {root-id=DA79692C31031ED6A1943E120FF187A1}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => PREPARE C_0241 on connection 0, rc=266
[dbslsdb.cpp 9347]
C SQLCODE : 266
C SQLERRTEXT : inconsistent datatype: only numeric type is available for SUM/AVG/STDDEV/VAR function: line 1 col 29\


Read more...

Environment

  • SAP NetWeaver 7.3
  • SAP NetWeaver 7.4
  • SAP NetWeaver 7.5

Product

SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

Business Warehouse, BW on HANA, 7.3, 7.4, infocube, openhub, open hub, advanced datastore object, adso, odso, dso, cube, RS_EXCEPTION 000 , KBA , BW-WHM-DBA-IOBJ , InfoObjects , BW-WHM-DST-DTP , Data Transfer Process , BW-WHM-DBA , Data Basis , BW-WHM-DBA-ODS , DataStore Object (classic) , HAN-DB-ENG-BW , SAP HANA BW Engine , BW-WHM-DBA-ICUB , InfoCubes , BW-WHM-DBA-ADSO , DataStore Object (advanced) , Problem

About this page

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

Search for additional results

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