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
1 REPLY
One Star

Re: Exception in component tPostgresqlInput ERROR

Hi All
This topic is relate to 22945.
Regards,
Pedro