SQL prefix for 'As of' Date getting ADFS error

Content

Hello, 

I have a sql prefix set as SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}';

I'm all of a sudden getting this error:

State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G (HY000)

I read I need to update the prefix to this:

SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}';

When I do that I still get an error. Could someone give me a second set of eyes on this? Maybe I'm just missing a needed change with my filter or prompt. 

Appreciate any guidance. My xml is attached.