SAP Knowledge Base Article - Public

3313192 - error "Invalid new element, level to high: 7 but expected 6" while inserting data source

Symptom

1. When inserting data source, error "Invalid new element, level to high: 7 but expected 6" occurs.

Below error is in AO log.

=========

>> Bali Exception:
Invalid program status\: Invalid new element, level to high: 7 but expected 6

2. The query works fine in T-cd: RSRT.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1.  Open Analysis for Office.
  2.  Insert data source.
  3.  Press OK button on prompts.
  4.  Error occurs.

Resolution

With the RSADMIN parameter "RS_USE_RESULT_OPS" set to the value "N" the frontend specific implementation of the result set operations are used. It's recommended to use the report "SAP_RSADMIN_MAINTAIN" (SE38) to maintain RSADMIN parameters.

  • RS_USE_RESULT_OPS = N

Keywords

  data source, BICS, element, RS_USE_RESULT_OPS , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-WJR-BICS , BI Consumer Services , Problem

Product

SAP Analysis for Microsoft Office all versions