Problem

Metric store is on a Microsoft SQL Server 2000. When you create a new strategy in Metric Studio and after that you click on the Metrics tab, you receive the following error : 'Server user 'db_user' is not a valid user in database 'db_name'. ' WHILE Error returned from SQL='Server user 'cognos_test' is not a valid user in database 'DWHC_Staging3'.' WHILE Failure checking for more results WHILE getting more results from resultset wrapper WHILE processing JSP WHILE in JSP page '/alp/jsp/strategies/strategy_metrics.jsp' WHILE Exception in JSPC '/alp/jsp/strategies/strategy_metrics.jsp' WHILE executing JSPC for url '/alp/jsp/strategies/strategy_metrics. jsp' WHILE Rendering JSP WHILE dispatching to jsp='/alp/jsp/strategies/strategy_metrics.jsp', pid='strategy_metrics' WHILE calling doRender method of the view class 'JSPView' for pid 'strategy_metrics' WHILE dispatching to pid 'strategy_metrics', view '/alp/jsp/strategies/strategy_metrics.jsp - (com.cognos.jpf.view.views. JSPView)', from pageMap 'strategyPageMap' WHILE Executing page 'strategy_metrics', from pageMap 'strategyPageMap', via request: QUERY_STRING='rwc=50&path=%2fcontroller&encoding=UTF- 8&grouped=y&b_action=mms. session&stid=628&id=628&visibleiframe=0&printMode=0&_alpFrom_pid=content Frame_main&skr=0&pid=strategy_metrics&pps_tracking=-1% 3bslM24yl48Chv9h4q9lyhl4dqddvs4Ms29q8sysy9%3b8606AB5E-B125-4730-9006- 12509E800546%3b-1%3bcomplete%3b&time_period_sid=1018&recentdata=true&ui. object=storeID(%22iA97C0C9E9AA748BA8CE7146196E16C85%22) &startpage=strategy_details' Parameters = { rwc=['50'] path=[ '/controller' '/controller' ] encoding=['UTF-8'] grouped=['y'] b_action=[ 'mms.session' 'mms.session' ] stid=['628'] id=['628'] visibleiframe=['0'] printMode=['0'] _alpFrom_pid=['contentFrame_main'] skr=['0'] pid=['strategy_metrics'] pps_tracking=[ '-1;slM24yl48Chv9h4q9lyhl4dqddvs4Ms29q8sysy9;8606AB5E-B125-4730-9006- 12509E800546;-1;complete;' '-1;slM24yl48Chv9h4q9lyhl4dqddvs4Ms29q8sysy9;8606AB5E-B125-4730-9006- 12509E800546;-1;complete;' ] time_period_sid=['1018'] recentdata=['true'] ui.object=[ 'storeID("iA97C0C9E9AA748BA8CE7146196E16C85")' 'storeID("iA97C0C9E9AA748BA8CE7146196E16C85")' ] startpage=['strategy_details'] } Attributes = { kpi_grp_expanded='N' metric_summary_display_sid='999999997' use_default_chart_options='Y' use_default_neg_format='Y' use_default_sort='Y' alp.app.attach='com.cognos.jpf.dispatcher. MessageContextWrapper@1dba1dba' use_default_currency='Y' browser_creation_date='2010-02-01' telephone_nr='+47 911 00 480' created_dt='2010-02-01' listview_rows='50' cmm.session='Session: Rasmussen, Merethe Liebak' overview_chart_cache='{}' time_period_sid='1019' ticket_id='xxx' user_type_sid='1' alert_status_chg_flag='Y' currency_cd='USD' product_language_cd='EN' alert_separately_flag='Y' scorecard_display_sid='999999997' kpi_class_display_sid='999999997' use_default_tl_style='Y' content_country_cd=' ' use_default_listvrows='Y' chart_settings='{}' show_to_date='N' product_country_cd=' ' language_cd='EN' contentLang='EN' productLang='EN' email_address='Merethe.Liebak.Rasmussen@dnv.com' use_default_scgrp='Y' cmm.cmm='com.cognos.cmm.MetricsManager@287e287e' alpAction='2' alp.instance='com.cognos.jpf.control.Alp@2b1a2b1a' alp.PageData='DataSet Name='strategy_metrics' Status='Ok' Direct='true' CurRow='-1'rowCount='1' colCount='1' atEnd='false' init='true'Column names=[]Row names={ ['getCall1']} Properties={ } (com.cognos.jpf.dataset. CompoundDataSet@32cc32cc)' alp.resource='com.cognos.ccl4j.resource.CCLResource@711a711a' show_neg_as_brackets_ind='N' use_default_columns='Y' app_user_sid='293' use_default_number_format='Y' alert_annotation_chg_flag='Y' ticket='xxx' presentation_mode='N' traffic_light_style_cd='traffic' alp.grouped='true' use_default_kpigrp='Y' sc_grp_expanded='N' alp.request.done='strategy_metrics' } .