Not able to run query on Flexera Database

GouravBaid · ‎Nov 06, 2019

Users are not able to view data from database side even after setting the session context property as mentioned below:

Query 1:

select * from ComplianceOperator where operatorlogin like '%AP_FNMS_INTEGRATION%'

Query 2:

exec SetSessionContext <enter the ComplianceOperatorIDhere> ,1

ChrisG · ‎Nov 06, 2019

Could you give some more detail about what is going wrong? Is some sort of error being reported, or just no results coming back?

Unless you are running a multi-tenant system, you executing SetSessionContext will have no impact on the SELECT query you're running here. If you are running a multi-tenant system, you will need to use a valid tenant ID when calling SetSessionConext instead of the "1" value you have there currently.

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)