Dynamics CRM Workflow: SQL Server Error Occured

Published on April th, 2012
Andri Kasta Marengga

Dynamics CRM Workflow: SQL Server Error Occured

While testing my Dynamics CRM workflow development, the following error occurs: A SQL Server error occurred. Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization’s Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support. I think it was an uncommon error, i never […]

Continue Reading →

Dynamics CRM: Invalid Action – The selected action was not valid

Published on March th, 2012
Andri Kasta Marengga

Dynamics CRM: Invalid Action – The selected action was not valid

Yesterday one of my client made me panic by giving me error message screenshot. After examining event log, I found an odd message. Current active key (KeyType : CrmWRPCTokenKey) is expired. This can indicate that a key is not being regenerated properly. blablabla And I realize that something wrong on my services. Fortunately, resolution of […]

Continue Reading →

Parsing Comma Separated Parameter Inside IN Clause SQL Server

Published on March th, 2012
Andri Kasta Marengga

Parsing Comma Separated Parameter Inside IN Clause SQL Server

Parsing array parameter into SQL Stored Procedure isn’t as simple as it seen. The problem is SQL Server has not array parameter. To outsmart this problem, we can make a SQL Function to delimit our parameter before parsing it to Stored Procedurr, DataSet, etc. Here’s a sample code of this SQL Function Done! Now we […]

Continue Reading →

Filtering Lookup Data in Dynamics CRM 4

Published on March th, 2012
Andri Kasta Marengga

Filtering Lookup Data in Dynamics CRM 4

First, we have to make sure filtering lookup is supported by your Dynamics CRM. Open lookupsingle.aspx inside <CRM site folder>\_controls\lookup\ folder. If filtering lookup has not been supported, add these code snippet to the top of the page. As usual, never change a file without a backup. After that, let’s play with Dynamics CRM Forms. […]

Continue Reading →

SQL Operator Equal to Equal (=) For NText Datatype

Published on February th, 2012
Andri Kasta Marengga

SQL Operator Equal to Equal (=) For NText Datatype

This morning, I’ve got a problem with using equal operator (=) in transact-SQL for ntext datatype column. I try this SQL command text And it returns this error message “The data types text and varchar are incompatible in the equal to operator.” After some googling, I found a fact that comparison operator doesn’t match with […]

Continue Reading →

Excel Concatenate Error: You’ve Entered Too Many Arguments

Published on February th, 2012
Andri Kasta Marengga

Excel Concatenate Error: You’ve Entered Too Many Arguments

Yesterday i got this error when trying to put all the info from the hundreds cells that are populated into one cell. Cause: My arguments exceed argument limit of concatenate formula. In 2007 concatenate supports only 255 arguments. There are some resolution to get this done. Concatenate “Inception“. For example you’ll concat all Cells from […]

Continue Reading →

Sharepoint HTTP Error 503. The service is unavailable

Published on February th, 2012
Andri Kasta Marengga

Sharepoint HTTP Error 503. The service is unavailable

Cause: Application Pool is in stopped state Password of Application Pool identity account is changed First, check your Application Pool on IIS Manager, if its state is stopped then start it and re-check again your Sharepoint. In my case, i realized that application pool account’s password got changed. Here are my resolution steps: Login to […]

Continue Reading →