Tip - SSRS Time Format functions for converting to am/pm

Dear Friends,

Sometime back I was working on few standalone SSRS reports which uses time fields from AX 2009 database like for e.g. smmActivities table and the time here is stored in form of integer values.

How to convert int field into time (am/pm)

=Format(TimeSerial(0,0,Fields!starttime.Value),"hh:mm:ss tt") - 12 hour clock
=Format(TimeSerial(0,0,Fields!starttime.Value),"HH:mm:ss tt") - 24 hour clock

Troubleshoot Sharepoint Exception Microsoft.SharePoint.SPException: Feature definition with Id failed validation

Greetings Friends!

Hope you all are well. Just thought to share with you on how I went troubleshooting an issue on our Sharepoint 2010 box.

Issue:

Error while saving site as template via Site settings > Save as template

Microsoft.SharePoint.SPException: Feature definition with Id  failed validation
Medium   Solution Deployment : Missing one or more of the following attributes from the root node in solution Room Reservations 4.wsp: assembly '', type ''. a6d46846-5092-4317-9e75-05afda727463
02/19/2013 12:27:17.80 w3wp.exe (0x67A0)                       0x9590 SharePoint Foundation         Runtime                       tkau Unexpected Microsoft.SharePoint.SPException: Feature definition with Id 8cc022f5-2271-4618-9e82-b03cc11bd179 failed validation, file '1RoomReservations4ListInstances\ElementsFields.xml', line 43, character 513: The 'RowOrdinal2' attribute is not allowed.    at Microsoft.SharePoint.Administration.SPSolutionPackage.SolutionFile.FeatureXmlValidationCallBack(Object sender, ValidationEventArgs evtargs)     at System.Xml.Schema.XmlSchemaValidator.SendValidationEvent(String code, String arg)     at System.Xml.Schema.XmlSchemaValidator.ValidateAttribute(String lName, String ns, XmlValueGetter attributeValueGetter, String attributeStringValue, XmlSchemaInfo schemaInfo)     at System.Xml.XsdValidatingReader.ValidateAttributes()     at System.Xml.XsdValidatingReader.ProcessElementEvent()     at System.Xml.XsdVa... a6d46846-5092-4317-9e75-05afda727463


Solution:

1. Save the site to solution gallery
2. Had to fix the wss.xsd schema file in 14 hive i.e. add this line  <xs:attribute name="RowOrdinal2" type="xs:int" />

Update - Integrating Dynamics AX 2012 with Sharepoint 2010 Workflow (Nintex) List using REST Services (Querying List data) - Part 1

Dear Friends,

I have come back and updated my previous blog with additional code on how to query the List data in Sharepoint using LINQ.

More here... http://daxdilip.blogspot.com.au/2013/10/blogpost-500-integrating-dynamics-ax.html

Soon, I will be writing Part 2 on how to create the journals in AX.

Keep reading...

Troubleshooting Linked Server Error The OLEDB provider MSDASQL for linked server reported an error. The provider ran out of memory

Dear Friends,

Some months ago, I was working on a SSRS Report which sources data from a third party Oracle database. I had shared my experiences in this post http://daxdilip.blogspot.com.au/2013/03/ssrs-troubleshooting-error-im014.html

I have a Linked Server connection from my SQL box which will talk to the Oracle db and do a nightly refresh of the local data. Now, the source database (oracle db) got upgraded and some of the tables/fields were changed.

Error: I got this error in one of my data transfer jobs.

Solution:

You can refer to the Microsoft KB Article over here http://support.microsoft.com/kb/268520

Re-create the linked server to use the Microsoft OLE DB Provider for ODBC (MSDASQL).

• Use the ODBC driver for ORACLE that is provided by Microsoft:
  
  

  EXEC sp_addlinkedserver @server = 'ORACLEODBC', @srvproduct = 'MSDASQL', @provider = 'MSDASQL',
   @provstr = 'DRIVER={Microsoft ODBC for Oracle};SERVER=MyOracleServer;UID=USERNAME;PWD=Password;'
  go
  
  sp_addlinkedsrvlogin 'ORACLEODBC', false, NULL, 'USERNAME', 'Password'

Book Review - Extending Microsoft Dynamics AX 2012 Cookbook

Dear Friends,

Greetings!

Thanks to Packt team once again for sending me a copy of this wonderful book to review.

This is one of the best book which I have reviewed and written by one of the best in the game - Murray Fife

Introduction of the Author (from the book)

Murray Fife is a Microsoft Dynamics AX MVP, a presenter, and an author with over 18 years 
of experience in the software industry.

Like most people he has paid his dues as a developer, as an implementation consultant, 
and a trainer. He has a hard-to-find blend of technical and interpersonal skills and spends 
his days working with companies solving their problems with the Microsoft suite of products, 
specializing in Dynamics AX solutions

I'm sure most of us would have come across Murray's blog (www.atinkerersnotebook.com) or  SlideShare account (www.slideshare.net/murrayfife). I would recommend you to go through his presentations and blog, it's really helpful. 

Who this Book is for

This book is really a great resource and handy for AX developers/consultants who would like to take that extra advantage of integrating and extending Dynamics AX into their existing Microsoft stack of Sharepoint and SSRS/SSAS (Reporting and BI) tools. Likewise, if you have a Sharepoint or Reporting Team working with Dynamics AX team, they can as well leverage some of the knowledge from this book.

What to expect from this book

This book is filled with practical and do-it-yourself examples which one can leverage in their enterprise straightaway and get productive.

Some Highlights of the book:

* Extending with Sharepoint - Create document Libaries in sharepoint, Link the document library directly to AX Records

* A whole chapter is dedicated to Power View Reporting and integrating Power View Reports into Dynamics Ax forms and Role Centers - very cool

* More Reports, Dashboards, Scorecard, Charts etc

* Leveraging Unified communication via Lync 2010

* Organizing Workflows

* Reporting using Office Tools via Dynamics Add-In

* Create Help

* Use Infopath forms to consume Dynamics AX WebServices


Please refer the chapters of book over here http://www.packtpub.com/extending-microsoft-dynamics-ax-2012-cookbook/book?utm_source=networking.com&utm_medium=book&utm_campaign=book_networking


Conclusion

Overall, I really enjoyed going through this book and I would give it a full 5/5 rating. I recommend this book highly to anyone who is interested to utilize Dynamics AX and the surrounding Microsoft technologies to it's fullest. Once again kudos to Murray Fife for taking time and writing such a useful book.