Dynamics 365 , MS Dynamics CRM 2011, 2013, 2015, 2016 Hospital: October 2013

Monday, October 28, 2013

Creating Heat Maps with Bing Maps and Dynamics CRM (MS CRM 2011)

here is the link its clearly described about the heat map and how to heat on top of Bing :P

http://blogs.msdn.com/b/crm/archive/2012/10/29/creating-heat-maps-with-bing-maps-and-dynamics-crm.aspx

Regards,
yes.sudhanshu

Monday, October 7, 2013

Invalid Trace Directory. Additional Info:[ Unable to Write file , Trace directory not defined (Reporting Process:File Name is Null. LocalTraceSettings: {Filename: ,FileCountSuffix:1 ,TraceFileSize:10485760 ,TraceDirectory: ,TracingCallStack:Yes ,IsTracingOff:No ,LoadState:LoadSuccessfulUnreported ,RefreshTraceInt:-1 ,SiteWideRefreshTraceInt:-1 ,RegistryRefreshTraceInt:-1} ] , AppDomain:CrmAsyncService) MS CRM 2011

Hi All,

while i was looking the Event viewer in one of my MS CRM 2011 instance, i got the below error message in event viewer

Invalid Trace Directory. Additional Info:[ Unable to Write file , Trace directory not defined (Reporting Process:File Name is Null. LocalTraceSettings: {Filename: ,FileCountSuffix:1 ,TraceFileSize:10485760 ,TraceDirectory: ,TracingCallStack:Yes ,IsTracingOff:No ,LoadState:LoadSuccessfulUnreported ,RefreshTraceInt:-1 ,SiteWideRefreshTraceInt:-1 ,RegistryRefreshTraceInt:-1} ] , AppDomain:CrmAsyncService)

this means the trace directory is nto available.

so set the directory by following the below commands

open the windws power shell in admin mode

run the below commands...

Add-PSSnapin Microsoft.Crm.PowerShell

Get-CrmSetting TraceSettings

$setting=Get-CrmSetting TraceSettings

$setting.Directory=”C:\Program Files\Microsoft Dynamics CRM\Trace” (this is the directory that u want)

Set-CrmSetting $setting

Get-CrmSetting TraceSettings

Regards,

yes.sudhanshu

an error occurred during an attempt to build the certificate chain for the relying party trust adfs, MS CRM 2011 CBA configurations, error code 317

Hi All,

while doing CBA configurations, all went well, but while ccessing to MS CRM (internall URL), i got the prompt to key in the credentials, but after that i got the below error...

below is the event vieweer log

Encountered error during federation passive request.

Additional Data

Exception details:

Microsoft.IdentityServer.Web.RequestFailedException: MSIS7012: An error occurred while processing the request. Contact your administrator for details. ---> System.ServiceModel.FaultException: ID3242: The security token could not be authenticated or authorized.

at Microsoft.IdentityServer.Protocols.WSTrust.WSTrustClientManager.Issue(Message request, WCFResponseData responseData)

at Microsoft.IdentityServer.Protocols.WSTrust.WSTrustClient.Issue(RequestSecurityToken rst, WCFResponseData responseData)

at Microsoft.IdentityServer.Web.FederationPassiveAuthentication.SubmitRequest(MSISRequestSecurityToken request)

--- End of inner exception stack trace ---

at Microsoft.IdentityServer.Web.FederationPassiveAuthentication.SubmitRequest(MSISRequestSecurityToken request)

at Microsoft.IdentityServer.Web.FederationPassiveAuthentication.RequestBearerToken(MSISSignInRequestMessage signInRequest, SecurityTokenElement onBehalfOf, SecurityToken primaryAuthToken, String desiredTokenType, Uri& replyTo)

at Microsoft.IdentityServer.Web.FederationPassiveAuthentication.BuildSignInResponseCoreWithSerializedToken(String signOnToken, WSFederationMessage incomingMessage)

at Microsoft.IdentityServer.Web.FederationPassiveAuthentication.BuildSignInResponseCoreWithSecurityToken(SecurityToken securityToken, WSFederationMessage incomingMessage)

at Microsoft.IdentityServer.Web.FederationPassiveAuthentication.BuildSignInResponseForProtocolRequest(FederationPassiveContext federationPassiveContext, SecurityToken securityToken)

at Microsoft.IdentityServer.Web.FederationPassiveAuthentication.BuildSignInResponse(SecurityToken securityToken)

System.ServiceModel.FaultException: ID3242: The security token could not be authenticated or authorized.

at Microsoft.IdentityServer.Protocols.WSTrust.WSTrustClientManager.Issue(Message request, WCFResponseData responseData)

at Microsoft.IdentityServer.Protocols.WSTrust.WSTrustClient.Issue(RequestSecurityToken rst, WCFResponseData responseData)

at Microsoft.IdentityServer.Web.FederationPassiveAuthentication.SubmitRequest(MSISRequestSecurityToken request)

Solution

open the "windows power shell " in admin privilege.

run the below commands

Add-PSSnapin Microsoft.Adfs.PowerShell

Set-ADFSRelyingPartyTrust -TargetName <replying panrty name in ADFS> -EncryptionCertificateRevocationCheck None

then do an IISRESET in adfs server and then try..

it should work perfect

Regards,

yes.sudhanshu

CRM 2011 claims-based authentication problem adding Relying Party Trust to ADFS - federationdata.xml not served by CRM server (503 error), MS CRM 2011

Hi All,

while i was configuring CBA for MS CRM 2011, i got the below error, while adding relying party in ADFS server.

ofcuz i got the error also while accessing the federation meta data url in browser as below

Solution

i found some link to install the URL rewrite component and then did IISRESET, then cool, it worked for me. :)

the link to download the URL rewrite component... http://www.iis.net/downloads/microsoft/url-rewrite

downdlaod as per your bits(32 or 64)

Regards,

yes.sudhanshu

Wednesday, October 2, 2013

"Database cannot be started in this edition of SQL Server" error when restoring a Microsoft Dynamics CRM database , MS CRM 2011

while restoring MS CRM 2011 db i got the error message as below
""Database cannot be started in this edition of SQL Server" error when restoring a Microsoft Dynamics CRM database , MS CRM 2011".
the below lonk says how to do...
http://support.microsoft.com/kb/2567984

this is cause of the SQL version....
hope this will definitely help :P

below is the script

what i suggest to do is, donot run this script directly in the Org_MSCRM DB.
just restore it as Temp DB and then run the script on Temp DB then take the backup from Temp DB and restore in your destination server.

IF EXISTS (SELECT name FROM sys.partition_schemes WHERE name='AuditPScheme')

BEGIN

SELECT

CASE WHEN ind.type != 1

THEN

'DROP INDEX [dbo].[AuditBase].' + QUOTENAME(ind.name) + ' '

ELSE ' '

END +

'CREATE ' + CASE is_unique WHEN 1 THEN 'UNIQUE ' ELSE '' END +

ind.type_desc + ' INDEX ' + QUOTENAME(ind.name COLLATE SQL_Latin1_General_CP1_CI_AS ) + ' ON [dbo].' + QUOTENAME(OBJECT_NAME(object_id)) + ' (' +

REVERSE(SUBSTRING(REVERSE((

SELECT name + CASE WHEN sc.is_descending_key = 1 THEN ' DESC' ELSE ' ASC' END + ','

FROM

sys.index_columns sc

JOIN sys.columns c ON sc.object_id = c.object_id AND sc.column_id = c.column_id

WHERE

OBJECT_NAME(sc.object_id) = 'AuditBase' AND

sc.object_id = ind.object_id AND

sc.index_id = ind.index_id

ORDER BY index_column_id ASC

FOR XML PATH('')

)), 2, 8000)) + ')' +

CASE WHEN ind.type = 1

THEN

' WITH (DROP_EXISTING = ON) ON [PRIMARY]'

ELSE

' '

END as Script

INTO #indexesScript

FROM sys.indexes ind

JOIN sys.partition_schemes ps on ind.data_space_id=ps.data_space_id

WHERE

OBJECT_NAME(object_id) = 'AuditBase'

AND ps.name = 'AuditPScheme'

AND is_unique_constraint = 0

SELECT * FROM #indexesScript

DECLARE @recreateScript nvarchar(max)

DECLARE indScript CURSOR FOR

SELECT Script FROM #indexesScript

OPEN indScript

FETCH NEXT FROM indScript INTO @recreateScript

WHILE @@FETCH_STATUS = 0

BEGIN

BEGIN TRANSACTION t1

Execute sp_executesql @recreateScript

IF @@ERROR > 0

BEGIN

ROLLBACK TRAN t1

declare @message varchar(max)

set @message = 'Audit history recreate index failed. SQL: ' + @recreateScript

RAISERROR (@message, 10,1)

END

ELSE

BEGIN

COMMIT TRAN

END

FETCH NEXT FROM indScript INTO @recreateScript

END

DROP PARTITION SCHEME AuditPScheme

DROP PARTITION FUNCTION AuditPFN

CLOSE indScript

DEALLOCATE indScript

DROP TABLE #indexesScript

END

Regards,
yes.Sudhanshu