CUIC - using stored procedures : error

Version 1
    This document was generated from CDN thread

    Created by: Richard Rhinehart on 09-11-2010 07:34:33 PM
    Hello,
     
    I am trying to get a stored procedure to work with one of my reports in CUIC.
     
    Important to note: 
    I have verified the query works in SQL Server.
    The fields get created when i set the report to run with the stored proc.
    I removed all parameters to ensure that it wasn't a parameter that was causing the issue.
    I ran SQL Profiler on the db server and the request did not come through.

     
    I am getting the error below.  If anyone has had success or seen this can you please advise?  Thank you!
     
    Rick Rhinehart
     

    Error information:  
    com.cisco.ccbu.cuic.objectmodel.engine.CuicFormulaEvaluationException: java.lang.IndexOutOfBoundsException: Index: 50, Size: 50 at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetImplJexl.executeJexlScript(CuicDataSetImplJexl.java:533) at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetImplJexl.computeGlobalFooters(CuicDataSetImplJexl.java:402) at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetImplJexl.produceCustomData(CuicDataSetImplJexl.java:369) at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetBuilderJexl.produceCustomData(CuicDataSetBuilderJexl.java:188) at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.runReport(CuicDataProcessingCenterWorkerRunnable.java:313) at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.run(CuicDataProcessingCenterWorkerRunnable.java:117) 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) Caused by: java.lang.IndexOutOfBoundsException: Index: 50, Size: 50 at java.util.ArrayList.RangeCheck(ArrayList.java:547) at java.util.ArrayList.set(ArrayList.java:337) at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.commons.jexl.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:231) at org.apache.commons.jexl.parser.ASTMethod.execute(ASTMethod.java:104) at org.apache.commons.jexl.parser.ASTReference.execute(ASTReference.java:82) at org.apache.commons.jexl.parser.ASTReference.value(ASTReference.java:56) at org.apache.commons.jexl.parser.ASTReferenceExpression.value(ASTReferenceExpression.java:50) at org.apache.commons.jexl.parser.ASTJexlScript.value(ASTJexlScript.java:57) at org.apache.commons.jexl.ScriptImpl.execute(ScriptImpl.java:47) at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetImplJexl.executeJexlScript(CuicDataSetImplJexl.java:530) ... 10 more


    Subject: RE: CUIC - using stored procedures : error
    Replied by: Dattatraya Rooyikar on 12-11-2010 01:44:10 PM
    HI,
     
    The error looks like, you have created a formula field for a field which is incorrect after updating stored procedure. Can you create a new report definition with this stored procedure ? Please try this, it should work.
     
    Thanks,
    Datta
     
    Hello,
     
    I am trying to get a stored procedure to work with one of my reports in CUIC.
     
    Important to note: 
    I have verified the query works in SQL Server.
    The fields get created when i set the report to run with the stored proc.
    I removed all parameters to ensure that it wasn't a parameter that was causing the issue.
    I ran SQL Profiler on the db server and the request did not come through.

     
    I am getting the error below.  If anyone has had success or seen this can you please advise?  Thank you!
     
    Rick Rhinehart
     

    Error information:  
    com.cisco.ccbu.cuic.objectmodel.engine.CuicFormulaEvaluationException: java.lang.IndexOutOfBoundsException: Index: 50, Size: 50 at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetImplJexl.executeJexlScript(CuicDataSetImplJexl.java:533) at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetImplJexl.computeGlobalFooters(CuicDataSetImplJexl.java:402) at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetImplJexl.produceCustomData(CuicDataSetImplJexl.java:369) at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetBuilderJexl.produceCustomData(CuicDataSetBuilderJexl.java:188) at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.runReport(CuicDataProcessingCenterWorkerRunnable.java:313) at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.run(CuicDataProcessingCenterWorkerRunnable.java:117) 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) Caused by: java.lang.IndexOutOfBoundsException: Index: 50, Size: 50 at java.util.ArrayList.RangeCheck(ArrayList.java:547) at java.util.ArrayList.set(ArrayList.java:337) at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.commons.jexl.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:231) at org.apache.commons.jexl.parser.ASTMethod.execute(ASTMethod.java:104) at org.apache.commons.jexl.parser.ASTReference.execute(ASTReference.java:82) at org.apache.commons.jexl.parser.ASTReference.value(ASTReference.java:56) at org.apache.commons.jexl.parser.ASTReferenceExpression.value(ASTReferenceExpression.java:50) at org.apache.commons.jexl.parser.ASTJexlScript.value(ASTJexlScript.java:57) at org.apache.commons.jexl.ScriptImpl.execute(ScriptImpl.java:47) at com.cisco.ccbu.cuic.objectmodel.engine.CuicDataSetImplJexl.executeJexlScript(CuicDataSetImplJexl.java:530) ... 10 more