11g Getting Error When Using Postgresql 9.x Database Trying To Create A New Logical Column With TimeStampAdd Function In BI Admin Tool - Business Model (Doc ID 1667113.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

User is using Postgresql 9.x database and trying to create a new logical column with TimeStampAdd function.

In Admin tool when trying to define new logical column (trying to add 10 days to timestamp column):
TimeStampAdd(SQL_TSI_DAY,10, "CANARD Replika"."RP-B04-0009_pismo"."data_zarejestrowania_przez_can" )

Error from Analytics:

Program obsługi ODBC zwrócił błąd (SQLExecDirectW).
  Szczegóły błędu
Kody błędów: OPR4ONWY:U9IM8TAC:OI2DL65P
Stan: HY000. Kod: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] Błąd ogólny. [nQSError: 12010] Communication error connecting to remote end point: address = hd2.canard.local; port = 9703. (HY000)
Użyty kod SQL: SELECT 0 s_0, "CANRP - Replika"."RP-B04-0009"."123" s_1, "CANRP - Replika"."RP-B04-0009"."data_zarejestrowania_przez_can" s_2 FROM "CANRP - Replika" FETCH FIRST 1000001 ROWS ONLY

Data is retrieved from Postgresql 9.x database.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms