Presentation Variable Prompt causes Error on Results tab, but not in Open link
Summary
AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65PContent
I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}';
Then I created a Presentation Variable prompt for AsOfDate with the following:
Default Selection: Variable Expression @{system.currentTime}[MM/DD/YYYY]
This works when I run the analysis from the Open link, but when I am in Edit mode I get the following error on the Results tab:
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: ADFException-1004: Invalid/empty ADF query. (HY000)
Tagged:
0