SAP Knowledge Base Article - Public

3447048 - Unable to import data using Multiple Parameters based on HANA Database - SAP Analytics Cloud

Symptom

While trying to enter multiple parameters on an Import Connection based on HANA Database a generic error appears on the Frontend and below error appears on the HAR Traces and on Import job logs:

  • Error Code: "PLUGIN_ERROR\"
    "SAP DBTech JDBC: [2048]: column store error: search parameter error: [2018] A received argument has an invalid value;TABLE/VIEW parameter: ( 'PLACEHOLDER'='$$DATA$$, 'ENTRY1', 'ENTRY2'') not supported."

Environment

SAP Analytics Cloud version: 2024.2.8

Reproducing the Issue

  1. Open SAP Analytics Cloud Tenant.
  2. Go to Model or Public Dimension.
  3. Go to Data Management.
  4. Select the Import job and click on Edit or Create a New import job.
  5. Select the parameter needed and add two entries.  
  6. Click on next and save the job. 
  7. Run the job.
  8. The error appears.

Cause

HANA query with multiple input parameters selected on SAP Analytics Cloud is not supported.

  • Until version 2024.07.XX.

Resolution

A fix has been deployed and all Tenants with Version 2024.08 and higher, will be able to perform the Multiple Input parameter Selection for a HANA based Query.

In any related behavior, create a case under LOD-ANA-AQU for further investigation.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, kba, note, help, knowledge, chart, story, canvas, responsive, model, modeling, connection, tenant, version, HANA, multiple, parameters, parameter, "SAP DBTech JDBC: [2048]: column store error: search parameter error: [2018] A received argument has an invalid value;TABLE/VIEW parameter: ( 'PLACEHOLDER'='$$DATA$$, 'ENTRY1', 'ENTRY2'') not supported.", 2048, column, store, error, 2018, argument, invalid, value, PLACEHOLDER, supported, not , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0