shardingsphere-elasticjob-ui icon indicating copy to clipboard operation
shardingsphere-elasticjob-ui copied to clipboard

sqlserver2012 历史轨迹、历史状态报错

Open sandyisone opened this issue 3 years ago • 2 comments

Which version of ElasticJob did you use?

apache-shardingsphere-elasticjob-3.0.0-RC1-lite-ui

事件追踪数据源配置: 数据源驱动:com.microsoft.sqlserver.jdbc.SQLServerDriver,数据库版本:sqlserver2012,

选择“历史轨迹”报错:{"success":false,"errorCode":500,"errorMsg":"“LIMIT”附近有语法错误。 {prepstmnt 2020890103 SELECT t0.id, t0.complete_time, t0.execution_source, t0.failure_cause, t0.hostname, t0.ip, t0.is_success, t0.job_name, t0.sharding_item, t0.start_time, t0.task_id FROM JOB_EXECUTION_LOG t0 LIMIT ?} [code=102, state=S0001]","model":null}

选择“历史状态”报错:{"success":false,"errorCode":500,"errorMsg":"“LIMIT”附近有语法错误。 {prepstmnt 1515743386 SELECT t0.id, t0.creation_time, t0.execution_type, t0.job_name, t0.message, t0.original_task_id, t0.sharding_item, t0.slave_id, t0.source, t0.state, t0.task_id FROM JOB_STATUS_TRACE_LOG t0 LIMIT ?} [code=102, state=S0001]","model":null}

sandyisone avatar May 24 '21 04:05 sandyisone

ENV: elasticjob.tracing.datasource.driverClassName=org.postgresql.Driver elasticjob.tracing.datasource.url=jdbc:postgresql://127.0.0.1:5432/ejhis

errorMsg "ERROR: operator does not exist: boolean = integer\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts.\n Position: 211 {prepstmnt 625356322 SELECT t0.id, t0.complete_time, t0.execution_source, t0.failure_cause, t0.hostname, t0.ip, t0.is_success, t0.job_name, t0.sharding_item, t0.start_time, t0.task_id FROM JOB_EXECUTION_LOG t0 WHERE (t0.is_success = ?) LIMIT ?} [code=0, state=42883]"

ArberChang avatar Jun 09 '21 08:06 ArberChang

This issues may be related to #82 Before the problem fixed, try restarting the Spring Boot Application.

TeslaCN avatar Jul 11 '21 04:07 TeslaCN