BizTalk 2010

Forum Post: Re: Error: The published message could not be routed because no subscribers were found.

Anonymous — Fri, 17 May 2013 20:00:00 GMT

Thanks for the options. The first one solved it.....!

Forum Post: Re: Input string was not in a correct format

Anonymous — Tue, 14 May 2013 07:01:00 GMT

Sorry, the error.

xlang/s engine event log entry: Uncaught exception (see the 'inner exception' below) has suspended an instance of service 'QUASAR.BusinessHiway.Common.PhdInterface.CommonTestTrigger(3bcb26a2-08d7-a4db-8fda-463c4a483850)'.

The service instance will remain suspended until administratively resumed or terminated.

If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception.

InstanceId: 7d537472-7283-474e-a690-aafd2876b18e

Shape name:

ShapeId: 0194f9a7-adf6-4349-9845-8985ab5c1d43

Exception thrown from: segment 1, progress 25

Inner exception: Input string was not in a correct format.

Exception type: FormatException

Source: mscorlib

Target Site: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

The following is a stack trace that identifies the location where the exception occured

at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)

at Microsoft.XLANGs.RuntimeTypes.XmlHelpers.ParseString(String s, Type targetType, Boolean throwIfNotParsed)

at Microsoft.XLANGs.RuntimeTypes.XmlHelpers.ChangeType(Object val, Type targetType)

at Microsoft.XLANGs.Core.XMessage.GetContentProperties()

at Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.PrepareMessage(XLANGMessage msg, IList promoteProps, IList toPromote)

at Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.PersistMessageState(XLANGMessage msg)

at Microsoft.XLANGs.Core.XMessage.PrePersist(Boolean dehydrate, IStateManager state)

at Microsoft.XLANGs.Core.ReferencedMessages.PrePersist(Boolean dehydrate, Context state)

at Microsoft.XLANGs.Core.Context.PrePersist(Boolean dehydrate, Context state)

at Microsoft.XLANGs.Core.Context.PrePersist(Boolean dehydrate, XlangStore store)

at Microsoft.XLANGs.Core.ExecutingSubStates.PrePersist(Boolean dehydrate, Context ctx)

at Microsoft.XLANGs.Core.Context.PrePersist(Boolean dehydrate, Context state)

at Microsoft.XLANGs.Core.ServiceContext.PrePersist(Boolean dehydrate, Context state)

at Microsoft.XLANGs.Core.Service.PrePersist(Boolean dehydrate, Context ctx)

at Microsoft.XLANGs.Core.Service.PrePersist(Boolean dehydrate, XlangStore store)

at Microsoft.XLANGs.Core.ExecutingSubStates.PrePersist(Boolean dehydrate, Context ctx)

at Microsoft.XLANGs.Core.Context.PrePersist(Boolean dehydrate, Context state)

at Microsoft.XLANGs.Core.Context.PrePersist(Boolean dehydrate, XlangStore store)

at Microsoft.XLANGs.Core.ExecutingSubStates.PrePersist(Boolean dehydrate, Context ctx)

at Microsoft.XLANGs.Core.Context.PrePersist(Boolean dehydrate, Context state)

at Microsoft.XLANGs.Core.ServiceContext.PrePersist(Boolean dehydrate, Context state)

at Microsoft.XLANGs.Core.Service.PrePersist(Boolean dehydrate, Context ctx)

at Microsoft.XLANGs.Core.Service.Persist(Boolean dehydrate, Context ctx, Boolean idleRequired, Boolean finalPersist, Boolean bypassCommit, Boolean terminate)

at Microsoft.XLANGs.Core.LongRunningTransaction.PendingCommit(Boolean ignore, XMessage msg)

at Microsoft.BizTalk.XLANGs.BTXEngine.BTXPortBase.SendMessage(Int32 iOperation, XLANGMessage msg, Correlation[] initCorrelations, Correlation[] followCorrelations, SubscriptionWrapper& subscriptionWrapper, Context cxt, Segment seg, ActivityFlags flags)

at Microsoft.XLANGs.Core.PortBase.SendMessage(Int32 iOperation, XLANGMessage msg, Correlation[] initCorrelations, Correlation[] followCorrelations, SubscriptionWrapper& subscriptionWrapper, Context cxt, Segment seg)

at QUASAR.BusinessHiway.Common.PhdInterface.PhdInterfaceModify.segment1(StopConditions stopOn)

at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp)

Forum Post: How many Receive locatons i can create for one application, and can i create those by any script

Anonymous — Thu, 09 May 2013 09:06:00 GMT

I have task to create 700 receive locations which picks the messages from sharepoint site, so my question is what is the limit of receive locations in a biztalk server, and how to create those RcvLoc by any script?

Thanks,

Madhu

Forum Post: Re: BizTalk 2010 FTP Adapter getting suspended without Any Issues

Olivia Jones — Tue, 07 May 2013 14:11:00 GMT

Hi,

I also faced similar type of situation some time ago and Athena was very helpful to me.

www.athenainfotech.co.uk

Forum Post: Re: BizTalk Application Bloat

Ritley572 — Wed, 01 May 2013 12:49:00 GMT

Nobody has any experience with such a large amount of applications within BizTalk? No pitfalls to watch out for?

Forum Post: 400 Bad Request error

saravanan@biztalk — Mon, 29 Apr 2013 08:42:00 GMT

Hai. I am using Biztalk 2010 for Integration between SAP R3 Servers with RNIF standards.

One side windows’ using RNIF Adaptor and Another side is Web Method.

The below is my scenario

RNIF Adaptor(http send) --> RNIF Adaptor(https Receive) (Success)

RNIF Adaptor(http Send) --> Web Method(https Receive) (Failure)

One of my client system having Public IP address only but certificate is applied for Domain.

I am getting 400 Bad Request Error. Can anyone tell me where I am going wrong?

Forum Post: How to read a file from Solaris-UNIX server using FILE adapte

Anonymous — Wed, 24 Apr 2013 15:09:00 GMT

Hi All,

I am able to send a file to the UNIX (samba file share) using BizTalk FILE adapter but getting the below error when trying to read a file using FILE adapter. The host user account has the full permissions on the UNIX file share, surprisingly error shows the windows account.

Error(error code)16397
Windows(R) Lightweight Directory Access Protocol (LDAP) failed a request to connect to Active Directory Domain Services(R) for Windows user <Domain\WindowsLogin>.
Without the corresponding UNIX identity of the Windows user, the user cannot access Network File System (NFS) shared resources.
Verify that the Windows user is in Active Directory Domain Services and has access permissions.
Please advise.
Regards.

Forum Post: Re: Track messages by schema name

Anonymous — Thu, 18 Apr 2013 14:48:00 GMT

Hi Tamas, here's hopefully a useful link for you

social.msdn.microsoft.com/.../a49fe8ac-5e8f-4760-8a90-26e7eb71b45d

Forum Post: Re: Execute DTS Package on SQL 2008R2

ajay.kallur@gmail.com — Mon, 08 Apr 2013 21:54:00 GMT

That is correct, xp_cmdShell is not allowed for security reasons

The option to call a sql job is not good in my case because I am also looking to get a response back from sql.

So, Yes I did go with the option of calling a stored procedure from C# within my orchestration. That works fine as well.

Thank you

Ajay

Forum Post: XML elements of type date generate errors when data is blank or 00/00/0000

ajay.kallur@gmail.com — Mon, 08 Apr 2013 21:51:00 GMT

Hi,

Here's an error I am getting when validating a flatfile against its schema,

"The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar"

This error is showing up for elements with datatype: "xs:date" and custom format: "MM/dd/yyyy"

The error occurs when data value is blank or in one case when the data was 00/00/0000.

For blank data, I set the Nillable property to "True" but still gave the same error.

Also, tried giving a default value in the date format but the it was still giving out the same error.

Note: the flatfile source is a mainframe system where its not possible to fix the data and has to be done at my end. Also, I am trying to avoid to use a map with a scripting functoid for each date type element, since the current doesn't need one, if not for this issue.

Please do let me know how do I fix this? All help is greatly appreciated.

Thanks.

Ajay Kallur

ajay.kallur@gmail.com

Forum Post: Orchestration instance goes in Dehydrated state

Anonymous — Thu, 04 Apr 2013 09:55:00 GMT

Hi All,

I have orchestration, where I am using parallel shape with 4 branches and Receive shape to receive all the message. The receive shape have Correlation set initialize to 'BTS.MessageType'.

In each of the branch of parallel shape I am using scope shape where I have put all my business logic.

My business logic involves, sending request to oracle and SQL DB and receiving response from the same.

When I execute the orch, everything runs fine except Orchestration is not going in completed state.

Can anyone explain me what is the issue ? and if I have to set any property for it.

It's very urgent for me. Right now I am Restarting application instance after each run to overcome such issue.

Please help me to resolve such issue.

Regards,

Jyotsna

Forum Post: Re: Mapping .msg to XML to SQL

NISHIL — Sun, 31 Mar 2013 22:01:00 GMT

Write the body out to a file folder. and in other Receivelocation use a FlatFile Disassemble pipeline which will convert the body file to Xml format and then map it to SQL Schema and send it further to SQL SendPort. Or you can call the FlatFile Disassemble pipeline directly from the Orchestration which will return you the XML.

Forum Post: Re: WCF-SQL missing

NISHIL — Sun, 31 Mar 2013 21:56:00 GMT

It should work fine. When you installed BzTalk did you also clicked on the CheckBox to install the default WCF Adapter which comes with BizTalk?. Try that and then things should work fine.

Forum Post: Re: DBLookup functioids not working

NISHIL — Sun, 31 Mar 2013 21:51:00 GMT

There might be some configuration issue. The problem is ValueExtractor functoid wont return you any Error if any. It will return blank.

So what you can do is use a Error Return Functoid and see if any Error is returned. Most probably it is access issue with databases.

msdn.microsoft.com/.../aa559365(v=bts.20).aspx

Forum Post: Re: A message with new fields will be accepted even though BizTalk does NOT now taht new fields in the appropriate schema

Anonymous — Fri, 29 Mar 2013 18:31:00 GMT

Hi all. Thank you very much...

The issue has been answered...

Forum Post: MetadataException: The assembly required for type mapping not found

bd_biz — Thu, 28 Mar 2013 23:16:00 GMT

I have generated schemas using ConsumeAdapterService from oracle database. I just want to insert data into tables that contain user defined types. Hence, the usertype assembly also got generated.I also have specified the below properties.

enableBizTalkCompatibilityMode = True

useSchemaInNameSpace = False

useAmbientTransaction = True

userAssembliesLoadPath=<DLL path>

I have deployed the solution in my development environment and the solution works great and I can insert data into oracle tables.

Now I deploy this solution to another test environment. I have GACed the assemblies and copied to the Biztalk installation folder as well. I have also specified the path in the userAssembliesLoad property and have done all the setup just i did in my local environment.

I receive the below error

Error Description: Microsoft.ServiceModel.Channels.Common.MetadataException: The assembly required for type mapping not found.

The change is the biztalk environment and the Oracle database server. However, i specified all other properties accurately.

I wonder why it works in my local and does not work in test environment.

Please advise if you have any solution

Forum Post: Biztalk 2010 TPM : Unable to delete Batch from the parties via Admin console

karthick.sampangi — Thu, 28 Mar 2013 15:24:00 GMT

Hi All,

I'm unable to delete the batch from parties in Biztalk server 2010 via Admin console. Even i cleared/deleted all the running batching orchestration instance and restarted the Host instances. I get below errors if delete the batch configuration:
Even i queried in BiztalkMgmtdb, I could see the batch details records in batchdescription table.

Exception has been thrown by the target of an invocation. (Microsoft.ManagementConsole)

===================================

Batch Id 71 not found. Check if batch and party exist. (Microsoft.BizTalk.Edi.Shared)

------------------------------
Program Location:

at Microsoft.BizTalk.Edi.Shared.BatchingUtilities.GetBatchDescription(TpmContext context, Int64 batchId)
at Microsoft.BizTalk.Edi.Shared.ControlMessageUtils.CreateControlMessage(Int64 batchId, ControlMessageType controlMessageType)
at Microsoft.BizTalk.Administration.EdiExt.UserControls.PartnerBatchControl.toolStripStartButton_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Please suggest me how to solve this issue.

Regards,
Karthick

Forum Post: Error in Custom Unzipping pipeline component that inherits Flat file disassembler (FFDasm)

Anonymous — Wed, 27 Mar 2013 14:14:00 GMT

Hi,

I have a custom disassembler that unzips files. and files for which an xml schema is defined, I call the base.Disassemble and base.GetNext methods to convert them from flat file to xml.

It works fine in some situations, however for some test sample files where Base.GetNext method should be called only once (and then null should be returned from FFDasm) it is getting called multiple times until it throws an exception with this message

==============

Reason: Unexpected data found while looking for:
'|'
The current definition being parsed is Record. The stream offset where the error occured is 1063. The line number where the error occured is 1. The column where the error occured is 1063.

==============

I tried to check if the flat file in the sample zip files that does not match the schema configured, However when I validate the flat file instance against the schema, the validation is successful.

So what I did was I wanted to find out why so many times the Base.GetNext method is getting called and hence I read the message returned by the Base.GetNext method wrote it to the event log . When I do that the component works propertly !!!! Base.GetNext gets called only once and then the message returned is read and written to the event log. The moment I remove the piece of code( that reads the returned message and writes it to the event log) I get back the exception. And this happens for only certain sample zip files not all.

Here is the method that unzips the file

=====================================

private void UnZip(IPipelineContext pContext, IBaseMessage pInMsg)
{
string sBatchMark = Guid.NewGuid().ToString();
Ionic.Zip.ZipFile objZipFiles = Ionic.Zip.ZipFile.Read(pInMsg.BodyPart.Data);
IEnumerator<Ionic.Zip.ZipEntry> objZipEntries = objZipFiles.GetEnumerator();
//pContext.ResourceTracker.AddResource(objZipFiles);
//pContext.ResourceTracker.AddResource(objZipEntries);
objMessage = pInMsg;
IBaseMessage objResult, objDisassemResult;

//
while (objZipEntries.MoveNext())
{
objResult = pContext.GetMessageFactory().CreateMessage();
IBaseMessagePart objPart = pContext.GetMessageFactory().CreateMessagePart();
objPart.Data = new VirtualStream();
objZipEntries.Current.Extract(objPart.Data);
objPart.Data.Position = 0;
objResult.AddPart("body", objPart, true);
objResult.Context = objMessage.Context;
//pContext.ResourceTracker.AddResource(objResult);

if (objFileExtensions.Contains(Path.GetExtension(objZipEntries.Current.FileName).ToUpper()))
{
base.Disassemble(pContext, objResult);
while ((objDisassemResult = base.GetNext(pContext)) != null)
{
//StreamReader sr = new StreamReader(objDisassemResult.BodyPart.Data);
//EventLog.WriteEntry("Zip", sr.ReadToEnd());

objMessageList.Enqueue(objDisassemResult);
AddContextProperties(objDisassemResult, FileNameContextProperty, FileNameContextNamespace, objZipEntries.Current.FileName);
AddContextProperties(objDisassemResult, BatchMarkContextProperty, BatchMarkContextNamespace, sBatchMark);
}
}
else
{
objMessageList.Enqueue(objResult);
AddContextProperties(objResult, FileNameContextProperty, FileNameContextNamespace, objZipEntries.Current.FileName);
AddContextProperties(objResult, BatchMarkContextProperty, BatchMarkContextNamespace, sBatchMark);
}
}
}

=====================================

If I uncomment the BOLD Lines it works fine , else It doesn't

Any ideas why this is happening ??

PLEASE HELP

Thanks in advance

Surya

Forum Post: Error while configuring WSS 3.0 in Biztalk Server

Anonymous — Thu, 28 Feb 2013 21:25:00 GMT

Trying to install & configure WSS 3.0 services in biztalk server where SQL SErver is in remote machine. Installed these SQL server components(Client Connectivity and Management tools) in Biztalk server. The account that I am using has Admin rights in both machines. New databases are being created in sql server while configuring , but fails at the end.

I would really appreciate if anyone can help me on this. Thankyou in Advance!!

ERROR:Failed to create the configuration database.An exception of type System.UnauthorizedAccessException was thrown. Additional exception information: Attempted to perform an unauthorized operation.System.UnauthorizedAccessException: Attempted to perform an unauthorized operation. at System.Security.AccessControl.Win32.SetSecurityInfo(ResourceType type, String name, SafeHandle handle, SecurityInfos securityInformation, SecurityIdentifier owner, SecurityIdentifier group, GenericAcl sacl, GenericAcl dacl) at System.Security.AccessControl.NativeObjectSecurity.Persist(String name, SafeHandle handle, AccessControlSections includeSections, Object exceptionContext) at System.Security.AccessControl.NativeObjectSecurity.Persist(String name, AccessControlSections includeSections, Object exceptionContext) at System.Security.AccessControl.FileSystemSecurity.Persist(String fullPath) at Microsoft.SharePoint.Administration.SPProvisioningAssistant.ResetAcl(FileSystemInfo fi, Boolean append) at Microsoft.SharePoint.Administration.SPServer.ResetAcl(FileSystemInfo fi, Boolean append) at Microsoft.SharePoint.Administration.SPServer.StaticProvision(SPConfigurationDatabase configurationDatabase) at Microsoft.SharePoint.Administration.SPFarm.Join() at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb() at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run() at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

Forum Post: cannot find the ETW classes TraceProvider, ComponentTraceProvider classes in Microsoft.BizTalk.Tracing.dll

Anonymous — Thu, 28 Feb 2013 10:16:00 GMT

Hi,

I am trying to implement ETW tracing in my BizTalk solutions and I am pretty new to ETW. I read the post ( http://blogs.msdn.com/b/appfabriccat/archive/2010/05/11/best-practices-for-instrumenting-high-performance-biztalk-solutions.aspx ) and I found the Microsoft.BizTalk.Tracing.dll in GAC and added its reference.

However in the namespace Microsoft.BizTalk.Diagnostics, I am not able to find the classes TraceProvider and ComponentTraceProvider. Am I missing anything here ? Is there anything else I need to do here ?

Are there any other assemblies I need to install ? Should I install windows SDK (I am not sure as I already have the Microsoft.BizTalk.Tracing.dll )?

THANKS IN ADVANCe

PLEASE HELP

Surya