Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12c, session variable error "[nqsError: 23006] The session variable, NQ_SESSION."variable nam
Hi All,
Here is the scenario.
I created a non-system session variable in the RPD and a request variable in answers dashboard prompt (both with same name, including case). In the RPD, i defined a default value as well for the session variable and the connection also established (when i hit "test" shows the variable and its default value)
In the front end, i created a simple report and one of the column is being filtered using the prompt created with request variable.
But once i run the report i see below error:
State: HY000: Code: 23006: [nQSError: 23006] The session variable, NQ_SESSION.("my variable name") has no value definition.
i did some online search and read suggestions like assign a default value for session variable in RPD (which i already did), still see this error.
Please suggest what might be causing this.
Thanks in advance.
Answers
-
The object is called an "analysis". Not a "report". Two different objects. Two different technologies.
An "analysis" and a "report" are not the same thing just because both display data. Same as a liver is not a heart becauset both are organs. It's probably best if a surgeon doesnt use these terms as interchangeable....
0 -
Agree, my mistake
0 -
What exact version of 12c?
Did you refresh metadata if you were changing the RPD online?
Did you logout - login in between the changed?
Did you try to just display the value of your variable in a dashboard page using a text block? Do you see it?
0 -
Hi Gianni,
Version is 12.2.1.4.0.
1. i did not made any online changes
2. yes, i logged out after deploying RPD, and logged in.
3. yes, i can see the default variable value in the dashboard text block.
Thanks.
0 -
So you maybe have a wrong syntax to reference it ...
What is the exact formula / code / expression using it?
0 -
It is a simple column which i have added to an existing MS SQL Server stored procedure.
FYI the original stored proc definition's select statement do not contain this column but one of the tables in the same database has this column. I added this column in the RPD physical layer.
----------------------------------------------------------------------
create procedure [xyz].[procedure name] @variable-name char()
as
select
col A,
col B,
col C from table d join table e
where
d."variable-name" = @variable-name
-------------------------------------------------------------
0 -
Gianni meant what's the statement you got in our init block.
0 -
I actually meant any kind of real code where it's used.
The error is about an analysis being filtered on a prompt, the prompt uses the variable. It's highly confusing also because every time it's hand-written pieces of error message or pseudo code.
And I stopped counting the number of times it was a syntax mistake when using variables, also because there are few ways to reference the same thing.
There isn't much confidential thing in a variable name...
@2711084 if privacy is a concern a SR is what you look for as it's between you and Oracle.
0 -
Ok
0 -
Usually variable names shouldn't have any space in between its name
..although not tried yet..can you try myvariable instead of my variable.
Also you cannot use a request variable with @ .it should be referenced with nqsession.variable name
0
