Skip to Content
0

HANA Input parameters/ Variable Error in BO 4.2 SP3

Mar 25, 2017 at 12:59 AM

246

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jyothirmayee A Mar 29, 2017 at 05:27 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 25, 2017 at 04:02 PM
0

Please re-create the DataFoundation

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 13, 2017 at 11:31 AM
0

Hello Amish,

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

Thanks and regards

Mariele

Share
10 |10000 characters needed characters left characters exceeded