[GitHub] [shardingsphere-elasticjob-ui] sandyisone opened a new issue #115: sqlserver2012 历史轨迹、历史状态报错

[GitBox <gi...@apache.org>]

sandyisone opened a new issue #115:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/115


   
   ### 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}
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere-elasticjob-ui] ArberChang commented on issue #115: sqlserver2012 历史轨迹、历史状态报错

[GitBox <gi...@apache.org>]

ArberChang commented on issue #115:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/115#issuecomment-857496145


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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere-elasticjob-ui] TeslaCN commented on issue #115: sqlserver2012 历史轨迹、历史状态报错

[GitBox <gi...@apache.org>]

TeslaCN commented on issue #115:
URL: https://github.com/apache/shardingsphere-elasticjob-ui/issues/115#issuecomment-877740138


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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org