HomeForum
Welcome, Guest

PostgreSQL problem
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: PostgreSQL problem

PostgreSQL problem 2 years, 7 months ago #721

  • acury
  • OFFLINE
  • Junior Boarder
  • Posts: 20
  • Karma: 0
Hi, more one problem....

I´m try retry information from PostgreSQL 7.2.1 database.

first problem, i create a ODBC connection, if i try use \"Build Connection String\", put the parameter, server, user, password, etc.. the string create fine, i press the button \"Test Connection\", the messagem \"Connected!\" show me, but, i press the \"OK\" button so save there.. the error: \"Data Provider or other service returned an E_FAIL\" show me !!

I use the ODBC Administration to test, create a connection, include in the ETL, test, and all fine ! in the connection of corse.... now i will go to Transformation, in the read source i select the connection, select source (ODBC), in Source is option i select: \"Select statment\", write my query SQL, fine, click OK to return this page, all records show me in the preview, i edit Validator (fine to), i edit transformation (to the TXT file, for example), always read and test, on the RUN, the error occured:

Information 23/10/2009 17:37:51 Starting Transformation...
Information 23/10/2009 17:37:51 Preparing Writers...
Information 23/10/2009 17:37:51 Writer: {} Writer { } Is Ready
Information 23/10/2009 17:37:51 All Writers are Ready
Information 23/10/2009 17:37:51 Writer: {} Target File: C:\TEMP\projetores.txt
Information 23/10/2009 17:37:51 Processing Data...
Information 23/10/2009 17:37:51 Reader:{} Source Select Statement: Select
duracao,hour, min,mday,mon,year,wday,nome
From
intervalos_arquivados,
salas
Where
salas.placa = intervalos_arquivados.placa And
salas.endereco = intervalos_arquivados.endereco








Error 23/10/2009 17:37:51 Reader:{} SQLExecDirect(FHSMT,PChar ('select count(*) rec_count from (Select
duracao,hour, min,mday,mon,year,wday,nome
From
intervalos_arquivados,
salas
Where
salas.placa = intervalos_arquivados.placa And
salas.endereco = intervalos_arquivados.endereco







) a'), SQL_NTS) Failed: HY000 ERROR: parser: parse error at or near \"rec_count\";
Error while executing the query
Information 23/10/2009 17:37:51 Reader:{} Processed : 0 Record(s)
Information 23/10/2009 17:37:51 Reader:{} Records per second : 0
Information 23/10/2009 17:37:51 Reader:{} Rejected : 0 Record(s)
Information 23/10/2009 17:37:51 Reader:{} Time Taken : 00:00:00
Information 23/10/2009 17:37:51 Writer: {} Wrote : 0 Line(s)
Information 23/10/2009 17:37:51 Transformation Completed


Help-me !!

Tanks

Re:PostgreSQL problem 2 years, 6 months ago #724

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Alexandre

It was fixed in the latest version of Advanced ETL Processor

Peter
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

One of the good things about Advanced ETL Processor that the trial has no limitations. There is no need to fill in any registration forms or to buy the software in advance.  That saved us a lot of time and we were able to load and  validate all our data when we needed it urgently.

John Parker.

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top