- Notifications
You must be signed in to change notification settings - Fork958
Description
Describe the bug
We got a consistent error in log file rundeck.log
[2025-10-09T00:00:04,709] WARN spi.SqlExceptionHelper [qtp695356327-4015] - SQL Error: 8117, SQLState: S0001
[2025-10-09T00:00:04,709] ERROR spi.SqlExceptionHelper [qtp695356327-4015] - Operand data type datetime2 is invalid for subtract operator.
As i can see there are plenty columns of datetime2 on the DB. So i look into code and find a subtract operations in ExecutionServise.groovy(rundeck/rundeckapp/grails-app/services/rundeck/services/ExecutionService.groovy).
` private boolean isSqlCompatible() {
boolean isCompatible = false
try{
Execution.createCriteria().list(max:1) {
projections{
sqlProjection '(date_completed - date_started) as durationSum', 'durationSum', StandardBasicTypes.TIME
}
}
isCompatible = true } catch(JDBCException ex){ isCompatible = false } return isCompatible}`` def metricCriteriaA = {
def baseQueryCriteria = query.createCriteria(delegate, jobQueryComponents)
baseQueryCriteria()
resultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP) projections { rowCount("count") sqlProjection 'sum(date_completed - date_started) as durationSum', 'durationSum', StandardBasicTypes.TIME sqlProjection 'min(date_completed - date_started) as durationMin', 'durationMin', StandardBasicTypes.TIME sqlProjection 'max(date_completed - date_started) as durationMax', 'durationMax', StandardBasicTypes.TIME } }`` def metricCriteriaB = {
// Run main query criteria
def baseQueryCriteria = query.createCriteria(delegate, jobQueryComponents)
baseQueryCriteria()
resultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP) projections { rowCount("count") sqlProjection 'sum(extract(EPOCH from (date_completed - date_started))) as durationSum', 'durationSum', StandardBasicTypes.LONG sqlProjection 'min(extract(EPOCH from (date_completed - date_started))) as durationMin', 'durationMin', StandardBasicTypes.LONG sqlProjection 'max(extract(EPOCH from (date_completed - date_started))) as durationMax', 'durationMax', StandardBasicTypes.LONG } }`My Rundeck detail
- Rundeck version: 5.16.0-20251006
- install type: war
- OS Name/version: Windows Server 2016 Standart
- DB Type/version: mssql
To Reproduce
Steps to reproduce the behavior:
- Go to C:\rundeck\server\logs\rundeck.log
- See error
Desktop (please complete the following information):
- OS: Windows 11
- Browser: firefox
- Version: 143.0.4