Jump to content
Changes to the Jaspersoft community edition download ×

Ad Hoc View server error when exporting to PDF, XLS, etc.


Recommended Posts

I have an Ad Hoc View using a domain with multiple tables, including a derived table. The derived table has a sum field, Reserve Amount. In the Ad hoc view, i have a filter on the Reserved Amount where the value is greater than or equal to 3000000. The Ad hoc View works fine, however, when I try to export the data, i get a server Error exception getting data Strategy and a java.sql.SQLException: ORA-01438: value larger than specified precision allowed for this column. The values in the table are much higher than this 3M filter. And if i lower the filter to 30000, it will export fine. 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...