Starting the Java application using /opt/run-java/run-java.sh ... exec java -javaagent:/opt/jolokia/jolokia.jar=config=/opt/jolokia/etc/jolokia.properties -javaagent:/opt/prometheus/jmx_prometheus_javaagent.jar=9779:/tmp/src/prometheus-config.yml -XX:+UseParallelGC -XX:GCTimeRatio=4 -XX:AdaptiveSizePolicyWeight=90 -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -XX:+ExitOnOutOfMemoryError -cp . -jar /deployments/project-0.1-SNAPSHOT.jar OpenJDK 64-Bit Server VM warning: If the number of processors is expected to increase from one, then you should configure the number of parallel GC threads appropriately using -XX:ParallelGCThreads=N I> No access restrictor found, access to any MBean is allowed Jolokia: Agent started with URL https://10.131.1.9:8778/jolokia/ _______. _ _ / | | | (_) | (----`_ _ ____ _ | | ____ ___ _ ___ \ \ | | | || _ \ / || | / _ ) /___)| | /___) .----) | | |_| || | | |( (_| |( (/ / |___ || ||___ | |_______/ \__ ||_| |_| \____| \____)(___/ |_|(___/ ============ (____/ =================================== :: Integration :: :: v 2021-06-15 14:30:10.229 INFO 1 --- [ main] io.syndesis.example.Application : Starting Application on i-limit-7-87xd8 with PID 1 (/deployments/project-0.1-SNAPSHOT.jar started by jboss in /deployments) 2021-06-15 14:30:10.232 DEBUG 1 --- [ main] io.syndesis.example.Application : Running with Spring Boot v2.3.9.RELEASE, Spring v5.2.13.RELEASE 2021-06-15 14:30:10.233 INFO 1 --- [ main] io.syndesis.example.Application : No active profile set, falling back to default profiles: default 2021-06-15 14:30:12.847 INFO 1 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.apache.camel.spring.boot.CamelAutoConfiguration' of type [org.apache.camel.spring.boot.CamelAutoConfiguration$$EnhancerBySpringCGLIB$$52c1c243] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2021-06-15 14:30:13.406 WARN 1 --- [ main] io.undertow.websockets.jsr : UT026010: Buffer pool was not set on WebSocketDeploymentInfo, the default pool will be used 2021-06-15 14:30:13.453 INFO 1 --- [ main] io.undertow.servlet : Initializing Spring embedded WebApplicationContext 2021-06-15 14:30:13.453 INFO 1 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 3148 ms 2021-06-15 14:30:13.856 INFO 1 --- [ main] o.a.c.i.converter.DefaultTypeConverter : Type converters loaded (core: 195, classpath: 7) 2021-06-15 14:30:14.078 INFO 1 --- [ main] o.a.c.s.boot.CamelAutoConfiguration : Adding custom InterceptStrategy with id: integrationLoggingInterceptStrategy and implementation: io.syndesis.integration.runtime.tracing.TracingInterceptStrategy@48a12036 2021-06-15 14:30:14.202 INFO 1 --- [ main] o.c.s.w.s.ServerTracingAutoConfiguration : Creating FilterRegistrationBean bean with TracingFilter mapped to [], skip pattern is "/api-docs.*|/swagger.*|.*\.png|.*\.css|.*\.js|.*\.html|/favicon.ico|/hystrix.stream|/actuator/(health|health/.*|info|info/.*)" 2021-06-15 14:30:15.414 INFO 1 --- [ main] o.c.s.w.s.ServerTracingAutoConfiguration : Creating WebMvcConfigurer bean with class io.opentracing.contrib.spring.web.interceptor.TracingHandlerInterceptor 2021-06-15 14:30:15.559 INFO 1 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2021-06-15 14:30:16.279 INFO 1 --- [ main] io.undertow : starting server: Undertow - 2.1.6.Final 2021-06-15 14:30:16.379 INFO 1 --- [ main] org.xnio : XNIO version 3.8.0.Final 2021-06-15 14:30:16.406 INFO 1 --- [ main] org.xnio.nio : XNIO NIO Implementation Version 3.8.0.Final 2021-06-15 14:30:16.453 INFO 1 --- [ main] org.jboss.threads : JBoss Threads version 3.1.0.Final 2021-06-15 14:30:16.520 INFO 1 --- [ main] o.s.b.w.e.undertow.UndertowWebServer : Undertow started on port(s) 8080 (http) 2021-06-15 14:30:16.665 INFO 1 --- [ main] io.undertow.servlet : Initializing Spring embedded WebApplicationContext 2021-06-15 14:30:16.665 INFO 1 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 135 ms 2021-06-15 14:30:16.683 INFO 1 --- [ main] o.s.b.a.e.web.EndpointLinksResolver : Exposing 2 endpoint(s) beneath base path '/actuator' 2021-06-15 14:30:16.741 INFO 1 --- [ main] io.undertow : starting server: Undertow - 2.1.6.Final 2021-06-15 14:30:16.746 INFO 1 --- [ main] o.s.b.w.e.undertow.UndertowWebServer : Undertow started on port(s) 8081 (http) 2021-06-15 14:30:16.748 DEBUG 1 --- [ main] o.a.camel.spring.boot.RoutesCollector : Camel already started, not adding routes. 2021-06-15 14:30:16.754 DEBUG 1 --- [ main] o.a.camel.spring.boot.RoutesCollector : Post-processing CamelContext bean: limit 2021-06-15 14:30:16.755 DEBUG 1 --- [ main] o.a.camel.spring.boot.RoutesCollector : CamelContextConfiguration found. Invoking beforeApplicationStart: io.syndesis.integration.runtime.sb.IntegrationRuntimeAutoConfiguration$1@22db8f4 2021-06-15 14:30:16.756 INFO 1 --- [ main] .r.s.IntegrationRuntimeAutoConfiguration : Autowired IntegrationStepHandlers found: 0 2021-06-15 14:30:16.776 INFO 1 --- [ main] .r.s.IntegrationRuntimeAutoConfiguration : ServiceLoader loaded IntegrationStepHandlers: 13 2021-06-15 14:30:16.778 INFO 1 --- [ main] i.s.i.runtime.IntegrationRouteBuilder : Loading integration from: classpath:syndesis/integration/integration.json 2021-06-15 14:30:17.896 DEBUG 1 --- [ main] i.s.i.runtime.IntegrationRouteBuilder : Step kind: endpoint, handler: io.syndesis.integration.runtime.handlers.ConnectorStepHandler 2021-06-15 14:30:17.905 INFO 1 --- [ main] i.s.i.r.handlers.ConnectorStepHandler : Resolving component: sql-0-0 sql Connector{id=sql, version=1, actions=[], tags=[verifier], name=Database, properties={password=ConfigurationProperty{tags=[], order=3, componentProperty=true, deprecated=false, displayName=Password, enum=[], dataList=[], group=security, javaType=java.lang.String, kind=property, label=common,security, labelHint=Password for the database connection., relation=[], required=true, secret=true, type=string}, schema=ConfigurationProperty{tags=[], order=4, componentProperty=true, deprecated=false, displayName=Schema, enum=[], dataList=[], group=common, javaType=java.lang.String, kind=property, label=common, labelHint=Database schema., relation=[], required=false, secret=false, type=string}, url=ConfigurationProperty{tags=[], order=1, componentProperty=true, deprecated=false, displayName=Connection URL, enum=[], dataList=[], group=common, javaType=java.lang.String, kind=property, labelHint=JDBC URL of the database., relation=[], required=true, secret=false, type=string}, user=ConfigurationProperty{tags=[], order=2, componentProperty=true, deprecated=false, displayName=Username, enum=[], dataList=[], group=common, javaType=java.lang.String, kind=property, labelHint=Username for the database connection., relation=[], required=true, secret=false, type=string}}, configuredProperties={}, dependencies=[Dependency{type=MAVEN, id=io.syndesis.connector:connector-sql:1.12.0-20210608}, Dependency{type=EXTENSION_TAG, id=jdbc-driver}], metadata={}, description=Invoke SQL to obtain, store, update, or delete data., kind=connector, connectorCustomizers=[io.syndesis.connector.sql.customizer.DataSourceCustomizer]} ConnectorDescriptor{inputDataShape=DataShape{kind=none, type=SQL_PARAM_IN, metadata={}, variants=[]}, outputDataShape=DataShape{name=SQL Result, description=Result of SQL [select * from todo limit(1)], kind=json-schema, type=SQL_PARAM_OUT, specification={"type":"array","$schema":"http://json-schema.org/schema#","items":{"type":"object","title":"SQL_PARAM_OUT","properties":{"id":{"type":"integer","required":true},"task":{"type":"string","required":true},"completed":{"type":"integer","required":true}}}}, metadata={variant=collection}, variants=[]}, propertyDefinitionSteps=[ActionDescriptorStep{name=SQL statement, properties={query=ConfigurationProperty{tags=[], order=1, defaultValue=select * from todo limit(1), deprecated=false, displayName=SQL statement, enum=[], dataList=[select * from todo limit(1)], group=common, javaType=java.lang.String, kind=path, labelHint=SQL statement to be executed., relation=[], required=true, secret=false, type=dataList}, schedulerExpression=ConfigurationProperty{tags=[], order=2, defaultValue=60000, deprecated=false, displayName=Period, enum=[], dataList=[], group=consumer, javaType=long, kind=parameter, labelHint=Delay between scheduling (executing)., relation=[], required=false, secret=false, type=duration}, isRaiseErrorOnNotFound=ConfigurationProperty{tags=[], order=3, deprecated=false, displayName=Raise NotFoundError, enum=[], dataList=[], group=consumer, javaType=java.lang.Boolean, kind=parameter, labelHint=Raise NotFoundError if no records are inserted, updated, selected or deleted, relation=[], required=false, secret=false, type=boolean}}, configuredProperties={}, description=Enter a SQL statement that returns results, such as SELECT.}], configuredProperties={}, componentScheme=sql, connectorCustomizers=[io.syndesis.connector.sql.customizer.SqlStartConnectorCustomizer], standardizedErrors=[]} 2021-06-15 14:30:17.944 INFO 1 --- [ main] i.s.i.r.handlers.ConnectorStepHandler : Got component: io.syndesis.integration.component.proxy.ComponentProxyComponent@46baf579, sql-0-0, sql 2021-06-15 14:30:18.264 DEBUG 1 --- [ main] i.s.c.sql.common.SqlStatementParser : org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getSchema()Ljava/lang/String; 2021-06-15 14:30:18.305 WARN 1 --- [ main] i.s.c.sql.common.SqlStatementParser : Parsing with SQL and legacy parser failed, will rethrow the first exception only java.sql.SQLException: Table 'TODO' does not exist in schema 'public' at io.syndesis.connector.sql.common.SqlStatementLegacyParser.findTablesInSelectStatement(SqlStatementLegacyParser.java:306) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.common.SqlStatementLegacyParser.parseSelect(SqlStatementLegacyParser.java:195) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.common.SqlStatementLegacyParser.parse(SqlStatementLegacyParser.java:105) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.common.SqlStatementParser.parse(SqlStatementParser.java:236) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlStartConnectorCustomizer.init(SqlStartConnectorCustomizer.java:94) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlStartConnectorCustomizer.customize(SqlStartConnectorCustomizer.java:54) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlStartConnectorCustomizer.customize(SqlStartConnectorCustomizer.java:43) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.handlers.HandlerCustomizer.customizeComponent(HandlerCustomizer.java:67) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.handlers.ConnectorStepHandler.handle(ConnectorStepHandler.java:131) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.IntegrationRouteBuilder.configureFlow(IntegrationRouteBuilder.java:224) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.IntegrationRouteBuilder.configure(IntegrationRouteBuilder.java:143) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.builder.RouteBuilder.checkInitialized(RouteBuilder.java:463) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.builder.RouteBuilder.configureRoutes(RouteBuilder.java:403) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.builder.RouteBuilder.addRoutesToCamelContext(RouteBuilder.java:384) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext$3.call(DefaultCamelContext.java:1024) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext$3.call(DefaultCamelContext.java:1021) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext.doWithDefinedClassLoader(DefaultCamelContext.java:3279) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext.addRoutes(DefaultCamelContext.java:1021) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.sb.IntegrationRuntimeAutoConfiguration$1.beforeApplicationStart(IntegrationRuntimeAutoConfiguration.java:93) [integration-runtime-springboot-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.spring.boot.RoutesCollector.onApplicationEvent(RoutesCollector.java:153) [camel-spring-boot-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.spring.boot.RoutesCollector.onApplicationEvent(RoutesCollector.java:57) [camel-spring-boot-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:404) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:361) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:898) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:554) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at io.syndesis.example.Application.main(Application.java:13) [classes!/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_191] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_191] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_191] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_191] at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) [project-0.1-SNAPSHOT.jar:na] 2021-06-15 14:30:18.306 ERROR 1 --- [ main] i.s.c.s.c.SqlStartConnectorCustomizer : net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "(" "(" at line 1, column 25. Was expecting one of: ":" "?" "ALL" "NULL" java.sql.SQLException: net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "(" "(" at line 1, column 25. Was expecting one of: ":" "?" "ALL" "NULL" at io.syndesis.connector.sql.common.SqlStatementParser.parse(SqlStatementParser.java:241) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlStartConnectorCustomizer.init(SqlStartConnectorCustomizer.java:94) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlStartConnectorCustomizer.customize(SqlStartConnectorCustomizer.java:54) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlStartConnectorCustomizer.customize(SqlStartConnectorCustomizer.java:43) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.handlers.HandlerCustomizer.customizeComponent(HandlerCustomizer.java:67) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.handlers.ConnectorStepHandler.handle(ConnectorStepHandler.java:131) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.IntegrationRouteBuilder.configureFlow(IntegrationRouteBuilder.java:224) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.IntegrationRouteBuilder.configure(IntegrationRouteBuilder.java:143) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.builder.RouteBuilder.checkInitialized(RouteBuilder.java:463) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.builder.RouteBuilder.configureRoutes(RouteBuilder.java:403) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.builder.RouteBuilder.addRoutesToCamelContext(RouteBuilder.java:384) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext$3.call(DefaultCamelContext.java:1024) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext$3.call(DefaultCamelContext.java:1021) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext.doWithDefinedClassLoader(DefaultCamelContext.java:3279) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext.addRoutes(DefaultCamelContext.java:1021) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.sb.IntegrationRuntimeAutoConfiguration$1.beforeApplicationStart(IntegrationRuntimeAutoConfiguration.java:93) [integration-runtime-springboot-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.spring.boot.RoutesCollector.onApplicationEvent(RoutesCollector.java:153) [camel-spring-boot-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.spring.boot.RoutesCollector.onApplicationEvent(RoutesCollector.java:57) [camel-spring-boot-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:404) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:361) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:898) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:554) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at io.syndesis.example.Application.main(Application.java:13) [classes!/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_191] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_191] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_191] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_191] at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) [project-0.1-SNAPSHOT.jar:na] Caused by: net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "(" "(" at line 1, column 25. Was expecting one of: ":" "?" "ALL" "NULL" at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:165) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:59) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:37) ~[jsqlparser-4.0.jar!/:na] at io.syndesis.connector.sql.common.SqlStatementParser.parse(SqlStatementParser.java:230) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] ... 40 common frames omitted Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" at line 1, column 25. Was expecting one of: ":" "?" "ALL" "NULL" at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:26538) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:26377) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.PlainLimit(CCJSqlParser.java:8079) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.LimitWithOffset(CCJSqlParser.java:7998) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:4359) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:4496) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:4163) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:4158) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:130) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:81) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:163) ~[jsqlparser-4.0.jar!/:na] ... 43 common frames omitted 2021-06-15 14:30:18.318 INFO 1 --- [ main] i.s.i.c.proxy.ComponentProxyComponent : Register component: sql-0-0 (type: org.apache.camel.component.sql.SqlComponent) with scheme: sql and alias: sql-sql-0-0 2021-06-15 14:30:18.319 DEBUG 1 --- [ main] i.s.i.c.proxy.ComponentProxyComponent : Starting connector: sql-0-0 2021-06-15 14:30:18.321 DEBUG 1 --- [ main] i.s.i.runtime.IntegrationRouteBuilder : Step kind: split, handler: io.syndesis.integration.runtime.handlers.SplitStepHandler 2021-06-15 14:30:18.334 DEBUG 1 --- [ main] i.s.i.runtime.IntegrationRouteBuilder : Step kind: log, handler: io.syndesis.integration.runtime.handlers.LogStepHandler 2021-06-15 14:30:18.335 DEBUG 1 --- [ main] i.s.i.runtime.IntegrationRouteBuilder : Step kind: mapper, handler: io.syndesis.integration.runtime.handlers.DataMapperStepHandler 2021-06-15 14:30:18.342 DEBUG 1 --- [ main] i.s.i.runtime.IntegrationRouteBuilder : Step kind: endpoint, handler: io.syndesis.integration.runtime.handlers.ConnectorStepHandler 2021-06-15 14:30:18.342 INFO 1 --- [ main] i.s.i.r.handlers.ConnectorStepHandler : Resolving component: sql-0-4 sql Connector{id=sql, version=1, actions=[], tags=[verifier], name=Database, properties={password=ConfigurationProperty{tags=[], order=3, componentProperty=true, deprecated=false, displayName=Password, enum=[], dataList=[], group=security, javaType=java.lang.String, kind=property, label=common,security, labelHint=Password for the database connection., relation=[], required=true, secret=true, type=string}, schema=ConfigurationProperty{tags=[], order=4, componentProperty=true, deprecated=false, displayName=Schema, enum=[], dataList=[], group=common, javaType=java.lang.String, kind=property, label=common, labelHint=Database schema., relation=[], required=false, secret=false, type=string}, url=ConfigurationProperty{tags=[], order=1, componentProperty=true, deprecated=false, displayName=Connection URL, enum=[], dataList=[], group=common, javaType=java.lang.String, kind=property, labelHint=JDBC URL of the database., relation=[], required=true, secret=false, type=string}, user=ConfigurationProperty{tags=[], order=2, componentProperty=true, deprecated=false, displayName=Username, enum=[], dataList=[], group=common, javaType=java.lang.String, kind=property, labelHint=Username for the database connection., relation=[], required=true, secret=false, type=string}}, configuredProperties={}, dependencies=[Dependency{type=MAVEN, id=io.syndesis.connector:connector-sql:1.12.0-20210608}, Dependency{type=EXTENSION_TAG, id=jdbc-driver}], metadata={}, description=Invoke SQL to obtain, store, update, or delete data., kind=connector, connectorCustomizers=[io.syndesis.connector.sql.customizer.DataSourceCustomizer]} ConnectorDescriptor{inputDataShape=DataShape{name=SQL Parameter, description=Parameters of SQL [INSERT INTO todo(id, completed, task) VALUES (:#id, :#completed, :#task) ON CONFLICT (id) DO UPDATE SET completed=:#completed, task=:#task], kind=json-schema, type=SQL_PARAM_IN, specification={"type":"object","$schema":"http://json-schema.org/schema#","title":"SQL_PARAM_IN","properties":{"id":{"type":"integer","required":true},"completed":{"type":"integer","required":true},"task":{"type":"string","required":true}}}, metadata={variant=element}, variants=[]}, outputDataShape=DataShape{name=SQL Result, description=Result of SQL [INSERT INTO todo(id, completed, task) VALUES (:#id, :#completed, :#task) ON CONFLICT (id) DO UPDATE SET completed=:#completed, task=:#task], kind=json-schema, type=SQL_PARAM_OUT, specification={"type":"array","$schema":"http://json-schema.org/schema#","items":{"type":"object","title":"SQL_PARAM_OUT","properties":{"id":{"type":"integer","required":true}}}}, metadata={variant=collection}, variants=[]}, propertyDefinitionSteps=[ActionDescriptorStep{name=SQL statement, properties={query=ConfigurationProperty{tags=[], order=1, defaultValue=INSERT INTO todo(id, completed, task) VALUES (:#id, :#completed, :#task) ON CONFLICT (id) DO UPDATE SET completed=:#completed, task=:#task, deprecated=false, displayName=SQL statement, enum=[], dataList=[INSERT INTO todo(id, completed, task) VALUES (:#id, :#completed, :#task) ON CONFLICT (id) DO UPDATE SET completed=:#completed, task=:#task], group=common, javaType=java.lang.String, kind=path, labelHint=SQL statement to be executed. Can contain input parameters prefixed by ':#'., placeholder=for example ':#MYPARAMNAME', relation=[], required=true, secret=false, type=dataList}, batch=ConfigurationProperty{tags=[], order=2, defaultValue=false, deprecated=false, displayName=Batch update, enum=[], dataList=[], group=common, javaType=java.lang.Boolean, kind=property, labelHint=Use prepared statements for INSERT, UPDATE, DELETE in order to update multiple rows with batch update., relation=[], required=false, secret=false, type=boolean}, raiseErrorOnNotFound=ConfigurationProperty{tags=[], order=3, defaultValue=false, deprecated=false, displayName=Raise error when record not found, enum=[], dataList=[], group=common, javaType=java.lang.Boolean, kind=property, labelHint=Error when no records are selected, updated or deleted, relation=[], required=false, secret=false, type=boolean}}, configuredProperties={}, description=Enter a SQL statement that starts with INSERT, SELECT, UPDATE or DELETE.}], configuredProperties={}, componentScheme=sql, connectorCustomizers=[io.syndesis.connector.sql.customizer.SqlConnectorCustomizer], standardizedErrors=[StandardizedError{displayName=DataAccessError, name=DATA_ACCESS_ERROR}, StandardizedError{displayName=EntityNotFoundError, name=ENTITY_NOT_FOUND_ERROR}, StandardizedError{displayName=DuplicateKeyError, name=DUPLICATE_KEY_ERROR}, StandardizedError{displayName=ConnectorError, name=CONNECTOR_ERROR}]} 2021-06-15 14:30:18.348 INFO 1 --- [ main] i.s.i.r.handlers.ConnectorStepHandler : Got component: io.syndesis.integration.component.proxy.ComponentProxyComponent@d0ec63, sql-0-4, sql 2021-06-15 14:30:18.368 DEBUG 1 --- [ main] i.s.c.sql.common.SqlStatementParser : org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getSchema()Ljava/lang/String; 2021-06-15 14:30:18.373 WARN 1 --- [ main] i.s.c.sql.common.SqlStatementParser : Parsing with SQL and legacy parser failed, will rethrow the first exception only java.sql.SQLException: Table 'TODO' does not exist in schema 'null' at io.syndesis.connector.sql.common.SqlStatementMetaData.addTable(SqlStatementMetaData.java:53) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.common.SqlStatementLegacyParser.parseInsert(SqlStatementLegacyParser.java:140) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.common.SqlStatementLegacyParser.parse(SqlStatementLegacyParser.java:96) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.common.SqlStatementParser.parse(SqlStatementParser.java:236) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlConnectorCustomizer.initJdbcMap(SqlConnectorCustomizer.java:171) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlConnectorCustomizer.customize(SqlConnectorCustomizer.java:66) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlConnectorCustomizer.customize(SqlConnectorCustomizer.java:51) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.handlers.HandlerCustomizer.customizeComponent(HandlerCustomizer.java:67) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.handlers.ConnectorStepHandler.handle(ConnectorStepHandler.java:131) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.IntegrationRouteBuilder.configureFlow(IntegrationRouteBuilder.java:224) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.IntegrationRouteBuilder.configure(IntegrationRouteBuilder.java:143) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.builder.RouteBuilder.checkInitialized(RouteBuilder.java:463) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.builder.RouteBuilder.configureRoutes(RouteBuilder.java:403) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.builder.RouteBuilder.addRoutesToCamelContext(RouteBuilder.java:384) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext$3.call(DefaultCamelContext.java:1024) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext$3.call(DefaultCamelContext.java:1021) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext.doWithDefinedClassLoader(DefaultCamelContext.java:3279) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext.addRoutes(DefaultCamelContext.java:1021) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.sb.IntegrationRuntimeAutoConfiguration$1.beforeApplicationStart(IntegrationRuntimeAutoConfiguration.java:93) [integration-runtime-springboot-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.spring.boot.RoutesCollector.onApplicationEvent(RoutesCollector.java:153) [camel-spring-boot-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.spring.boot.RoutesCollector.onApplicationEvent(RoutesCollector.java:57) [camel-spring-boot-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:404) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:361) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:898) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:554) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at io.syndesis.example.Application.main(Application.java:13) [classes!/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_191] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_191] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_191] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_191] at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) [project-0.1-SNAPSHOT.jar:na] 2021-06-15 14:30:18.374 ERROR 1 --- [ main] i.s.c.s.c.SqlConnectorCustomizer : net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "CONFLICT" at line 1, column 77. Was expecting: "DUPLICATE" java.sql.SQLException: net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "CONFLICT" at line 1, column 77. Was expecting: "DUPLICATE" at io.syndesis.connector.sql.common.SqlStatementParser.parse(SqlStatementParser.java:241) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlConnectorCustomizer.initJdbcMap(SqlConnectorCustomizer.java:171) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlConnectorCustomizer.customize(SqlConnectorCustomizer.java:66) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.connector.sql.customizer.SqlConnectorCustomizer.customize(SqlConnectorCustomizer.java:51) [connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.handlers.HandlerCustomizer.customizeComponent(HandlerCustomizer.java:67) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.handlers.ConnectorStepHandler.handle(ConnectorStepHandler.java:131) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.IntegrationRouteBuilder.configureFlow(IntegrationRouteBuilder.java:224) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at io.syndesis.integration.runtime.IntegrationRouteBuilder.configure(IntegrationRouteBuilder.java:143) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.builder.RouteBuilder.checkInitialized(RouteBuilder.java:463) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.builder.RouteBuilder.configureRoutes(RouteBuilder.java:403) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.builder.RouteBuilder.addRoutesToCamelContext(RouteBuilder.java:384) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext$3.call(DefaultCamelContext.java:1024) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext$3.call(DefaultCamelContext.java:1021) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext.doWithDefinedClassLoader(DefaultCamelContext.java:3279) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.impl.DefaultCamelContext.addRoutes(DefaultCamelContext.java:1021) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.sb.IntegrationRuntimeAutoConfiguration$1.beforeApplicationStart(IntegrationRuntimeAutoConfiguration.java:93) [integration-runtime-springboot-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.spring.boot.RoutesCollector.onApplicationEvent(RoutesCollector.java:153) [camel-spring-boot-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.spring.boot.RoutesCollector.onApplicationEvent(RoutesCollector.java:57) [camel-spring-boot-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:404) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:361) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:898) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:554) [spring-context-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.9.RELEASE.jar!/:2.3.9.RELEASE] at io.syndesis.example.Application.main(Application.java:13) [classes!/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_191] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_191] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_191] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_191] at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.Launcher.launch(Launcher.java:107) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) [project-0.1-SNAPSHOT.jar:na] at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:467) [project-0.1-SNAPSHOT.jar:na] Caused by: net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "CONFLICT" at line 1, column 77. Was expecting: "DUPLICATE" at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:165) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:59) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:37) ~[jsqlparser-4.0.jar!/:na] at io.syndesis.connector.sql.common.SqlStatementParser.parse(SqlStatementParser.java:230) ~[connector-sql-1.12.0-20210608.jar!/:1.12.0-20210608] ... 40 common frames omitted Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "CONFLICT" at line 1, column 77. Was expecting: "DUPLICATE" at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:26538) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:26377) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.Insert(CCJSqlParser.java:2155) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:143) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:81) ~[jsqlparser-4.0.jar!/:na] at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:163) ~[jsqlparser-4.0.jar!/:na] ... 43 common frames omitted 2021-06-15 14:30:18.378 INFO 1 --- [ main] i.s.i.c.proxy.ComponentProxyComponent : Register component: sql-0-4 (type: org.apache.camel.component.sql.SqlComponent) with scheme: sql and alias: sql-sql-0-4 2021-06-15 14:30:18.378 DEBUG 1 --- [ main] i.s.i.c.proxy.ComponentProxyComponent : Starting connector: sql-0-4 2021-06-15 14:30:18.379 DEBUG 1 --- [ main] i.s.i.runtime.IntegrationRouteBuilder : Step kind: log, handler: io.syndesis.integration.runtime.handlers.LogStepHandler 2021-06-15 14:30:18.380 DEBUG 1 --- [ main] o.a.camel.spring.boot.RoutesCollector : CamelContextConfiguration found. Invoking beforeApplicationStart: io.syndesis.integration.runtime.sb.jmx.IntegrationMetadataAutoConfiguration$1@6e92c6ad 2021-06-15 14:30:18.385 INFO 1 --- [ main] s.j.IntegrationMetadataAutoConfiguration : Added Syndesis MBean Service 2021-06-15 14:30:18.386 DEBUG 1 --- [ main] o.a.camel.spring.boot.RoutesCollector : CamelContextConfiguration found. Invoking beforeApplicationStart: io.syndesis.integration.runtime.sb.tracing.TracingCamelContextConfiguration@2fb5fe30 2021-06-15 14:30:18.386 INFO 1 --- [ main] i.r.s.t.TracingCamelContextConfiguration : ActivityTracking: Opentracing Activity Logging strategy 2021-06-15 14:30:18.389 INFO 1 --- [ main] o.a.camel.spring.SpringCamelContext : Apache Camel 2.23.2.fuse-790029 (CamelContext: limit) is starting 2021-06-15 14:30:18.391 INFO 1 --- [ main] o.a.camel.spring.SpringCamelContext : StreamCaching is enabled on CamelContext: limit 2021-06-15 14:30:18.391 INFO 1 --- [ main] o.a.c.m.ManagedManagementStrategy : JMX is enabled 2021-06-15 14:30:18.632 INFO 1 --- [ main] i.s.i.c.proxy.ComponentProxyComponent : Connector resolved: sql-0-0 -> sql-sql-0-0://select%20*%20from%20todo%20limit(1) 2021-06-15 14:30:18.893 INFO 1 --- [ main] i.s.i.c.proxy.ComponentProxyComponent : Connector resolved: sql-0-4 -> sql-sql-0-4://INSERT%20INTO%20todo(id,%20completed,%20task)%20VALUES%20(:%23id,%20:%23completed,%20:%23task)%20ON%20CONFLICT%20(id)%20DO%20UPDATE%20SET%20completed=:%23completed,%20task=:%23task?batch=false 2021-06-15 14:30:18.907 INFO 1 --- [ main] o.a.c.impl.DefaultStreamCachingStrategy : StreamCaching in use with spool directory: /tmp/camel/camel-tmp-3db0a99a-ba85-428f-8116-5cce12384057 and rules: [Spool > 128K body size] 2021-06-15 14:30:18.984 INFO 1 --- [ main] i.s.i.r.jmx.CamelContextMetadataMBean : Registered mbean io.syndesis.camel:context=limit,type=context,name="limit" 2021-06-15 14:30:18.987 INFO 1 --- [ main] o.a.camel.spring.SpringCamelContext : Route: -McF-eRl-oSsqDwOvKO1 started and consuming from: timer://integration?period=60000 2021-06-15 14:30:18.988 INFO 1 --- [ main] o.a.camel.spring.SpringCamelContext : Total 1 routes, of which 1 are started 2021-06-15 14:30:18.990 INFO 1 --- [ main] o.a.camel.spring.SpringCamelContext : Apache Camel 2.23.2.fuse-790029 (CamelContext: limit) started in 0.600 seconds 2021-06-15 14:30:18.990 DEBUG 1 --- [ main] o.a.camel.spring.boot.RoutesCollector : CamelContextConfiguration found. Invoking afterApplicationStart: io.syndesis.integration.runtime.sb.IntegrationRuntimeAutoConfiguration$1@22db8f4 2021-06-15 14:30:19.908 DEBUG 1 --- [ main] .r.s.IntegrationRuntimeAutoConfiguration : Routes: -McF-hzX-oSsqDwOvKO2 -McF-eRl-oSsqDwOvKO1 io.syndesis.integration.runtime.handlers.SplitStepHandler$SplitExpression@6f8d7714 -McF1EQa-oSsqDwOvKO3 -McF1_CT-oSsqDwOvKO3 -McF1WAL-oSsqDwOvKO3 -McF1JHD-oSsqDwOvKO3 -McF-isX-oSsqDwOvKO2 2021-06-15 14:30:19.908 DEBUG 1 --- [ main] o.a.camel.spring.boot.RoutesCollector : CamelContextConfiguration found. Invoking afterApplicationStart: io.syndesis.integration.runtime.sb.jmx.IntegrationMetadataAutoConfiguration$1@6e92c6ad 2021-06-15 14:30:19.908 DEBUG 1 --- [ main] o.a.camel.spring.boot.RoutesCollector : CamelContextConfiguration found. Invoking afterApplicationStart: io.syndesis.integration.runtime.sb.tracing.TracingCamelContextConfiguration@2fb5fe30 2021-06-15 14:30:19.923 INFO 1 --- [ main] io.syndesis.example.Application : Started Application in 10.555 seconds (JVM running for 11.476) 2021-06-15 14:30:20.155 INFO 1 --- [r://integration] -McF-eRl-oSsqDwOvKO1 : Message Context: [{breadcrumbId=i-McF47lSmZlpZ_rlQqlvz, CamelSqlRowCount=1, firedTime=Tue Jun 15 14:30:19 UTC 2021, Syndesis.FLOW_ID=-McF-eRl-oSsqDwOvKO1, Syndesis.STEP_ID=-McF1_CT-oSsqDwOvKO3, Syndesis.STEP_SPAN=1ff283ea6ee7dbd3:6d5e01eb969b9da8:1ff283ea6ee7dbd3:1 - -McF1_CT-oSsqDwOvKO3}] Body: [[{"id":1, "task":"task1", "completed":null}]] 2021-06-15 14:30:20.281 ERROR 1 --- [r://integration] o.a.camel.processor.DefaultErrorHandler : Failed delivery for (MessageId: i-McF47pkmZlpZ_rlQqlzz on ExchangeId: i-McF47mhmZlpZ_rlQqlxz). Exhausted after delivery attempt: 1 caught: org.apache.camel.RuntimeExchangeException: Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF47mhmZlpZ_rlQqlxz] Message History --------------------------------------------------------------------------------------------------------------------------------------- RouteId ProcessorId Processor Elapsed (ms) [-McF-eRl-oSsqDwOvK] [-McF-eRl-oSsqDwOvK] [timer://integration?period=60000 ] [ 283] [-McF-eRl-oSsqDwOvK] [setHeader3 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [capture-out:-McF1E] [Processor@0x45f0255b ] [ 0] [-McF-eRl-oSsqDwOvK] [step:-McF1_CT-oSsq] [pipeline ] [ 76] [-McF-eRl-oSsqDwOvK] [setHeader4 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [log1 ] [log ] [ 76] [-McF-eRl-oSsqDwOvK] [step:-McF1WAL-oSsq] [pipeline ] [ 116] [-McF-eRl-oSsqDwOvK] [setHeader5 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [process1 ] [Processor@0x4544b816 ] [ 0] [-McF-eRl-oSsqDwOvK] [to2 ] [atlas:mapping-flow-0-step-3.json?encoding=UTF-8&sourceMapName=Syndesis.CAPTURE] [ 115] [-McF-eRl-oSsqDwOvK] [process2 ] [Processor@0x3913b6c7 ] [ 0] [-McF-eRl-oSsqDwOvK] [capture-out:-McF1W] [Processor@0x45f0255b ] [ 0] [-McF-eRl-oSsqDwOvK] [step:-McF1JHD-oSsq] [pipeline ] [ 0] [-McF-eRl-oSsqDwOvK] [setHeader6 ] [setHeader[Syndesis.STEP_ID] ] [ 1] [-McF-eRl-oSsqDwOvK] [to3 ] [sql-0-4 ] [ 6] Stacktrace --------------------------------------------------------------------------------------------------------------------------------------- org.apache.camel.RuntimeExchangeException: Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF47mhmZlpZ_rlQqlxz] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy$PopulateIterator.next(DefaultSqlPrepareStatementStrategy.java:355) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy.populateStatement(DefaultSqlPrepareStatementStrategy.java:180) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:146) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) ~[spring-jdbc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.apache.camel.component.sql.SqlProducer.process(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.component.proxy.ComponentProxyProducer.process(ComponentProxyProducer.java:44) ~[integration-component-proxy-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:148) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.tracing.TracingInterceptStrategy$EventProcessor.process(TracingInterceptStrategy.java:80) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:715) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:638) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:248) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Splitter.process(Splitter.java:129) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:197) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:79) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at java.util.TimerThread.mainLoop(Timer.java:555) [na:1.8.0_191] at java.util.TimerThread.run(Timer.java:505) [na:1.8.0_191] 2021-06-15 14:30:20.286 WARN 1 --- [r://integration] o.a.camel.component.timer.TimerConsumer : Error processing exchange. Exchange[i-McF47lSmZlpZ_rlQqlvz]. Caused by: [org.apache.camel.RuntimeExchangeException - Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF47mhmZlpZ_rlQqlxz]] org.apache.camel.RuntimeExchangeException: Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF47mhmZlpZ_rlQqlxz] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy$PopulateIterator.next(DefaultSqlPrepareStatementStrategy.java:355) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy.populateStatement(DefaultSqlPrepareStatementStrategy.java:180) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:146) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) ~[spring-jdbc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.apache.camel.component.sql.SqlProducer.process(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.component.proxy.ComponentProxyProducer.process(ComponentProxyProducer.java:44) ~[integration-component-proxy-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:148) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.tracing.TracingInterceptStrategy$EventProcessor.process(TracingInterceptStrategy.java:80) ~[integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:715) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:638) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:248) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Splitter.process(Splitter.java:129) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:197) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:79) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at java.util.TimerThread.mainLoop(Timer.java:555) [na:1.8.0_191] at java.util.TimerThread.run(Timer.java:505) [na:1.8.0_191] 2021-06-15 14:31:19.996 INFO 1 --- [r://integration] -McF-eRl-oSsqDwOvKO1 : Message Context: [{breadcrumbId=i-McF4MPpmZlpZ_rlQqm-z, CamelSqlRowCount=1, firedTime=Tue Jun 15 14:31:19 UTC 2021, Syndesis.FLOW_ID=-McF-eRl-oSsqDwOvKO1, Syndesis.STEP_ID=-McF1_CT-oSsqDwOvKO3, Syndesis.STEP_SPAN=4add090d163b2963:42e7f0d97520eff5:4add090d163b2963:1 - -McF1_CT-oSsqDwOvKO3}] Body: [[{"id":1, "task":"task1", "completed":null}]] 2021-06-15 14:31:20.007 ERROR 1 --- [r://integration] o.a.camel.processor.DefaultErrorHandler : Failed delivery for (MessageId: i-McF4MQ2mZlpZ_rlQqm3z on ExchangeId: i-McF4MPtmZlpZ_rlQqm1z). Exhausted after delivery attempt: 1 caught: org.apache.camel.RuntimeExchangeException: Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF4MPtmZlpZ_rlQqm1z] Message History --------------------------------------------------------------------------------------------------------------------------------------- RouteId ProcessorId Processor Elapsed (ms) [-McF-eRl-oSsqDwOvK] [-McF-eRl-oSsqDwOvK] [timer://integration?period=60000 ] [ 17] [-McF-eRl-oSsqDwOvK] [setHeader3 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [capture-out:-McF1E] [Processor@0x45f0255b ] [ 0] [-McF-eRl-oSsqDwOvK] [step:-McF1_CT-oSsq] [pipeline ] [ 3] [-McF-eRl-oSsqDwOvK] [setHeader4 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [log1 ] [log ] [ 2] [-McF-eRl-oSsqDwOvK] [step:-McF1WAL-oSsq] [pipeline ] [ 6] [-McF-eRl-oSsqDwOvK] [setHeader5 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [process1 ] [Processor@0x4544b816 ] [ 0] [-McF-eRl-oSsqDwOvK] [to2 ] [atlas:mapping-flow-0-step-3.json?encoding=UTF-8&sourceMapName=Syndesis.CAPTURE] [ 6] [-McF-eRl-oSsqDwOvK] [process2 ] [Processor@0x3913b6c7 ] [ 0] [-McF-eRl-oSsqDwOvK] [capture-out:-McF1W] [Processor@0x45f0255b ] [ 0] [-McF-eRl-oSsqDwOvK] [step:-McF1JHD-oSsq] [pipeline ] [ 0] [-McF-eRl-oSsqDwOvK] [setHeader6 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [to3 ] [sql-0-4 ] [ 3] Stacktrace --------------------------------------------------------------------------------------------------------------------------------------- org.apache.camel.RuntimeExchangeException: Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF4MPtmZlpZ_rlQqm1z] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy$PopulateIterator.next(DefaultSqlPrepareStatementStrategy.java:355) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy.populateStatement(DefaultSqlPrepareStatementStrategy.java:180) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:146) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) ~[spring-jdbc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.apache.camel.component.sql.SqlProducer.process(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.component.proxy.ComponentProxyProducer.process(ComponentProxyProducer.java:44) ~[integration-component-proxy-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:148) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.tracing.TracingInterceptStrategy$EventProcessor.process(TracingInterceptStrategy.java:80) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:715) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:638) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:248) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Splitter.process(Splitter.java:129) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:197) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:79) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at java.util.TimerThread.mainLoop(Timer.java:555) [na:1.8.0_191] at java.util.TimerThread.run(Timer.java:505) [na:1.8.0_191] 2021-06-15 14:31:20.009 WARN 1 --- [r://integration] o.a.camel.component.timer.TimerConsumer : Error processing exchange. Exchange[i-McF4MPpmZlpZ_rlQqm-z]. Caused by: [org.apache.camel.RuntimeExchangeException - Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF4MPtmZlpZ_rlQqm1z]] org.apache.camel.RuntimeExchangeException: Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF4MPtmZlpZ_rlQqm1z] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy$PopulateIterator.next(DefaultSqlPrepareStatementStrategy.java:355) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy.populateStatement(DefaultSqlPrepareStatementStrategy.java:180) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:146) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) ~[spring-jdbc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.apache.camel.component.sql.SqlProducer.process(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.component.proxy.ComponentProxyProducer.process(ComponentProxyProducer.java:44) ~[integration-component-proxy-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:148) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.tracing.TracingInterceptStrategy$EventProcessor.process(TracingInterceptStrategy.java:80) ~[integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:715) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:638) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:248) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Splitter.process(Splitter.java:129) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:197) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:79) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at java.util.TimerThread.mainLoop(Timer.java:555) [na:1.8.0_191] at java.util.TimerThread.run(Timer.java:505) [na:1.8.0_191] 2021-06-15 14:32:13.106 INFO 1 --- [ XNIO-2 task-1] io.undertow.servlet : Initializing Spring DispatcherServlet 'dispatcherServlet' 2021-06-15 14:32:13.107 INFO 1 --- [ XNIO-2 task-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2021-06-15 14:32:13.116 INFO 1 --- [ XNIO-2 task-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 9 ms 2021-06-15 14:32:19.994 INFO 1 --- [r://integration] -McF-eRl-oSsqDwOvKO1 : Message Context: [{breadcrumbId=i-McF4a3JmZlpZ_rlQqm4z, CamelSqlRowCount=1, firedTime=Tue Jun 15 14:32:19 UTC 2021, Syndesis.FLOW_ID=-McF-eRl-oSsqDwOvKO1, Syndesis.STEP_ID=-McF1_CT-oSsqDwOvKO3, Syndesis.STEP_SPAN=a51e94b57039c123:89c373bcbf73d9:a51e94b57039c123:1 - -McF1_CT-oSsqDwOvKO3}] Body: [[{"id":1, "task":"task1", "completed":null}]] 2021-06-15 14:32:20.004 ERROR 1 --- [r://integration] o.a.camel.processor.DefaultErrorHandler : Failed delivery for (MessageId: i-McF4a3WmZlpZ_rlQqm8z on ExchangeId: i-McF4a3OmZlpZ_rlQqm6z). Exhausted after delivery attempt: 1 caught: org.apache.camel.RuntimeExchangeException: Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF4a3OmZlpZ_rlQqm6z] Message History --------------------------------------------------------------------------------------------------------------------------------------- RouteId ProcessorId Processor Elapsed (ms) [-McF-eRl-oSsqDwOvK] [-McF-eRl-oSsqDwOvK] [timer://integration?period=60000 ] [ 15] [-McF-eRl-oSsqDwOvK] [setHeader3 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [capture-out:-McF1E] [Processor@0x45f0255b ] [ 0] [-McF-eRl-oSsqDwOvK] [step:-McF1_CT-oSsq] [pipeline ] [ 2] [-McF-eRl-oSsqDwOvK] [setHeader4 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [log1 ] [log ] [ 1] [-McF-eRl-oSsqDwOvK] [step:-McF1WAL-oSsq] [pipeline ] [ 6] [-McF-eRl-oSsqDwOvK] [setHeader5 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [process1 ] [Processor@0x4544b816 ] [ 0] [-McF-eRl-oSsqDwOvK] [to2 ] [atlas:mapping-flow-0-step-3.json?encoding=UTF-8&sourceMapName=Syndesis.CAPTURE] [ 6] [-McF-eRl-oSsqDwOvK] [process2 ] [Processor@0x3913b6c7 ] [ 0] [-McF-eRl-oSsqDwOvK] [capture-out:-McF1W] [Processor@0x45f0255b ] [ 0] [-McF-eRl-oSsqDwOvK] [step:-McF1JHD-oSsq] [pipeline ] [ 0] [-McF-eRl-oSsqDwOvK] [setHeader6 ] [setHeader[Syndesis.STEP_ID] ] [ 0] [-McF-eRl-oSsqDwOvK] [to3 ] [sql-0-4 ] [ 2] Stacktrace --------------------------------------------------------------------------------------------------------------------------------------- org.apache.camel.RuntimeExchangeException: Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF4a3OmZlpZ_rlQqm6z] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy$PopulateIterator.next(DefaultSqlPrepareStatementStrategy.java:355) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy.populateStatement(DefaultSqlPrepareStatementStrategy.java:180) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:146) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) ~[spring-jdbc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.apache.camel.component.sql.SqlProducer.process(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.component.proxy.ComponentProxyProducer.process(ComponentProxyProducer.java:44) ~[integration-component-proxy-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:148) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.tracing.TracingInterceptStrategy$EventProcessor.process(TracingInterceptStrategy.java:80) [integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:715) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:638) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:248) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Splitter.process(Splitter.java:129) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:197) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:79) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at java.util.TimerThread.mainLoop(Timer.java:555) [na:1.8.0_191] at java.util.TimerThread.run(Timer.java:505) [na:1.8.0_191] 2021-06-15 14:32:20.006 WARN 1 --- [r://integration] o.a.camel.component.timer.TimerConsumer : Error processing exchange. Exchange[i-McF4a3JmZlpZ_rlQqm4z]. Caused by: [org.apache.camel.RuntimeExchangeException - Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF4a3OmZlpZ_rlQqm6z]] org.apache.camel.RuntimeExchangeException: Cannot find key [id] in message body or headers to use when setting named parameter in query [INSERT INTO todo(id, completed, task) VALUES (:?id, :?completed, :?task) ON CONFLICT (id) DO UPDATE SET completed=:?completed, task=:?task] on the exchange: Exchange[i-McF4a3OmZlpZ_rlQqm6z] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy$PopulateIterator.next(DefaultSqlPrepareStatementStrategy.java:355) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy.populateStatement(DefaultSqlPrepareStatementStrategy.java:180) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:146) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) ~[spring-jdbc-5.2.13.RELEASE.jar!/:5.2.13.RELEASE] at org.apache.camel.component.sql.SqlProducer.process(SqlProducer.java:116) ~[camel-sql-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.component.proxy.ComponentProxyProducer.process(ComponentProxyProducer.java:44) ~[integration-component-proxy-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:148) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at io.syndesis.integration.runtime.tracing.TracingInterceptStrategy$EventProcessor.process(TracingInterceptStrategy.java:80) ~[integration-runtime-1.12.0-20210608.jar!/:1.12.0-20210608] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:715) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:638) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:248) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Splitter.process(Splitter.java:129) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:138) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.Pipeline.process(Pipeline.java:101) ~[camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:197) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:79) [camel-core-2.23.2.fuse-790029.jar!/:2.23.2.fuse-790029] at java.util.TimerThread.mainLoop(Timer.java:555) [na:1.8.0_191] at java.util.TimerThread.run(Timer.java:505) [na:1.8.0_191]