Report Generation failed

When I try and run the report published on iServer express , I get the following error but I can run the report in Espreadsheet designer.

Report Generation failed. Exception: Not all queries executed sucessfully.

Can someone help.

Thanks

Find more posts tagged with

Comments

rmurphy

What is your datasource? If it is JDBC, are you using the drivers that ship with the product, or are you using a different JDBC driver?

What version of the designer are you using, and what version of iServer Express are you using?

Can you post the .sod file?

Rob

Amruta29

I am using MY SQL Connector/J as a JDBC Driver. I downloaded JDBC DRiver from <a class='bbc_url' href='http://www.mysql.com/products/connector/'>MySQL :: MySQL Connectors</a> 
 
I am using Actuate 10 SP1 version. I downloaded Espreadsheet designer from BIRT exchnage place. 
 
I am using Actuate iServer version: 10 Service Pack 1 Fix 2 (Build 100C090701) 
 
I am unable to upolad the file. I get an error that says invalid file. Looks like.SOD extension is not supported.

rmurphy

If you add the .sod file to a zip you will be able to upload it.

If you are not using the MySQL JDBC Driver that comes with the Spreadsheet Designer, you will have to make sure you add the JDBC Jar file to the iServer. Assuming a default install, your JAR file should go in C:Program FilesActuate10iServerreportenginesenginesesslib. Restart the iServer after copying in the JAR file.

Rob