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

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

    1970659

      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.