Microsoft Dynamics AX 2012 Services Book - Brief Overview

Dear Friends,

First of all Wish you a Very Happy New Year!

Thanks once again to Packt Publishing team for forwarding me this book for review.

Introduction

This book is exclusively on Dynamics AX 2012 Services and it covers the following:

• Dynamics AX 2012 service architecture.
• Build your own services using wizards or X++ code
• Consume existing web services and services you’ve created yourself

• Using the AIF Document Service Wizard
• Deploying services using a variety of protocols
• Consuming your services in .NET
• Using system services in your applications
• Using the SysOperation framework to create batch processes

Cover Image

Who this book is for

This book is aimed at Dynamics AX developers, both new and experienced with services and Microsoft Dynamics AX 2012. A basic understanding of MorphX and X++ is assumed, but the step-by-step instructions are easy to follow even for beginners. Some examples use C#.NET, so experience with Visual Studio is a plus but not a must. 

Book Link

http://www.packtpub.com/microsoft-dynamics-ax-2012-services/book

Book Authors

I know Klaas and Kenny as fellow bloggers on Dynamics AX. Both have been in Dynamics AX space for a while and have contributed immensely to Dynamics AX ecosystem via their blogs. Thanks guys for the good work on this book.

Klaas Deforche

Klaas Deforche started working as a developer on Microsoft Dynamics AX in 2007 for the Belgian ICT company RealDolmen, primarily working with Dynamics AX 4.0. He gained experience with AX 2009 while working on projects for some well-known Belgian fashion retailers, especially on the integration side of things. He is currently working on AX 2012 projects for customers in the healthcare sector. Klaas likes to share his knowledge with the community, which is why in 2009 he started his AX-oriented blog artofcreation.be.

---

Kenny Saelen

Kenny Saelen works for the Belgian ICT company RealDolmen. He started as a developer on Microsoft Dynamics AX in 2004 primarily working on a European customer implementation with Dynamics AX 3.0. At RealDolmen, he gained experience with Dynamics AX 2009 while implementing AX internally, followed by a project for a books wholesale company. Currently, he is working as a technical architect for a worldwide customer implementation with Microsoft Dynamics AX 2012, mainly working towards integrating Dynamics AX with other technologies such as Sharepoint, Biztalk, and AgilePoint. He can be reached through his blog ksaelen.be.

Free Microsoft E-Books Windows Server 2012, SQL Server 2012, Programming windows 8 and more...

Good morning Friends!! :)

I was browsing through some community forums and I hit upon this pile of  free e-books..so thought to share it over here in my blog..

* Windows Server 2012
* SQL Server 2012
* Programming Windows 8
   ..

You can find more e-books and articles over here

 

Merry Xmas!!

Dear Friends,

Wish you and your family A Merry Xmas and a Happy New Year in Advance!!! Keep Daxing.... :)

Troubleshooting SSRS Report Error - An item with the same key has already been added

Error:

While building one of the SSRS Reports, I ran into this error "An item with the same key has already been added" while loading my datasets from Visual Studio.

Solution:

Thanks to this blog, it came to my rescue.

Configuring and Implementing Sharepoint 2010 RBS (Remote Blob Storage) with SQL Server 2012 - Part 2

Good day Friends!

A while ago, I blogged on Configuring and Implementing Sharepoint 2010 RBS (Remote Blob Storage) with SQL Server 2012 - Part 1

In Part1, I gave an introduction on RBS, Benefits of implementing RBS in your enterprise, Installing the required components of RBS, Configuring and Setting up RBS for Sharepoint Content database.

In this post, I will try and cover the steps involved in Enabling RBS on a Second content database, Troubleshooting RBS, General Links and References and finally how it can be a part of your enterprise (along with Dynamics AX ERP)

A. Enabling RBS on a Second Content database

While enabling RBS for a second content database, Follow the similar steps which I mentioned in Part 1 except for the msiexec part, run the following command:

msiexec /qn /i rbs.msi REMOTEBLOBENABLE=1 FILESTREAMPROVIDERENABLE=1 DBNAME=WSS_Content_IntranetBlob FILESTREAMSTORENAME=FilestreamProvider_1 ADDLOCAL=EnableRBS,FilestreamRunScript DBINSTANCE=CD

Finally we need to run this Powershell Script to activate RBS on Second content database

            $cdb = Get-SPContentDatabase –WebApplication  <URL>
            $rbss = $cdb.RemoteBlobStorageSettings
            $rbss.Installed()
            $rbss.Enable()
            $rbss.SetActiveProviderName($rbss.GetProviderNames()[0])

B. Troubleshooting


Error# 1
Initially, for testing purpose I installed and configured RBS with Sharepoint Foundation 2010 on one of my test vm's, Everything went well but when I try to upload a document, it throws the below exception:

Exception: Microsoft.Data.SqlRemoteBlobs.BlobStoreException: There was a generic database error.

Solution:

Tried completely uninstalling RBS from Sharepoint Foundation and re-configured once again the Content database for RBS but still no luck :(.

Then I turned on to my ultimate weapon ;-) SQL profiler to identify the queries running behind the scenes whilst uploading a document to sharepoint library.

As usual, SQL Profiler didn’t let me down and it showed me the stored proc which was getting executed:

exec [mssqlrbs_filestream].[rbs_fs_sp_initialize] @schema_suffix=N'1',@filegroup_name=N'RBSFileStreamProvider',@data_filegroup_name=N'PRIMARY',@allow_remote=0,@schema_version=@p5 output,@share_prefix=@p6 output

I copied this statement from the Profiler and opened a new query window via SSMS and fired the query and I got the same error, I debugged the stored proc and found that the stored proc definition just took 3 input parameters, while sharepoint was sending 4 parameters, modified the stored proc to cater for @allow_remote parameter and that did the trick!!! :). Not a pretty way to fix it up, but I guess this would be a bug with Foundation 2010 version running on my VM.

C. References

Thought to post some useful links/references which can be handy while configuring RBS:

http://technet.microsoft.com/en-us/library/ee748631%28v=office.14%29.aspx
http://blogs.technet.com/b/pramodbalusu/archive/2011/07/09/rbs-and-sharepoint-2010.aspx
http://stevemannspath.blogspot.com.au/2012/07/bang-two-pound-four-remote-blob-storage.html
http://sharepoint.nauplius.net/2011/03/enabling-rbs-on-multiple-content.html
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=174
 

D. Conclusion

To summarize, I believe RBS is the answer if you want to externalize your storage rather than cluttering your database and even this concept can be extended to Microsoft Dynamics AX (Document Management) wherein we end up storing huge BLOB type data in SQL.