XmlPolling with WCF SQL Adapter – System.ArgumentException

If you get the below error when using XmlPolling with the WCF SQL Adapter :

The adapter “WCF-Custom” raised an error message. Details “System.ArgumentException: The empty string is not a valid local name.
Parameter name: localName
   at System.Xml.XmlBaseWriter.StartElement(String& prefix, String….

Remember to setup the following binding properties :

xmlStoredProcedureRootNodeName & xmlStoredProcedureRootNodeNamespace

🙂

Advertisements

BizTalk 2009 Light & Easy on MSDN

BizTalk 2009 Light & Easy webcasts are now on msdn.  Check them out, some great content there.

http://code.msdn.microsoft.com/bts09/Release/ProjectReleases.aspx?ReleaseId=3086

Microsoft Knowledge Base monitoring

ever wanted to know, or get a list, to the hotfixes and knowledge base articles for a particular microsoft product, say BizTalk.

well….check out this site http://kbupdate.info/ 

now what I would really love is an alert feature 🙂

BizTalk 2009 Hands-On Labs – Thanks to all who attended

Just a quick thanks to all who attended the BizTalk 2009 Hands-On Labs, it was great to see some well known faces and to meet some of you for the first time.

If you would like similar events to be held in the future ( ESB 2 Toolkit maybe !!! ), let us know the content/topics you are interested in.  Just e-mail me on miguel@commodo.com.au.

Cheers 🙂

BizTalk 2009 Hands On Days – Hope to see you there :)

Hi All,

If you are involved with BizTalk in any way, or just want to know more about BizTalk, this Hands on Day, which will focus on the new realease of BizTalk 2009, is definetly worth it.Check out the agenda by clicking on the links below, some great speakers 😉

Hurry don’t miss out, there are limitted seats !!!

Some of the info below :

The Australian BizTalk User Groups (Sydney Connected Systems User Group, Brisbane BizTalk Community (BrizTalk) and Melbourne BizTalk User Group, would like to invite you to attend one of the BizTalk Server 2009 Hands On Days being presented in May and June 2009.

The event is targeted for those using previous version of BizTalk Server and those wishing to learn more about BizTalk Server. The attendees will have an a dedicated BizTalk 2009 development environment to use during the event. The attendees can either work on the hands on labs or to experiment with the feature of BizTalk 2009. The BizTalk 2009 development environment will include BizTalk 2009, RFID, ESB 2.0, Windows 2008, SQL 2008, Team Foundation Server 2008, Visual Studio 2008 Team Suite.

The Hands On Days will be on the following dates:

Melbourne

Brisbane

Saturday May 30th

Saturday June 13th

Register early as there are limited seats.

 

Sydney

Canberra

Perth

Adelaide

Saturday June 20th

TBA

TBA

TBA

Registration Opens Soon Register Your Interest Register Your Interest Register Your Interest

The Event cost is $200* (inc GST) and will include lunch.

The event fee will be used to cover the venue and travel expenses of the presenters, any left over funds will be used for food and drinks at upcoming user group events.

* Please note that the registration fee will be processed via PayPal by Chesnut Consulting Services

* Each presentation will finish in time for the attendees to have a chance to put what they have learned to use on the BizTalk 2009 Environments that will be provided.

Use uppercase username on Oracle LOB Adapter config

Here is a little gotcha with the Oracle LOB Adapter.

When configuring the database credentials to use, make sure you use all upper case characters for your username in the config.

The password is case sensitive, but even thought the username is not, it will only work if it’s all upper cased.

Calling a procedure owned by another schema when using Oracle LOB Adapter

recently I experienced an issue when using the Oracle LOB adapter which I thought I share here….

If you are trying to call a stored procedure using an account that does not own the proc, the adapter fails with an error similar to the below one :

Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5754
Description:
A message sent to adapter “WCF-Custom” on send port
Error details:
Microsoft.ServiceModel.Channels.Common.TargetSystemException:
ORA-06550: line 1, column 7:
PLS-00201: identifier ‘[YOUR PROC HERE]’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored —> Oracle.DataAccess.Client.OracleException
ORA-06550: line 1, column 7: PLS-00201: identifier ‘[YOUR PROC HERE]’ must be declared ORA-06550: line 1, column 7:
PL/SQL: Statement ignored at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Microsoft.Adapters.OracleDB.OracleDBXmlParser.ExecuteSingleCommand(OracleCommand command, Boolean recordPresent, Boolean accumateRowAffected)
at Microsoft.Adapters.OracleDB.OracleDBXmlParser.ExecutePackProcFunc(AdapterDataTable parsedMessage)

this happens because the adapter fails to fully qualify the proc call with the schema that owns the proc.

to fix this you will need to apply the hotfix described here : http://support.microsoft.com/kb/950101

The hotfix cannot be download, so you will need to ring Micrsoft and request it. 

After applying it, all works as expected 🙂