One Star

Exception in component tPostgresqlInput ERROR

Hi,
i have this ERRORS when i try to synchronise between two tables in two different postgresql DB
any help please...??

connecting to socket on port 3493
connected
Exception in component tPostgresqlInput_1
org.postgresql.util.PSQLException: ERROR: schema "pg_rami" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)
at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.tPostgresqlInput_1Process(cnx_2_bd_pg.java:645)
at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.runJobInTOS(cnx_2_bd_pg.java:1189)
at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.main(cnx_2_bd_pg.java:1057)
disconnected
PS:
"pg_rami" is my input DB name
"cnx_2_bd_pg_0_1" is my job name
2 REPLIES
One Star

Re: Exception in component tPostgresqlInput ERROR

Hi
Welcome to talend community!
The concepts of schema and DB are different.
The error shows that you type DB name in Schema textfield.
You'd better check all parameters from postgresql.
Regards,
Pedro
One Star

Re: Exception in component tPostgresqlInput ERROR

Thanks for the help