BizTalk 2006 Forum - Recent Threads

biztalk to pick emails without POP3adapter

Anonymous — Tue, 12 Mar 2013 05:48:42 GMT

Hi,

We are facing a scenario where an application will send e-mails to a particular account. And BizTalk needs to pick the mails and process them (parse though the message) and send it. We use POP3 Adapter to Receive mails. Is there any way in BizTalk can pick an email coming to an account on a Microsoft Exchange Server. The POP3 feature wouldnt be provided and policies restrict us to connect to an external POP3 account.
Is there any other alternative in biztalk?

Thanks!

Can we call 'Start Orchestration Shape' from .Net Assembly?

Anonymous — Tue, 05 Feb 2013 17:39:41 GMT

We are trying to achieve following scenario. Let me know if someone can help me in this.

There is master orchestration which need to initate different orchestrations based upon one of the value returned by rules defined(BRE). We want orchestration binding to be done at runtime i.e we are planning to keep Orchestration name in the rule engine, which will return us different value based upon the business logic.

e.g. Following is written in BRE, if messageType = 'XXX' then return 'Name of Orchestratrion1 or Orchestration1 Assembly Name', if messagetype = 'YYYY' then return 'Name of Orchestration2 or Orchestration2 Assembly Name'

Our master orchestration will call the business rule engine using Call Rule shape, which will return us the name or assembly name of orchstration to be initiated. Now we will pass the assembly name to .NET code which will call 'Start Orchestration Shape'.

We can't use 'Start Orchestration Shape' or 'Call Orchestration shape' in the Master Orchestration as doing this means they will be tighly coupled. The only way to achieve is to call 'Start Orchestration shape' from .NET Assembly and pass Orchestration name returned from BRE to the .NET assembly, which will initiate Orchestration based on the name returned.

I haven't done this before. Can someone let me know how can we do this in .NET assembly.

---Sunny

Simple Debatching without orchestration

Piyush — Sat, 12 Jan 2013 14:28:51 GMT

Hi,

I am trying to debatch a single csv file into multiple csv files, based on no. of records.

My format of csv file is :

10001, Name of product, 723.56, 2

10013, Name of product, 234.99, 1

10021, Name of product, 836.99, 9

10045, Name of product, 500.27.3

Have completed the following steps :

Created flat file schema
Created send and receive pipeline.
Set the child delimiter of root node as 0x0D 0x0A
delimiter type : Hexadecimal , Order :Postfix
Set the child delimiter of child record node as ,(comma)
delimiter type : Character , Order :Infix

Now when i drop the csv file in input location it gets picked up, but at the send location instead of 4 csv file, i get the same file which was dropped as input.

Kindly help.

Thanks ,

Piyush

Deployment error

Anonymous — Fri, 16 Nov 2012 14:34:09 GMT

Hi All,

I am getting the below error when I try to deploy .. Please help me ...

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Out of Memory Exception

questionare — Tue, 04 Sep 2012 10:06:19 GMT

Hi gurus,

I am implementing a custom pipeline; which splits an XML message into smaller chuncks (configured number of records). The issue is if the XML message size is big +100Mb, I got an out of memory exception; and the line where the exception occurs is:

Stream originalMessageStream = pInMsg.BodyPart.GetOriginalDataStream();

string originalDataString = streamReader.ReadLine();

Since the XML string loaded is huge, an exception is thrown. I tried using the VirtualStream & Seakable stream; however, couldn't find the Microsoft.BizTalk.Streaming assembly.

How I can solve such issue?

Crossing BizTalk 2006

leoncius — Thu, 09 Aug 2012 19:35:29 GMT

I'm in charge on evolving an application wich uses BizTalk. The problems is that this company have omited to have an architect look into the XML files passed to Biztalk. Now there are xml that have the same structure but for two diffent things. For example the same XML file is used to contain information on Toyota car and Volkswagen car and normaly they should have a diffenrent structure.

Anyhow I have a policy that is comparing values from XML files and even if I coded .NEt vocabularies to test for the ID to be equal, it stills crosscheck XML files that don't have the same ID.

For Each brePolicy As Rule In listePolicys

Dim priority As Integer = brePolicy.Priority

policy.Rules.Clear()

policy.Rules.Add(brePolicy)

Dim re As RuleEngine = New RuleEngine(policy)

re.Execute(objectBuffer)

That is how the xml files are being executed one at the time an all xml files are being thrown to Biztalk inside the objectBuffer

Looping issue

bpleshek — Thu, 02 Aug 2012 19:29:09 GMT

I have an input schema similar to this:

Header

--itemNumber

Detail

--lineItemNum

--Status

I am mapping to a schema similar to this:

root

----itemNumber

----Notes

Item number maps straight across. lineItemNum and Status are concatenated and separated via a comma and each loop on detail is separated by a ~. I am using a concatenate functoid with 4 parameters: lineItemNumber, ",", Status, and '~'. I am then using a cumulative concatenate on the result of that and finally a value mapper to the Notes field.

Instead of getting:

<root>

<Notes> 1,Active~2,Cancelled~3,Active </Notes>

</root>

I am getting:

<root>

<Notes> 1,Active~2,Cancelled~3,Active </Notes>

</root>

Any ideas?

Thanks

lost data in biztalkmsgboxdb

Anonymous — Sat, 21 Jul 2012 12:14:29 GMT

I am a dba at a company and we happened to have a power shortage.Our servers were shut down.

The problem now is that the database biztalkmsgboxdb went into "suspect" mode and I couldnt put it back online without data loss.

I have a backup which is 20 minutes old, so I restored my backup 20 minutes earlier which made me lose all the data that went to this database during these 20 minutes.

My question is what is the effect of this data loss on the biztalk transactions that were done during these 20 minutes? Is this database only used as a buffer? and will this affect my future transactions.

Problem processing multiple files at the same time

Anonymous — Mon, 21 May 2012 13:16:32 GMT

Hi all,

I have a custom developed pipelineand a receive port used to pick files from the local folder. The problem we have is that only 5 files (at best) are processed simoultaneously. We have already increased the Batch Size and number of messages in batch settings with no result. We have already modified the registry to introduce the CLR Hosting Key with the recommended values for IO threads and worker threads, with no result..

Any ideas to increase the amount of files or threads of our application?

Thanks and best regards!

SendPort FTP Transport Properties Temporary Folder

Anonymous — Thu, 26 Apr 2012 11:53:44 GMT

Hello, I have problems with a orchestration that starts with an FTP that puts file in a temporary folder setup as "E:\FolderName", and this doesn't work anymore. The errorcodes is The adapter failed to transmit message going to send port "Fiskhamnen.toConsafe"
with URL "ftp://212.181.1.85:21/Inbox/%MessageID%.xml".
It will be retransmitted after the retry interval specified for this Send Port.
Details:"The folder "E:\FolderName" does not exist. ".¨

A message sent to adapter "FTP" on send port "Fiskhamnen.toConsafe"
with URI "ftp://212.181.1.85:21/Inbox/%MessageID%.xml" is suspended.
Error details: The folder "E:\FolderName" does not exist.
MessageId: {00F8EEFD-C89A-493C-83C7-DC003752513D}
InstanceID: {AF2857ED-DB18-4EB0-BF8F-0AA440336F25} The FolderName exists and is setup with rights to everyone, any clues? /Regards Anders

BizTalk Receive and iSeries IFS

sbrown63 — Tue, 17 Jan 2012 17:55:29 GMT

I am trying to map a FILE recieve location to an IBM iSeries IFS share. I tried using the Authentication tab and changing credentials to those that allow access. Below are the three messages I receive. Are there any tricks to making this work? I can connect just fine via windows explorer using the same credentials.

The receive location "TESTContractReceiveLocation" with URL "\\qrli03\ROOT\pfrlitxt.txt" is shutting down. Details:"The FILE receive adapter cannot monitor receive location \\qrli03\ROOT\. ".

There was a failure executing the receive pipeline: "Microsoft.BizTalk.DefaultPipelines.PassThruReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "Pipeline " Receive Port: "TESTContractReceivePort" URI: "\\qrli03\ROOT\pfrlitxt.txt" Reason: External component has thrown an exception.

The Messaging Engine encountered an error while suspending one or more messages.

Zero Touch BizTalk Deployments - LIVE WEBINAR

Anonymous — Mon, 09 Jan 2012 09:40:06 GMT

Learn how you can fully automate complex deployments for your Microsoft BizTalk applications.

In this webinar, Nolio’s Product Director Ron Gidron will introduce the concept of Zero Touch Deployment™; demonstrating how the successful realization of fully automated application releases can reduce errors, lower costs, increase operational throughput and accelerate time-to-market.

Mr. Gidron will systematically demonstrate how the successful implementation of an automated solution will allow you to:

Achieve full control of BizTalk applications, host instances, orchestrations and bindings
Fully automate all aspects of BizTalk applications deployment and configuration
Create reusable deployment processes across multiple BizTalk versions
Reduce your dependency on command line and complex manual deployments of BizTalk applications

Mr. Gidron will show a live demo as part of his presentation and be available for a dedicated ‘Question and Answer’ session at the webinar’s conclusion. At that time, all participants will be invited to talk with him directly.

This free webinar will be held on Tuesday, January 24, 2012 at 11am EST/4pm GMT. Register today: http://www2.noliosoft.com/biztalk

Error configuring group - BT 2006 R2

Anonymous — Mon, 05 Dec 2011 19:13:14 GMT

I am seeing the error "Login failed for user ''. The user is not associated with a trusted SQL Server connection." configuring biztalk 2006 R2 group. SQL is on my local machine and my user account has full permissions to the database. Below is the error log created.

Please help!

2011-12-05 14:07:50:0595 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:50:0830 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\BTS_Version_Schema.sql
2011-12-05 14:07:50:0892 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\BTS_Version_Logic.sql
2011-12-05 14:07:50:0986 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\TDDS_Dest_Schema.sql
2011-12-05 14:07:51:0049 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\BTS_Tracking_Schema.sql
2011-12-05 14:07:51:0392 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\DTA_RulesEngine_Schema.sql
2011-12-05 14:07:51:0549 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\msgbox_tracking_schema.sql
2011-12-05 14:07:51:0814 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\Backup_Setup_All_Tables.sql
2011-12-05 14:07:51:0908 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\BtsEdiMessageContentTables.sql
2011-12-05 14:07:51:0986 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\TDDS_Dest_Logic.sql
2011-12-05 14:07:52:0174 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\BTS_Tracking_Logic.sql
2011-12-05 14:07:52:0783 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\DTA_RulesEngine_Logic.sql
2011-12-05 14:07:52:0986 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\msgbox_tracking_logic.sql
2011-12-05 14:07:53:0142 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\Backup_Setup_All_Procs.sql
2011-12-05 14:07:53:0267 [INFO] WMI Executing SQL script: C:\Program Files (x86)\Microsoft BizTalk Server 2006\Schema\\BtsEdiMessageContentSps.sql
2011-12-05 14:07:53:0345 [INFO] WMI CoCreating BizTalkDBVersion
2011-12-05 14:07:53:0408 [INFO] WMI Stamping database schema version to be 3.7.1.0
2011-12-05 14:07:53:0439 [INFO] WMI Tracking database created
2011-12-05 14:07:53:0783 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkMgmtDb
2011-12-05 14:07:53:0830 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:53:0892 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:53:0924 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:54:0002 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:54:0095 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:54:0158 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:54:0220 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:54:0267 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:54:0345 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:54:0377 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:54:0455 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:54:0486 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:54:0549 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:54:0595 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:54:0674 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:54:0720 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:54:0799 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:54:0861 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:54:0924 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:54:0986 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\BizTalkDTADb
2011-12-05 14:07:55:0049 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:55:0142 [INFO] WMI Creating SQL login 'BizTalk Server Administrators' for BTS Admin Group
2011-12-05 14:07:55:0299 [INFO] WMI Creating SQL login 'BizTalk Server Operators' for BTS Operator Group
2011-12-05 14:07:55:0361 [INFO] WMI Creating SQL login 'BizTalk Server Administrators' for BTS Admin Group
2011-12-05 14:07:55:0424 [INFO] WMI Calling CDataSource.Open() against VSREENIVASADEVF\BizTalkRuleEngineDb
2011-12-05 14:07:55:0470 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:55:0533 [WARN] AdminLib GetBTSMessage: hrErr=c0c025ca; Msg=BizTalk Server cannot access SQL server. This could be due to one of the following reasons:
1. Access permissions have been denied to the current user. Either log on as a user that has been granted permissions to SQL and try again, or grant the current user permission to access SQL Server.
2. The SQL Server does not exist or an invalid database name has been specified. Check the name entered for the SQL Server and database to make sure they are correct as provided during SQL Server installation.
3. The SQL Server exists, but is not currently running. Use the Windows Service Control Manager or SQL Enterprise Manager to start SQL Server, and try again.
4. A SQL database file with the same name as the specified database already exists in the Microsoft SQL Server data folder.

Internal error from OLEDB provider: "Login failed for user ''. The user is not associated with a trusted SQL Server connection.";
2011-12-05 14:07:55:0564 [WARN] AdminLib GetBTSMessage: hrErr=80070002; Msg=The system cannot find the file specified.;
2011-12-05 14:07:55:0611 [WARN] AdminLib GetBTSMessage: hrErr=c0c02560; Msg=Failed to read "KeepDbDebugKey" from the registry.
The system cannot find the file specified.;
2011-12-05 14:07:55:0658 [INFO] WMI Error occurred during database creation; attempt to rollback and delete the partially created database'vsreenivasadevfl\BizTalkDTADb'
2011-12-05 14:07:55:0705 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\master
2011-12-05 14:07:55:0752 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:55:0939 [WARN] AdminLib GetBTSMessage: hrErr=80070002; Msg=The system cannot find the file specified.;
2011-12-05 14:07:55:0970 [WARN] AdminLib GetBTSMessage: hrErr=c0c02560; Msg=Failed to read "KeepDbDebugKey" from the registry.
The system cannot find the file specified.;
2011-12-05 14:07:56:0017 [INFO] WMI Error occurred during database creation; attempt to rollback and delete the partially created database'vsreenivasadevfl\BizTalkMgmtDb'
2011-12-05 14:07:56:0142 [INFO] WMI Calling CDataSource.Open() against vsreenivasadevfl\master
2011-12-05 14:07:56:0189 [INFO] WMI CDataSource.Open() returned
2011-12-05 14:07:56:0330 [ERR] WMI Failed in pAdmInst->Create() in CWMIInstProv::PutInstance(). HR=c0c025ca
2011-12-05 14:07:56:0361 [ERR] WMI WMI error description is generated: BizTalk Server cannot access SQL server. This could be due to one of the following reasons:
1. Access permissions have been denied to the current user. Either log on as a user that has been granted permissions to SQL and try again, or grant the current user permission to access SQL Server.
2. The SQL Server does not exist or an invalid database name has been specified. Check the name entered for the SQL Server and database to make sure they are correct as provided during SQL Server installation.
3. The SQL Server exists, but is not currently running. Use the Windows Service Control Manager or SQL Enterprise Manager to start SQL Server, and try again.
4. A SQL database file with the same name as the specified database already exists in the Microsoft SQL Server data folder.

Internal error from OLEDB provider: "Login failed for user ''. The user is not associated with a trusted SQL Server connection."
2011-12-05 14:07:56:0392 [INFO] WMI CWMIInstProv::PutInstance() finished. HR=c0c025ca
[2:07:56 PM Error BtsCfg] d:\depot2300\mercury\private\mozart\source\setup\btscfg\btswmi.cpp(358): FAILED hr = c0c025ca

[2:07:56 PM Error BtsCfg] BizTalk Server cannot access SQL server. This could be due to one of the following reasons:
1. Access permissions have been denied to the current user. Either log on as a user that has been granted permissions to SQL and try again, or grant the current user permission to access SQL Server.
2. The SQL Server does not exist or an invalid database name has been specified. Check the name entered for the SQL Server and database to make sure they are correct as provided during SQL Server installation.
3. The SQL Server exists, but is not currently running. Use the Windows Service Control Manager or SQL Enterprise Manager to start SQL Server, and try again.
4. A SQL database file with the same name as the specified database already exists in the Microsoft SQL Server data folder.

Internal error from OLEDB provider: "Login failed for user ''. The user is not associated with a trusted SQL Server connection."
[2:07:56 PM Error BtsCfg] d:\depot2300\mercury\private\mozart\source\setup\btscfg\btscfg.cpp(1769): FAILED hr = c0c025ca

[2:07:56 PM Info BtsCfg] Entering function: CBtsCfg::UnConfigureFeature
[2:07:56 PM Info BtsCfg] Unconfiguring feature: WMI
[2:07:56 PM Warning BtsCfg] BTS management server or DB names are not found in the registry.
[2:07:56 PM Info BtsCfg] Entering function: CWMI::StopHostInstance
2011-12-05 14:07:56:0439 [INFO] WMI CWMIInstProv::EnumerateInstances() try to acquire lock
2011-12-05 14:07:56:0486 [INFO] WMI CWMIInstProv::EnumerateInstances() lock acquired successfully
2011-12-05 14:07:56:0517 [INFO] WMI CWMIInstProv::EnumerateInstances(MSBTS_HostInstance) started
2011-12-05 14:07:56:0564 [INFO] WMI CWMIInstProv::VerifyMgmtDbCompatibility() started
2011-12-05 14:07:56:0611 [INFO] WMI QueryStringValue query regkey 'MgmtDBServer'
2011-12-05 14:07:56:0627 [INFO] WMI QueryStringValue query regkey 'MgmtDBName'
2011-12-05 14:07:56:0689 [INFO] WMI CWMIInstProv::VerifyMgmtDbCompatibility(ServerName, DBName) started
2011-12-05 14:07:56:0720 [INFO] WMI CWMIInstProv::VerifyMgmtDbCompatibility(ServerName, DBName) finished successfully
2011-12-05 14:07:56:0767 [INFO] WMI CWMIInstProv::VerifyMgmtDbCompatibility() finished successfully
2011-12-05 14:07:56:0814 [INFO] WMI CWMIInstProv::EnumerateInstancesWithQuery(MSBTS_HostInstance) started
2011-12-05 14:07:56:0861 [WARN] AdminLib GetBTSMessage: hrErr=c0c024bf; Msg=The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.;
2011-12-05 14:07:56:0908 [ERR] WMI Failed in RetrieveInstances in CWMIInstProv::EnumerateInstancesWithQuery(). HR=c0c024bf
2011-12-05 14:07:56:0955 [ERR] WMI WMI error description is generated: The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
2011-12-05 14:07:56:0986 [INFO] WMI CWMIInstProv::EnumerateInstances() finished. HR=c0c024bf
[2:07:57 PM Error BtsCfg] d:\depot2300\mercury\private\mozart\source\setup\btscfg\btswmi.cpp(1672): FAILED hr = c0c024bf

[2:07:57 PM Error BtsCfg] The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
[2:07:57 PM Info BtsCfg] Entering function: CWMI::UnMapHost
2011-12-05 14:07:57:0095 [INFO] WMI CWMIInstProv::EnumerateInstances() try to acquire lock
2011-12-05 14:07:57:0142 [INFO] WMI CWMIInstProv::EnumerateInstances() lock acquired successfully
2011-12-05 14:07:57:0189 [INFO] WMI CWMIInstProv::EnumerateInstances(MSBTS_ServerHost) started
2011-12-05 14:07:57:0236 [INFO] WMI CWMIInstProv::VerifyMgmtDbCompatibility() started
2011-12-05 14:07:57:0267 [INFO] WMI QueryStringValue query regkey 'MgmtDBServer'
2011-12-05 14:07:57:0314 [INFO] WMI QueryStringValue query regkey 'MgmtDBName'
2011-12-05 14:07:57:0361 [INFO] WMI CWMIInstProv::VerifyMgmtDbCompatibility(ServerName, DBName) started
2011-12-05 14:07:57:0392 [INFO] WMI CWMIInstProv::VerifyMgmtDbCompatibility(ServerName, DBName) finished successfully
2011-12-05 14:07:57:0455 [INFO] WMI CWMIInstProv::VerifyMgmtDbCompatibility() finished successfully
2011-12-05 14:07:57:0486 [INFO] WMI CWMIInstProv::EnumerateInstancesWithQuery(MSBTS_ServerHost) started
2011-12-05 14:07:57:0533 [WARN] AdminLib GetBTSMessage: hrErr=c0c024bf; Msg=The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.;
2011-12-05 14:07:57:0580 [ERR] WMI Failed in RetrieveInstances in CWMIInstProv::EnumerateInstancesWithQuery(). HR=c0c024bf
2011-12-05 14:07:57:0611 [ERR] WMI WMI error description is generated: The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
2011-12-05 14:07:57:0658 [INFO] WMI CWMIInstProv::EnumerateInstances() finished. HR=c0c024bf
[2:07:57 PM Error BtsCfg] d:\depot2300\mercury\private\mozart\source\setup\btscfg\btswmi.cpp(1821): FAILED hr = c0c024bf

[2:07:57 PM Error BtsCfg] The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
[2:07:57 PM Info BtsCfg] Instantiating IBTSMsgBoxPerformance object
[2:07:57 PM Info BtsCfg] Calling IBTSMsgBoxPerformance::UninstallArtifacts
Exception in CounterManager.UninstallArtifacts when uninstalling the perf counter instances. The exception details are:
Source of exception: .Net SqlClient Data Provider
Message: Could not find stored procedure 'MsgBoxPerfCounters_GetMsgBoxesAndServers'.
Stack trace: at Microsoft.BizTalk.MsgBoxPerfCounters.MgmtDbAccessEntity.UninstallInstances(Boolean regularUninstall)
at Microsoft.BizTalk.MsgBoxPerfCounters.CounterManager.UninstallArtifacts(Boolean regularUninstall, String logFileName)

XML containing email mapped to CSV, send as attachment

kumaker — Wed, 30 Nov 2011 02:23:51 GMT

Hi All,

Here is my situation:

- I receive an XML which contains an email address in the <title></title> field (ie <title>xxxx@hotmail.com</title>).

- This XML is then mapped to a CSV (The Email is not mapped to the CSV and it does not contain this email address).

- I then need to send this CSV as an attachment to the email which was contained in the original XML.

What I have done before is sent email through an SMTP adapter and used a custom pipeline component to attach a file to an email. BUT, the reason I am not going into depth about how hard I have tried to figure this out, and all my code etc... is because with the company I am working for I am unable to access an SMTP server on my desktop. I can only deploy solutions and test the SMTP functionality on a test server (i cannot develop them/debug etc on the test server), which has basically made this particular project a massive headache. So I have tried a few things, but continuing I feel, without some help is a lost cause.

Can someone please point me in the right direction, or the steps I should take (code would be amazing), the objects I might need in an orchestration, or anything that would help me?

Thanks so much for your help in advance.

Problem in receivePipeline

markand911 — Wed, 12 Oct 2011 14:08:46 GMT

I followed the article http://www.codeproject.com/KB/biztalk/UnzipDisassembler.aspx?fid=1607856 to create a custom component that can be used in Receive pipeline.

It doesnt work.

Are there any other steps to be followed to implement this custom component?

BizTalk Servers sharing same Databases

sbrown63 — Fri, 30 Sep 2011 15:37:30 GMT

I have two BizTalk servers sharing the same databases, and inprocess hosts both called BizTalkServerHost that run on both servers. If I send a message to the message box (via direct binding) to one of the servers, could that message then be sent to subscribers on both servers and thus be processed twice? These subscribers are send ports using the FTP adapter to FTP the file. I have a situation where the messages appear to be routed to the send port but then they hang there in an InProcess state as Running Service Instances. I'm wondering if there may be some sort of conflict due the sharuing of the databases.

Transaction issue with Oracle DB

Murali.Suneendra — Thu, 22 Sep 2011 14:16:31 GMT

Hi All,

We had a requirement in our project to bulk insert in to tables of an oracle DB, so we have developed an orchestration which process the incoming message and sends the data to Oracle DB using a WCF-Oracle adapter,on the send port where we have set the “ambient transaction” property to true, as we need to revert back in case of any error while inserting in to any of the tables, but at this point we are getting an error as shown below.

Error Description: Microsoft.ServiceModel.Channels.Common.MetadataException: Metadata resolution failed for OperationId: "http://Microsoft.LobServices.OracleDB/2007/03/Server alias name /Table/Name of the table /Insert". ---> Microsoft.ServiceModel.Channels.Common.ConnectionException: Due to an Oracle Client limitation, the adapter failed to open a connection. This is because either (a) ambient transaction is present and the TNS alias is longer than 39 characters, or (b) ambient transaction is present and a non-TNS based URI was used. To resolve this, use a TNS alias to connect to Oracle and make sure it is not more than 39 characters. at Microsoft.Adapters.OracleDB.OracleDBConnection.OpenConnection(OracleCommonExecutionHelper executionHelper) --- End of inner exception stack trace

We have checked the TNS alias name in the TNSNames.ora which is just 6 characters long ,so that is also ruled out can anyone please help us in resolving this issue, if you need more information please reach me on 7829692692.

Thanks & Regards,

Murali

Remvoing BuiltIn\Administrators from Biztalk database server

Anonymous — Mon, 12 Sep 2011 22:34:31 GMT

BuiltIn\Administrators group is present as a login on Biztalk SQL Server (database server) and is a member of the sysadmin role in it. As part of our security policy, our IT security team wants it to be removed from this role and also as a login from this server. Does removing BuiltIn\Administrators from sysadmin role have any impact on the Biztalk server and database server and the overall biztalk functionality. Our Biztalk server 2006 (applications) and SQL database server (containing messagebox, management database etc) are hosted on different machines.

Expressions in FILE Adapter Mask

sbrown63 — Tue, 06 Sep 2011 16:31:58 GMT

Can anyone tell me if there is a way to have regular expressions within a File adapters File Mask property. I want to be able to setup two rec locations pointed at the same source folder but each picking up different files based on a timestamp within the name of the file.

Hipaa Accelerator 3.3 generates files for each data entries in the file instead of segments

ajay.kallur@gmail.com — Mon, 05 Sep 2011 20:21:50 GMT

Hello,

Need some help with the BizTalk Hipaa Accelerator 3.3, which we are using with biztalk server 2006. The hipaa edi accelerator is not splitting segments as usual.

The incoming edi hipaa data file has six segments with each segment with 70-80 thousand data entries (people records), the Hipaa edi accelerator is generating 70-80 thousand files instead of 6 files.

have anyone seen such behaviour before???

nothing wrong with the data files they work well in a different environment.

any help is greatly appreciated?

Thanks

Ajay

Biztalk 2006 + forestFunctionality 2008R2 + domainFunctionality 2008R2

jochen_schober — Tue, 30 Aug 2011 11:17:17 GMT

Are there any well known Problems after migrating the forestFunctionality + domainFunctionality up to 2008R2?

The Biztalkserver runs under 2003 SP2. It will be replaced in the next time so I won't migrate the Biztalk to the aktual Version.

Only for for the Biztalk: we use one Exchange 2003 SP2, our main mailsystem runs under 2010.

I don't found a compability matrix, only for the 2010 Biztalk.....

Regards

Jochen

BRE

colderfall — Sat, 13 Aug 2011 22:24:43 GMT

How to update SQL table using BRE directly?

I have a msg which has 3 elements ( Name,City,State) and i subscribe this msg to orchestration. Now i have a table in my SQL DB which has the same 3 columns. Now i want to use BRE by calingl a CALL RULE shape.

Which has to perform following Actions:

In my case ,

In Condition if my STATE= TRUE or FALSE I need to update my SQL table. This shd happen when ever i sent a new msg like if i have 10 msg i need to get 10 rows with 3 columns and so on........

I want to know whether it is possible, by using some Facts.

Note: I know i can update using storeprocedure and .net components in orchestration but i want to know if their are any possible ways to update SQL table directly in BRE withoout using Storeprocedures and .NetComponents.

CAN SOME GIUDE ME IF THERE IS A POSSIBLE WAY TO DO THIS.

how to have different serial numbers in one section

hsi21898 — Wed, 10 Aug 2011 00:34:21 GMT

Hi,

I'm new for Biztalk 2006, and have the issue needs to fix.

I received an order and the order detail has same information such as line number, part number. However it has different serial number. How I can put the serail number in one section?

For instance:

<OrderDetail>
<OrderNumber>123</OrderNumber>
<ShipDate>2011-08-09</ShipDate>
<LineNumber>1</LineNumber>
<PartNumber>abc</PartNumber>
<Description>PINK</Description>
<Quantity>2</Quantity>
<SerialNumber>159</SerialNumber>
</OrderDetail>
- <OrderDetail>
<OrderNumber>123</OrderNumber>
<ShipDate>2011-08-09</ShipDate>
<LineNumber>1</LineNumber>
<PartNumber>abc</PartNumber>
<Description>PINK</Description>
<Quantity>2</Quantity>
<SerialNumber>252</SerialNumber>
</OrderDetail>

Instead, it should be like:

<OrderDetail>
<OrderNumber>123</OrderNumber>
<ShipDate>2011-08-09</ShipDate>
<LineNumber>1</LineNumber>
<PartNumber>abc</PartNumber>
<Description>PINK</Description>
<Quantity>2</Quantity>
<SerialNumber>159</SerialNumber>
<SerialNumber>252</SerialNumber>
</OrderDetail>

However, the quantity might change to 3 or 4 with 3 or 4 serial numbers. Thanks for the help.

biztalk

Anonymous — Thu, 28 Jul 2011 07:39:57 GMT

plz anyone provide biztalk realtime scenraio, project

bre testing error, plzzzzzz help me

Anonymous — Tue, 26 Jul 2011 21:15:25 GMT

hi , im created policy and vocabriles, when im policy , i got error,

im using callrule , there not apppear parametername, parameter type , i see empty.