Thursday, November 14, 2013

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" />



Monday, November 4, 2013

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'