CA PPM JasperSoft Studio Error

book

Article ID: 195799

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

When try to run the query in Jaspersoft Studio 7.1 and get the below error message

But getting error: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: DJ_1.
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:347)
 at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFieldsProvider.java:68)
 at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(JDBCDataAdapterDescriptor.java:70)
 at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGetFields(DataQueryAdapters.java:519)
 at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQueryDesignerContainer.java:49)
 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

Caused by: java.sql.SQLException: Execute Query fail.Invalid fetch size set. Cannot be of value: 100
 at com.jaspersoft.web.rest.JasperRestConnector.executeRequest(JasperRestConnector.java:269)
 at com.jaspersoft.jdbc.driver.JasperPreparedStatement.executeQuery(JasperPreparedStatement.java:52)
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310)
 ... 5 more

Cause

The JDBC Drivers was not install properly

Environment

Release : 15.8.1

Component : CA PPM APPLICATION

Resolution

Removed and Re-add the JDBC Drivers has resolved the issue.