JasperSoft Adhoc Report Fails When Adding Measure

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

When adding a new measure to a JasperSoft crosstab adhoc view column, the following error is received within Service Desk Manager (SDM) logs:

SDMSERVER sqlagt:select3       7004 ERROR        sqlclass.c            1013 SQL Execute  failed: [Microsoft SQL Server Native Client 10.0] [ SQL Code=103 SQL State=42000] The identifier that starts with 'JASPERSOFT_MEASURE NAME' is too long. Maximum length is 128.

SDMSERVER bpvirtdb_srvr        4816 ERROR        vdbmisc.c              688 Miscellaneous Database error occured :[Microsoft SQL Server Native Client 10.0] [ SQL Code=103 SQL State=42000] The identifier that starts with 'JASPERSOFT_MEASURE NAME' is too long. Maximum length is 128.

where JASPERSOFT_MEASURE NAME = the Measure Name created in JasperSoft for the report

Environment

Service Desk Manager 17.1 and 17.2

JasperSoft 7.x

All Supported Windows Operating Systems

Cause

The error is caused strictly as a result of a hardcoded SQL query identifier limit of 128 characters.    You can test it out by using a simple SQL query using an independent tool.

https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-ver15

Resolution

The only short term workaround would be to use shorter calculated measure names that do not exceed 128 characters.

Additional Information

Enhancement request has been submitted to Tibco for JasperSoft to handle longer measure names (JS-60074)