[nQSError: 23006] The session variable has no value definition

Question

Hi All,

I am facing issues when referencing a session variable from a session variable. Let me explain.

My requirement is to find the minimum transaction time for the latest date. The user has ability to change the date thru a prompt.

So, I created a session variable to be used as a request variable to find the Max date. I then created another initblock to find the Min time using this request variable. Both the Init blocks are working fine and returning correct results when doing a Test.

My request variable is working as expected. However, I am getting the mentioned error when using the Min Time session variable in the report.

Init Block 1 (for request variable) - select max(TRANSACTION_DATE) from TRANSACTIONS

Request Variable name - MAX_TRANS_DT

Init Block 2 -

select to_char(min(TXN_TIME), 'mm/dd/yyyy hh24:mi:ss') from TRANSACTIONS where TRANSACTION_DATE = to_date('VALUEOF(NQ_SESSION.MAX_TRANS_DT)', 'yyyy-mm-dd hh24:mi:ss')

Any help is greatly appreciated.

Gianni Ceresa · Answer

Good that you have you 2 variables and no error anymore

So you can maybe close the thread? For now it's still This question is Not Answered.

user4839281 · Answer

Hi Gianni, I had it deleted but was using the wrong variable name . Thanks for your help. Works perfectly.

Gianni Ceresa · Answer

You maybe still have the second init bloc defined? (you forgot to delete it...)