Melick's Blog

SharePoint 2010 Prerequisites Microsoft Sync Framework Runtime v1.0 (x64) http://download.microsoft.com/download/C/9/F/C9F6B386-824B-4F9E-BD5D-F95BB254EC61/Redist/amd64/Microsoft%20Sync%20Framework/Synchronization.msi Microsoft Chart Controls for the Microsoft .NET Framework 3.5 http://download.microsoft.com/download/c/c/4/cc4dcac6-ea60-4868-a8e0-62a8510aa747/MSChart.exe Microsoft .NET Framework 3.5 Service Pack 1    http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe Windows PowerShell 2.0 http://download.microsoft.com/download/2/8/6/28686477-3242-4E96-9009-30B16BED89AF/Windows6.0-KB968930-x64.msu Windows Identity Framework (Win2008 R2) http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu WCF fix for Win2008 SP2 http://download.microsoft.com/download/6/8/1/681F5144-4092-489B-87E4-63F05E95079C/Windows6.0-KB976394-x64.msu WCF fix for Win2008 R2 http://download.micro...

  I was failed installing Windows Live writer  in few attempts and It didn't work for me by doing several work rounds that is available in the web.   So I have ultimately switched to the OpenLive Writter that was very similar in every aspects. You can find the open source version of your great tool by using the following link http://openlivewriter.org/

  I had this error appearing in event viewer when I tried to run a tool which is doing updates on SharePoint pages. But this was working very fine in my Dev environment and it is not working on my SharePoint production servers. Surprised isn’t It … I tried to figure out the error nothing was successful. But ones I tried to run the same tool of web front end servers it worked . My server farm contains 2 application servers and 2 web front end servers. And I figured it out this error is not appearing and working fine in WFEs not App servers.

SQLState = 08001, NativeError = 53 Error = [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53]. SQLState = 08001, NativeError = 53 Error = [Microsoft][ODBC Driver 11 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. SQLState = S1T00, NativeError = 0 Error = [Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired This is a error i have got when my program is trying to connect to a SQL Server 2012 using named pipe. I did a little google and found below article and followed it very carefully and still i got the error. https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/ Futhur digging my syl server is in different act...

  Albert was told either: May , June , July , August Bernard was told either: 15 ,16,17,18,19 May 15 16     19 June     17 18   July 14   16     August 14 15   17   Albert : I Don’t know when charley's B’Day. Bernard does not know too. First we take second argument. If Bernard know the answer It should be June 18 or May 19. Because they are the only dates that does not have ambiguity in months. So Albert knows it is not 18 or 19. Now albert remains with these options. May 15 16       June     17     July 14   16     August 14 15   17   Albert saying that I don’t know when charley's B’Day . if albert told month as June would know the answer because only one date left to pick in the June that is June 17 . But he Says He don’t know the answer, which means the month told to him was not June. Bernard : Fi...

I got this exception when I tried to execute a query using DB2 ODBC script. There fore I found that ODBC property has a time out option which we can used to omit this problem. go to configuration section and then Performance section and click  Advanced button. and clear the option “ Allow Query Time out ”

This error Occurred to me while I design the query in the Query Builder and generate the report in SSRS ( MDX). Months are showing alphabetical order (April , August,..) , but it should be January , February .. I did some background works and even follows the the thread http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/27765eda-371d-4428-ab13-2e96b2fbb6ca . But ultimately I  found there is a sorting adding by default to that column. I Deleted it .. Bingo .. It worked ..  

This Active directory configuration I have did to configure VPC with SharePoint and  Active Directory services. First you need to run the Active Directory service binary installation. therefore you need to run the “ dcppromo ”. Thus you can simply type it in the run window to execute it. Then it checks the Domain services installations and prompt you for selection mode. Select Use advanced mode installation and proceed to next. This will prompt a compatibility note. So make it next to proceed. Then it will ask for forest configuration. since this is a new configuration we want to select create a new forest root domain . after that it is asking domain name for the forest. therefore you can provide a fully qualified name for the domain. the it will prompt for net bios name (you can leave the default) After that it will ask the functionality level. I choose Windows Server R2. You can see the available functionalities in the description itself. And Click the DNS. Then...

Recently i encountered with a major problem. I created a Workflow using a SharePoint designer and publish it. But when i did some changes and publish it is publishing and SharePoint also  showing it as a latest version by putting existing one as a previous version. But  the functionality remain the same. It took many days to identify actually workflow is not publishing to the server, it will publish same old workflow though i modify it. SharePoint Designer cache workflow activities in the local user folder. thus it is actually publishing the cached workflow but not the original one. so use following steps to clear the designer cache. Go to C:\Users\ username and then go to \AppData\Local\Microsoft\WebsiteCache (AppData is a hidden folder so you can use the explorer to access the folder) and Delete the cache which named in your site name.

Go to Developer Tools the Disable Menu uptick the Scripts . It worked for me.

Here i got a problem of Visio Web Part (actually problem for me) It is changing zoom level to view maxim as possible. so in my requirement i want it to be 100 in default. So i opened the page (That is having the Visio Web Part ) in SharePoint Designer and  search the word “Zoom” and it returned Web part configuration line as follows. ViewSettings="{"pageIndex":0,"viewBounds":{"x":-97,"y":-44,"width":938,"height":775}," zoomValue":100 }" here you can see zoom level is specified. So i changed it to 100 and save it back.   hooray…. It worked for me.

The SharePoint Software Factory is a Visual Studio Extension helping SharePoint newbies, as well as experienced developers to create, manage and deploy SharePoint solutions without having to know every tiny XML and C# secret. SPSF provides a huge collection of helpful utilities for development, debugging and deployment of SharePoint standard artifacts and is fully compatible with SharePoint 2007/2010 and Visual Studio 2008/2010 (in any combination) .. This is very powerful developer extension for visual studio. This is worth to try .. http://spsf.codeplex.com/

There are some special characters which we can use in the XML. thus XML parser will return something like Entity X not defined like errors. this problem comes using ok special characters such as &, > and etc. Following shoes hoe you can use XML special characters inside the Field values in XML or SharePoint list instance creation. < Data > < Rows > < Row > < Field Name = " Value " ><![CDATA[ & ]]></ Field > </ Row > </ Rows > </ Data > you can use any special character inside the CDATA tag.

This error i got when I'm opening a SharePoint Task from MS Outlook . So it is pretty forward. You need to add the source site to the Trusted Sites in the IE (Internet Explorer) or ask network security admin to trust it from the proxy policies.

Type following JavaScript in the Address bar in the browser. javascript:MSOLayout_ToggleLayoutMode();

this massage came when i tried to install  Visual Studio 2010 Service Pack 1. I do not have the Team foundation installed in my machine either. Ultimately i found that there is a program installed in Microsoft Team Foundation Server 2010 Beta 1 Object Model – ENU in the program files. i uninstalled it , Wow.. I manage to install the service pack without any errors.

SharePoint workflows are getting  slow for several reasons. in my environment I'm having a problem with following performance issues, therefore in my environment i got following problems. When a item added to the library it takes some times to initiate the workflow. Workflow mail generating is not very fast sometimes. Workflows takes more time to process “Due to heavy load, the latest workflow operation has been queued. It will attempt to resume at a later time” is coming sometimes. I had a custom workflow approval web part and it is taking more than 30 seconds to proceed. Work Done I had a custom workflow approval web part and it is taking more than 30 seconds to proceed. here in my custom web part there is the function which is programmatically updating the workflow. SPWorkflowTask.AlterTask(item, data, false) the last parameter mentioning whether it is synchronous asynchronous. if  is it true it it will wait until workflow schedule accept the workflow task. ...

This Error comes to me when i try to open Services.mcs Following fix worked for me. Fix Me (Download and Run this)

Normally in the we are developing InfoPath in a test server and published it in to the production server. when we are going to publish in to the different server InfoPath asked to change the connection files accordingly.  But sometimes when we are changing the publish location it is giving wrong URL’s for the connections. thus you can manually change the connection URL properties in the InfoPath manifest files. but please be careful of what you are doing. Howe to Change InfoPath Manifest manually   Export Info path as source files. change the manifest and save it. Tips: InfoPath data connections are stored in the section <xsf:dataObjects> You can change the urls by using site collection, baseurl  , relaliveurl attributes. Open manifest as design. save it again as xsn.