SAP Knowledge Base Article - Preview

2391990 - ODP-BW: Function NOP is not supported aggregate function

Symptom

During data loading from Advanced DataStore Object (aDSO) (SAP BW) to another SAP Business Warehouse via Operational Data Provisioning interface fails with the following error in the target BW system:

groupby.PNG

Also the replication test in RODPS_REPL_TEST (SE38) fails with the following error:

Error while accessing
Error while extracting from source XXXX (type Datastore)
not a GROUP BY expression: The function NOP is not supported aggregate function or 'XXXX' must be in group by clause.: line 1 col 2504 (at pos 2503)
Error while accessing
Error while extracting from source XXXX (type Datastore)
not a GROUP BY expression: The function NOP is not supported aggregate function or 'XXXX' must be in group by clause.: line 1 col 2504 (at pos 2503) 

 

Furthermore the ODQ Request job finished with the following errors:

---
Job started

Step 001 started (program ODQ_TASK, variant VARIANTNR, user ID USERID)

Start of processing for request {TIMESTAMP} delayed by 0 seconds
Group request {TIMSTAMP} for queue BW/XXXX$F
The selection conditions for the request are... (see subsequent messages)
Everything
Extraction is starting: Extraction mode 'F', package size NNNN.
Extractor initialized
Exception occurred in line 36 of include CL_SQL_STATEMENT==============CM004 (program CL_SQL_STATEMENT==============CP)
Exception occurred in line 290 of include CL_RSDRS_SQL_QUERY============CM01C (program CL_RSDRS_SQL_QUERY============CP)
Error while extracting from source PFAP12 (type Datastore)
Exception occurred in line 213 of include CL_RSDSO_X_ADSO_CMD===========CM005 (program CL_RSDSO_X_ADSO_CMD===========CP)
Error while accessing
Exception occurred in line 96 of include CL_RSODP_BW_CURSOR============CM00A (program CL_RSODP_BW_CURSOR============CP)

Job finished
---


Read more...

Environment

  • SAP NetWeaver 7.4
  • SAP NetWeaver 7.5
  • SAP enhancement package 1 for SAP NetWeaver 7.5
  • SAP BW/4HANA 1.0

Product

SAP BW/4HANA 1.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

No-operation, NOP1, NOP2, adso, odp, odq, odqmon, odqr, bw, sap bw, CL_SQL_STATEMENT, CL_RSDRS_SQL_QUERY, CL_RSDSO_X_ADSO_CMD, CL_RSODP_BW_CURSOR, GROUP BY, SQLERRTEXT, SQLCODE, 277, DECIDE_UPON_AGGREGATION   , KBA , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , 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.