ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error Creating JasperSoft Domain When Adding Pre-Filter

book

Article ID: 200017

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager

Issue/Introduction

When trying to create a Domain in JasperSoft 7.1, receive an error message when clicking on the DISPLAY tab. 
 
 
The following error can be seen within the JasperServer log:
 
ERROR BaseJdbcMetaDataFactoryImpl,http-nio-8080-exec-8:250 - Cannot execute JDBC Query.
 
The issue only occurs when you add a pre-filter and select a family_symbol that has a dotted name, like Software.Application shown below. NOTE: This is where the problem is.  “Software” will work, but “<value>.<value>” does not. 
 

Environment

JasperSoft 7.1.1

Resolution

Tibco Support has indicated that this is a bug in JasperSoft 7.1.1.

There is a workaround for JasperSoft 7.1.1, though it is imperfect.  

1.  Create the domain while filtering on something without the 'dot' (i.e. Software) and save.  

2.  Export the domain schema to file and manually edit the filterString expression to include the dot.name.  For example:

<filterString>name == 'Software.Application'</filterString>

3.  Edit the domain and upload the updated schema and submit.  

This will update the domain, but you cannot click back into the pre-filter tab or you will encounter the same exception.  You can choose other tabs, but going from the pre-filter tab to any other tab will result in the exception.

Attachments