SQL Server Error (CLR) V2.0.50727 With HRESULT 0x8007000e

I guys,

I have this store procedure which does a bulk insert to a session table from a XML file. This store procedure used to work fine until couple of month ago and now all of the sudden it stopped working. Whenever this procedure is executed I get following error:

 

Msg 6511, Level 16, State 82, Procedure up_XNetSessionBulkInsert, Line 42

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x8007000e. You may fix the problem and try again later.

I also tested same procedure on the development sql server and it works fine. the settings on the production and development are same.

I was wondering if any of you have a solution for it.   Here is the procedure which causes error.

dbo.up_SessionBulkInsert '<sessions><s id="6" val="45465465" len="9" /></sessions>'

 

 

ALTER PROCEDURE [dbo].[up_SessionBulkInsert]

(

@sessionXml text

)

AS

SET NOCOUNT ON

declare @handle int

exec sp_xml_preparedocument @handle output, @sessionXml

INSERT INTO SessionTb

(

sessionID

,session

,length

)

SELECT

sessionID

,dbo.udf_DecodeBase64StringToBinary(session) as RawBytes -- Base64-decode to byte[] before we insert.

,length

FROM

OpenXml(@handle, '/sessions/s', 1)

WITH

(

sessionID varchar(88) '@id'

,session varchar(max) '@val' -- This value should be a base64-encoded string

,length int '@len'

)

select @@rowcount

exec sp_xml_removedocument @handle

SET NOCOUNT OFF