My Oracle Support Banner

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 22, 2019

Applies to:

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


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, "<subject_area>"."<table_name>"."<column_name_2>" )

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 = hostname.local; port = 9703. (HY000)
Użyty kod SQL: SELECT 0 s_0, "<subject_area>"."table_name"."column_name_1" s_1, "<subject_area>"."table_name"."column_name_2" s_2 FROM "subject_area" FETCH FIRST 1000001 ROWS ONLY

Data is retrieved from Postgresql 9.x database.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.