What are the Essential DB Role required for DBUserName JBoss -Jasperreport server installation

Solution Verified - Updated -

Issue

  • We would like to verify the specific underlying DB role of the dbuser ( that configured to connect the reporting database server) needed for JBoss and Jasper Reporting server installation and generating WAR files ?
  • we need to know what are the essential specific DB roles to be granted during setup JBoss and Jasper reporting server ?

The related error message with no sufficient permission granted:

Error Message:

[org.infinispan.factories.GlobalComponentRegistry] (ServerService Thread Pool -- 76) ISPN000128: Infinispan version: Infinispan 'Brahma' 5.1.2.FINAL22:04:43,967 INFO  [stdout] (ServerService Thread Pool -- 76) 2015-08-31 22:04:43,967 ERROR JDBCExceptionReporter,ServerService Thread Pool -- 76:101 - [TIBCO][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'JIResourceFolder', database 'DEDMT3', schema 'dbo'.
22:04:43,967 INFO  [stdout] (ServerService Thread Pool -- 76) 2015-08-31 22:04:43,967 ERROR JDBCExceptionReporter,ServerService Thread Pool -- 76:101 - [TIBCO][SQLServer JDBC Driver][SQLServer]The cursor was not declared.
22:04:44,341 INFO  [stdout] (ServerService Thread Pool -- 76)

Environment

  • Red Hat JBoss Enterprise Application Platform 6.4.0
  • Jasper Server
  • MS SQL 2008 R2.

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content