Microsoft Dynamics 365 – Page 200 – Nishant Rana's Weblog

A security error has occurred. Make sure you are signed into Microsoft Dynamics CRM and try again in Click Dimensions.

We had this issue in past when we started getting below error in most of the entities of Click Dimensions.

The issue can occur if the password would have expired or changed for the Service Credentials account of Click Dimensions.

Go to Settings à ClickDimensions Settings à Service Credentials.

In our case it wasn’t changed but we were still getting the issue. The only way we were able to fix it was to specify a different account for the Service Credentials.

Hope it helps.

The remote server returned an error: (403) Forbidden while sending SMS from Click Dimension

We got the below while sending SMS from Click Dimension. We were using Bulk SMS as our SMS connector for Click Dimension.

When we opened the Text Messages record we figured out that we were getting “The remove serve returned an error (403) Forbidden.

This occurred because we had our credit with Bulk SMS already consumed.

The issue got fixed when bought the credits again with Bulk SMS.

https://youtu.be/d__-flPGoFc

Hope it helps.

How to – Convert Fetch XML to SQL in Dynamics 365

Hi,

Recently we had a requirement to convert Fetch XML query of certain views to SQL. Basically, we wanted to validate it again the source DB from which we push the data inside Dynamics 365.

For this we can use the below managed solution,

https://fetchxml2sql.codeplex.com/

The tool is built using Silverlight so will only work in IE.

The other tool is that we can use is one of the most useful plugins – Fetch XML Builder of XRM Tool Box.

Below video explains how to use them

https://www.youtube.com/watch?v=OESJxa3bwrU

And in case you’d feel like converting fetch xml to SQL we have

http://www.sql2fetchxml.com/

Hope it helps..

Annual Report – 2017 in Blogging– “Nishant Rana’s Weblog”

As there will be no Year in Review Annual Report for the WordPress blog, I have created the report myself, following the same pattern used by WordPress.

The blog was viewed about 303,182 times in 2017 with 186,110 visitors: –

Below were the top posts in 2017: –

Below were the top referrers: –

‘

All time views: –

Index (zero based) must be greater than or equal to zero and less than the size of the argument list

Nice solution 🙂

Prashant Kumar Maurya

Hello friends, I found a weird issue during a USD configuration, I was getting error message “Index (zero based) must be greater than or equal to zero and less than the size of the argument list“, when I was trying to assign a custom entity record to a different agent (systemuser) using USD action call.

Scenario: A CRM custom entity record get created in Unified Service Desk when an agent receives a customer call. And if agent transfer customer call to their supervisor, same entity record should also get assigned to supervisor. Below are the details of the action call I created.

Issue: action call was failing with error message “Index (zero based) must be greater than or equal to zero and less than the size of the argument list“, complete error message was