JASPER installation errors: DBUSERNAME_INSUFFICIENT_RIGHTS

Document ID : KB000006758
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

Environment:
Win 2012 R2Jaspersoft 6.2Java SDK 1.8.0_91/93Tomcat 8.5.13/14MS SQL 2012/2014
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.

 

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