Jasper Reports Error Through Workflow

[Former Member]

Hi,

Getting the following error on trying to generate the "Entry Report" from IDM workflow. Any clues on how this error can be troubleshooted and resolved. I have gone through the embedded SQLs in the "Entry Report.jrxml" and the .jrxml subreport files but haven't been able to corner on the reason.

Error filling print... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : fetchExecEntryName

net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : fetchExecEntryName 

    at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:663) 

    at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:331) 

    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:406)      at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:365) 

    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1429) 

    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:729) 

    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:276) 

    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:118)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:911) 

    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:814)      at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:561) 

    at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) 

    at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209)      at java.lang.Thread.run(Unknown Source) 

Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : fetchExecEntryName 

    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) 

    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:685) 

    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605) 

    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1235)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:865)      ... 5 more 

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the nvarchar value 'INITIALLY PROVISIONED MX_PERSON PRIVILEGE

S' to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) 

    at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)      at com.microsoft.sqlserver.jdbc.SQLServerStatement.buildNextRowset(Unknown Source) 

    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source) 

    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source) 

    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) 

    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source) 

    at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) 

    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source) 

    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)      ... 9 more 

Print not filled. Try to use an EmptyDataSource...

Thanks & Regards,

Vijaykumar Ganesan

[Former Member · Accepted solution]

Can you please check related errors on this? also make sure JDBC drivers updated properly.

try to re-start java instance

regards

nag