Skip to Main Content
IBM Data and AI Ideas Portal for Customers
Hide about this portal


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Please increase size of LAST_FAILURE_REASON column in Task Attributes table.

See this idea on ideas.ibm.com

The SSM and SIM error log is saved in LAST_FAILURE_REASON column of Task Attributes table. It is set to 2048 chars currently. However, the error message is much longer than 2048 chars. So we can't see the whole error message in Task Attributes table and "soamview task -l command output". Please increase size of LAST_FAILURE_REASON column in Task Attributes table. We are using "Oracle Database 19c Enterprise Edition". Thank you very much.

Needed By Not sure -- Just thought it was cool
  • Guest
    Reply
    |
    Dec 31, 2024

    Hi,

     When support find the error log in file for task_attributes few days before, I see it is around 7500 characters. I know we have [SPCS-I-1053] to increase last_failure_reason column varchar to 5000 from 2048 in task_attributes. Not sure if it is enough for user to trace the error. The following is the error message in log.

     Thank you very much

    Diane

     --------------------------------------------------------

    2024-12-27 01:45:15.236 GMT Standard Time ERROR [17508:6216] soam.common.EventAgent - Code[S75053]: Application <SimplicitiRiskGrid>, service <comlib_prod_24.44.1>: Fatal exception thrown on method <invoke>, control code <707>. Action on workload: action <fail> taken on task <1> in session <3958025>. Action on service instance: action <keepAlive> taken on service instance process <8576>, host <GRIDEXLNW1021>, service <comlib_prod_24.44.1>.

    2024-12-27 01:45:15.236 GMT Standard Time ERROR [17508:6216] sim.simcore.ServiceBroker - Code[S20060]: d:\buildagent-1\work\packages\platform-symphony-de.7.2.0.3\lib\native\7.2.0\src\soamservicecontainer.cpp : 469 IException  Domain <Application>: Fatal service error in method onInvoke(): #GridErr: NetAddinClientException [#GridErr: RtException [Exception in task handler [Traceback (most recent call last):

      File "module_main", line 352, in ComputePAAForTrades

        res = ComputePAAForTrade(factory,trade, dateT,dateTp1,envT,envTp1,envSodTp1,pnlExplainType,useRiskEngine,useForwardsRisk,useTp1Results,bumpCfxNatively,isTreasuryHedged,useDefaultBumpSettings,UseYcRiskPnl,False,None,None,disaggregatePaa,hierarchy,UseCSAFlow)

      File "module_main", line 429, in ComputePAAForTrade

        paa_results = paa_results.Add(cmd.ValuationUtilsExplain2(cenvSOD,cenv2, today, today_p1, trade, trade, valfactory, result_risk, req_sod_paa, useRiskEngine = useRiskEngine, useForwardRisks = useForwardsRisk,use_tp1_results = useTp1Results, useYCRisk = UseYcRiskPnl))

      File "C:\Symphony732\soam\deploy\162496_Commodities\162496_SimpliCiti_rtGrid\comlib_prod_24.44.1.v1\comlib\cmd.py", line 230133, in ValuationUtilsExplain2

        return globals()["IResult"]._convert(_ValuationUtilsExplain2(_CheckedRefToXVar(env, globals()["IEnv"], "env", "cmd", "IEnv", "cmd.ValuationUtilsExplain2", 1), _CheckedRefToXVar(env_tp1, globals()["IEnv"], "env_tp1", "cmd", "IEnv", "cmd.ValuationUtilsExplain2", 2), _CheckedDateTimeToXVar(date_t, datetime.date, "date_t", "xi", "Date", "cmd.ValuationUtilsExplain2", 3), _CheckedDateTimeToXVar(date_tp1, datetime.date, "date_tp1", "xi", "Date", "cmd.ValuationUtilsExplain2", 4), _CheckedRefToXVar(trade_t, globals()["IIdentifiedTrade"], "trade_t", "cmd", "IIdentifiedTrade", "cmd.ValuationUtilsExplain2", 5), _CheckedRefToXVar(trade_tp1, globals()["IIdentifiedTrade"], "trade_tp1", "cmd", "IIdentifiedTrade", "cmd.ValuationUtilsExplain2", 6), _CheckedRefToXVar(valuationFactory, globals()["IValuationFactory"], "valuationFactory", "cmd", "IValuationFactory", "cmd.ValuationUtilsExplain2", 7), _CheckedRefToXVar(result_t, globals()["IResult"], "result_t", "cmd", "IResult", "cmd.ValuationUtilsExplain2", 8), _CheckedRefToXVar(resultControl, globals()["IResultControl"], "resultControl", "cmd", "IResultControl", "cmd.ValuationUtilsExplain2", 9), _CheckedBoolToXVar(useRiskEngine, bool, "useRiskEngine", "xi", "Bool", "cmd.ValuationUtilsExplain2", 10), _CheckedBoolToXVar(useForwardRisks, bool, "useForwardRisks", "xi", "Bool", "cmd.ValuationUtilsExplain2", 11), _CheckedBoolToXVar(use_tp1_results, bool, "use_tp1_results", "xi", "Bool", "cmd.ValuationUtilsExplain2", 12), _CheckedBoolToXVar(bumpCfxNatively, bool, "bumpCfxNatively", "xi", "Bool", "cmd.ValuationUtilsExplain2", 13), _CheckedRefToXVar(result_optional, globals()["IResult"], "result_optional", "cmd", "IResult", "cmd.ValuationUtilsExplain2", 14), _CheckedBoolToXVar(useDisaggRisks, bool, "useDisaggRisks", "xi", "Bool", "cmd.ValuationUtilsExplain2", 15), _CheckedBoolToXVar(useYCRisk, bool, "useYCRisk", "xi", "Bool", "cmd.ValuationUtilsExplain2", 16), _CheckedBoolToXVar(addUnderlyingsAttribution, bool, "addUnderlyingsAttribution", "xi", "Bool", "cmd.ValuationUtilsExplain2", 17), _CheckedBoolToXVar(forbidEvaluations, bool, "forbidEvaluations", "xi", "Bool", "cmd.ValuationUtilsExplain2", 18), _CheckedBoolToXVar(tryPreloadData, bool, "tryPreloadData", "xi", "Bool", "cmd.ValuationUtilsExplain2", 19), XVar(None) if config is None else config._to_xvar()))

      File "_xi_py39.pyx", line 1468, in _xi_py39._Function.__call__

      File "_xi_py39.pyx", line 483, in _xi_py39.check

    xi._xi_py39.Error: call to cmd.ValuationUtilsReplicatingPortfolio failed: Error found in input IResult for ReplicatingPortfolio: Requested Data node with EnvKey <cmd.EnvKey: IndexAsset|25-DEC-2024|25-DEC-2024|HY|CARBUSD> not in environment

    STACK: Function: cmd::IEnv::Objects, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsInterfaces\IEnv.cpp, Line: 142

    STACK: Function: cmd::IEnv::Objects, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsInterfaces\IEnv.cpp, Line: 149

    STACK: Function: cmd::MarketEnvProjected::MarketObjects, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsMarkets\MarketEnvProjected.cpp, Line: 48

    STACK: Function: cmd::UnsafeMarketServiceProjected::MarketObject, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsMarkets\UnsafeMarketServiceProjected.cpp, Line: 52

    STACK: Function: cmd::MEnv::`anonymous-namespace'::GetObjectFromService, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsMarkets\MEnv.cpp, Line: 58

    STACK: Function: cmd::MEnv::IndexAsset, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsMarkets\MEnv.cpp, Line: 159

    STACK: Function: `anonymous-namespace'::GetIndexAsset, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsValuationModels\HypeIndexSwapVM.cpp, Line: 95

    STACK: Function: cmd::ConvertToExplicitSwap, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsValuationModels\HypeIndexSwapVM.cpp, Line: 1314

    STACK: Function: cmd::ResultUtils::ExtractErrorsFromSuppliedResults, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsValuation\ResultUtils.cpp, Line: 2219

    STACK: Function: cmd::ResultUtils::ExtractErrorsFromSuppliedResults, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsValuation\ResultUtils.cpp, Line: 2229

    STACK: Function: cmd::ReplicatingPortfolio, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsValuationModels\InstrumentPropertyAndRiskValModel.cpp, Line: 430

    STACK: Function: cmd::ValuationUtils::PAA::Explain2, File: D:\BuildAgent-1\work\50eb31c8f15699ae\cmd\CMDAnalyticsValuation\ValuationUtilsPAA.cpp, Line: 5576

     

    During handling of the above exception, another exception occurred:

     

    Traceback (most recent call last):

      File "module_main", line 365, in ComputePAAForTrades

        result[trade.TradeId()] = XVar(exception)

      File "_xi_py39.pyx", line 681, in _xi_py39.XVar.__init__

    TypeError: Can't create from <class 'xi._xi_py39.Error'>

     

    During handling of the above exception, another exception occurred:

     

    Traceback (most recent call last):

      File "C:\Symphony732\soam\deploy\162496_Commodities\162496_SimpliCiti_rtGrid\rt_grid_package_24.24.0.v1\rt_grid_package\grid_handlers_imp.py", line 281, in wrapped_call

        handler_result = handler(**filtered_kwargs)

      File "module_main", line 382, in ComputePAAForTrades

        return XVar(e)

      File "_xi_py39.pyx", line 681, in _xi_py39.XVar.__init__

    TypeError: Can't create from <class 'TypeError'>

    ]] rt_netaddin_server\server.cpp:555] rt_grid_platform_server\service_container.cpp:985

    2024-12-27 01:45:15.653 GMT Standard Time INFO [17508:6216] sim.simcore.SiProcessObject - SiProcessObject::terminate(): Terminated SI 8576