search

apache / shardingsphere-elasticjob-ui

Administrator console of ElasticJob
https://shardingsphere.apache.org/
Apache License 2.0
162 stars 97 forks source link

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

Open sandyisone opened 3 years ago

sandyisone commented 3 years ago

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}

ArberChang commented 3 years ago

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]"

TeslaCN commented 3 years ago

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