topic Exception in component tPostgresqlInput ERROR in Talend Studio https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tPostgresqlInput-ERROR/m-p/2362530#M126652 Hi, <BR />i have this ERRORS when i try to synchronise between two tables in two different postgresql DB <BR />any help please...?? <BR /> <BR /> connecting to socket on port 3493 <BR /> connected <BR />Exception in component tPostgresqlInput_1 <BR />org.postgresql.util.PSQLException: ERROR: schema "pg_rami" does not exist <BR /> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) <BR /> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) <BR /> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) <BR /> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) <BR /> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336) <BR /> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235) <BR /> at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.tPostgresqlInput_1Process(cnx_2_bd_pg.java:645) <BR /> at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.runJobInTOS(cnx_2_bd_pg.java:1189) <BR /> at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.main(cnx_2_bd_pg.java:1057) <BR /> disconnected <BR />PS: <BR />"pg_rami" is my input DB name <BR />"cnx_2_bd_pg_0_1" is my job name Mon, 26 Mar 2012 10:24:21 GMT Anonymous 2012-03-26T10:24:21Z Exception in component tPostgresqlInput ERROR https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tPostgresqlInput-ERROR/m-p/2362530#M126652 Hi, <BR />i have this ERRORS when i try to synchronise between two tables in two different postgresql DB <BR />any help please...?? <BR /> <BR /> connecting to socket on port 3493 <BR /> connected <BR />Exception in component tPostgresqlInput_1 <BR />org.postgresql.util.PSQLException: ERROR: schema "pg_rami" does not exist <BR /> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) <BR /> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) <BR /> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) <BR /> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) <BR /> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336) <BR /> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235) <BR /> at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.tPostgresqlInput_1Process(cnx_2_bd_pg.java:645) <BR /> at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.runJobInTOS(cnx_2_bd_pg.java:1189) <BR /> at testsynchro.cnx_2_bd_pg_0_1.cnx_2_bd_pg.main(cnx_2_bd_pg.java:1057) <BR /> disconnected <BR />PS: <BR />"pg_rami" is my input DB name <BR />"cnx_2_bd_pg_0_1" is my job name Mon, 26 Mar 2012 10:24:21 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tPostgresqlInput-ERROR/m-p/2362530#M126652 Anonymous 2012-03-26T10:24:21Z Re: Exception in component tPostgresqlInput ERROR https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tPostgresqlInput-ERROR/m-p/2362531#M126653 Hi <BR />Welcome to talend community! <BR />The concepts of schema and DB are different. <BR />The error shows that you type DB name in Schema textfield. <BR />You'd better check all parameters from postgresql. <BR />Regards, <BR />Pedro Mon, 26 Mar 2012 10:28:35 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tPostgresqlInput-ERROR/m-p/2362531#M126653 Anonymous 2012-03-26T10:28:35Z Re: Exception in component tPostgresqlInput ERROR https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tPostgresqlInput-ERROR/m-p/2362532#M126654 Thanks for the help Mon, 26 Mar 2012 11:08:17 GMT https://community.qlik.com/t5/Talend-Studio/Exception-in-component-tPostgresqlInput-ERROR/m-p/2362532#M126654 Anonymous 2012-03-26T11:08:17Z