BO Version - BO4.1 SP6 Patch7
After BO plantform patch update, we are getting a below query script generation issue while refreshing the webi report. But before patch upgrade it was working fine.
Bex --> Direct BICS --> WEBI
Report is running fine for the first refresh. We are getting this below issue, when we try to change the user input value of prompt (user input enabled Text variable from Bex) in second refresh. If we didn't give/ change user input values of prompt (user input enabled Text variable from Bex), this error will not occur. Only the user input enabled text variable is causing this issue. (User input enabled text variable is being included in key figures description)
We have raised this concern to SAP. As per the SAP workaround, we have re-created the BO report. But still we are facing the same issue.
Any idea why text variable is not supported after patch upgrade. Kindly let me know if you know about this issue & have any work around for this issue.
(For temporary fix we are going to remove this variable from BEx. Instead of this we are going to use formula variable to get the user input)