DevTeach: Check out the Bonus sessions! Free for everyone

At DevTeach Ottawa we’re having Bonus sessions. This time, we have two nights with different bonus sessions done in collaboration with the local community. On November 2nd ,you can attend for free the Ottawa IT Community Speaker Idol. Come and see a friendly contest where local speakers have to do a 10 minutes presentation; the audiences will choose the winners. On November 3rd, we’re having three user groups presentations at the same time. The OttawaSQL will be presenting a sessions by Paul Nielson, The ODNC user group will present an Agile Scrum and Kanban presentation by David Starr and the OWSUG is having a IT Camp. All bonus sessions are free for everyone. Get all the details at this link.

For more info visit:

http://www.devteach.com/BonusSession.aspx

Biztalk: The “XLangTask” task failed unexpectedly

Last Monday I started, mainly, a Biztalk contract with a previous client. When I tried to build some of the work I have done before I was getting the following error:

Error 1 The “XLangTask” task failed unexpectedly.
System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {1BBA9F19-D4CC-34AA-918C-44FEF11E8274} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
at Microsoft.VisualStudio.BizTalkProject.Compiler.XLangCompiler.Compile(BizTalkBuildSnapshot buildSnapshot, IEnumerable`1 orchestrationFilesToCompile, String switches, String outputPath, List`1& generatedCodeFiles)
at Microsoft.VisualStudio.BizTalkProject.BuildTasks.XLangTask.Execute()
at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
at Microsoft.Build.BackEnd.TaskBuilder.ExecuteInstantiatedTask(ITaskExecutionHost taskExecutionHost, TaskLoggingContext taskLoggingContext, TaskHost taskHost, ItemBucket bucket, TaskExecutionMode howToExecuteTask, Boolean& taskResult)

The environment was:
Windows Server 2008 R2
Biztalk 2010 Enterprise Edition
SQL Server 2008 R2
VS2010 Ultimate

I tried few things like cleaning the solution, change the build target ..etc. Nothing worked. Finally, I decided to repair Biztalk:

Control Panel –> UnInstall Programs –> click Microsoft Biztalk Server Enterprise Edition –> Uninstall/Change. Choose Repair option when prompted

And That fixed it

LightSwitch: Oracle An error occurred while starting a transaction on the provider connection. See the inner exception for details

I got this issue today while connecting to the Oracle database. I am not taking credit of the solution but I couldn’t find a post that explains it step by step. For the benefit of the community I decided to write this post. It is also good for me to find the solution later on if I get stuck J

To fix the issue we need to create a transaction scope and call TransactionScope.complete when the execution is complete

Right click the oracle Datasource

Select View Code

Add the following code to the generated class; replace OracleDSService with the name of your class

using System.Transactions;

namespace LightSwitchApplication
{

    public partial class OracleDSService
    {
        private TransactionScope transactionScope;
        partial void SaveChanges_Executing()
        {
            transactionScope = new TransactionScope(TransactionScopeOption.Required,
                        new TransactionOptions() { IsolationLevel = IsolationLevel.ReadCommitted });
        }

        partial void SaveChanges_Executed()
        {
            transactionScope.Complete();
        }
    }
}

In my case System.Transactions namespace wasn’t resolved. To fix that I had to add a reference to the System.Transactions assembly

To do so, follow these steps

Switch to the File View

Right click on the server project and choose Add Reference

Find the System.Transactions assembly; in my case it was at C:\Windows\Microsoft.NET\Framework\v4.0.30319\System.Transactions.dll

Save the solution, build, and run

LightSwitch: Change Default Database Instance

I posted How to Change Development Database in LightSwitch which shows how to change the database at the project level. But if you are really bored repeating the process every single time you create a new project and you want to change the default instance of you database, you can follow these steps:

• Close Visual Studio (IMPORTANT!)
• Open the Windows Registry i.e. Regedit
• I am using Visual Studio Ultimate: Go to HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\DataProject
• Change the value for the DefaultSSEName key with the database instance you want to use. For instance I replace SQLExpress with SQLExpress2k8R2
• Close Regedit
• Open Visual Studio
• Create new Lightswitch project
• Unload project then right click and select edit project
• Check SqlExpressInstanceName

Windows 8: Run applications like Regedit

One way

• Go to the Start menu which is your tiles screen
• Move the mouse cursor to the bottom left corner until you see what I call the short menu
• Select Search
• Type the application you want to run such as regedit

Another way

• Move the mouse cursor to the bottom left corner
• You should see a mini start screen
• Right click
• Select Run
• Type Regedit