bytechefhq
[bug]: Unable to handle connections
Describe the bug
There are error log entries: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT "connection"."id" AS "id", "connection"."type" AS "type", "connection"."name" AS "name", "connection"."version" AS "version", "connection"."created_by" AS "created_by", "connection"."parameters" AS "parameters", "connection"."created_date" AS "created_date", "connection"."environment" AS "environment", "connection"."component_name" AS "component_name", "connection"."last_modified_by" AS "last_modified_by", "connection"."last_modified_date" AS "last_modified_date", "connection"."credential_status" AS "credential_status", "connection"."authorization_name" AS "authorization_name", "connection"."connection_version" AS "connection_version" FROM "connection" ORDER BY "connection"."name" ASC, "connection"."id" ASC]
Steps To Reproduce
- Go to Deployments
- select Email Reader - OnDemand and Execute In the logs there is: Message value Stack Trace java.lang.NullPointerException: value at java.base/java.util.Objects.requireNonNull(Objects.java:259) at com.github.mizosoft.methanol.FormBodyPublisher$Builder.query(FormBodyPublisher.java:144) at com.bytechef.platform.component.service.ConnectionDefinitionServiceImpl.lambda$getDefaultRefreshFunction$23(ConnectionDefinitionServiceImpl.java:466) at com.bytechef.platform.component.service.ConnectionDefinitionServiceImpl.executeRefresh(ConnectionDefinitionServiceImpl.java:219) at com.bytechef.platform.component.util.TokenRefreshHelper.getRefreshedCredentialsComponentConnection(TokenRefreshHelper.java:117) at com.bytechef.platform.component.util.TokenRefreshHelper.executeSingleConnectionFunction(TokenRefreshHelper.java:89) at com.bytechef.platform.component.facade.ActionDefinitionFacadeImpl.executePerform(ActionDefinitionFacadeImpl.java:155) at com.bytechef.platform.workflow.worker.task.handler.AbstractTaskHandler.handle(AbstractTaskHandler.java:59) at com.bytechef.atlas.worker.TaskWorker.doExecuteTask(TaskWorker.java:194) at com.bytechef.atlas.worker.TaskWorker.lambda$onTaskExecutionEvent$0(TaskWorker.java:116) at com.bytechef.tenant.concurrent.TenantThreadPoolTaskExecutor.lambda$getTenantRunnable$0(TenantThreadPoolTaskExecutor.java:64) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.lang.Thread.run(Thread.java:1583)
and
[2m2025-06-24T14:06:52.804Z[0;39m [31mERROR[0;39m [35m7[0;39m [2m---[0;39m [2m[egateEndpoint-1][0;39m [36mc.e.l.TriggerExecutionErrorEventListener[0;39m [2m:[0;39m Trigger id=30: message=com.bytechef.component.exception.ProviderException$UnauthorizedException: 401: {[31m_[0;39m "error": {[31m_[0;39m "code": 401,[31m_[0;39m "message": "Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",[31m_[0;39m "status": "UNAUTHENTICATED"[31m_[0;39m }[31m_[0;39m}[31m_[0;39m[31m_[0;39mstackTrace=[com.bytechef.platform.workflow.worker.exception.TriggerExecutionException: com.bytechef.component.exception.ProviderException$UnauthorizedException: 401: {, "error": {, "code": 401,, "message": "Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",, "status": "UNAUTHENTICATED", }, }, [31m_[0;39mat com.bytechef.platform.workflow.worker.trigger.handler.AbstractTriggerHandler.handle(AbstractTriggerHandler.java:70), [31m_[0;39mat com.bytechef.platform.workflow.worker.TriggerWorker.doExecuteTrigger(TriggerWorker.java:152), [31m_[0;39mat com.bytechef.platform.workflow.worker.TriggerWorker.lambda$onTriggerExecutionEvent$0(TriggerWorker.java:90), [31m_[0;39mat com.bytechef.platform.workflow.worker.executor.TriggerWorkerExecutor.submit(TriggerWorkerExecutor.java:32), [31m_[0;39mat java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103), [31m_[0;39mat java.base/java.lang.reflect.Method.invoke(Method.java:580), [31m_[0;39mat org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:359), [31m_[0;39mat org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196), [31m_[0;39mat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163), [31m_[0;39mat org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:114), [31m_[0;39mat com.bytechef.tenant.concurrent.TenantThreadPoolTaskExecutor.lambda$getTenantCallable$1(TenantThreadPoolTaskExecutor.java:80), [31m_[0;39mat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317), [31m_[0;39mat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144), [31m_[0;39mat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642), [31m_[0;39mat java.base/java.lang.Thread.run(Thread.java:1583), Caused by: ExecutionException{entityClass=interface com.bytechef.component.definition.ActionDefinition, errorKey=106, errorMessageArguments=null, inputParameters=
Expected behavior
I expect I can create and use connection.
Version
2.3.1
OS
macos
Browser
No response
Additional context
No response
