Unified Reporter error when creating adhoc view

Document ID : KB000069726
Last Modified Date : 30/03/2018
Show Technical Document Details
Issue:

When trying to create an adhoc view (to create custom reports later), Unified Reporter displays the following error with all browser types:

"The server has encountered an error. Please excuse the inconvenience.
Error Message
java.lang.RuntimeException: exception getting dataset from cache

Error Trace
java.lang.RuntimeException: exception getting dataset from cache at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:184) at com.jaspersoft.ji.adhoc.strategy.NewClassicDataStrategy.getWorkingDataSet(NewClassicDataStrategy.java:120) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1026) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.initWorkingDataSet(InteractiveDataLayoutEngine.java:350) at com.jaspersoft.ji.adhoc.InteractiveCrosstabBaseEngine$DimensionDataSetInitializer.initDimensionDataSet(InteractiveCrosstabBaseEngine.java:101) at com.jaspersoft.ji.adhoc.InteractiveCrosstabBaseEngine$DimensionDataSetInitializer.init(InteractiveCrosstabBaseEngine.java:81) at com.jaspersoft.ji.adhoc.InteractiveIntelligentChartEngine.generateViewModel(InteractiveIntelligentChartEngine.java:113) at "

........... Could not find stored procedure 'spn_js_QosReport'.

The above error is also seen in the X:\Nimsoft\probes\service\wasp\webapps\jasperserver-pro\WEB-INF\logs\jasperserver.log

Run the Unified Reporter install again (installUR.exe) over the existing install and confirm that the missing stored procedure, 'spn_js_QosReport' is listed in the UIM database stored procedure list.

Environment:
Unified Reporter 8.4
Cause:
This error may be seen with a faulty install/upgrade of Unified Reporter when stores procedures are not created in the UIM database.
Store procedures are listed in the UIM Database -> Programmability -> Stored Procedures
 
Resolution:
Run the Unified Reporter install again (installUR.exe) over the existing install and confirm that the missing stored procedure, 'spn_js_QosReport' is listed in the UIM database stored procedure list.