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.....
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...