Hi, I see this error occasionally when loading data into Vertica through Informatica 9. Severity: INFO Timestamp: 2/13/2013 7:31:29 AM Thread: WRITER_1_*_1 Process ID: 30245 Message Code: VERTICA_WRITER_1762 Message: [DEBUG] No response from the backend Can anyone please shed some light on what migh...

Thanks

However, I notice this issue only occasionally. I have other jobs running with 10k commit interval which run without issues.
I'll try with the commit interval change anyway.

Thanks,
Sean

Hi, I'm using Vertica plugin for Informatica 9.1 to insert data. The speed is generally good. But every once in a while its slows down to a trickle and I see the informatica session logs fill up with this message: [INFO] accepted 104 rejected 0 144537824 Anybody know what would cause this? Could thi...

I'm on Vertica version 5.1.4. My user has USAGE privileges on the schema but i still wasn't able to create projections on the tables. The DBA gave CREATE privileges to the user and it worked then. But glad to know that version 6 does need any explicit grants for projections. we are in the process of...

To load data, I'm created a connection of type "VerticaConnection" in the workflow manager and that worked when inserting data into Vertica. However, I added a lookup to the mapping, but that connection does not show up in the list for the lookup

The vertica drivers I have is version 5.1.4

Hi,

Informatica does not allow vertica connections to do lookups against tables in the Vertica database. Whats the work-around? ODBC?

Thanks.

Yes I did