Prompt is showing error, while i use the multiple subject area through Logical SQL

Hi Friends,

I am trying to add a prompt to an OTBI report, But I end up with some error.

I have used two subject areas and wrote a logical SQL.

Subject area Used:

1) Workforce Goals - Goal Tasks Real Time,

2) "Workforce Goals - Goal Status Overview Real Time"

The errors are as follows:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 27002. [nQSError: 27002] Near <WHERE>: Syntax error (HY000)

State: HY000. Code: 26012. [nQSError: 26012] . (HY000)

Regards,

Partha