Hello Everybody,
Ã, Ã, I am hoping that someone may be able to point me in the correct direction. We are upgrading to Cognos 8, and everything seems to work, except the upgrade of Metrics Manager to Metric Studio. The data seems to import correctly from metrics manager 2.2, however when we go to view metric history by clicking on a specific metric we get the following error message:
'Failed in Java_com_cognos_cgs_FrameWork_CGSCanvas_drawAsRaster()'
WHILE executing Java call...
WHILE ALP worker executing call pid=metric_history call=[
Ã, Ã, CallName='HistoryChartOverviewPNGProc' CallParamName='getCall7' IsJavaCall='true' ProcParamCount='2' FirstParamIndex='1' ForceExecute='false' Session='<null>'
Ã, Ã, Ã, DataSetNames=[
Ã, Ã, Ã, Ã, 'timeRegionsDetAreas'
Ã, Ã, Ã, Ã, 'dataMappingDetAreas'
Ã, Ã, Ã, ]
Ã, Ã, Ã, ParamMeta=[ Param=[getCall7=[Param-List='top' {
Ã, Ã, Ã, Ã, Ã, Ã, Param=[class='HistoryChartOverviewPNGProc' source='literal' Properties=<none>]
Ã, Ã, Ã, Ã, Ã, Ã, Param=[ticket source='request-attr' Properties=<none>]
Ã, Ã, Ã, Ã, Ã, Ã, Param=[detectionAreasOnly='y' source='literal' Properties=<none>]
Ã, Ã, Ã, Ã, Ã, Ã, Param=[datasetNames='' source='literal' Properties={
Ã, Ã, Ã, Ã, Ã, Ã, Ã, dataset2='dataMappingDetAreas'
Ã, Ã, Ã, Ã, Ã, Ã, Ã, dataset1='timeRegionsDetAreas'
Ã, Ã, Ã, Ã, Ã, Ã, }]
Ã, Ã, Ã, Ã, Ã, Ã, }
Ã, Ã, Ã, Ã, ]
Ã, Ã, Ã, Ã, source='inline-list' [top]Ã, Properties=<none>]
Ã, Ã, Ã, ]]
WHILE Failed to complete database transaction for page 'metric_history'.Ã, rollback=yes
WHILE Unrecoverable problem executing worker for page 'metric_history'
WHILE Excuting page 'metric_history', from pageMap 'metricsPageMap', via request:
Ã, Ã, QUERY_STRING='visibleiframe=0&sid=329&skr=0&kid=394&recentdata=true&rwc=50&startpage=metric_metrics&printMode=0&pid=metric_history&grouped=y&cid=&id=394&encoding=UTF-8&b_action=mms.run&path=%2fcontroller'
Ã, Ã, Parameters = {
Ã, Ã, Ã, visibleiframe=['0']
Ã, Ã, Ã, sid=['329']
Ã, Ã, Ã, skr=['0']
Ã, Ã, Ã, kid=['394']
Ã, Ã, Ã, recentdata=['true']
Ã, Ã, Ã, rwc=['50']
Ã, Ã, Ã, startpage=['metric_metrics']
Ã, Ã, Ã, printMode=['0']
Ã, Ã, Ã, pid=['metric_history']
Ã, Ã, Ã, grouped=['y']
Ã, Ã, Ã, cid=['']
Ã, Ã, Ã, id=['394']
Ã, Ã, Ã, encoding=['UTF-8']
Ã, Ã, Ã, b_action=['mms.run']
Ã, Ã, Ã, path=['/controller']
Ã, Ã, }
Ã, Ã, Attributes = {
Ã, Ã, Ã, metric_summary_display_sid='999999997'
Ã, Ã, Ã, alert_annotation_chg_flag='Y'
Ã, Ã, Ã, kpi_grp_expanded='N'
Ã, Ã, Ã, use_default_kpigrp='Y'
Ã, Ã, Ã, browser_creation_date='2006-05-23'
Ã, Ã, Ã, sc_grp_expanded='N'
Ã, Ã, Ã, show_to_date='N'
Ã, Ã, Ã, use_default_tl_style='Y'
Ã, Ã, Ã, product_country_cd='US'
Ã, Ã, Ã, use_default_neg_format='Y'
Ã, Ã, Ã, use_default_number_format='Y'
Ã, Ã, Ã, ticket_id='101:e803bc63-5390-3ab0-3398-ebe4a7656dbb:0915248461'
Ã, Ã, Ã, use_default_columns='Y'
Ã, Ã, Ã, use_default_scgrp='Y'
Ã, Ã, Ã, kpi_class_display_sid='999999997'
Ã, Ã, Ã, currency_cd='USD'
Ã, Ã, Ã, language_cd='EN'
Ã, Ã, Ã, svg_plugin='N'
Ã, Ã, Ã, time_period_sid='2456'
Ã, Ã, Ã, alpAction='2'
Ã, Ã, Ã, telephone_nr='(111) 111-1111'
Ã, Ã, Ã, scorecard_display_sid='999999997'
Ã, Ã, Ã, use_default_chart_options='Y'
Ã, Ã, Ã, alp.grouped='true'
Ã, Ã, Ã, user_type_sid='0'
Ã, Ã, Ã, product_language_cd='EN'
Ã, Ã, Ã, contentLang='EN'
Ã, Ã, Ã, use_default_listvrows='Y'
Ã, Ã, Ã, app_user_sid='19'
Ã, Ã, Ã, content_country_cd='US'
Ã, Ã, Ã, alert_separately_flag='Y'
Ã, Ã, Ã, alp.app.attach='com.cognos.pogo.pdk.BIBusEnvelope@1692442'
Ã, Ã, Ã, time_period_cd='P'
Ã, Ã, Ã, usercapabilitiesobject='com.cognos.cmm.security.MMUserCapabilities@63bfc9'
Ã, Ã, Ã, use_default_sort='Y'
Ã, Ã, Ã, alp.resource='com.cognos.ccl4j.resource.CCLResource@46f95c'
Ã, Ã, Ã, cmm.cmm='com.cognos.cmm.MetricsManager@19d3030'
Ã, Ã, Ã, alp.request.done='metric_history'
Ã, Ã, Ã, listview_rows='50'
Ã, Ã, Ã, chart_settings='{}'
Ã, Ã, Ã, alert_status_chg_flag='Y'
Ã, Ã, Ã, display_active_sc_on_startup='N'
Ã, Ã, Ã, show_neg_as_brackets_ind='N'
Ã, Ã, Ã, productLang='EN'
Ã, Ã, Ã, ticket='101:e803bc63-5390-3ab0-3398-ebe4a7656dbb:0915248461'
Ã, Ã, Ã, cmm.session='m_CMMcontentLocale=en m_CMMproductLocale=enm_CRNContentLocale=en_US m_CRNProductLocale=en m_ticket=101:e803bc63-5390-3ab0-3398-ebe4a7656dbb:0915248461 m_bInitialized=true'
Ã, Ã, Ã, use_default_currency='Y'
Ã, Ã, Ã, alp.instance='com.cognos.alp.control.Alp@c6d267'
Ã, Ã, Ã, presentation_mode='N'
Ã, Ã, Ã, email_address='testme@testing.com'
Ã, Ã, }
We are running on a Windows 2003 server, with Oracle as the backend, with Cognos 8.1.108.17 with a Hotsite of 8.1.108.24 to fix some Oracle issues.Ã, We are assuming something is either not installed correctly or we are missing something that Cognos needs to run successfully.Ã, Any help would be greatly appreciated.
Spiff
Cognos support fixed this issue, by supplying an updated version of the cgs.dll file which replaces the one in the c8/bin directory.