Cognos Analytics

 View Only
Expand all | Collapse all

Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

  • 1.  Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    Posted Thu March 09, 2023 09:45 AM

    I have a report that runs.  It has 2 pages.

    After paging down several pages which appear fine.  There comes a point when I then page down and get the following error message.

    Anyone have any ideas?

    CCLAssertError:0:Fatal: CCL_ASSERT_NAMED(false, "Generic ident/value parse can only handle one value type - if more than one, create a specific method to handle it");
    RSV-SRV-0042 Trace back:
    RSReportService.cpp(774): CCLAssertError: CCL_CAUGHT: RSReportService::processImpl()
    RSReportServiceMethod.cpp(254): CCLAssertError: CCL_RETHROW: RSReportServiceMethod::process(): pagingNextPage_Request
    RSASyncExecutionThread.cpp(887): CCLAssertError: RSASyncExecutionThread::checkException
    RSASyncExecutionThread.cpp(331): CCLAssertError: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): pagingNextPage_Request
    RSASyncExecutionThread.cpp(932): CCLAssertError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): pagingNextPage_Request
    Execution/RSRenderExecution.cpp(586): CCLAssertError: CCL_RETHROW: RSRenderExecution::execute
    Assembly/RSDocAssemblyDispatch.cpp(339): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSLayoutAssembly.cpp(79): CCLAssertError: CCL_RETHROW: RSLayoutAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(448): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
    Assembly/RSReportPagesAssembly.cpp(185): CCLAssertError: CCL_RETHROW: RSReportPagesAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(384): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSPageAssembly.cpp(314): CCLAssertError: CCL_RETHROW: RSPageAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(384): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSTableRowAssembly.cpp(177): CCLAssertError: CCL_RETHROW: RSTableRowAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(384): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSTableCellAssembly.cpp(151): CCLAssertError: CCL_RETHROW: RSTableCellAssembly::assemble
    Assembly/RSDocAssemblyDispatch.cpp(448): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
    Assembly/RSDocAssemblyDispatch.cpp(384): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSDocAssemblyDispatch.cpp(384): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSDocAssemblyDispatch.cpp(384): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
    Assembly/RSDocAssemblyDispatch.cpp(448): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
    RSCssStyleMgr/RSCssDeclarationParser.cpp(2623): CCLAssertError: CCL_THROW: 



    ------------------------------
    Jenifer Broughton
    ------------------------------


  • 2.  RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    Posted Thu March 09, 2023 10:47 AM

    Additional information:

    RQP-DEF-0177 An error occurred while performing operation 'sqlROpen' status='-58'.
    UDA-SQL-0601 Cannot access blob data of previous rows, since the query contains blob column "rc19" that requires sequential access.



    ------------------------------
    Jenifer Broughton
    ------------------------------



  • 3.  RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    IBM Champion
    Posted Thu March 09, 2023 11:14 AM
    Are you on a version earlier than v11 by chance? It was mentioned in the link below as a fix since resolved:




    Logan Whitaker

    PMO, HEB Supply Chain Planning & Operations

    o: 210.938.6043 m: 210.429.3181

    e: whitaker.logan@heb.com







  • 4.  RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    Posted Thu March 09, 2023 11:19 AM

    @Logan Whitaker it's version 11.1.5



    ------------------------------
    Jenifer Broughton
    ------------------------------



  • 5.  RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    Posted Thu March 09, 2023 11:14 AM

    Hi Jennifer,

    That looks like a bug. I did a quick scan and it isn't a known issue as far as I can tell.

    Could you please log a ticket with IBM Support



    ------------------------------
    Kind regards,
    Henk Cazemier
    ------------------------------



  • 6.  RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    Posted Thu March 09, 2023 11:24 AM

    @HENK CAZEMIER Ok, I will request this be done on my end.  Also, some added information.  There is a field in the report (a comments field) that is being defined as a 'Rich text item'.  This is the field causing the issue.  Any work around to have I could apply in the report to fix the formatting other than using the Rich Text Item?

    Thanks,

    Jen



    ------------------------------
    Jenifer Broughton
    ------------------------------



  • 7.  RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    Posted Fri March 10, 2023 12:05 AM

    Hi Jennifer,

    From what I can tell from the message/code it is related to a blob field. One of the things that may work is to apply a cast to a nvarchar(4000) around the blob column reference. This is not supported by all vendors and may not work in your case. Also the 4000 has vendor limitations, so you may need to adjust that.



    ------------------------------
    Kind regards,
    Henk Cazemier
    ------------------------------



  • 8.  RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    Posted Fri March 10, 2023 09:40 AM

    @HENK CAZEMIER   Hi Henk.  Thanks for this info.  I tried it and got a expected CHAR got LONG error message.



    ------------------------------
    Jenifer Broughton
    ------------------------------



  • 9.  RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    Posted Fri March 10, 2023 09:47 AM

    Hi Jennifer,

    That doesn't leave many options on the table.

    I found one reference that might be helpful: How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONG - Ed Chen Logic



    ------------------------------
    Kind regards,
    Henk Cazemier
    ------------------------------



  • 10.  RE: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED

    Posted Fri March 10, 2023 01:08 PM

    @HENK CAZEMIER Thanks Henk!  I do not have access to the database to create a new table or view.  I did try everything I could think of in Cognos but with no luck.  I'll reach out to our db and have them do some testing.

    Thank you so much for your quick response!



    ------------------------------
    Jenifer Broughton
    ------------------------------