Pls do me a favor: check if your on-premise Org db has function: dbo.fn_ConvertUtcToSpecificTimeCLR?

Pls do me a favor: check if your on-premise Org db has function: dbo.fn_ConvertUtcToSpecificTimeCLR?

This question has suggested answer(s)

Please go to your org database to see if it has that function. Several functions related to dates are calling that? let me know which Rollup you have.

All Replies
  • I have it in a dev environment (CRM 2011 RU 13).


    /****** Object:  UserDefinedFunction [dbo].[fn_ConvertUtcToSpecificTimeCLR]    Script Date: 7/12/2013 12:29:48 PM ******/

    SET ANSI_NULLS OFF

    GO

    SET QUOTED_IDENTIFIER OFF

    GO

    CREATE FUNCTION [dbo].[fn_ConvertUtcToSpecificTimeCLR](@UTCTime [datetime], @timeZoneId [nvarchar](60))

    RETURNS [datetime] WITH EXECUTE AS CALLER

    AS

    EXTERNAL NAME [MSCRMSqlClr].[UserDefinedFunctions].[ConvertUtcToSpecificTime]

    GO

  • from the definition, this function was created an assembly.

    Could you please check if you have any assembly besides Microsoft.SqlServer.Types?

    appreciate for your quick response,

  • It appears to be part of the .NET Framework (3.5 or above) http://msdn.microsoft.com/en-us/library/bb495915(v=vs.90).aspx
  • Sorry, wrong function.

    Not sure where it's pulling that from.  Any suggestions on how to locate it?

  • That's a C# class method. It needs to be exposed as a sql function and loaded into SQL. so probably if you check if your db loaded some assembly named [MSCRMSqlClr].

  • I believe you have the same question in two different threads :community.dynamics.com/.../216533.aspx

    Thanks,

    Mohammad

  • go to your org db, then Programmability, then assemblies, check if see any assembly besides Microsoft.SqlServer.Types

  • yes, I need to figure out why it is coming from.

    From Daryl, seems that function is from an assembly. However I did not see it. Did you see the same function definition as him?

    If it is from an assembly, I need to know which dll?

  • couple of things were missing here: we fixed the problem.

    The function is implemented in an assemble: Microsoft.Crm.SqlClr.Helper.dll .

    For some reason that assembly is still the RTM version: so it is a bug of the CRM updates - did not get the latest but other updates are fine.

    The online crm db copy might have problem too: it did not define the function (or reporting the assembly was not there....)

    Thanks,