search cancel

Bad request when I select an item on a Jasper report

book

Article ID: 256227

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

When I click a model in a CABI report, the next error message is displayed

This seems to start happening after SSL was configured in OneClick.

The url is 

http://<OneClick_Server>:8443/spectrum...

but it should be

https://<OneClick_Server>:8443/spectrum...

How can this be configured to use the correct URL?

Environment

Release : 21.2

Cause

The URL is obtained from the Reporting database.

Specifically from the reporting.registry table.

Resolution

To set the correct URL,

1. ssh to the server as the spectrum owner, and cd to $SPECROOT/mysql/bin

2. run: ./mysql --defaults-file=../my-spectrum.cnf -uroot -pMySqlR00t

3. run: use reporting;

4. run: UPDATE registry SET OneClickServerEntry = 'https://<oneclick_fqdn>:443' WHERE reg_user = 'System';

5. run: exit

6. Run a report to confirm the Bad Request error is no longer seen when you click a model (It is not necessary to restart OneClick or Jasper)
    This time a jnlp file should be downloaded.

NOTES:

You need to replace <oneclick_fqdn> with the oneclick FQDN.

In the above example the port 443 was, but if OneClick is using a different SSL port, you need to change that as well.

Attachments