Clicking on the Metric Studio link in Cognos Connection returns CMM-SYS-5999 err

[monika]

Clicking on the Metric Studio link in Cognos Connection returns CMM-SYS-5999 error.

the details of the error is as follows:

The metrics management service encountered an internal error. 

'[IBM][CLI Driver][DB2/AIX64] SQL0198N  The statement string of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty.  SQLSTATE=42617
'
WHILE Error returned from SQL='[IBM][CLI Driver][DB2/AIX64] SQL0198N  The statement string of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty.  SQLSTATE=42617
'
WHILE Failure to execute
WHILE Executing call (sp_svg_diagram) for page 'diagram_generate'.
WHILE ALP worker executing call pid=diagram_generate call=[
    CallName='sp_svg_diagram' CallParamName='getCall1' IsJavaCall='false' ProcParamCount='11' FirstParamIndex='1' ForceExecute='false' Session='<null>'
      DataSetNames=[
        'fn_page_content'
        'num_formatting_info'
        'trafficLightColors'
        'columns'
        'score_weight'
        'diagram_object'
        'group_kpis'
        'group_names'
        'diagram_kpi'
        'diagram_dgm'
        'diagram_proj'
        'diagram_link'
        'diagram_text'
      ]
      ParamMeta=[ Param=[getCall1=[Param-List='dhtmlDiagram' {
            Param=[callName='sp_svg_diagram' source='literal' Properties=<none>]
            Param=[ticket source='request-attr' Properties=<none>]
            Param=[did source='request-param' Properties=<none>]
            Param=[id source='request-param' Properties=<none>]
            Param=[type source='request-param' Properties=<none>]
            Param=[recentdata source='request-param' Properties=<none>]
            Param=[show_to_date source='request-attr' Properties=<none>]
            Param=[time_period_sid source='request-param' Properties=<none>]
            Param=[user_type_sid source='request-attr' Properties=<none>]
            Param=[contentLang source='request-attr' Properties=<none>]
            Param=[productLang source='request-attr' Properties=<none>]
            Param=[currency_cd source='request-attr' Properties=<none>]
            Param=[datasetNames='' source='literal' Properties={
              dataset9='diagram_kpi'
              dataset8='group_names'
              dataset13='diagram_text'
              dataset12='diagram_link'
              dataset11='diagram_proj'
              dataset6='diagram_object'
              dataset10='diagram_dgm'
              dataset7='group_kpis'
              dataset4='columns'
              dataset5='score_weight'
              dataset2='num_formatting_info'
              dataset3='trafficLightColors'
              dataset1='fn_page_content'
            }]
           }
        ]
        source='list' [dhtmlDiagram]  Properties=<none>]
      ]]
WHILE Executing DefaultWorker for page 'diagram_generate'.
WHILE Unrecoverable problem executing worker for page 'diagram_generate'
WHILE Executing page 'diagram_generate', from pageMap 'diagramsPageMap', via request:

    QUERY_STRING='symbol_text=Y&encoding=UTF-8&path=%2fcontroller&b_action=mms.session&id=109&type=SC&pid=diagram_generate&did=472&pps_tracking=-1%3bCs4jvCCv4Mw9d4GlsvvjqC8v42vMwv82sGvqj2dw%3b2010-09-29-11.34.01.438295%3b-1%3bcomplete%3b&time_period_sid=1003&recentdata=true&symbol_type=traffic&diagram_type=0&ui.object=storeID(%22iD2A534AF3BC44E3CB5548C4CD5B02DE8%22)&symbol_size=32'
    Parameters = {
symbol_text=['Y']
encoding=['UTF-8']
path=['/controller']
b_action=['mms.session']
id=['109']
type=['SC']
pid=['diagram_generate']
did=['472']
pps_tracking=['-1;Cs4jvCCv4Mw9d4GlsvvjqC8v42vMwv82sGvqj2dw;2010-09-29-11.34.01.438295;-1;complete;']
time_period_sid=['1003']
recentdata=['true']
symbol_type=['traffic']
diagram_type=['0']
ui.object=['storeID("iD2A534AF3BC44E3CB5548C4CD5B02DE8")']
symbol_size=['32']
}
    Attributes = {
      kpi_grp_expanded='N'
      metric_summary_display_sid='999999997'
      use_default_scgrp='Y'
      use_default_chart_options='Y'
      use_default_neg_format='Y'
      cmm.cmm='com.cognos.cmm.MetricsManager@63246324'
      use_default_sort='Y'
      alp.app.attach='com.cognos.jpf.dispatcher.MessageContextWrapper@5f8c5f8c'
      alpAction='2'
      use_default_currency='Y'
      created_dt='2010-12-28'
      listview_rows='50'
      cmm.session='Session: Anonymous'
      alp.instance='com.cognos.jpf.control.Alp@65d665d6'
      time_period_sid='1053'
      show_neg_as_brackets_ind='N'
      user_type_sid='1'
      ticket_id='xxx'
      product_language_cd='EN'
      currency_cd='USD'
      alert_status_chg_flag='Y'
      use_default_columns='Y'
      app_user_sid='2'
      alert_separately_flag='Y'
      kpi_class_display_sid='999999997'
      scorecard_display_sid='999999997'
      alert_annotation_chg_flag='Y'
      use_default_tl_style='Y'
      use_default_number_format='Y'
      traffic_light_style_cd='traffic'
      presentation_mode='N'
      ticket='xxx'
      content_country_cd=''
      use_default_kpigrp='Y'
      use_default_listvrows='Y'
      sc_grp_expanded='N'
      chart_settings='{}'
      alp.request.done='diagram_generate'
      product_country_cd=''
      show_to_date='N'
      contentLang='EN'
      language_cd='EN'
      productLang='EN'
    }


Please tell if any solution u know.....

[kane]

HI,

Hey i got same problem when i am working on Metric Studio.
but when i restarted my services it automatically fixed.
try once by going to configuration and restart the services ......
it may work.

Good Luck...