King Arthur's Technology Round Table

Error when workflow is running in publishing page

2011-04-12T12:16:00.000+01:00

I had a custom workflow associated with a content type used by a publishing page, that gave this error

[NullReferenceException: Object reference not set to an instance of an object.] Microsoft.SharePoint.Publishing.Internal.WorkflowUtilities.GetAssociationDataValue(CachedWorkflow workflow, String xmlNodeName) +124

Digging throught the web I found a solution.

We need to had this association data to the workflow

<my:myFields xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:my=\"http://schemas.microsoft.com/office/infopath/2003/myXSD\" xml:lang=\"en-us\"><my:ItemChangeStop>false</my:ItemChangeStop></my:myFields>

Apparently Sharepoint is looking for node called "ItemChangeStop"

Thanks to Julien C (http://www.sharepointdev.net/sharepoint--workflow/sharepoint-error-when-editing-documents-with-custom-content-types-44343.shtml)

Somewhere else people talked about and hotfix from microsot that isn't available on the web ...

Error using TextAlignment="Justify"

2011-03-17T22:11:00.000Z

When using TextAlignment="Justify" in a TextBlock a windows phone application unexpectedly exits.

After some digging apparently this alignment isn't supported on this control. Although appear as an option is a bug.

How to Configure Simple Network Time Protocol (SNTP)

2010-11-06T19:34:00.000Z

Just run the following commands

NET TIME /SETSNTP:time.windows.com
NET STOP W32TIME
NET START W32TIME
W32TM /config /reliable:YES
W32TM /resync /rediscover

Just replace time.windows.com with closest atomic clock address

For instance for Portugal the address is "ntp02.oal.ul.pt"

SQL Server 2000, 2005 intellisense and snippets

2010-10-20T21:56:00.000+01:00

In SQL Server 2008 there's a cool feature that improves productivity alot, intellisense or code completion as some people call it. But in the early versions there's nothing. In my daily work I use a lot SQL Server 2000 e SQL Server 2005.

I found the following aplication that does the trick, unfortunately there only a trial version,

SQL Prompt

Digging through I found out that old version 2.0.0.59 is free.For me it's good enough.

Download it for free HERE

Content Management Server 2002 stand-alone template explorer

2010-10-16T00:48:00.000+01:00

Several peolpe told me that they couln't load the template explorer even with cmsEnable="1" in the Vwd.webinfo file when opening a MCMS 2002 Project in Visual Studio 2005.

After some digging I found out that there was a stand alone MCMS template explorer available

Check the site Tools for Content Management Server 2002

Check for table dependencies on SQL Server

2010-10-14T22:54:00.000+01:00

I particularly use this instruction

EXEC sp_depends TABLE_NAME

But there are several methods as stated here

SQL Server 2000 guys please read de following the article BUG: SP_Depends Does Not List Triggers

Error: 18452 Login failed for user ‘user’. The user is not associated with a trusted SQL Server connection

2010-10-13T23:53:00.000+01:00

Just the other day I spent an hour trying to figure the "Error: 18452 Login failed for user ‘user’. The user is not associated with a trusted SQL Server connection" error.

I easily found out that I need to change the server authentication mode to mixed mode.

It took me a while but I just needed to restart the SQL Server as stated here

http://msdn.microsoft.com/en-us/library/ms188670.aspx

How to use UDL File to create sql connection string

2010-10-12T23:43:00.001+01:00

1. On a directory of your choosing, create file with UDL extension i.e. test.UDL

2. Open the file icon and a wizard will appear.

3. Create your connection string. First (in the first tab) chose appropriate Provider. Then (in the second tab) construct the Connection by filling the required information (servername, database or similar).

4. Test Connection. If the connection is successful, click OK.

5. Open the UDL file with NOTEPAD

In notepad, you will have the connection string like this

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=MySampleDB;Data Source=.;Initial File Name="";Server SPN=""

The wizard has constructed the connection string. This is for SQL Server. Copy the bolded part and use it as connection string in your application.

Date Picker JQuery Plugin

2010-10-09T15:16:00.000+01:00

The same guy who developed the cool color picker done another excelent job with this date picker. Thanks Stefan Petre

Check how it works here

Nice Color Picker JQuery Plugin

2010-10-09T15:07:00.000+01:00

Cool Jquery Plugin with no need of flash. Until now all that I found was in flash. It's A simple component to select color in the same way you select color in Adobe Photoshop.

Check out it works here

Free print screen capture tool

2010-10-09T00:11:00.000+01:00

Having to print webpage with a big scroll, all solution that I know were paid until I found this free tool, well free until version 5.3

FastStone Capture is a powerful, lightweight, yet full-featured screen capture tool that allows you to easily capture and annotate anything on the screen including windows, objects, menus, full screen, rectangular/freehand regions and even scrolling windows/web pages. It also allows you to record screen activities and sound into video files.

HomePage

Download Here

Connection problems using Live Messenger 2011 in Windows 7(seven)

2010-10-07T21:57:00.000+01:00

I've just updated my messenger to the most recent version, and instantly got problems at work because I'm behing a proxy.

After I trial and error I just found out that all I need to do was to configure the proxy by command-line

Just do what I say in the link below

http://tkingarthur.blogspot.com/2010/10/proxy-configuration-windows-7-seven.html

For other windows use

proxycfg - p server_ip:port_number

Proxy configuration windows 7 (seven)

2010-10-07T21:49:00.000+01:00

Working mostly in windows server 2003 never noticed that in windows 7 there's no proxycfg command.

You can do the same doing the following

Start --> Run --> CMD

netsh winhttp set proxy proxy-server=PROXYIP:PORT

Finding Long Lost emails super fast with Outlook Plug-in Xobni

2009-11-03T22:22:00.000Z

Have you ever had trouble finding a particular email with standard search from Outlook?

I had until I found this great tool. It basically builds a cube with all the information from outlook, and makes it ultra fast to find all emails from a contact, a particular email from some contact, and the feature that I like most to find a specific attachment you remember someone sent you.

This plug-in is excelent, although when you open the outlook it can be a little slow indexing all the information from your email.

The only real drawback I could find is that it doen't work in Windows 7 yet.

The great thing about it is that is free! You can download it here
And you can know more about it here

There is also a paid version with more features such as unlimited pst search, but for me this works just fine

Web.Config: Using a proxy with bypass list

2009-11-02T23:35:00.001Z

Sometimes when we are developing some application, we do it in a particular location where there's a proxy to access internet.

To build some websites with the capability to integrate information from internet sources we defined the proxy in the application's web.config like this

<configuration>
<system.net>
<defaultProxy>
   <proxy proxyaddress ="http://localproxy:8080" bypassonlocal="True" usesystemdefault="False" />
   <bypasslist>
   <add address="somelocaladdress.com" />
   <add address="someotherlocaladdress.com" />
   </bypasslist>
</defaultProxy>
</system.net>
</configuration>

Producing a timestamp in a batch file log

2009-11-02T00:01:00.000Z

Every now and then is necessary to log some command line output. If you need to recursively do it every in a automatic way it's good that you timestamp the log file with the current date.

So to do it use a batch file with the following instructions

set startDate=%date%
set startTime=%time%

set sdy=%startDate:~10%
set /a sdm=1%startDate:~4,2% - 100
set /a sdd=1%startDate:~7,2% - 100
set /a sth=%startTime:~0,2%
set /a stm=1%startTime:~3,2% - 100
set /a sts=1%startTime:~6,2% - 100

somecommand > logfilename%sdy%%sdm%%sdd%%sth%%stm%.txt

Event Id 59: Generate Activation Context failed for <...> Reference error message:Access is denied

2009-11-01T23:48:00.001Z

For some reason, I came across this error on a sql server machine.

Generate Activation Context failed for C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is denied.

To solve this problem I had to give the "Performance Log Users" List Folder Contents permissions

c:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin

Credits to this website more specifically Max Ustinov

Quickly view free space on your computer: Space Monger

2009-11-01T23:40:00.002Z

Every now and then my hard drive starts to be almost full and for some reason I long forgot or for some unneeded files that lays around.

There's was a time where I checked folder by folder for those files that were eating up free space, the I found out this free tool that quickly displays what and how much space is being used

Download here

Theres is also a more recent but paid version here

TFS and MCMS Template Explorer

2009-10-28T23:39:00.000Z

Opening an Microsoft Content Management Server 2002 project in Visual Studio 2005 with the MCMS 2002 SP2 installed when trying to checking in files in TFS gave me the following error

Unable to cast object of type 'Microsoft.ContentManagement.DeveloperTools.VisualStudio.Documents.TemplateExplorerDocument' to type 'Microsoft.VisualStudio.Shell.Interop.IVsHierarchy'.

Apparently it's a known error. To solve this problem, disable the MCMS Template Explorer when you use the Team Foundation service.

To do this open the Vwd.webinfo file located at the project's root with notepad and set the value of the CmsEnabled property to 0.

Check the microsoft link for more info:
FIX: Error message when you try to use Visual Studio 2005 Team Foundation Server to check in files on a computer that is running Content Management Server 2002: "Unable to cast object of type"

MCMS 2002: create new page leads to "channel not found" error

2009-10-28T23:30:00.000Z

Working with Microsoft Content Management Server 2002 when trying to "create a new page" in the console it gave me the erro "channel not found" when it was suposed to show me the page where I choose the template for the new page.

After some trial on error, I found out that for some reason the authentication in the web.config file was set to windows authentication, after changed it to forms authentication every started to work correctly.

ASP.NET version 2.0 Session State is not installed on the SQL server

2009-10-28T23:22:00.000Z

Sometime ago I encountered this error upgrading an ASP .NET 1.1 application to 2.0

"Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server"

To solve it just run this command in the server of SQL

aspnet_regsql.exe -S <servername> -E -ssadd -sstype c -t <customtable>

This happened because when I was using SQL Session State, so don't forget to change the web.config element sessionstate to have the attribute allowCustomSqlDatabase equals true

Something like this

<sessionState
mode="SQLServer"
allowCustomSqlDatabase ="true"
cookieless="true"
sqlConnectionString=" Integrated Security=SSPI;data source=MySqlServer;Initial catalog=customtable;"
sqlCommandTimeout="10" /

MCMS 2002 Template explorer not available in Visual Studio 2005

2009-10-19T21:18:00.000+01:00

Every now and then I have to maintain a website with the Microsoft Content Management Server 2002 and my surprise the site was still being developed in Visual Studio 2003. Immediately I start thinking on upgrading to Visual Studio 2005.

It seemed pretty easy. I opened the solution on VS 2005 upgrade the solution file to that version, and there was no MCMS Template explorer available. After a long time searching for a solution I found out that the website project must be the first on the solution file for some reason I can't imagine. So using notepad opened the sln and changed the order of the project.

Email Notification ASP.NET - Setting pickup directory

2009-10-14T09:47:00.001+01:00

Simply add the following to your web.config’s system.net section:


<mailSettings>
 <smtp deliveryMethod="SpecifiedPickupDirectory>
  <specifiedPickupDirectory pickupDirectoryLocation="c:\temp\"/>
 </smtp>
</mailSettings>

All mail sent will then been save as an eml file. Excellent stuff in a development environment.

Code Generation: Boost in productivity

2009-10-11T16:06:00.003+01:00

Everybody in the IT enviroments knows that when developing an application, eventually will be necessary to access some sort of database engine. All that work ends up being the same, develop the data access layer, implement the bussiness objects that store the information, write the store procedures that encapsule the database logic and this doesn't change much from one project another.
The amount of time spent doing this is huge, and I started to think that this could be done faster, so I start seaching in the Internet for a possible solution and came across an open source solution that suits my needs and I'd like to share with others.

The software is called "My Generation" a very suitable name.You can find it at (http://www.mygenerationsoftware.com/) .

With this tool you can use a number of predefined templates to generate code. I personally like the Dooads Template, and this template I generate the the store procedures, the bussiness entities, and the business data acess layer, base on existing SQL tables. Currently Dooads is available for Microsoft SQL, Oracle, Firebird, Access, PostgreSQL, VistaDB, SQLite and MySQL. You can find more information here

There are much more template you can find and try at the website.

You can download it here : My Generation Download
HomePage: My Generation Homepage

Introduction Video

With this my productivity increased a lot giving time to develop other components much more interesting to me and giving me a better overall performance within my company.

Good generations to you all

Welcome to the world of blogging...

2009-10-10T10:38:00.000+01:00

Oh well, this starts on a bumping road...

This is not the first time I used blogger. I thought this would be easy. Wrong. Configuring the blog was like going through a hurdle, I just had to jump.

Trying to activate adsense gave me an error:

"The publisher must be associated with the developer account before the developer can invoke operations on the publisher's account."

Those blogger guys could have written a better message.

Aparently to activate the adsense from blogger we have to give access to blogger.com on the adsense page

So if you have this problem go to log in to https://www.google.com/adsense and then select My Account and then Account Access and finally give access to blogger.com