SAP Knowledge Base Article - Public

3039470 - dberror(PreparedStatement.executeQuery): 340 - not all variables bound: unbound parameter : 2 of 3, 1 out of 1 batches - SAP Analytics Cloud

Symptom

After adding a Parent-Child hierarchy in a specific public dimension then trying to save the changes, below error happens:

dberror(PreparedStatement.executeQuery): 340 - not all variables bound: unbound parameter : 2 of 3, 1 out of 1 batches

Environment

SAP Analytics Cloud version 2021.2.8

Reproducing the Issue

1. Connect to the SAC tenant

2. Browse > Dimensions > Public Dimension: "Pub_Dim1"

3. Add a new parent-child hierarchy

4. Maintain <root> for # member

5. Click Save

Cause

If you change a public dimension from the dimension list which has data access control enabled in the following way:

  • Add a first hierarchy
  • delete the first hierarchy

then this database error occurs.

Resolution

Perform the belwo actions:

1. Turn off data access control.

2. Save dimension

3. Add hierarchy

4. Turn data access control on again

 Note: You need to setup the data access control data again.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, DAC, parent-child hierarchy, public dimension , KBA , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0