Error while creating adhoc view reports in jaspersoft
book
Article ID: 5154
calendar_today
Updated On:
Products
CA SpectrumDX NetOps
Issue/Introduction
"An error occurred while creating the connection. Try again." is observed when creating Ad Hoc reports like below:
Environment
Spectrum integrated with CABI
Cause
CR_user does not have privileges
Jasper Repository spectrum_domain_ds does not:
use CR_user
point to the Spectrum Report Manager (SRM Server)
Resolution
Part 1. Assign privileges to CR_user from Spectrum Report Manager (SRM) as below:
Login to Spectrum Report Manager, from command prompt, navigate to $SPECROOT/mysql/bin running the below command:
cd $SPECROOT/mysql/bin
Now, login to mysql by running the below command:
mysql.exe –uroot –proot
Assign all privileges on to the user CR_user as below:
grant all privileges on *.* to 'CR_user'@'<CABI Hostname or IP address>' identified by '0n3cl1Ck';
Example: grant all privileges on *.* to 'CR_user'@'testserver.xyz.com' identified by '0n3cl1Ck'; where testserver.xyz.com is the CABI hostname, the below screenshot provides another example:
Part 2. Point Jasper Repository spectrum_domain_ds to the Spectrum Report Manager and change the user to CR_user
From browser (preferably Chrome), login to Jasper Console as superuser
Navigate to View ~~> Repository ~~> root ~~> public ~~> ca ~~> spectrum ~~> datasources
The below screenshot provides the view of the same:
Right click on spectrum_domain_ds data and click on Edit, or click spectrum_domain_ds and click on Edit beside Run
In "Set Data Source Type and Properties" page, make sure:
Host is set to the <SRM server hostname>
username is set to CR_user
password entered is 0n3cl1Ck
Perform "Test Connection"
On success, click Save.
Note:
If performing the "Test Connection" (Step 5) fails, try providing the FQDN (Ex:hostname.domainname.com) of the CABI Server while assigning privilege to CR_user mentioned in Step 3 under Part 1
Additional Information
Additionally, you can have OneClick reconfigure the Data Sources