[community-content]

This error message is usually the first of a number of errors in the event log.
What other errors are in the event log

[community-content]

So your second Orchestration gets started?

Sounds like a problem with the SQL Adapter. Are you sure that is set up correctly?

[community-content]

Looks like there is a size limit on the posts to this forum and your post has been truncated.

When I use the xpath expression, I open the schema, navigate to the node of interest and copy and paste the Instance Xpath property value.

Can you repost with the error message you are receiving

[community-content]

Greetings,

Relatively new to Biztalk and trying to use the xpath function in an expression to extract a value from an XML document. I can validate an xpath query using XML Spy but can’t seem to get it to work in Biztalk. Here is the XML I am trying to query:

-<ns0:ProductionPerformance xmlns:ns0=\”http://www.wbf.org/xml/b2mml-v02\”>[/code] <ns0:ID>WOSN9999</ns0:ID>
<ns0:PublishedDate>2005-12-15T08:18:44</ns0:PublishedDate>
– <ns0:ProductionResponse>
<ns0:ProductionRequestID>WOSN9999</ns0:ProductionRequestID>
– <ns0:SegmentResponse>
<ns0:ID>WOSN9999_ZZZ_WorkCell99</ns0:ID>
<ns0:ProcessSegmentID>WorkCell99</ns0:ProcessSegmentID>
– <ns0:MaterialConsumedActual>
<ns0:MaterialDefinitionID>MaterialConsummedPart9999</ns0:MaterialDefinitionID>
<ns0:MaterialLotID>Serial999</ns0:MaterialLotID>
<ns0:MaterialSubLotID />
– <ns0:Location>
<ns0:EquipmentID />
<ns0:EquipmentElementLevel>Site</ns0:EquipmentElementLevel>
</ns0:Location>
– <ns0:Quantity>
<ns0:QuantityString>1</ns0:QuantityString>
<ns0:DataType>decimal</ns0:DataType>
<ns0:UnitOfMeasure>EA</ns0:UnitOfMeasure>
</ns0:Quantity>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>BatchFlag</ns0:ID>
– <ns0:Value>
<ns0:ValueString>N</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>Operation</ns0:ID>
– <ns0:Value>
<ns0:ValueString>10</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>InterfaceFlag</ns0:ID>
– <ns0:Value>
<ns0:ValueString>I</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>SerialNumber</ns0:ID>
– <ns0:Value>
<ns0:ValueString>Serial999</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>SAPInterface</ns0:ID>
– <ns0:Value>
<ns0:ValueString>IN0054A</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>SerializedFlag</ns0:ID>
– <ns0:Value>
<ns0:ValueString>N</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>BatchNumber</ns0:ID>
– <ns0:Value>
<ns0:ValueString>Batch999</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>EventDateTime</ns0:ID>
– <ns0:Value>
<ns0:ValueString>12/15/2005 8:18:39.013 AM</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>BackFlushIndicatorFlag</ns0:ID>
– <ns0:Value>
<ns0:ValueString>N</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
– <ns0:MaterialConsumedActualProperty>
<ns0:ID>BulkIndicatorFlag</ns0:ID>
– <ns0:Value>
<ns0:ValueString>N</ns0:ValueString>
<ns0:DataType>string</ns0:DataType>
<ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
<ns0:Any />
</ns0:Value>
</ns0:MaterialConsumedActualProperty>
</ns0:MaterialConsumedActual>
</ns0:SegmentResponse>
</ns0:ProductionResponse>
</ns0:ProductionPerformance>

Ultimately, I wish to return the value \”IN0054A\” which in under the \”SAP Interface\” node. Would someone please help me construct this xpath expressio 😕 n that works in BizTalk? My thanks in advance!

[community-content]

Hi

We have used [b:ccb5b97a7e]Direct Binding [/b:ccb5b97a7e]in order to connect two orchestration. In this case we have use Looping structure in first orchestration and whatever output of one orchestration is given as a input to another orchestration.

In second orchestration program we have used SQL adapter to call stored procedure. It takes input correctly but gives me error as
[b:ccb5b97a7e]Publishing a batch of \”1\” message to message box database for the transfer adapter \”SQL\”[/b:ccb5b97a7e]

Could you tell me how to overcome that error?

Thanks in advanced

[community-content]

The 2 computers can ping each other. This particular web service is invoking BizTalk, which is ok, but then when BizTalk is done and is supposed to return data back to the web service, it just halts and times out. We are not rebuilding the web services deployed as orchestrations, we are just moving them over to the test box. I know the web services deployed as orchestrations do work because if I move them over to our production servers, they function normally. It seems to me like something in BizTalk is broken, but I don’t know what part that might be. Thanks!

Edit:
On the client that consumes the web service it fails on this line of code, waiting for the reply back from the web service: object[] results = this.Invoke(\”AcceptCompositonRequest\”, new object[]
{TXML});

Also, this gets logged to the Event Log every time an orchestration exposed as a web service gets called.

Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 318
Date: 12/15/2005
Time: 8:55:20 AM
User: N/A
Computer: XXXXXX
Description:
Unable to read local eventlog (reason: The data area passed to a system call is too small).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Not very informative, but seems to be related since it happens every time I call a BizTalk Orchestration web service

[community-content]

Hi,

You can find the fix at http://support.microsoft.com/default.aspx?scid=kb;en-us;821887

Cheers

[community-content]

i%u00b4m using FTP adapter to get files from a ARBOR system (ERP) over UNIX plataform and works fine.

See ya

[community-content]

Are you getting this at build time?

If so, it’s probably part of a decision shape or somehow has logic that might cause the message to not be created.

Might want to look at the shapes before you Transform or Send.

Hope this helps.

[community-content]

Since this is on another computer, is there any domain issue between the two? Can they both ping each other?

Or are you are trying to call the web service locally?

Are you moving existing web services over to the new computer or are you rebuilding them on the new server? In you are not rebuilding them; you might want to try that just to make sure that works. Maybe there is something hard coded in the web services.

Just some thoughts.

[community-content]

Hi, i got the same problem and solved this way:

when u select the store procedure to use inside bts ( in combo box ), it%u00b4s put down all the parameters in a grid.

Fill those parameters with some value according to the db type of the parameter.

then, push \” generate button \”.

i hope this helps !!

see ya

[community-content]

I wonder if the Oracle Adapter does not support SSO on the send side?

I think it uses the System DSN Settings that have an embedded user name. Can user names in a System DSN be overridden?

[community-content]

Did you find out the solution of your problem. Please share it with us, if you found it. I am having the same problem.

Thanx in advance.

[community-content]

Oops, just wanted to say that the posting above is from me. I just forgot to login 🙂

[community-content]

hi again. Yes i runs Biztalk 2006 Beta 2 also with the new oracle adapter that comes with it.
i’ve tracked the messages, it contains the correct windows user and SSOTicket, and it’s different when i logged on as different domain user.

So the problem must be either the Orchestration process, that overwrites this context user with the user that runs host instance or the Oracles Adapter does not pick up the correct user.

My orchestration is very simple, i use only send and recieve message, no transformation or create any new messages, it can illustrate as belows:

message to http —————–> orchestration <———> Oracle Adapter
response <—————-

The http adapter is set up to use SSO, and IIS has integrated windows authentication. Oracle adapter port has also set to use SSO with my affiliate application that i created, and the windows user is mapped into oracle user. i can’t really see where it can go wrong here. All the ports and orchestration runs under trusted host instance (both in-process and isolated). [/img]

[Author]

Posts