5 Replies Latest reply: Jan 28, 2014 3:11 AM by Srini VEERAVALLI RSS

[nQSError: 23006] The session variable, NQ_SESSION.S_Budgetary_Control, has no value definition.

1970659 Newbie
Currently Being Moderated

Hi All,

 

I have created a Initialization block named Budgetary_Control

 

the query entered in the data source is

 

select

     column

from

     table

where

     user_name=':USER';

then i selected a connection pool and tested with 2 USER

and it gave me expected result.

 

 

in the Edit data target i gave a name to this variable as S_Budgetary_Control and a default valus as -1

 

 

i checked on row wise initialization test again

 

it show me multiple record.

 

the i save the rpd and deployed the same to the server.

 

now when i trying to create a report using this varriable like VALUEOF(NQ_SESSION.S_Budgetary_Control) it gave me error like

[nQSError: 23006] The session variable, NQ_SESSION.S_Budgetary_Control, has no value definition.

 

Please help me to get rid of this issue.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points