Win7: SP1 and BSOD – awaiting a hotfix!

Win7: SP1 and BSOD – awaiting a hotfix!

Windows 7 SP1 was released yesterday and after a 1.9GB download I was ready
to install.

Or so I thought…

Ran the Upgrade from within my version of Windows 7 x64 on my Fujitsu laptop

After the installation and upon rebooting several times….the upgrade process was
at the step of ‘starting windows for the first time….’ (not quite as this was an
upgrade, but if we were installing from scratch that would be it).

I was lovingly greeted by a BSOD STOP 0x0000007B!!!

Going no further – message.

So I downloaded and burnt ‘Win7 with SP1’ and tried the whole fresh install again
– same again. STOP ERROR

Alas….I’m writing this message while I’m re-installing just Win7 x64 without a hitch

Mick is avoiding SP1 like the plague right now!

I’m sure its been tested on a machine with SATA drives 🙂

New BizTalk 2010 book unveiled – Line of Business Systems Integration

New BizTalk 2010 book unveiled – Line of Business Systems Integration

Received news this morning that the book that I have been working on for the past 7 months has now reached “RAW” status.  What is RAW you ask?  RAW stands for “Read As we Write”.  The idea is to get the book, in soft copy format, into the hands of readers early.  The goal is to get early feedback from readers with the possibility of incorporating this feedback before the book is published.  This is a relatively new program from Packt but when it was presented to us we decided to get the book into the community sooner than later.  I must caution that the book, in this format, is not the final version.  Think of it as a CTP (Community Technical Preview) with the polished version of the book set for the end of April timeframe.

 

What is the book about?

The book primarily deals with Line of Business integration with popular LOB systems like SAP, Dynamics CRM, SalesForce.com, Dynamics AX, Oracle, SQL Server and SharePoint.  In addition to these chapters we also introduce the Line of Business Adapters Fundamentals and connecting to the AppFabric Service bus. 

 

Why write another BizTalk book?

As experienced developers we understand the nuts and bolts of BizTalk.  We can create Schemas, Ports, Maps and understand various BizTalk patterns.  The challenge is often understanding the systems that we are integrating with.  When integrating with commercial products like SAP and Dynamics  there is always some pre-requisite knowledge required to effectively integrate with it.  The goal of this book is to expose some of this pre-requisite knowledge so that an experienced BizTalk developer can get up to speed quickly with the technology that they need to integrate with.

Who are the authors?

I have yet to meet a person who was an expert in each of these technology areas.  With this in mind a talented team of BizTalk specialists was assembled to take on this adventure including:

Technical Reviewers

Anyone who has written a book can appreciate the “unsung heroes” of a published book.  The unsung heroes of this book are our Packt publishing team and Technical Reviewers.  We have an outstanding roster that includes the following people:

Packt

  • Kerry George
  • Alina Lewis
  • Zainab Bagasrawala

Technical Reviewers

I can say, without any hesitation, that their efforts have significantly increased the quality of the book.

 

For more details on the RAW program, I encourage you to visit the PACKT website.

 

Stay tuned for more information as the actual published date nears.

1902en_mockupcover_normal_0

WCF-SQL Adapter Stored Procedure

WCF-SQL Adapter Stored Procedure

In this post I would like to show a different way to insert a record inside a SQL Table using a stored-procedure with WCF-SQL Adapter. Last year I wrote a post on WCF-SQL Table Operations, which was/is very useful for a lot BizTalk pro’s. For BizTalk 2010 you can find Adapter Pack Samples through BizTalk Server Development Center. On that page you can find a sample called SQL Adapter -> Using the adapter with BizTalk Server -> Invoking Stored Procedures. If you download this sample you have to run executable and unzip content in a folder. Then in that folder read the Readme.

Following through the readme file you will come to a point that you have to open the solution with Visual Studio and you will see the orchestration displayed below:

image

This is very basic (not really useful using an orchestration) and through messaging one can accomplished just the same. I did deploy this sample, but without the orchestration (I deleted it). I only needed the schema’s. I named the application StoredProcedure. Schema used to call stored procedure is displayed below:

image

After deploying the sample I imported the binding file accompanied with this sample called BINDINGS.xml. Receive and send ports will be created and only thing I had to do is adding filters to send ports, change database name and credentials.

Filter added for message type: “http://schemas.microsoft.com/Sql/2008/05/Procedures#ADD_EMP_DETAILS”

image

Change Address (URI) with appropriate server- and database name.

image

Filter added for message type: “http://schemas.microsoft.com/Sql/2008/05/Procedures#ADD_EMP_DETAILSResponse”

image

Next step is to enable the receive location and start sendports. Copy message to folder, message looks like this:

image

With response:

image

In database you will see newly added record.

image

As you can see through messaging one can call stored procedure with WCF-SQL Adapter. With maps inside port one can map incoming message and response message to desired format. I will delve into this next time, with some alternative ways.

Cheers.

Technorati:

The EXECUTE permission was denied on the object ‘bam_Metadata_GetConfigurationXml’

The EXECUTE permission was denied on the object ‘bam_Metadata_GetConfigurationXml’

We were seeing this exception on two servers when we tried to access the BAM Portal… after having to reconfigure the BAM Portal and Tools for reasons unrelated to the error:


Log Name: Application
Source: Bam Web Service
Date: 2/18/2011 10:24:07 AM
Event ID: 1534
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: yyyyyyyyyyyyyyyyyyyy
Description:
Current User: yy\yyyyyyyy

EXCEPTION:
Microsoft.BizTalk.Bam.Management.BamManagerException: Encountered error while executing command on SQL Server “yyyyyyyyyyyyyyy”. —> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘bam_Metadata_GetConfigurationXml’, database ‘BAMPrimaryImport’, schema ‘dbo’.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.BizTalk.Bam.Management.SqlHelper.ExecuteQuery(String cmdText, CommandType cmdType, Transaction transaction)
— End of inner exception stack trace —
at Microsoft.BizTalk.Bam.Management.SqlHelper.ExecuteQuery(String cmdText, CommandType cmdType, Transaction transaction)
at Microsoft.BizTalk.Bam.Management.BamConfigurationManager.GetConfigurationXmlFromPrimaryImportDb()
at Microsoft.BizTalk.Bam.Management.BamConfigurationManager..ctor(String piServer, String piDatabase, Int32 sqlHelperCmdTimeout, Boolean validateServerNames)
at Microsoft.BizTalk.Bam.Management.BamManager..ctor(String primaryImportServer, String primaryImportDatabase, Int32 sqlCmdTimeout, Boolean validateServerNames)
at Microsoft.BizTalk.Bam.Management.BamManager..ctor(String primaryImportServer, String primaryImportDatabase)
at Microsoft.BizTalk.Bam.WebServices.Utilities.FetchBamManager()
at Microsoft.BizTalk.Bam.WebServices.Management.BamManagementService.GetViewSummaryForCurrentUser()

EXCEPTION:
Microsoft.BizTalk.Bam.Management.BamManagerException: Encountered error while executing command on SQL Server “yyyyyyyyyyyyyyyyyy”. —> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘bam_Metadata_GetConfigurationXml’, database ‘BAMPrimaryImport’, schema ‘dbo’.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.BizTalk.Bam.Management.SqlHelper.ExecuteQuery(String cmdText, CommandType cmdType, Transaction transaction)
— End of inner exception stack trace —
at Microsoft.BizTalk.Bam.Management.SqlHelper.ExecuteQuery(String cmdText, CommandType cmdType, Transaction transaction)
at Microsoft.BizTalk.Bam.Management.BamConfigurationManager.GetConfigurationXmlFromPrimaryImportDb()
at Microsoft.BizTalk.Bam.Management.BamConfigurationManager..ctor(String piServer, String piDatabase, Int32 sqlHelperCmdTimeout, Boolean validateServerNames)
at Microsoft.BizTalk.Bam.Management.BamManager..ctor(String primaryImportServer, String primaryImportDatabase, Int32 sqlCmdTimeout, Boolean validateServerNames)
at Microsoft.BizTalk.Bam.Management.BamManager..ctor(String primaryImportServer, String primaryImportDatabase)
at Microsoft.BizTalk.Bam.WebServices.Utilities.FetchBamManager()
at Microsoft.BizTalk.Bam.WebServices.Management.BamManagementService.GetViewSummaryForCurrentUser()

We reconfigured the BAM Portal and Tools multiple times, trying to fix this issue, but kept getting the exception. The fix was to add the BizTalk Server Administrators and BizTalk Application Users to the BAM_ManagementWS role in the BAMPrimaryImport database. (Note that these two groups do not appear to be added to this role in a “clean” configuration.

Thanks go to Ed at http://talentedmonkeys.wordpress.com/ for figuring out a solution.


Manage RDP Sessions from command line

Manage RDP Sessions from command line

This is basically a note to myself, as BizTalk person you tend to remotely login to multiple machines frequently. Often time I’ll be greeted with the message "Terminal services exceeded the maximum connections". The main reason will be, people tend to login and don’t bother to logoff. For me the quickest way to figure out all the logged in user and kick them off is by couple of commands

The first one to see all the logged in sessions using the command:

qwinsta /server:<<servername>>

Example,

qwinsta /server:UKRAS923WIN2K (btw, this is just a factious name :-))

image

To disconnect someone after seeing their long inactive period. you simple use this command

rwinsta /server:<<servername>> <ID>

Example: rwinsta /server:UKRAS923WIN2K 3

Nandri

Saravana

BizTalk 2010 Recipes: A Problem-Solution Approach Book Now Available

I had the honor of being the Technical Reviewer on the BizTalk 2006 Recipes book. 

One of the authors, Mark Beckner, has updated the book for BizTalk 2010. 

It is currently available on Amazon.com at 38% off list price.

This book covers the following topics:

  • What’s New in BizTalk Server 2010
  • Schemas
  • Mapping
  • Messaging and Pipelines
  • Orchestrations
  • Adapters
  • Business Rules Framework
  • EDI Solutions
  • Deployment
  • Administration and Operations
  • Business Activity Monitoring

I would highly recommend this book for anyone new to BizTalk Server or wanting to brush up on BizTalk 2010 skills.

Slides and Sample code from my London Connected Systems Talk

Slides and Sample code from my London Connected Systems Talk

This week on 15th Feb 2011, I gave a talk on London Connected Systems user group titled “Instrument and Diagnose your BizTalk Solution in an efficient way“. The slide deck and the sample download can be found here

1. Presentation

2. Sample Source

The talk was mainly focused around the usage of the instrumentation framework released by the CAT team. The key references are:

* http://code.msdn.microsoft.com/appfabriccat/Release/ProjectReleases.aspx?ReleaseId=4355

* http://btscatifcontroller.codeplex.com/

* http://www.microsoft.com/downloads/en/details.aspx?FamilyID=2785c8bd-c10b-4961-b478-721973d6ccef&displaylang=en

Hope you enjoyed it.

Nandri!

Saravana

BizTalk 2010 certification coming soon

BizTalk 2010 certification coming soon

I saw today that the BizTalk 2010 certification details were posted at http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-595&Locale=en-us#tab2. According to the article the exam will be available at the very end of March 2011. I know many people in the BizTalk community have been eager for another BizTalk certification test so the good news for everyone is that Microsoft listened […]