Error Retrieving Cube Preload Settings From Advisor
or opening views This topic contains 12 replies, has 4 voices, and was last updated by jamesweb 4 years ago. Viewing 13 posts - 1 through 13 (of 13 total) Author Posts 14 July 2008 at 10:26 #2954 JeppeMember Hi, I have a big problem with creating and opening views accessing a SQL Server 2005 SSAS database. The database includes somewhat complex cubes and I suspect the writeback cube (with 1 MOLAP partition, 1 writeback ROLAP partition and 1 HOLAP partition with proactive caching) to be one that triggers the problem. Platform WM virtual server Executive Viewer 9.3 Build 1 Patch 1 (2142) - 64 bit Windows 2003 SP2 - 64 bit SQL Server 2005 SP2 With Cumulative Update 8 Build 9.0.3257 - 64 bit Internet Explorer 7 SSAS Database: 3 cubes: 2 with writeback enabled and partitions with proactive caching enabled (Have tried with default ROLAP, HOLAP and MOLAP). 1 Large MOLAP cube. Symptoms The problem occurs creating a new view or accessing an existing view in EV. After selecting the database EV freezes and the msmdsrv.exe (SSAS) process uses most of the available CPU resources (EVServer.exe starts first and uses some CPU). RAM usage is somewhat stable (not maximum). The CPU hogging will continue forever (at least a weekend) and can only be stopped by restarting Cognos Service or Analysis Service. Very seldom will the view open normal (1 in 50). When the error first has occurred any interaction through EV will have the same result – freezing and CPU hogging. There are no errors in Windows event log (except when forcing a restart of the Analysis Server). No problem browsing any of the cubes using other frontends (Excel 2007, Targit, MS Management Studio, BIDS). Below are some samples from the EV log. The log entries are committed to the log after restarting the EVServer service. The problem seems to be connected to the complexity of the SSAS database. I tried creating a very basic database with MOLAP, Proactive Caching and Writeback and it seems that querying this DB doesn’t cause the same problems. We have tried rebuilding, redeploying and reprocessing the SSAS database – with the same result. We tried both the 32 bit and the 64 bit version of EV and enabling/disabling preload cubes in the EV datasource/database. EV Logs logEntry level="warning" category="General" component="MSAS" date="09-07-2008″ time="18:38:26.640″ thread="3580″ process="1236″ session="3e9d22a6-b83d-415f-b1ab-9f70f7a9ce80″> Failed to retrieve system properties - LISSRVaccostat localhost Accostat_ROLAP Budget Indtastning - Module ‘Cognos.EV.Server.ServerProtocol.ServerProtocol' intercepted
PKI Service Identity Access Manager Shop Online Cyber Security Services Managed Security Services DeepSight Intelligence Incident Response Security Simulation Website Security SSL Certificates Complete Website Security Code Signing Certificates Norton Shopping Guarantee Buy SSL Products A-Z Services Services Home Business Critical Services Consulting Services Customer Success Services Cyber Security Services Education Services Solutions Solutions Home Topics http://evusers.org/forums/topic/ev-freezing-when-creating-or-opening-views/ Encryption Everywhere Internet of Things Next Generation Endpoint Office 365 Industries Automotive Cyber Insurance Education Financial Services Global Service Providers Industrial Control Systems Healthcare Retail Government Federal Government State & Local Support Center Technical Support Symantec Connect Buying Programs Upgrades Maintenance & https://support.symantec.com/en_US/article.HOWTO42236.html Renewals Training Security Center Security Center Home Blogs ISTR Threats Virus Definitions and Security Updates Removal Tools Partner Find a Partner Become a Partner Login Required Login into Partner Portal Partner Licensing Partner Renewals Partner Training Margin Builder Opportunity Registration Financial Benefits English 中文(简体) 中文(繁體) Česká English Français Deutsch Magyar Italiano 日本語 한국어 Polski Português Pусский Español Site: Symantec Enterprise Small Business Norton United States Search Support Home Support Home MySymantec Licensing Products A-Z SYM16-015 Security Advisory Login Profile Subscriptions Logout Login Forgot Password? Don't have a SymAccount? Create a SymAccount now!' Download Advisor: How to adjust Download Insight settings to change the number of detections HOWTO42236 April 11th, 2013 http://www.symantec.com/docs/HOWTO42236 Support / Download Advisor: How to adjust Download Insight settings to change the numb
allUploadSign inJoinBooksAudiobooksComicsSheet Music You're Reading a Free Preview Pages 4 to 5 are not shown in this preview. Buy the Full Version You're Reading a https://www.scribd.com/document/178626672/ig-exprss-pdf Free Preview Pages 9 to 64 are not shown in this preview. Buy the Full Version You're Reading a Free Preview Pages 68 to 125 are not shown in this preview. Buy the Full Version You're Reading a Free Preview Pages 129 to 165 are error retrieving not shown in this preview. Buy the Full Version You're Reading a Free Preview Pages 169 to 182 are not shown in this preview. Buy the Full Version More From This UserCOGNOS FAQSSubhash Cognosefeft4rtewig_crt4rtejkjfgfdgfjkjfgfdgfManjet_prashar2465Attendance Feb Manjeeti Part of Information ResourcesChapter 1 Data Modelling at Windsor error retrieving cube CastleLogical Data ModellingMaddy_91525i Part of Information Resourcesie352p6Framework Modeling GuidelinesCognos Express Technical Migrations and Deployment Guideppt-cognos32bfe50d4d7c01c21c7534211 Charts UnlimitedUsing a Blank Reportug_bestCognos Business Intelligence User Role Descriptions_45986How to Create a Drill-Thru Report 9876 ig_exprss.pdf by Manjeet Singh242 viewsEmbedDownloadDescriptionguideguideRead on Scribd mobile: iPhone, iPad and Android.Copyright: Attribution Non-Commercial (BY-NC)List price: $0.00Download as PDF, TXT or read online from ScribdFlag for inappropriate contentShow moreShow less RelatedCreating Auto Reply Agentby Rajesh Kumar GupthaThe Death of Workplaceby quocircaIBM Notes and Domino 9 Whats Newby Santhosh PcIBM Storage Famby Mihail Gheorghei5os v6r1 Brms Pptby Vasanth KumarWelch Allyn TDMS Installation 021709 V2by tom90cat924021 Aus Ibm Sbs11 File Ibm Maximo Oil and Gasby Anantaram KandukuriThe Moribund State of the Ib 274427by jonatas_nobre741redp4794by gulrukh142Web Securityby Sumit AnandSE_sec.pdfby Shady TharwatInfrastructure Matters 2014 IBM systems and servers by IBM India Smarter ComputingSegmentation.docxby AhTeikThinkPad_R51 (Manual)by faruyinCV_s
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 13 Oct 2016 05:32:16 GMT by s_ac4 (squid/3.5.20)