Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
nstefaniuk
Creator III
Creator III

[10SR4] Oracle silent errors

Hello all,

I have an issue with 10 SR4.

The oracle errors are silent in SR4 when they are not in SR2.

With this code (after a CONNECT of course), you should get an Oracle error (dividing by zero).

data:

Load

*

;

SQL

select

1/0 "test" from dual

;

drop table data;

In SR2 i get the error but in SR4 I don't, and so in SR4 I just have the table missing error (because the table is not created).

I haven't found a parameter to manage it.

I am in 32 bits on Windows 7, but same in 64 bits on 2003 server

Thanks for help

Labels (1)
11 Replies
nstefaniuk
Creator III
Creator III
Author

Tested with Qlikview SR4 with OraOLEDB11.dll on a Oracle 11 XE, same issue: the oracle error is silent.

I just don't understand why it works for you Ralf.

In ODBC the error is retrieved.

rbecher
Partner - Master III
Partner - Master III

I'm on Win7 64-bit. So, it's a different environment.

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine