18:27:47,200 WARN [org.teiid.CONNECTOR] (Worker105_QueryProcessorQueue3501) Connector worker process failed for atomic-request=BznOlwcKBVBl.2.65.290: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?] SQL: INSERT INTO "cir"."geobdffnd" ("session_id", "adr_id", "adres", "x", "y", "geom", "ent_id", "vestigingsnummer", "kvknummer", "naam", "is_hoofdvestiging") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:293) [translator-jdbc-8.12.13.6_3-redhat-1.jar:8.12.13.6_3-redhat-1] at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:84) [translator-jdbc-8.12.13.6_3-redhat-1.jar:8.12.13.6_3-redhat-1] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:401) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:363) at sun.reflect.GeneratedMethodAccessor199.invoke(Unknown Source) [:1.8.0_152] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_152] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_152] at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) at com.sun.proxy.$Proxy81.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_152] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_152] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_152] at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_152] Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO "cir"."geobdffnd" ("session_id", "adr_id", "adres", "x", "y", "geom", "ent_id", "vestigingsnummer", "kvknummer", "naam", "is_hoofdvestiging") VALUES ('GEO_ORA_TEST', 'xxxxx', 'xxxxxx', '6.417708735524963', '52.15921955171934', ?, 'xxxxx', 'xxxxxx', 'xxxxx', 'xxxxx', 'xxxxxx') was aborted: ERROR: Geometry SRID (0) does not match column SRID (28992) Call getNextException to see other errors in the batch. at org.postgresql.jdbc.BatchResultHandler.handleCompletion(BatchResultHandler.java:166) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:471) at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:793) at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1659) at org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1077) at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:252) [translator-jdbc-8.12.13.6_3-redhat-1.jar:8.12.13.6_3-redhat-1] ... 19 more Caused by: org.postgresql.util.PSQLException: ERROR: Geometry SRID (0) does not match column SRID (28992) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:460) ... 23 more 18:27:47,231 WARN [org.teiid.PROCESSOR] (Worker103_QueryProcessorQueue3502) TEIID30020 Processing exception for request BznOlwcKBVBl.2 'TEIID30504 CIR_PG_DS: 0 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?] SQL: INSERT INTO "cir"."geobdffnd" ("session_id", "adr_id", "adres", "x", "y", "geom", "ent_id", "vestigingsnummer", "kvknummer", "naam", "is_hoofdvestiging") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]'. Originally TeiidProcessingException 'ERROR: Geometry SRID (0) does not match column SRID (28992)' QueryExecutorImpl.java:2455. Enable more detailed logging to see the entire stacktrace.