Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tihlex
Contributor II
Contributor II

How to execute all query in one session

Hi everyone. I have a problem.

  1. I select 2 parameters on selection app (DT and ID)
  2. In on-demand app I call a procedure (ORACLE) with these parameters like this:
    1. Set call proc_name(DT) !EXECUTE _NON_SELECT_QUERY;
    2. Set call proc_name(ID) !EXECUTE _NON_SELECT_QUERY;
  3. The view is created with data based on these parameters
  4. I select data from view.

In dev it is work very well.

But in production we have a problem: every query execute in new session. And when we select data from view, view is empty.

My question: how to execute all query in one session? Mybe some setting in qlik (qmc)?

Labels (1)
1 Solution

Accepted Solutions
tihlex
Contributor II
Contributor II
Author

We updated our qlik sense stand and problem fixed.

View solution in original post

4 Replies
Mario_Petre
Support
Support

Are you using the native Oracle connector? Also, have you verified your connection details for any differences between Single Node and Production? 

tihlex
Contributor II
Contributor II
Author

We use standart oracle conector in Qlik Sense. Connection details is same, credentional difference only .

tihlex
Contributor II
Contributor II
Author

Who did encounter these problem?

tihlex
Contributor II
Contributor II
Author

We updated our qlik sense stand and problem fixed.