JASPER installation errors: DBUSERNAME_INSUFFICIENT_RIGHTS

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Installation of Jaspersoft 6.2 failed with the following error:

after executing install.bat:

Buildfile: C:\JASPER6.2\ca_install\build.xml

preinstallcheck:
[echo] Installation Component is:
[java] Initializing the Pre-Install Validation LOG file in ValidateAppServe
r Java
[java] Validation of Application server is completed Successfully
[java] Initializing the Pre-Install Validation LOG file in ValidateDbServer
Java
[java] Preinstall check failed with following errors -
[java] 16106: INVALID_APPSERVER_STATUS
[java] 16220: DBUSERNAME_INSUFFICIENT_RIGHTS
[java] 16220: DBUSERNAME_INSUFFICIENT_RIGHTS
[java] Java Result: 1

BUILD FAILED
C:\JASPER6.2\ca_install\build.xml:130: Preinstall check failed

Cause

This issue occurs because the user configured in the sample.properties doesn't have the correct grants to access the MS SQL to create a DB.

 

Environment

Win 2012 R2Jaspersoft 6.2Java SDK 1.8.0_91/93Tomcat 8.5.13/14MS SQL 2012/2014

Resolution

in sample.properties file the configured user as "dbUsername= xxxxx" must have roles: "public and dbcreator" to be able to create a the jaspersoft database in MS SQL.

Note: this is a pre-requisite to install Jaspersoft 6.2.

Additional Information

https://docops.ca.com/ca-business-intelligence/6-2-0/en/installing/installing-ca-business-intelligence/prerequisites