Archive
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