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)
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
Hello Amish,
have you solved this problem? I´m facing the same error.
Thanks and regards
Mariele