Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem in Vertica Components

While try to run run tVerticaRow_1 and using tLogRow_1 getting below error message.
Exception in component tVerticaRow_1
com.vertica.util.PSQLException: Something unusual has occured to cause the driver to fail. Please report this exception.
at com.vertica.Driver.connect(Unknown Source)
PS: 
JAR file is vertica-jdbc-7.0.1-0.jar.
I have successful Vertica connection.

Labels (2)
14 Replies
Anonymous
Not applicable
Author

Hi,
Could you please indicate the build version you are using? Screenshots of your component setting will be preferred.
Best regards
Sabrina
Anonymous
Not applicable
Author

Attached the screenshot.
version 6.1.1
Anonymous
Not applicable
Author

screenshot
Anonymous
Not applicable
Author

Hi,


Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.
Which version of your Vertica database? Could you please open the module view and see if the required jar has been installed or not?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina
I tried but it is not uploaded. vertica version is 7.1. 
Under Metadata--> Db connection --> my database check is successful.
Anonymous
Not applicable
Author

Hi,
So far, talend 6.1 can support verical 7.0.X
For more information, please refer to: TalendHelpCenter0683p000009M9p6.pngupported systems databases and business applications by Talend components
Best regards
Sabrina
Anonymous
Not applicable
Author

Thank you for sharing link.
As mentioned connect i guess connecting to vertica is not a problem. 
I believe when i am trying to pull/ see data from vertica then i get error.
tverticaRow_1 -------------->> tLogRow_1.
for tvertica query section, i have running query which is giving me output when i am running it on sqldeveloper.
Anonymous
Not applicable
Author

Hi,
We suppose that JAR file vertica-jdbc-7.0.1-0.jar. in talend studio may cause some issue when you are trying to  pull/ see data from vertica 7.1
Best regards
Sabrina
Anonymous
Not applicable
Author

Uploading the error files.
What would be solution for it , if you find vertica-jdbc-7.0.1-0.jar file is issue.