Get error when date Dashboard prompt is passed to presentation variable.
I am getting following error when date from dashboard prompt is passed to Presentation variable. Is there any solution to overcome this error.
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: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 22025. [nQSError: 22025] Function Calendar Extract is called with an incompatible type. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Workforce Management - Workforce Trend Real Time"."Grade"."Grade Name" s_1, "Workforce Management - Workforce Trend Real Time"."Time"."Calendar Month End Date" s_2, "Workforce Management - Workforce Trend Real Time"."Time"."Month" s_3, CASE WHEN "Workforce Management - Workforce Trend Real Time"."Grade"."Grade Name" ='Governor' THEN 1 WHEN "Workforce Management - Workforce Trend Real Time"."Grade"."Grade Name" ='Deputy Governor' THEN 2 WHEN "Workforce Management - Workforce Trend Real Time"."Grade"."Grade Name" ='Special Advisors' THEN 3 WHEN "Workforce Management - Workforce Trend Real Time"."Grade"."Grade Name" ='Scale A' THEN 4 WHEN "Workforce Management - Workforce Trend Real Time"."Grade"."Grade Name" ='Scale