Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Non-system session variable is not initializing

User_SMJFFAug 3 2011 — edited Aug 3 2011

Hi,

I have created a non-system session variable using Row wise initialization, and using it in answers to filter a column. it is displaying below error

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 23006] The session variable, NQ_SESSION.Visible_All_Offices1, has no value definition. (HY000)

I have tried all possible ways like giving the session variable in SQL result set, giving with quotes and without quotes. In all ways it is throwing the same error.

I think this variable is not getting initialized when starting the session, is there any way to check it. this variable is also not showing in Manage > Sessions > Variables in OBIEE Admin.

Please reply, if anyone faced similar issue. I am trying this from last 2 days.

Thanks,
Ash.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2011

Added on Aug 3 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

7 comments

454 views