Cognos Analytics

 View Only
Expand all | Collapse all

Error: UDA-SQL-0107 A general exception has occurred during the operation "open result".ORA-01722: invalid number

  • 1.  Error: UDA-SQL-0107 A general exception has occurred during the operation "open result".ORA-01722: invalid number

    Posted Fri January 13, 2023 01:58 PM
    Version 11.1.7

    I am not having luck resolving this.

    UDA-SQL-0107 A general exception has occurred during the operation "open result".ORA-01722: invalid number<br/>RSV-SRV-0042 Trace back:RSReportService.cpp(734): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(262): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(902): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(368): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(947): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(585): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(340): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(449): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(185): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(385): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(385): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(385): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(449): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(385): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyRSResultSetIterator.cpp(1513): QFException: CCL_RETHROW: RSResultSetIterator::retrieveDataQFSPartialDataset.cpp(80): QFException: CCL_RETHROW: QFSPartialDataset::GetEdgeIteratorSource/QEDmResultSet.cpp(75): QFException: CCL_THROW: QE

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

    #CognosAnalyticswithWatson


  • 2.  RE: Error: UDA-SQL-0107 A general exception has occurred during the operation "open result".ORA-01722: invalid number

    Posted Mon January 16, 2023 03:24 AM

    Hi Jenifer,

    have you checked used functions and filters?

    This error is most likely caused by an invalid data type comparison.

    Regards



    ------------------------------
    Gertrud Lohwasser
    ------------------------------

    Original Message


  • 3.  RE: Error: UDA-SQL-0107 A general exception has occurred during the operation "open result".ORA-01722: invalid number

    IBM Champion
    Posted Tue January 17, 2023 04:51 AM
    Hi Jenifer,

    It might be something wrong in a calculation, in a filter or in a query subject. A character string or a null value is returned and a number is expected.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message


  • 4.  RE: Error: UDA-SQL-0107 A general exception has occurred during the operation "open result".ORA-01722: invalid number

    Posted Tue January 17, 2023 07:50 AM

    As others have suggested, there is at least one expression that ORACLE is trying type convert a value to a numeric type and failing.

    This could be an implicit data type conversion, where you have a column reference, string expression or literal value, which ORACLE is trying to convert to a numeric type.

    For example:

    select 1 from dual where 'abc' > 123

    select 1 from dual where 'abc' + '123' = 22

    Typically you will start by looking at the SQL statement being sent to ORACLE, and review expressions. Should a "table" referenced in the statement be a view, then you would need to review the view definition, in case the expression is there.

    These are the typical scenarios to check first.



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

    Original Message


  • 5.  RE: Error: UDA-SQL-0107 A general exception has occurred during the operation "open result".ORA-01722: invalid number

    Posted Fri January 20, 2023 08:02 AM
    All,

    You were correct.  I was looking in the filters with no luck.  So I was baffled, but then I looked at every field and the user had created several calc fields that needed updated.

    Thank you so much everyone!
    Jen

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

    Original Message