Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Prompt in WebI causes Syntax error

Hi Colleagues,

we´re using BI Platform 4 and I have a report based on a Universe which is based on a HANA calculation view.

Whithin the report I use prompt query filters based on parameters and value lists which are defined in the data foundation. The report was running fine until I changed it.

I added two fields in the HANA view and refreshed the universe. Also I added one more value list and parameter in the universe which is also used as prompt input in the report. I did all the changes step by step, checking the refresh after every step and it worked. Once I saved the report, closed it and reopened I get the error :

Database error: [SAP AG][LIBODBCHDB DLL][HDB] Syntax error or access

violation;257 sql syntax error: incorrect syntax near "@": line 24 col

29 (at pos 647). (IES 10901)

SQL Script from Query Panel:

SELECT

  Table__1."BLD_SYSTEM_ID",

  Table__1."BLD_SYSTEM_ROLE",

  Table__1."BLD_BUSINESS_SYSTEM_TYPE",

  Table__1."SID_CLIENT",

  Table__1."CLIENT_ID",

  Table__1."TENANT_NUMBER",

  Table__1."CUSTOMER_ID",

  Table__1."CUSTOMER_NAME",

  Table__1."BUSINESS_TENANT_TYPE",

  Table__1."DESCRIPTION",

  Table__1."WORKCENTERVIEW",

  Table__1."TITLE",

  Table__1."DATE",

  Table__1."HOUR_SLOT",

  Table__1."MIN_SLOT",

  sum(Table__1."E2E_STEPS_COUNT"),

  sum(Table__1."E2E_FRONTEND_TIME"),

  sum(Table__1."E2E_NETWORK_TIME"),

  sum(Table__1."E2E_BACKEND_TIME")

FROM

  "_SYS_BIC"."dcsa/BYD_TENANT_WL_OVERVIEW"  Table__1

WHERE

  Table__1."DATE"  BETWEEN  @prompt('Evaluation Period Start','D',,Mono,Free,Not_Persistent,,User:0)  AND  @prompt('Evaluation Period End','D',,Mono,Free,Not_Persistent,,User:1)

GROUP BY

  Table__1."BLD_SYSTEM_ID",

  Table__1."BLD_SYSTEM_ROLE",

  Table__1."BLD_BUSINESS_SYSTEM_TYPE",

  Table__1."SID_CLIENT",

  Table__1."CLIENT_ID",

  Table__1."TENANT_NUMBER",

  Table__1."CUSTOMER_ID",

  Table__1."CUSTOMER_NAME",

  Table__1."BUSINESS_TENANT_TYPE",

  Table__1."DESCRIPTION",

  Table__1."WORKCENTERVIEW",

  Table__1."TITLE",

  Table__1."DATE",

  Table__1."HOUR_SLOT",

  Table__1."MIN_SLOT"

There are two more prompts which are not in the Script, these are optional. I noticed that, sometimes I get to the point of selecting values for the prompts, sometimes the error occurs before the selection screen comes up. Also, sometimes I can open and run the report 2 or 3 times and the error happens at the fourth.

Until now I tried the following:

1. I removed all prompts and added them one by one again, checking the refresh. Sometimes it works until I save the report and reopen it and the error occurs on reopen. Sometimes the error occurs already after adding the second prompt.

2. I rebuilt the universe and report from scratch using WebI prompts instead of the universe parameters. This seemed to work. But after saving and reopening - same error.

3. I checked the refresh of the data preview in the query panel as well as the same query built in the universe - this always works fine.

Any hint is very appreciated.

Thanks and best regards,

Katja

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question