OBIEE Upgraded from 11g to 12c, the rpd of 11g is giving errors in 12c

Nikhila reddy

Hi there,

obiee is upgarded from 11g to 12c where 11g rpd i tried opening through 12c Administration tool, when i check the consistency it is throwing the following errors. please share your inputs to solve this issue.

38197] Data filter expression "Core"."Dim - Customer"."Hierarchy Based Login" =  VALUEOF(NQ_SESSION."USER") for Application Role "Primary Employee/Position Hierarchy-based Security" is considered as non conditional, error: [nQSError: 23006] The session variable, NQ_SESSION.USER, has no value definition..

[38197] Data filter expression "Core"."Dim - Opportunity"."Hierarchy Based Login" =  VALUEOF(NQ_SESSION."USER") for Application Role "Primary Employee/Position Hierarchy-based Security" is considered as non conditional, error: [nQSError: 23006] The session variable, NQ_SESSION.USER, has no value definition..

[38197] Data filter expression "Core"."Dim - Order"."Hierarchy Based Login" =  VALUEOF(NQ_SESSION."USER") for Application Role "Primary Employee/Position Hierarchy-based Security" is considered as non conditional, error: [nQSError: 23006] The session variable, NQ_SESSION.USER, has no value definition..

[38197] Data filter expression "Core"."Dim - Position Security"."Hierarchy Based Column" =  VALUEOF(NQ_SESSION."USER") for Application Role "Primary Employee/Position Hierarchy-based Security" is considered as non conditional, error: [nQSError: 23006] The session variable, NQ_SESSION.USER, has no value definition..

[38197] Data filter expression "Core"."Dim - Position"."Hierarchy Based Login" =  VALUEOF(NQ_SESSION."USER") for Application Role "Primary Employee/Position Hierarchy-based Security" is considered as non conditional, error: [nQSError: 23006] The session variable, NQ_SESSION.USER, has no value definition..

Thanks,

Nikhila

[Deleted User]

USER having no value definition sounds fishy since it is a system session variable.

Do you have any init blocks which overwrite the session variable? Respectively write something else into it?

Nikhila reddy

Thank you for replay

We have Initialization Block for user, where this rpd is not throwing any error when i use this in 11g, when i open this in 12c Administartion tool it is giving this session variable errors.

[Deleted User]

Ok: WHY? What's the point of that?!

Nikhila reddy

OBIEE got upgraded to 12c, rpd which is deployed in 11g now i want to deploy the same rpd in 12c.

when am opening the 11g rpd using 12c Administration tool it is giving this errors.

->how to migrate from rpd from 11g to 12c.

can you please help me on this

Thanks,

Nikhila

Gianni Ceresa

You can't expect that a totally different version (12c) works exactly as the old one (11g), or what would be the reason for the new version to exists?

There are changes in 12c and security is exactly one of the things which changed with things like security groups finally not supported anymore (it was few years that the doc said they had to migrate to application roles). Often in 11g people had, like in 10g, init blocks playing with security.

So if you don't explain why you have that init block setting the value of :USER to something else than what it's supposed to be, what other answer do you expect?

Explain why did things in your 11g and you will get suggestion on how to fix it.

If you expect a "click here to fix all the issue" button, stop looking for it.

An upgrade is not really a "next next next finish" operation.

Now it's up to you: you can answer question of people trying to help you and provide as many information as you can, or hire somebody to do the job.

[Deleted User]

My point is: What's the use of that intialization block at all? S_USER sounds like Siebel CRM but that whole process is pointless. You go with the user name into the user table to get the user...

Sherry George

Oracle support has some documentation for this error. Not sure if it applies to your case, but may be worth taking a look

Doc ID 2285536.1

[Deleted User]

Sherry the problem is that the system session variable USER was re-initialized. 12c doesn't like that and already warns you when you're even attempting to create an init block targetting that variable

Sherry George

Hi Chris,

Okay I was just going by the error, didn't look into the details. Having said that, the init block is straight out of the box for BI apps. And as you said 12c doesn't like that and OP needs to clarify what is the need.

[Deleted User]

Since when is BI Apps anything even remotely close to best practices?