Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  CASE in SQL fails with Oracle since upgrade to 11.1.7FP2

    Posted Tue January 26, 2021 12:13 PM
    Hi Community,

    we have a strage effect after upgrading from 11.1.7 GA to 11.1.7FP2:

    The Query Subject has a attribute defined as:

    CASE [Behandler]  WHEN 'Otto' THEN 'getroffen'

    END

    results in this error:

    XQE-DAT-0001 Datenquellenadapterfehler: java.sql.SQLException: ORA-12704: Zeichensatz-Mismatch

    RSV-SRV-0042 Zurückverfolgen:

    RSReportService.cpp(764): XQEException: CCL_CAUGHT: RSReportService::processImpl()

    RSReportServiceMethod.cpp(254): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_Request

    RSASyncExecutionThread.cpp(887): XQEException: RSASyncExecutionThread::checkException

    RSASyncExecutionThread.cpp(331): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_Request

    RSASyncExecutionThread.cpp(932): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_Request

    Execution/RSRenderExecution.cpp(585): XQEException: CCL_RETHROW: RSRenderExecution::execute

    Assembly/RSDocAssemblyDispatch.cpp(340): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly

    Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assemble

    Assembly/RSDocAssemblyDispatch.cpp(449): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward

    Assembly/RSReportPagesAssembly.cpp(185): XQEException: CCL_RETHROW: RSReportPagesAssembly::assemble

    Assembly/RSDocAssemblyDispatch.cpp(385): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly

    Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW: RSPageAssembly::assemble

    Assembly/RSDocAssemblyDispatch.cpp(385): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly

    Assembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW: RSTableRowAssembly::assemble

    Assembly/RSDocAssemblyDispatch.cpp(385): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly

    Assembly/RSTableCellAssembly.cpp(151): XQEException: CCL_RETHROW: RSTableCellAssembly::assemble

    Assembly/RSDocAssemblyDispatch.cpp(449): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward

    Assembly/RSDocAssemblyDispatch.cpp(385): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly

    Assembly/RSAssembly.cpp(699): XQEException: CCL_RETHROW: RSAssembly::createListIterator

    Assembly/RSAssembly.cpp(767): XQEException: CCL_RETHROW: RSAssembly::createListIterator

    RSQueryMgr.cpp(840): XQEException: CCL_RETHROW: RSQueryMgr::getListIterator

    RSQueryMgr.cpp(912): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIterator

    RSQueryMgr.cpp(1020): XQEException: CCL_RETHROW: RSQueryMgr::createIterator

    RSQueryMgrBasic.cpp(296): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommand

    RSQueryMgrExecutionHandlerImpl.cpp(167): XQEException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()

    QFSSession.cpp(1238): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()

    QFSSession.cpp(1236): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()

    QFSSession.cpp(1197): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()

    QFSConnection.cpp(854): XQEException: CCL_RETHROW: QFSConnection::Execute

    QFSQuery.cpp(213): XQEException: CCL_RETHROW: QFSQuery::Execute v2

    XQEConnector.cpp(300): XQEException: CCL_THROW: XQEConnector::send


    does any customer ran into the same problem?
    Any hints are welcome!

    BTW: IF3 does not fix the problem...

    Target DB is a Oracle Exadata

    cheers
    Martin
    (Senior Solution Expert, IBM Champion 2019, 2020, 2021)


    ------------------------------
    Martin Otto
    senior solution expert
    avantum consult AG
    Konstanz area
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: CASE in SQL fails with Oracle since upgrade to 11.1.7FP2

    Posted Tue January 26, 2021 10:38 PM

    I recommend that you open a support call, re comment about seeing error having moved to 11.1.7 FP2.

    ORACLE typically will throw such errors when a conditional expression (i.e. CASE, COALESCE, ...) combines two or more character expressions with different character sets.

    https://docs.oracle.com/en/database/oracle/oracle-database/21/errmg/ORA-12700.html#GUID-E6873876-0D0A-456E-B89B-F5A2E41F0638

    Customer support can explain how to enable our trace to capture the SQL statement being sent to ORACLE.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------

    Original Message


  • 3.  RE: CASE in SQL fails with Oracle since upgrade to 11.1.7FP2

    Posted Wed January 27, 2021 03:26 AM
    Hello Martin,

    Oracle error seems to be related to encoding problem :
    http://www.dba-oracle.com/t_ora_12704_character_set_mismatch.htm

    maybe you could get the generate SQL I try to directly execute it with oracle client.

    regards,
    Vivien

    ------------------------------
    Vivien
    ------------------------------

    Original Message


Related Content