AHD12002 Error when using PDMSeconds in Service Desk Manager

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

The following error appears when trying to apply SUM function to PDMSeconds. Example: SUM ( PDMSeconds(PDMDownTime('Días Hábiles 24 hrs','Mon - Fri { 12:00 am - 12:00 am } 01/01/16{}',  ktd.prev_time, ktd.end_time)) ) AS Time

Caused by: java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]AHD12002:Error en QueryHandler casmadmin-513797823-1 en el método fetch_response: syntax error, unexpected ',' at N'Regular' ,

This issue does not occur when not using sum function. Example: PDMSeconds(PDMDownTime('Días Hábiles 24 hrs','Mon - Fri { 12:00 am - 12:00 am } 01/01/16{}',  ktd.prev_time, ktd.end_time))

 

Environment

Release : 17.2

Component : JASPERSOFT REPORTS FOR SERVICE MANAGEMENT

Resolution

SQL Functions like SUM cannot be applied to PDMSeconds/PDMDownTime.

Workaround: In Jaspersoft: Use the "Use the group fields as sort fields. Select this option if you want to aggregate all the group fields with the same value..." or using a subreports.