Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
fer_damas
Contributor

Can't load some value fields from a SQL Select table

Hi everyone,

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:

1.png

2. When I try to load everything, no good:

2.png

3. Curiosly, when I load only the "text" values, the load executes well.

3.png

4. But when I try to load VALORH and VALORD, it doesn't load at all.

4.png

I have already tried to do a SQL SELECT *, but, again, resulted in the same error

Anyone could help me?

Thanks a lot!

Tags (2)
13 Replies
ahaahaaha
Honored Contributor

Re: Can't load some value fields from a SQL Select table

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.

MVP
MVP

Re: Can't load some value fields from a SQL Select table

Are you able to share the schema definition of the table called VW_CRPORCASO_ANOMES?

fer_damas
Contributor

Re: Can't load some value fields from a SQL Select table

kinda difficult

But, if it was it, it should bring me results when applying a Select *, huh?

Thanks, Andrey!

fer_damas
Contributor

Re: Can't load some value fields from a SQL Select table

Will see if it is possible. You've got any hint?

Thanks, Petter.

MVP
MVP

Re: Can't load some value fields from a SQL Select table

Which Oracle driver are you using? Is it the one that comes with Qlik ODBC Connectors or is it Oracles own ODBC driver? Which version is it?

fer_damas
Contributor

Re: Can't load some value fields from a SQL Select table

It is Oracles own ODBC Driver. I've downloaded direct from their website.

Version is OraClient11 g_home1.

Thanks!

ahaahaaha
Honored Contributor

Re: Can't load some value fields from a SQL Select table

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?

ronnywaage
New Contributor III

Re: Can't load some value fields from a SQL Select table

Hi

Have you tried to just test with Select * from .... (Without specify the fields/columns)? This is the first step.

Employee
Employee

Re: Can't load some value fields from a SQL Select table

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?