From: | Matthias Coene <Matthias(dot)Coene(at)idewe(dot)be> |
---|---|
To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | fn TIMESTAMPADD |
Date: | 2020-03-12 15:04:52 |
Message-ID: | bbadd5bec4d14563a75917c6665a8fdf@exch01.idewe.be |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
I am using Postgres for my data warehouse. I am using Oracle BI as my reporting tool, using the Postgres ODBC driver to connect.
I seem to have a problem with the TIMESTAMPADD function:
]]
[2020-03-12T15:32:53.182+01:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 27dc] [messageid: USER-18] [requestid: 66350030] [sessionid: 66350000] [username: weblogic] -------------------- Sending query to database named IDEWE_DWH (id: <<430532>>), connection pool named Connection_Pool, logical request hash 4bcf4b69, physical request hash 496312e3: [[
WITH
SAWITH0 AS (select distinct T54148.GEBOREN as c1,
{fn TimestampAdd(SQL_TSI_YEAR, 18, T54148.GEBOREN)} as c2
from
DIM_WERKNEMERS T54148)
select 0 as c1,
D1.c1 as c2,
D1.c2 as c3
from
SAWITH0 D1
order by 2
]]
[2020-03-12T15:32:53.188+01:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 27dc] [messageid: USER-34] [requestid: 66350030] [sessionid: 66350000] [username: weblogic] -------------------- Query Status: [nQSError: 16002] Cannot obtain number of columns for the query result. [[
[nQSError: 16001] ODBC error state: 42703 code: 1 message: ERROR: column "sql_tsi_year" does not exist;
No query has been executed with that handle.
[nQSError: 43119] Query Failed:
]]
Can you please check if this is a problem in Oracle BI ODBC interface, or the driver itself?
Kind regards,
Matthias
Matthias Coene
ICT business intelligence engineer
+32 16 39 04 98
Matthias(dot)Coene(at)idewe(dot)be<mailto:Matthias(dot)Coene(at)idewe(dot)be>
Groep IDEWE | Interleuvenlaan 58 | 3001 Heverlee
[cid:Goedevoornemens000_c4eff03c-9041-4dd5-aaeb-29e23c34988f.jpg]<https://www.idewe.be/><http://www.idewe.be/> <http://www.idewe.be/wps/PA_Internet_site/resources/document/f12ca58b-1108-4c60-a37b-2d6429c3daf8/IDEWE_Opleidingskalender_2017nj_NL_LR.pdf> [cid:WELL001_6593a399-3d5a-4519-8738-19bb7c40fc1f.jpg] [cid:WELL002_b4843e34-98bf-44ba-9427-595115d90d21.jpg] <https://www.idewe.be/bouwstandaard-well> [cid:WELL003_e8a747f9-99b5-4fa9-a096-4f5f53077041.jpg] <https://www.idewe.be/fr/bouwstandaard-well> <http://www.idewe.be/wps/PA_Internet_site/resources/document/e4b56f0c-b32d-4224-992b-573f88fb1bd3/IDEWE_Opleidingskalender_2017nj_FR_LR.pdf>
< (e-mail disclaimer NL <https://www.idewe.be/disclaimer> / FR <https://www.idewe.be/fr/disclaimer> )
From | Date | Subject | |
---|---|---|---|
Next Message | Clemens Ladisch | 2020-03-12 15:55:41 | Re: fn TIMESTAMPADD |
Previous Message | Stefan Wolf | 2020-03-02 14:25:17 | MS-ACCESS 2010, ODBC 12.01, Out of Memory |