[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

.Net Runtime Optimization Service failed to compile

Posted on 2008-10-02
1
Medium Priority
?
5,952 Views
Last Modified: 2013-11-07
I am getting this error on a new Sql 2005 server I am building.  I am not a SQL person, but I'm installing it none the less.  I had installed 2 database instances and SP2 on both, rebooted and no errors (execpt for Schannel, but I have another thread for that).  Only after I installed the Workstation Compnents and reapplied SP2 to them did the following did the errors appear.  This is my log of the install:

Install SQL Workstation components
                     Run sql setup
      Select Workstation components, books online and development tools.
      Default install path c:\program files\microsoft sql server
      Rerun SP2 to upgrade client components
      Reboot
      Check Logs
      Getting error after installing Workstation components and Rerunning SP2
      
                     Event Type:      Error
.      Event Source:      .NET Runtime Optimization Service
      Event Category:      None
      Event ID:      1101
                     Date:            10/1/2008
      Time:            12:10:56 PM
      User:            N/A
      Computer:      SAMEDAY2
      Description:
      .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile:              Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
      
.      
.      For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Then I tried to reinstall .net 2.0:
      In add/remove programs
      Tried to remove .net 2, said could not due to would affect other programs
      Clicked Change instead. Several event viewer info entries
      Also did Change on Visual studio.
      Reboot
      Still errors, but seems not as often.

Here's a post I found:

Suggestion from http://blog.mechanised.com/2008/09/event-log-error-fix-for-rs-errors-after.html
To Fix, drag
C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Design.dll
to
C:\WINDOWS\assembly

To install the offending library to the GAC.
Double check all is fine:

C:\WINDOWS\microsoft.net\Framework\v2.0.50727\ngen executeQueueditems

Cannot drag to folder is read only
Executed executeQueueditems without copy dll to see what it did.  A ton of entries scrolled by for several minutes.  Lot of file not founds.

Reboot 2:42 to make sure nothing else messed up

No more errors, but .net Runtime Optimization service is now set to Manual and not started, previously it was started.  Started it manually, but it stops after a few seconds.

I did not finish trying the above suggestion since the instructions on installing to the GAC are missing and I don't know what that is.

I have not installed any ot the post SP2 cumulative updates as I don't want to mess anything else up and I'm not sure which one to apply.
0
Comment
Question by:Brian_MB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
Brian_MB earned 0 total points
ID: 22746447
Gave up on a solution for this.  Tried installing reporting services etc and several other "fixes" found on the net.  Nothing worked.  Came across this post:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125659
 
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question