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
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-DSO , 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.
SAP Knowledge Base Article - Preview