Discussion board where members can get started with Qlik Sense.
I have one problem that is driving me nuts. Since I have very limited knowledge in SQL, maybe you guys could help me out here.
I have an ODBC connection with a oracle system, and it is working just fine with every select i am making.
But, when trying to load this table, it gives me a error connector reply: *** message.
Above some images of what is happening.
1. I open de connection and see the table i'm about to load:
2. When I try to load everything, no good:
3. Curiosly, when I load only the "text" values, the load executes well.
4. But when I try to load VALORH and VALORD, it doesn't load at all.
I have already tried to do a SQL SELECT *, but, again, resulted in the same error
Anyone could help me?
Thanks a lot!
I think something with the field name VALORH. Play with him. Check that there are no spaces in front of the field name. It can help quotes. The impression that the Qlik Sense does not find the name VALORH in ODBC connection with a oracle system.
If the field name *VALORH* is valid for Qlik Sense, yes. But Qlik Sense writes an error while loading. Other fields and table loads, as this field does not load.
Above the first your Figure has field VALORH, it loaded (although all zeros). What has changed from the time of the download, when the field was read Qlik Sense and moment load, when the error?
You´ve written "load this table" but by name, I´m assuming you are retrieving data from a View since it starts with a "VW"
Does that view uses any particular stored procedure, temporary table or not ANSI SQL feature?