Polaty collection of important stuff i came across

ENTSSO service not starting up when .NET 4.0 is installed

2010-10-01T08:19:00.000-07:00

When you get following errors with ENTSSO service after installing .Net 4.0 then you may need to apply the hotfix
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=46fa6c65-531a-4c9f-99f9-7af3fac098a6&displaylang=en.

Could not create SSOSQL. To fix the problem, reinstall SSO or try 'regasm SSOSQL.dll' from a Visual Studio command prompt.
Error Code: 0x80131700

or

The SSO service failed to start.
Error Code: 0x80131700

Adding a node usine Microsoft.RuleEngine.XMLHelper

2010-08-10T12:01:00.000-07:00

Adding a node without a namespace in BRE using Microsoft.RuleEngine.XMLHelper can be done quite easily with AddNode method.
For eg :
Step 1. XmlHelper.AddNode(AcCanonicalSchemas.AcCommonPCTypes.MsgStatus:/MsgStatus, . ,ExtendedStatus)
2. XmlHelper.AddNodeWithValue(AcCanonicalSchemas.AcCommonPCTypes.MsgStatus:/MsgStatus, ./ExtendedStatus[position()=last()], ExtendedStatusCd, Code added in this node through BRE)
Step 1 adds a node to ExtendedStatus under MsgStatus TypedXMLDocument.
Step 2 adds a node ExtendedStatusCd and its value under ExtendedStatus node.

This is fine untill the TypedXMLDocument MsgStatus is without any namespace. If MsgStatus has a namespace for eg http://AcCanonicalSchemas.PANDC then the above code with addnode will generate xml as

<MsgStatus xmlns="http://AcCanonicalSchemas.PANDC"><ExtendedStatus xmlns=""><ExtendedStatusCd>Code added in this node through BRE</ExtendedStatusCd></ExtendedStatus></MsgStatus>

Which cannot be validated. To add a node with the same namespace, use the Xpath as below in .
Step 1
XmlHelper.AddNode(AcCanonicalSchemas.AcCommonPCTypes.MsgStatus:/MsgStatus, . ,ExtendedStatus, http://AcCanonicalSchemas.PANDC)
2. XmlHelper.AddNodeWithValue(AcCanonicalSchemas.AcCommonPCTypes.MsgStatus:/MsgStatus, ./*[local-name()='ExtendedStatus' and namespace-uri()=http://AcCanonicalSchemas.PANDC'][position()=last()], ExtendedStatusCd, Code added in this node through BRE)

This will generate Xml as

<MsgStatus xmlns="http://AcCanonicalSchemas.PANDC"><extendedstatus><ExtendedStatusCd>Code added in this node through BRE</ExtendedStatusCd></ExtendedStatus></MsgStatus>

This will make sure all nodes are under the same namespace.

XSD.exe not able to generate C# classes when the schema uses imports

2010-08-03T11:37:00.000-07:00

XSD.Exe is unable to generate C# classes when an import function is used to use the existing types from another schema. It throws a warning like
Schema could not be validated. Class generation may fail or may produce incorrect results.
Solution : Copy the imported schema(Schema with reuse types) to the same folder as the schema which is using its types and also don't use the reference when importing to get to the reusable types instead use the schema which is copied to the local folder and then execute the following command.

Xsd.exe NewSchema.xsd SchemaWithReuseTypes.xsd /c this should generate the corresponding c# class.

BizTalk HttpServiceInstances not getting terminated

2009-12-09T08:21:00.000-08:00

Execute the below query against BizTalk messagebox database.

Declare @out int
Begin transaction
exec dbo.int_AdminTerminateInstance_BizTalkHttpHost '3ae6ac2f-9b24-407a-a072-63733bc84254', '3ae6ac2f-9b24-407a-a072-63733bc84254', @out
Commit

where BizTalkHttpHost is the host name of the active instance
First GUID value is the service instance id and second GUID is service type id.

Remember this is provided as is with no gurantee.

User account issues while accessing BAM

2009-06-04T07:16:00.000-07:00

BAM Web Services and SQL Server mixed mode authentication
This is an issue I see every once in while so let's see what causes it and how to diagnose and fix it.
You have created and deployed a BAM definition with some BAM views in it but when you hit the BAM Portal with IE all you see in the "My Views" pane on the left is an error message "Views or Activites may be missing because one or more database(s) could not be contacted." followed by "No view to display" message. Now what?
Your first step to troubleshooting such issues is the Windows Event Log on the machine hosting the IIS server running the BAM Portal and the BAM web services. The BAM event log entries will be in the Application event log. You can filter on event source equal to "BAM Portal" or "BAM Web Service". I will usually look at the last few errors from "BAM Web Service".
So you open the Windows Event Viewer and you see one error from "BAM Web Service" with event ID 12033. Double-click on it and the description says:
Referenced database 'BAMPrimaryImport' on server 'SERVERNAME' is not accessible. The error is:
System.NullReferenceException: Object reference not set to an instance of an object.at Microsoft.BizTalk.Bam.WebServices.AsyncResult.End(AsyncResult asyncResult)at Microsoft.BizTalk.Bam.WebServices.Management.GetViewSummaryAsyncResult.End(IAsyncResult result)at Microsoft.BizTalk.Bam.WebServices.Management.BamManagementService.EndGetViewSummaryForDatabase(IAsyncResult result)at Microsoft.BizTalk.Bam.WebServices.Management.BamManagementService.GetViewSummaryForCurrentUser().
Now what?
The second step to troubleshooting BAM Web Services issues is to... enable tracing. To turn on tracing go to the "Program Files\Microsoft BizTalk Server 2006\BAMPortal\BAMManagementService" directory (or "...\BAMQueryService") and open the web.config file with notepad. Uncomment the element towards the end of the file. By default the traces will be saved in "C:\temp\BamManagementServiceTrace.log" or "C:\temp\BamQueryServiceTrace.log". Make sure that the IIS worker process user account (usually Network Service or ASPNET) and the BAM web service user have write permissions for the trace log file directory (C:\temp by default).
Turn on tracing for the BAM Management Web Service and refresh the BAM Portal home page in IE. Now open the trace file "C:\temp\BamManagementServiceTrace.log" and search for the string "Error" from the top of the file to find the first error. In this case the first error is:
06/13/2006 17:00:36 6 Microsoft.BizTalk.Bam.WebServices.TraceHelper ThrowHelperSoapException Error 11007 Cannot determine the SID for the user.
Bingo! This is the root cause of the problem.
Now some history behind this problem. The BAM Web Services authenticate all users using Windows authentication and authorize them based on their Windows identity. But there is a special case - DBO. DBO is a special account which has permissions to all BAM views. So the BAM Web Services will try to find the Windows identity for the DBO user for the BAM Primary Import database and they will fail if this is a SQL account.
BAM does not support anything other than Windows authentication for SQL Server. If everything else seems to work, there is no guarantee that it actually does and it will continue to work in the future. True, the error is not intuitive but it is correct.
How to resolve the problem now that we have identified it? It is really easy indeed. Just change the DBO accounts for all BAM databases to Windows accounts. You can do this using the sp_changedbowner system stored procedure.
To set DBO to the "domain\user" account run:
use BAMPrimaryImportgosp_changedbowner 'domain\user'go
Navigate to the BAM Portal and verify that you see all BAM views and no errors in the left pane on the home page.
There is a pretty nice BizTalk Installation Guide, which you can use the next time you setup BizTalk Server to avoid such issues.
Filed under: BAM

SQL server 2005 installation issues

2008-09-13T09:32:00.001-07:00

SQL server 2005 installation issues.Menu options in Start Programs not being dispalyed for SQL server 2005 after installation.

Solution.

Client components are not installed properly. You may need to uninstall workstation components and reinstall them from Disk1.
Follow the article http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953

Could not configure BAM Portal in BizTalk 2006

2008-03-22T07:22:00.000-07:00

When configuring BAM Portal you may come across a situation where in you cannot select users and groups in the BAP Portal configuration page in BizTalk configuration window.
This may happen due to various reasons and one of them is as below.
- If you have already configured BAM Portal but removed the portal from the website. Hence the configuration information remained in the BAM Config tables and is not removed from there.

To clear the config information stored earlier, use the BM.EXE and export the config file into a xml and removed the http://ServerName:80/BAM and reimport the config file using BM.EXE.
Now you should be able to configure the BAM portal from BizTalk Configuration window.

Wireless over DSL with fixed IP

2008-03-05T16:58:00.000-08:00

First connect the DSL modem directly to the computer using which you are configuring the DSL connection. Setup the internet connection by using the login /password and the fixed IP given. Remember to notedown the details are these are required while configuring the wireless. Also notedown the Primary DNS. Once the internet connection is established using a wired connection between DSL and Computer then just open the browser and by default the DSL modem home page should appear. And now go to connection setting page and change the connection PPPOE to bridge connection save and exit which will restart the DSL modem. Now connect the wireless router to DSL modem and login to the home page of wireless router where you can set the configuration setting and select PPPOE and enter the details (like login, pswd, IP address given by ISP and the DNS) properties of WAN. Now save these settings and you are good to go.

Removing SourceSafe dependencies from a solution/project

2008-02-29T22:01:00.000-08:00

Situation:Your buddy has created a cool VB.NET application that you want to use. He sends you the source code and it consists of a solution (MySolution) containing a single project (MyProject). You attempt to open the solution and find that it has SourceSafe dependencies. You need to remove all the VSS stuff from the solution/project files.
Solution:
1 - Go to the folder containing the solution files and delete the following: mssccprj.scc MyProject.vssscc vssver.scc
2 - Open MyProject.sln in your favorite text editor and remove the following section: GlobalSection(SourceCodeControl) = preSolution ... EndGlobalSection
3 - Go to the folder containing the project files and delete the following: MyProject.vbproj.vspscc mssccprj.scc vssver.scc
4 - Open MyProject.vbproj in your text editor and remove the following lines: SccProjectName = "SAK" SccLocalPath = "SAK" SccAuxPath = "SAK" SccProvider = "SAK"
Now you can open the solution/project with no source control errors.

Configuring IIS for BTSHTTPReceive.dll

2007-10-04T12:36:00.000-07:00

How to configure IIS for a BizTalk 2006 HTTP Receive Location
First thing you need to do is to make sure that IIS's security is not going to be blocking your calls to the BTSHTTPReceive.dll. To do this goto your IIS manager and click on the Web Service Extension node and right click it and 'Add a new Web Service Extension'. Now browse to the location of BTSHTTPReceive.dll (by default installation its in :\Program Files\Microsoft BizTalk Server 2006\HttpReceive\ folder). Also remember to check the 'Set extension status to Allowed' checkbox. It is also a good idea to create a new application pool for your application to run in. When creating one make sure that the user account used is a member of the BizTalk Isolated Hosts group and the IIS_WPG group.
Now your going to create a new virtual directory in IIS under Default Web Site. Make sure you link the location of BTSHTTPReceive.dll in the content directory. Also make sure you use the new application pool you just setup. Make sure that both Read and Execute permissions are selected, and that Execute permissions are set to Scripts and Executables. After this you should be all set to start setting up your HTTP Receive Location within BizTalk Explorer
Note: Make sure websites are refreshed.

Zombie identification in Biztalk 2006

2007-09-21T07:55:00.000-07:00

Zombies can be identified in Biztalk server 2006 by using the following query in the messagebox database.

SELECT * FROM HostNameQ_Suspended where nErrorCategory = 4

In the above query HostName should be replaced with corresponding host name in which you want to identify the Zombies. If the above query return any rows then it indicates that there are Zombies present.

BizTalk DW Reporting Faulting application btsntsvc.exe, version 3.5.1602.0

2007-08-30T06:56:00.000-07:00

BizTalk DW Reporting Faulting application btsntsvc.exe, version 3.5.1602.0
If you are seeing this error in application log,
Set the value of
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\BizTalk Server\3.0\DW\TracingEnabled to 0. Default is 1.

New transaction cannot enlist in the specified transaction coordinator

2007-08-23T12:57:00.000-07:00

The "SQL" adapter is suspending an outbound message going to destination http://www.blogger.com/ servername/DBName/". Details:"New transaction cannot enlist in the specified transaction coordinator. ".

The problem was resolved when I changed :
Administrative Tools \ Component Services \ My Computer \ Properties \ MSDTC \ Security Configuration \ Transaction Manager Communication \ "Mutual Authentication Required" --> and check "Incoming Caller Authentication Required"

USB device not showing up in windows explorer

2007-05-16T07:16:00.000-07:00

If your USB device is not showing up in windows explorer when connected to your system. Do the following.
- Go to Start - Control panel - Hardware - Device Manager
- Identify the device instance id by going to properties of the corresponding device.
- Go to registry HKLM - System - Enum - USB - and the corresponding device instance id.
- Change the registry value for PortableDeviceNameSpaceExcludeFromShell to "0" (value Zero)
- Connect the USB and the device should be detected now.