QlikView 12.02.04 Error while fetching tables through ODBC

[macpao64]

QlikView 12.02.04   - Error while fetching tables through ODBC connection

SQL##f - SqlState: S1C00, ErrorCode: 3, ErrorMsg: [Oracle][ODBC][Ora]Driver not capable.

LOAD CONNID,
DATA_UPDATE,
FLOW,
FLOW_STEP;
SQL SELECT *
FROM "CRM_SF_IF".PROVA2;

I’m trying to fetch a column that is defined as TIMESTAMP with TIMEZONE, that is causing the problem.

If I comment the column with that datatype into the load script, it doesn’t work yet.

I would not change the column size on the db, is there some solution to keep the TIMEZONE?

Thanks a lot

Paolo

[Clever_Anjos]

Try fetching only the needed columns

LOAD CONNID,
DATA_UPDATE,
FLOW,
FLOW_STEP;
SQL SELECT

CONNID,

DATA_UPDATE,

FLOW,

FLOW_STEP

FROM "CRM_SF_IF".PROVA2;

[macpao64]

wqwefregf

[macpao64]

Hi Clever,

I tried to fetch only the needed columns but it didn't work.

The error remains.

I have to change the field datatype of the table removing the TIMEZONE,

in this way the load script works well.

Is not possible to fetch a column that is defined as TIMESTAMP with TIMEZONE.

Paolo

[Clever_Anjos]

Did you try casting the field?

SQL

     SELECT

          CONNID,

          TO_DATE(DATA_UPDATE,'MM/DD/YYYY') AS DATA_UPDATE,

    FROM "CRM_SF_IF".PROVA2

[macpao64]

yes Idid.

I had the same error.

The only solution I've found is to change the field type in the data warehouse table

Paolo

[Or]

As I understand, tt is not possible to fetch a Timestamp with Timezone field via ODBC - this is an ODBC limitation that has nothing to do with QlikView.

Some workarounds are suggested here:

http://bigdatakb.syncsort.com/Default.htm#KB/Troubleshooting/ThirdPartyIssues/117_Resolving_Incorrec...

[sasiparupudi1]

Try without the preceeding load

SQL SELECT

CONNID,

DATA_UPDATE,

FLOW,

FLOW_STEP

FROM "CRM_SF_IF".PROVA2;

[macpao64]

Hi Sasidhar,

doesn't work

[sasiparupudi1]

May be try

SQL SELECT

CONNID,

TO_TIMESTAMP(DATA_UPDATE,'YYYY-MM-DD HH24:MI:SS') As DATA_UPDATE,

FLOW,

FLOW_STEP

FROM "CRM_SF_IF".PROVA2;

or

SQL SELECT

CONNID,

TO_char(DATA_UPDATE,'YYYY-MM-DD HH24:MI:SS') As DATA_UPDATE,

FLOW,

FLOW_STEP

FROM "CRM_SF_IF".PROVA2;