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-ADSO , DataStore Object (advanced) , BW-WHM-DBA-ICUB , InfoCubes , 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.