In Jasper Adhoc, Domain creation results into null

[ramachandra]

Hi All,

 

   I am trying to create Domain in Jasper Adhoc server. This involves 12 views with left outer join resulting into 10 million rows if executed externally from Oracle sql plus.

In a similar way when this is done on Adhoc, by creating new domain, at the end it shows 'null' dialog box and domain does not gets saved.

I am in a requirement where I cannot reduce these joins and the result goes into 10 milllion rows. How to I overcome this null issue.

Is it limitation on Jasper's mysql or limitation on jasper adhoc itself in limiting the resulting rows.

 

Any inputs in this direction would be greately helpful.

 

Thanks

Ram