Original Message:
Sent: Fri March 10, 2023 09:46 AM
From: HENK CAZEMIER
Subject: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED
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
Original Message:
Sent: Fri March 10, 2023 09:39 AM
From: Jenifer Broughton
Subject: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED
@HENK CAZEMIER Hi Henk. Thanks for this info. I tried it and got a expected CHAR got LONG error message.
------------------------------
Jenifer Broughton
Original Message:
Sent: Fri March 10, 2023 12:04 AM
From: HENK CAZEMIER
Subject: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED
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
Original Message:
Sent: Thu March 09, 2023 11:23 AM
From: Jenifer Broughton
Subject: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED
@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
Original Message:
Sent: Thu March 09, 2023 11:13 AM
From: HENK CAZEMIER
Subject: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED
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
Original Message:
Sent: Thu March 09, 2023 09:44 AM
From: Jenifer Broughton
Subject: Cognos 11.1.5 CCLAssertError:0:Fatal: CCL_ASSERT_NAMED
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
------------------------------