Hey all...
 
I'm hoping someone has seen this type of error and has some insight.  This is occuring every time a user tries to run a report in CUIC.  The page shows "Dataset Status is Failed" and when you click "Error Details" the following shows:
 

<table border="0">
<tbody>
<tr>
<td style="padding-left: 10px;" align="left">Error information:</td>
</tr>
<tr>
<td id="errMsg" style="padding-left: 10px;" align="left">com.cisco.ccbu.cuic.businesslogic.engine.CuicLowResourcesException: The number of rows requested is not available. Requested: 50 Available: 49 at com.cisco.ccbu.cuic.businesslogic.engine.CuicEngineRowsThrottler.checkoutRows(CuicEngineRowsThrottler.java:216) at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetBuilderJexl.loadData(CuicDataSetBuilderJexl.java:93) at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:1005) at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.runReport(CuicDataProcessingCenterWorkerRunnable.java:335) at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.run(CuicDataProcessingCenterWorkerRunnable.java:142) at com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:88) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) at com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)</td>
</tr>
</tbody>
</table>

 
Please let me know if anyone has any insight into what may be causing this.
 
Thanks!

I get the same error as Joe. Pasting the SQL into an HDS qry window works fine.

I believe I fixed the issue by changing the BeginDate and EndDate in the Data Source from a DateTime specification to just Date. The custom DateTime option in CUIS 7.5 does not translate very well to CUIC.