Skip to Content
avatar image
Former Member

HANA Input parameters/ Variable Error in BO 4.2 SP3

Web i report filter prompts give an error massage (HANA Input parameters/ Variable gives an error after upgrade BO 4.2 SP3.)

Error "The only authorized SQL statement is select. Empty SQL statement (IES 00020)"error.gif

Wrokflow:

1. Webi report consume HANA input parameter/variable.(Existing)

2 Upgrade BO 4.2 SP3 .

3. Refresh the Universe Data foundation (.Unx )

4. HANA Input parameters/ Variable gives an error after upgrade BO 4.2 SP3.)

Error "The only authorized SQL statement is select. Empty SQL statement (IES 00020)"error.gif

error.gif (9.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 29, 2017 at 05:27 PM

    Hi,

    There must security assigned on the views and your analysis is not generating SQL statements.

    In WebI >> Query Builder>> Open SQL code to verify.

    Few attributes may not be available when you did migration. Remove incompatible objects and refresh the report.

    Goto Data tab in WebI>> Edit source>> select the same HANA view>> and refresh the query, It should pop up another window with incompatible objects within query.

    If you have combined query.. Validate the 2nd one too.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2017 at 04:02 PM

    Please re-create the DataFoundation

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2017 at 11:31 AM

    Hello Amish,

    have you solved this problem? I´m facing the same error.

    Thanks and regards

    Mariele

    Add comment
    10|10000 characters needed characters exceeded